public Int32 UpdateAll(int intDesigRghtsIdno, bool bAdd, bool bEdit, bool bView, bool bDelete, bool bPrint, Int32 empIdno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblDesigRight objDesigRight = (from mast in db.tblDesigRights
where mast.DesigRghts_Idno == intDesigRghtsIdno
select mast).FirstOrDefault();
if (objDesigRight != null)
{
objDesigRight.Emp_Idno = empIdno;
objDesigRight.ADD = bAdd;
objDesigRight.Edit = bEdit;
objDesigRight.View = bView;
objDesigRight.Delete = bDelete;
objDesigRight.Print = bPrint;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
public Int64 InsertIntotblDesigRightss(Int64 intDesigIdno, Int32 empIdno)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from FM in db.tblFormMasts select FM).ToList();
foreach (var UR in lst)
{
tblDesigRight objtblDesigRights = new tblDesigRight();
if (UR.Rights_Default == true)
{
objtblDesigRights.Desig_Idno = intDesigIdno;
objtblDesigRights.Form_Idno = UR.Form_Idno;
objtblDesigRights.Emp_Idno = empIdno;
objtblDesigRights.View = true;
objtblDesigRights.Edit = true;
objtblDesigRights.Delete = true;
objtblDesigRights.Print = true;
objtblDesigRights.ADD = true;
db.AddTotblDesigRights(objtblDesigRights);
db.SaveChanges();
intValue = objtblDesigRights.DesigRghts_Idno;
}
else
{
objtblDesigRights.Desig_Idno = intDesigIdno;
objtblDesigRights.Form_Idno = UR.Form_Idno;
objtblDesigRights.View = false;
objtblDesigRights.Edit = false;
objtblDesigRights.Delete = false;
objtblDesigRights.Print = false;
objtblDesigRights.ADD = false;
db.AddTotblDesigRights(objtblDesigRights);
db.SaveChanges();
intValue = objtblDesigRights.DesigRghts_Idno;
}
}
}
}
catch
{
}
return(intValue);
}
