protected int GetNewId(ProcCore.Business.CodeTable tab) { using (TransactionScope tx = new TransactionScope()) { var db = getDB0(); try { string tab_name = Enum.GetName(typeof(ProcCore.Business.CodeTable), tab); var items = db.i_IDX.Where(x => x.table_name == tab_name).FirstOrDefault(); if (items == null) { return(0); } else { items.IDX++; db.SaveChanges(); tx.Complete(); return(items.IDX); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } finally { db.Dispose(); } } }
public int GetNewId(ProcCore.Business.CodeTable tab) { using (var db = getDB0()) { using (TransactionScope tx = new TransactionScope()) { try { String tab_name = Enum.GetName(typeof(ProcCore.Business.CodeTable), tab); var items = from x in db.i_IDX where x.table_name == tab_name select x; if (items.Count() == 0) { return(0); } else { var item = items.FirstOrDefault(); item.IDX++; db.SaveChanges(); tx.Complete(); return(item.IDX); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } } } }