public async Task <ApiResponse <List <AppUnitsGetDto> > > GetAll(AppUnitsQueryFilter filters)
{
filters.PageNumber = filters.PageNumber == 0 ? _paginationOptions.DefaultPageNumber : filters.PageNumber;
filters.PageSize = filters.PageSize == 0 ? _paginationOptions.DefaultPageSize : filters.PageSize;
List <AppUnitsGetDto> resultDto = new List <AppUnitsGetDto>();
Metadata metadata = new Metadata
{
IsValid = true,
Message = ""
};
ApiResponse <List <AppUnitsGetDto> > response = new ApiResponse <List <AppUnitsGetDto> >(resultDto);
var appUnits = await _unitOfWork.AppUnitsRepository.GetAllFilter(filters);
if (appUnits != null)
{
List <AppUnitsGetDto> appUnitsDto = _mapper.Map <List <AppUnitsGetDto> >(appUnits);
response.Data = appUnitsDto;
response.Meta = metadata;
return(response);
}
else
{
return(null);
}
}
public async Task <List <AppUnits> > GetAllFilter(AppUnitsQueryFilter filter)
{
List <AppUnits> result = new List <AppUnits>();
try
{
if (filter.Searchtext != null && filter.Searchtext.Length > 0)
{
result = await _context.AppUnits.Where(x => x.Code.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()) ||
x.Description1.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()) ||
x.Description2.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()) ||
x.Description3.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()) ||
x.Description4.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()))
.Skip((filter.PageNumber - 1) * filter.PageSize)
.Take(filter.PageSize).ToListAsync();
return(result);
}
if (filter.Code != null && filter.Code.Length > 0)
{
result = await _context.AppUnits.Where(x => x.Code.Trim().ToLower().Contains(filter.Code.Trim().ToLower())).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();
}
else if (filter.Description1 != null && filter.Description1.Length > 0)
{
result = await _context.AppUnits.Where(x => x.Description1.Trim().ToLower().Contains(filter.Description1.Trim().ToLower())).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();
}
else if (filter.Description2 != null && filter.Description2.Length > 0)
{
result = await _context.AppUnits.Where(x => x.Description2.Trim().ToLower().Contains(filter.Description2.Trim().ToLower())).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();
}
else if (filter.Description3 != null && filter.Description3.Length > 0)
{
result = await _context.AppUnits.Where(x => x.Description3.Trim().ToLower().Contains(filter.Description3.Trim().ToLower())).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();
}
else if (filter.Description4 != null && filter.Description4.Length > 0)
{
result = await _context.AppUnits.Where(x => x.Description4.Trim().ToLower().Contains(filter.Description4.Trim().ToLower())).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();
}
else if (filter.Id > 0)
{
result = await _context.AppUnits.Where(x => x.Id == filter.Id).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();
}
else
{
result = await _context.AppUnits.Skip((filter.PageNumber - 1) *filter.PageSize).Take(filter.PageSize).ToListAsync();
}
return(result);
}
catch (Exception e)
{
var a = e.InnerException.Message;
return(result);
}
}
public async Task <List <AppUnits> > GetAppUnitsWithConversion(AppUnitsQueryFilter filter)
{
List <AppUnits> result = new List <AppUnits>();
try
{
if (filter.Searchtext != null && filter.Searchtext.Length > 0)
{
result = await _context.AppUnits.Include(x => x.AppTemplateConversionUnitAppUnitIdSinceNavigation).Where(x => x.AppTemplateConversionUnitAppUnitIdSinceNavigation.Count > 0).ToListAsync();
result = result.Where(x => x.Code.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()) ||
x.Description1.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()) ||
x.Description2.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()) ||
x.Description3.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()) ||
x.Description4.Trim().ToLower().Contains(filter.Searchtext.Trim().ToLower()))
.Skip((filter.PageNumber - 1) * filter.PageSize)
.Take(filter.PageSize).ToList();
return(result);
}
else
{
result = await _context.AppUnits.Include(x => x.AppTemplateConversionUnitAppUnitIdSinceNavigation).Where(x => x.AppTemplateConversionUnitAppUnitIdSinceNavigation.Count > 0).ToListAsync();
result = result.Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToList();
}
return(result);
}
catch (Exception e)
{
var a = e.InnerException.Message;
return(result);
}
}
public async Task <IActionResult> GetAppUnitsWithConversion(AppUnitsQueryFilter filters)
{
var response = await _appUnitsService.GetAppUnitsWithConversion(filters);
return(Ok(response));
}