public int SubmitLookups(LookupsData Lookups) { LookupsDal LookupsDal = new LookupsDal(); //using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope(System.Transactions.TransactionScopeOption.Required)) try { switch (Lookups.DataStatus) { case DataStatus.New: LookupsDal.Add(Lookups); break; case DataStatus.Modified: LookupsDal.Update(Lookups); break; case DataStatus.Deleted: LookupsDal.Delete(Lookups); //ts.Complete(); return(0); default: break; } //ts.Complete(); return(Lookups._ID); } catch (Exception ex) { //ts.Dispose(); throw ex; } }