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