public async Task <bool> UpdateRole(SA_Role Role) { _context.Entry(Role).State = EntityState.Modified; // Role.ModeifiedDate = DateTime.Now; int x = await _context.SaveChangesAsync(); return(x == 0 ? false : true); }
internal List <SA_RoleWiseAccess> Getpage(string role) { if (role == "Admin") { return(_context.SA_RoleWiseAccess.ToList()); } SA_Role RoleDetails = _context.SA_Role.Where(Role => Role.Role == role).FirstOrDefault(); return(_context.SA_RoleWiseAccess.Where(x => x.RoleId == RoleDetails.id).ToList()); // return x == 0 ? false : true; }
public bool DeleteRole(int RoleId) { // Role.CreatedDate = DateTime.Now; SA_Role Editrole = _context.SA_Role.Where(role => role.id == RoleId).FirstOrDefault(); _context.Entry(Editrole).State = EntityState.Deleted; int x = _context.SaveChanges(); List <SA_RoleWiseAccess> deleteroleaceess = _context.SA_RoleWiseAccess.Where(role => role.RoleId == RoleId).ToList(); foreach (var item in deleteroleaceess) { _context.Entry(item).State = EntityState.Deleted; _context.SaveChanges(); } return(x == 0 ? false : true); }
public ActionResult Insert(SA_Role entity) { if (ModelState.IsValid) { entity.CreatedBy = GetCurrentUserName(); entity.CreatedDate = DateTime.Now; _service.AddRole(entity); _service.Save(); this.GetCmp <Window>("windowSA_Role").Hide(); this.GetCmp <Store>("storeSA_Role").Reload(); return(this.Direct()); } return(this.Direct()); }
internal SA_RoleViewModel GetRoleByid(int id) { SA_RoleViewModel model = new Models.SA_RoleViewModel(); SA_Role editrole = _context.SA_Role.Where(x => x.id == id).SingleOrDefault(); model.id = editrole.id; model.CreatedTime = editrole.CreatedTime != null?editrole.CreatedTime.Value.ToString("dd/MM/yyyy") : DateTime.Now.ToString("dd/MM/yyyy"); model.Role = editrole.Role; model.RoleDiscription = editrole.RoleDiscription; var editaccess = _context.SA_RoleWiseAccess.Where(x => x.RoleId == id).ToList(); foreach (var item in editaccess) { if (item.Pageid == 1) { model.ChemicalPricing = true; } if (item.Pageid == 2) { model.MarketAnalysis = true; } if (item.Pageid == 3) { model.CompanyProfile = true; } if (item.Pageid == 4) { model.IndustryReports = true; } if (item.Pageid == 5) { model.News = true; } if (item.Pageid == 6) { model.Deals = true; } if (item.Pageid == 7) { model.SubscriptionManagement = true; } } return(model); }
public ActionResult Update(SA_Role entity) { if (ModelState.IsValid) { entity.LastModifiedBy = GetCurrentUserName(); entity.LastModifiedDate = DateTime.Now; _service.UpdateRole(entity); _service.Save(); var window = this.GetCmp <Window>("windowSA_Role"); window.Hide(); this.GetCmp <Store>("storeSA_Role").Reload(); return(this.Direct()); } return(this.Direct()); }
public bool EditRole(SA_RoleViewModel RoleViewModel) { // Role.CreatedDate = DateTime.Now; SA_Role Role = _context.SA_Role.Where(role => role.id == RoleViewModel.id).FirstOrDefault(); Role.RoleDiscription = RoleViewModel.RoleDiscription; Role.Role = RoleViewModel.Role; _context.Entry(Role).State = EntityState.Modified; int x = _context.SaveChanges(); List <SA_RoleWiseAccess> Editrole = _context.SA_RoleWiseAccess.Where(role => role.RoleId == RoleViewModel.id).ToList(); foreach (var item in Editrole) { _context.Entry(item).State = EntityState.Deleted; _context.SaveChanges(); } if (RoleViewModel.ChemicalPricing == true) { SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess(); access.RoleId = Role.id; access.Pageid = 1; access.access = true; access.PageDiscription = "Chemical Pricing"; access.CreatedTime = DateTime.Now; _context.SA_RoleWiseAccess.Add(access); _context.SaveChanges(); } if (RoleViewModel.MarketAnalysis == true) { SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess(); access.RoleId = Role.id; access.Pageid = 2; access.access = true; access.PageDiscription = "Market Analysis"; access.CreatedTime = DateTime.Now; _context.SA_RoleWiseAccess.Add(access); _context.SaveChanges(); } if (RoleViewModel.CompanyProfile == true) { SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess(); access.RoleId = Role.id; access.Pageid = 3; access.access = true; access.PageDiscription = "Company Profile"; access.CreatedTime = DateTime.Now; _context.SA_RoleWiseAccess.Add(access); _context.SaveChanges(); } if (RoleViewModel.IndustryReports == true) { SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess(); access.RoleId = Role.id; access.Pageid = 4; access.access = true; access.PageDiscription = "Industry Reports"; access.CreatedTime = DateTime.Now; _context.SA_RoleWiseAccess.Add(access); _context.SaveChanges(); } if (RoleViewModel.News == true) { SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess(); access.RoleId = Role.id; access.Pageid = 5; access.access = true; access.PageDiscription = "News"; access.CreatedTime = DateTime.Now; _context.SA_RoleWiseAccess.Add(access); _context.SaveChanges(); } if (RoleViewModel.Deals == true) { SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess(); access.RoleId = Role.id; access.Pageid = 6; access.access = true; access.PageDiscription = "Deals"; access.CreatedTime = DateTime.Now; _context.SA_RoleWiseAccess.Add(access); _context.SaveChanges(); } if (RoleViewModel.SubscriptionManagement == true) { SA_RoleWiseAccess access = new Models.SA_RoleWiseAccess(); access.RoleId = Role.id; access.Pageid = 7; access.access = true; access.PageDiscription = "Subscription Management"; access.CreatedTime = DateTime.Now; _context.SA_RoleWiseAccess.Add(access); _context.SaveChanges(); } return(x == 0 ? false : true); }