//Add new record
public static int AddRecord(eGroups eobj, string Menus)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
OneFineRate.tblGroupM dbGroup = (OneFineRate.tblGroupM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblGroupM());
var dbobj = db.tblGroupMs.SingleOrDefault(u => u.sGroupName == dbGroup.sGroupName);
if (dbobj != null)
{
return(2);
}
else
{
var mns = Menus.Split(',').ToList();
if (mns[0] != "")
{
db.tblGroupMs.Add(dbGroup);
db.SaveChanges();
db.tblGroupMenuMs.AddRange(mns.Select(menu => new tblGroupMenuM
{
cStatus = "A",
dtActionDate = DateTime.Now,
dtCreationDate = DateTime.Now,
iActionBy = dbGroup.iActionBy,
iCreatedBy = dbGroup.iActionBy,
iMenuId = Convert.ToInt32(menu),
iGroupId = dbGroup.iGroupId
}));
db.SaveChanges();
retval = 1;
}
else
{
retval = 2;
}
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
//Update a record
public static int UpdateRecord(eGroups eobj, string Menus)
{
int retval = 0;
using (OneFineRateEntities db = new OneFineRateEntities())
{
try
{
var mns = Menus.Split(',').ToList();
if (mns.Count > 1)
{
OneFineRate.tblGroupM obj = (OneFineRate.tblGroupM)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblGroupM());
db.tblGroupMs.Attach(obj);
db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
try
{
var obj1 = db.tblGroupMenuMs.Where(u => u.iGroupId == obj.iGroupId);
db.tblGroupMenuMs.RemoveRange(obj1);
}
catch (Exception) { }
db.tblGroupMenuMs.AddRange(mns.Select(menu => new tblGroupMenuM
{
cStatus = "A",
dtActionDate = DateTime.Now,
dtCreationDate = DateTime.Now,
iActionBy = obj.iActionBy,
iCreatedBy = obj.iActionBy,
iMenuId = Convert.ToInt32(menu),
iGroupId = obj.iGroupId
}));
db.SaveChanges();
retval = 1;
}
else
{
retval = 2;
}
}
catch (Exception)
{
throw;
}
}
return(retval);
}
