public void setWorksOn(int pnr, int tno, int pno, DateTime date)
{
//Set isolation level of transaction
TransactionOptions ops = new TransactionOptions();
ops.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
//Wrapp the transaction
using (TransactionScope trans = new TransactionScope(TransactionScopeOption.Required, ops))
{
try
{
//db.Connection.Open();
//db.Transaction = db.Connection.BeginTransaction();
db.setWorksOn(pnr, tno, pno, date);
db.SubmitChanges();
//db.Transaction.Commit();
//Commit transaction
trans.Complete();
//db.Transaction.Commit();
}
catch (SqlException e)
{
MessageBox.Show(e.Message.ToString());
}
catch (TransactionAbortedException tab)
{
MessageBox.Show(tab.Message.ToString());
}
catch (TransactionInDoubtException tib)
{
MessageBox.Show(tib.Message.ToString());
}
}
}
