public async Task <PagedResultDto <PlaqueToHerdListDto> > GetPlaqueToHerd(GetPlaqueToHerdInput input)
{
var query = GetFilteredQuery(input);
var user = await UserManager.GetUserByIdAsync(AbpSession.GetUserId());
var isAdmin = await UserManager.IsInRoleAsync(user, StaticRoleNames.Host.Admin);
var isSysAdmin = await UserManager.IsInRoleAsync(user, StaticRoleNames.Host.SysAdmin);
var isStateAdmin = await UserManager.IsInRoleAsync(user, StaticRoleNames.Host.StateAdmin);
var isCityAdmin = await UserManager.IsInRoleAsync(user, StaticRoleNames.Host.CityAdmin);
var isOfficer = await UserManager.IsInRoleAsync(user, StaticRoleNames.Host.Officer);
if (isAdmin || isSysAdmin)
{
query = query;
}
else if (isStateAdmin)
{
var union = _unionInfoRepository.FirstOrDefault(x => x.UserId == AbpSession.UserId);
query = query.Where(x => x.Officer.Contractor.StateInfoId == union.StateInfoId);
}
else if (isCityAdmin)
{
var contractor = _contractorRepository.FirstOrDefault(x => x.UserId == AbpSession.UserId);
query = query.Where(x => x.Officer.Contractor.CityInfoId == contractor.CityInfoId);
}
else if (isOfficer)
{
var officer = _officerRepository.FirstOrDefault(x => x.UserId == AbpSession.UserId);
query = query.Where(x => x.OfficerId == officer.Id);
}
else
{
query = query.Where(x => false);
}
var userCount = await query.CountAsync();
var plaqueToHerds = await query
.OrderBy(input.Sorting)
.PageBy(input)
.ToListAsync();
var plaqueToHerdsListDto = ObjectMapper.Map <List <PlaqueToHerdListDto> >(plaqueToHerds);
return(new PagedResultDto <PlaqueToHerdListDto>(
userCount,
plaqueToHerdsListDto
));
}
private IQueryable <PlaqueToHerd> GetFilteredQuery(GetPlaqueToHerdInput input)
{
var tUser = UserManager.GetUserById(AbpSession.GetUserId());
var isOfficer = UserManager.IsInRoleAsync(tUser, StaticRoleNames.Host.Officer).Result;
var query = QueryableExtensions.WhereIf(
_plaqueToHerdRepository.GetAll()
.Include(x => x.Herd)
.Include(x => x.Officer),
!input.Filter.IsNullOrWhiteSpace(), u =>
u.Herd.Name.Contains(input.Filter) ||
u.Officer.Name.Contains(input.Filter) ||
u.Officer.Family.Contains(input.Filter) ||
u.NationalCode.Contains(input.Filter));
return(query);
}
