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