public List <Role> SearchRoles(RoleSC search)
{
var result = new List <Role>();
try
{
var query = Context.Role
.Where(r => r.IsDeleted != true && r.IsSysRole != true);
if (search != null)
{
if (!string.IsNullOrWhiteSpace(search.Name))
{
query = query.Where(r => r.Name.Contains(search.Name));
}
if (search.CreatedBy?.Count > 0 && !search.CreatedBy.Contains(0))
{
query = query.Where(r => search.CreatedBy.Contains(r.CreatedBy.GetValueOrDefault()));
}
if (search.CreationDateFrom != null)
{
query = query.Where(r => r.CreationDate >= search.CreationDateFrom);
}
if (search.CreationDateTo != null)
{
query = query.Where(r => r.CreationDate <= search.CreationDateTo);
}
}
result = query.ToList();
}
catch { }
return(result);
}
public PartialViewResult _RoleList(RoleSC search)
{
var roles = UnitOfWork.RoleBL.SearchRoles(search);
var users = UnitOfWork.UserBL.GetAllWithSystemAdmin(u => roles.Any(r => r.CreatedBy == u.Id || r.LastModifiedBy == u.Id));
var landingPages = UnitOfWork.PermissionBL.Find(p => roles.Any(r => r.DefaultPageId == p.Id));
var model = roles.Select(r => new RoleVM(r)
{
CreatedBy = users.FirstOrDefault(u => u.Id == r.CreatedBy)?.FullName,
LastModifiedBy = users.FirstOrDefault(u => u.Id == r.LastModifiedBy)?.FullName,
}).ToList();
return(PartialView(model));
}
