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); }
public async Task <bool> AddRole(SA_RoleViewModel RoleViewModel) { try { int x = 0; SA_Role Role = new Models.SA_Role(); Role.Role = RoleViewModel.Role; Role.CreatedTime = DateTime.Now; Role.RoleDiscription = RoleViewModel.RoleDiscription; _context.SA_Role.Add(Role); _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); x = await _context.SaveChangesAsync(); } return(x == 0 ? false : true); } catch (Exception ex) { return(false); } }