public int DeleteRole(int key) { TblRoleMaster role = dbContext.TblRoleMaster.Where(x => x.RoleId == key).FirstOrDefault(); role.IsActive = false; dbContext.TblRoleMaster.Update(role); return(dbContext.SaveChanges()); }
public object UpdateMenuSubMenu(MenuSubMenuParam ObjMenu) { TblRoleMaster objrole = db.TblRoleMasters.SingleOrDefault(r => r.RoleId == ObjMenu.RoleId); objrole.Role = ObjMenu.Role; objrole.Status = 1; objrole.ModifiedBy = 1; objrole.ModifiedDate = DateTime.Now; db.SaveChanges(); TblMenu objSubmenu = new TblMenu(); objSubmenu.RoleId = ObjMenu.RoleId; string[] sbno = ObjMenu.selectedid.Split(','); for (int i = 0; i < sbno.Length; i++) { if (sbno[i] != "0") { objSubmenu.ModuleId = int.Parse(sbno[i]); objSubmenu.CreatedBy = 1; objSubmenu.CreatedDate = DateTime.Now; objSubmenu.Status = 1; db.TblMenus.Add(objSubmenu); db.SaveChanges(); } } string[] sbuncheck = ObjMenu.Unselectedid.Split(','); for (int i = 0; i < sbuncheck.Length; i++) { if (sbuncheck[i] != "0") { int MenuId = int.Parse(sbuncheck[i]); TblMenu objmenu = db.TblMenus.SingleOrDefault(r => r.RoleId == ObjMenu.RoleId && r.ModuleId == MenuId); objmenu.Status = 0; db.SaveChanges(); } } return(""); }
public int UpdateRole(TblRoleMaster tblRole) { if (dbContext.TblRoleMaster.Where(r => r.RoleName.ToUpper() == tblRole.RoleName.ToUpper() && r.RoleId != tblRole.RoleId && r.IsActive == true).Count() > 0) { return(-1); } tblRole.IsActive = true; dbContext.Entry(tblRole).State = EntityState.Modified; dbContext.TblRoleMaster.Update(tblRole); int result = dbContext.SaveChanges(); dbContext.Entry(tblRole).State = EntityState.Detached; return(result); }
public object GetDuplicateMenu(MenuSubMenuParam ObjMenu) { bool value; TblRoleMaster objrole = db.TblRoleMasters.Where(r => r.Role == ObjMenu.Role).FirstOrDefault(); if (objrole != null) { value = true; } else { value = false; } return(value); }
public object SaveMenu(MenuSubMenuParam ObjMenu) { TblRoleMaster objrole = new TblRoleMaster(); objrole.Role = ObjMenu.Role; objrole.Status = 1; objrole.CreatedBy = 1; objrole.CreatedDate = DateTime.Now; db.TblRoleMasters.Add(objrole); db.SaveChanges(); TblMenu objSubmenu = new TblMenu(); objSubmenu.RoleId = objrole.RoleId; string[] sbno = ObjMenu.selectedid.Split(','); for (int i = 0; i < sbno.Length; i++) { if (sbno[i] != "0") { objSubmenu.ModuleId = int.Parse(sbno[i]); objSubmenu.CreatedBy = 1; objSubmenu.CreatedDate = DateTime.Now; objSubmenu.Status = 1; db.TblMenus.Add(objSubmenu); db.SaveChanges(); } } TblUserRole objuserrole = new TblUserRole(); objuserrole.RoleId = objrole.RoleId; objuserrole.AllowInsert = ObjMenu.AllowInsert; objuserrole.AllowEdit = ObjMenu.AllowEdit; objuserrole.AllowDelete = ObjMenu.AllowDelete; objuserrole.AllowView = ObjMenu.AllowView; objuserrole.CreatedBy = 1; objuserrole.CreatedDate = DateTime.Now; objuserrole.Status = 1; db.TblUserRoles.Add(objuserrole); db.SaveChanges(); return(""); }
public int UpdateRole(TblRoleMaster tblRole) { return(MastersDAL.UpdateRole(tblRole)); }
public int CreateRole(TblRoleMaster tblRole) { return(MastersDAL.CreateRole(tblRole)); }
public IActionResult Role(int id, [FromBody] TblRoleMaster tblRole) { int result = _imasters.UpdateRole(tblRole); return(Ok(result)); }
public IActionResult Role(int id) { TblRoleMaster result = _imasters.GetRoleByCriteria(id); return(Ok(result)); }