1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| public void Modifier(T obj)
{
try
{
connection.Open();
dbTransaction = connection.BeginTransaction(IsolationLevel.Serializable);
dataAdapter.UpdateCommand.Transaction = dbTransaction;
D[] dr = ChercherRangeeDansDataTable(obj.GetCle());
if (dr.Length == 1)
{
ModifierRangee(dr[0], obj);
dataAdapter.Update(GetDataTable());
if (commitTransactions)
{
dbTransaction.Commit();
}
else
{
dbTransaction.Rollback();
}
GetDataTable().AcceptChanges();
}
}
catch
{
if ((dbTransaction != null) && (connection.State == ConnectionState.Open))
{
dbTransaction.Rollback();
}
throw;
}
finally
{
connection.Close();
dbTransaction = null;
}
} |
Partager