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);
}
}
}
}
