private IQueryable <Herd> GetFilteredQuery(GetHerdInput input)
{
var tUser = UserManager.GetUserById(AbpSession.GetUserId());
var isOfficer = UserManager.IsInRoleAsync(tUser, StaticRoleNames.Host.Officer).Result;
var query = QueryableExtensions.WhereIf(
_herdRepository.GetAll()
.Include(x => x.Contractor)
.Include(x => x.Officer)
.Include(x => x.ActivityInfo)
.Include(x => x.StateInfo)
.Include(x => x.CityInfo)
.Include(x => x.RegionInfo)
.Include(x => x.VillageInfo)
.Include(x => x.UnionInfo),
!input.Filter.IsNullOrWhiteSpace(), u =>
u.Name.Contains(input.Filter) ||
u.Family.Contains(input.Filter) ||
u.NationalCode.Replace("-", "").Contains(input.Filter) ||
u.Mobile.Replace("-", "").Contains(input.Filter) ||
u.PostalCode.Replace("-", "").Contains(input.Filter) ||
u.HerdName.Contains(input.Filter) ||
u.EpidemiologicCode.Contains(input.Filter) ||
u.Officer.Name.Contains(input.Filter) ||
u.Officer.Family.Contains(input.Filter) ||
u.Contractor.Name.Contains(input.Filter) ||
u.Contractor.Family.Contains(input.Filter) ||
u.Contractor.FirmName.Contains(input.Filter) ||
u.StateInfo.Name.Contains(input.Filter) ||
u.CityInfo.Name.Contains(input.Filter) ||
u.RegionInfo.Name.Contains(input.Filter) ||
u.VillageInfo.Name.Contains(input.Filter));
return(query);
}
public async Task <PagedResultDto <HerdListDto> > GetHerd(GetHerdInput 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.Contractor.StateInfoId == union.StateInfoId);
}
else if (isCityAdmin)
{
var contractor = _contractorRepository.FirstOrDefault(x => x.UserId == AbpSession.UserId);
query = query.Where(x => x.ContractorId == contractor.Id);
}
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 herds = await query
.OrderBy(input.Sorting)
.PageBy(input)
.ToListAsync();
var herdsListDto = ObjectMapper.Map <List <HerdListDto> >(herds);
return(new PagedResultDto <HerdListDto>(
userCount,
herdsListDto
));
}
