public PagedListResponse <Entities.Parameter> Search(FilteredPagedListRequest <SearchParameterCriteria> request)
{
var result = new PagedListResponse <Entities.Parameter>();
var query = Entities.Where(p => p.IsDeleted == false);
if (!request.FilterCriteria.IncludeSystemParameters)
{
query = query.Where(p => p.IsSystem == false);
}
if (!string.IsNullOrEmpty(request.FilterCriteria.Name))
{
var nameLikeText = $"%{request.FilterCriteria.Name}%";
query = query.Where(p => EF.Functions.ILike(p.Value, nameLikeText));
}
if (request.IncludeRecordsTotal)
{
result.RecordsTotal = query.Count();
}
result.Items = query
.OrderBy(p => p.Order)
.ThenBy(p => p.Value)
.Skip(request.Offset)
.Take(request.Limit)
.ToList();
return(result);
}
public Result <PagedListResponse <UserDto> > Execute(GetUsersPagedListRequest request)
{
try
{
var response = new PagedListResponse <UserDto>();
var userRepository = Uow.GetRepository <User>();
var usersQuery = userRepository
.AsQueryable()
.Where(u => u.IsDeleted == false);
usersQuery = ProcessRequest(request, usersQuery);
response.Items = usersQuery
.Include(u => u.UserRoles)
.ThenInclude(ur => ur.Role)
.ApplyPagedListRequest(request, response)
.ToArray()
.Select(UserDto.MapFromUser)
.ToArray();
return(Result <PagedListResponse <UserDto> > .Ok(response));
}
catch (Exception exception)
{
return(Result <PagedListResponse <UserDto> > .Fail(null, exception.Message));
}
}
public static void AddPaginationHeaders <T>(this IHeaderDictionary headers, PagedListResponse <T> response) where T : class, IDto
{
headers.Add("Pagination-CurrentPage", response.CurrentPage.ToString());
headers.Add("Pagination-TotalPages", response.TotalPages.ToString());
headers.Add("Pagination-PageSize", response.PageSize.ToString());
headers.Add("Pagination-TotalCount", response.TotalCount.ToString());
}
public PagedListResponse <Entities.Customer> Search(FilteredPagedListRequest <SearchCustomerCriteria> request)
{
var result = new PagedListResponse <Entities.Customer>();
var query = Entities.Where(p => p.UserId == request.FilterCriteria.UserId);
if (!string.IsNullOrEmpty(request.FilterCriteria.Title))
{
var titleLikeText = $"%{request.FilterCriteria.Title}%";
query = query.Where(p => EF.Functions.ILike(p.Title, titleLikeText));
}
if (!string.IsNullOrEmpty(request.FilterCriteria.AuthorizedPersonName))
{
var personLikeText = $"{request.FilterCriteria.AuthorizedPersonName}%";
query = query.Where(p => EF.Functions.ILike(p.AuthorizedPersonName, personLikeText));
}
if (request.IncludeRecordsTotal)
{
result.RecordsTotal = query.Count();
}
switch (request.FilterCriteria.SortType)
{
case SortType.Ascending:
query = query
.OrderBy(p => p.Title);
break;
case SortType.Descending:
query = query
.OrderByDescending(p => p.Title);
break;
default:
query = query
.OrderByDescending(p => p.Id);
break;
}
result.Items = query
.Skip(request.Offset)
.Take(request.Limit)
.ToList();
return(result);
}
public ActionResult GetItemsByFilter(FilterPautaItems filter)
{
var response = new PagedListResponse <PautaItem>();
try
{
response = _admin.GetItemsByFilter(filter);
}
catch (Exception ex)
{
response.Result.HasErrors = true;
response.Result.Messages.Add(ex.Message);
}
return(this.JsonNet(response));
}
public ActionResult GetCdpsRecibidasByFilter(FilterCartasDePorteEmitidasRecibidas filter)
{
var response = new PagedListResponse <Dtos.SolicitudRecibida>();
try
{
response = _admin.GetCdpsRecibidasByFilter(filter);
}
catch (Exception ex)
{
response.Result.HasErrors = true;
response.Result.Messages.Add(ex.Message);
}
return(this.JsonNet(response));
}
public ActionResult GetClientesConProveedorByFilter(FilterClientesConProveedor filter)
{
var response = new PagedListResponse <Cliente>();
try
{
response = _admin.GetClientesConProveedorByFilter(filter);
}
catch (Exception ex)
{
response.Result.HasErrors = true;
response.Result.Messages.Add(ex.Message);
}
return(this.JsonNet(response));
}
public ActionResult GetTrasladosRechazados(FilterBase filter)
{
var response = new PagedListResponse <Dtos.SolicitudBandejaSalida>();
try
{
response = _admin.GetTrasladosRechazados(filter);
}
catch (Exception ex)
{
response.Result.HasErrors = true;
response.Result.Messages.Add(ex.Message);
}
return(this.JsonNet(response));
}
public ActionResult GetConfirmacionesArriboByFilter(FilterBase filter)
{
var response = new PagedListResponse <Dtos.SolicitudReport>();
try
{
response = _admin.GetConfirmacionesArriboByFilter(filter);
}
catch (Exception ex)
{
response.Result.HasErrors = true;
response.Result.Messages.Add(ex.Message);
}
return(this.JsonNet(response));
}
public ActionResult GetLogSapByFilter(FilterLogSap filter)
{
var response = new PagedListResponse <Dtos.LogSap>();
try
{
response = _admin.GetLogSapByFilter(filter);
}
catch (Exception ex)
{
response.Result.HasErrors = true;
response.Result.Messages.Add(ex.Message);
}
return(this.JsonNet(response));
}
public ActionResult GetSolicitadasByFilter(FilterSolicitudes filter)
{
var response = new PagedListResponse <Dtos.SolicitudBandejaSalida>();
try
{
response = _admin.GetSolicitadasByFilter(filter);
}
catch (Exception ex)
{
var sb = new StringBuilder();
response.Result.HasErrors = true;
while (ex != null)
{
sb.AppendLine(ex.Message);
ex = ex.InnerException;
}
response.Result.Messages.Add(sb.ToString());
}
return(this.JsonNet(response));
}
public async Task <PagedListResponse <ReservationHistory> > GetHistory(Guid id)
{
var pagedList = await queryBus.Send <GetReservationHistory, IPagedList <ReservationHistory> >(GetReservationHistory.Create(id));
return(PagedListResponse.From(pagedList));
}
public async Task <PagedListResponse <ReservationShortInfo> > Get([FromQuery] int pageNumber = 1, [FromQuery] int pageSize = 20)
{
var pagedList = await queryBus.Send <GetReservations, IPagedList <ReservationShortInfo> >(GetReservations.Create(pageNumber, pageSize));
return(PagedListResponse.From(pagedList));
}
public PagedListResponse <Entities.Transaction> Search(FilteredPagedListRequest <SearchTransactionCriteria> request)
{
var result = new PagedListResponse <Entities.Transaction>();
var query = Entities.Where(p => p.Customer.UserId == request.FilterCriteria.UserId);
if (request.FilterCriteria.CustomerId.HasValue)
{
query = query.Where(p => p.CustomerId == request.FilterCriteria.CustomerId.Value);
}
if (request.FilterCriteria.TypeId.HasValue)
{
query = query.Where(p => p.TypeId == request.FilterCriteria.TypeId.Value);
}
if (request.FilterCriteria.IsDebt.HasValue)
{
query = query.Where(p => p.IsDebt == request.FilterCriteria.IsDebt.Value);
}
if (request.IncludeRecordsTotal)
{
result.RecordsTotal = query.Count();
}
switch (request.FilterCriteria.SortType)
{
case SortType.Ascending:
query = query
.OrderBy(p => p.Customer.Title);
break;
case SortType.Descending:
query = query
.OrderByDescending(p => p.Customer.Title);
break;
default:
query = query
.OrderByDescending(p => p.Id);
break;
}
query = query.Select(p => new Entities.Transaction
{
Id = p.Id,
Description = p.Description,
AttachmentName = p.AttachmentName,
Amount = p.Amount,
TypeId = p.TypeId,
IsDebt = p.IsDebt,
Date = p.Date,
CreatedAt = p.CreatedAt,
ModifiedAt = p.ModifiedAt,
Customer = new Entities.Customer
{
Id = p.CustomerId,
AuthorizedPersonName = p.Customer.AuthorizedPersonName,
Title = p.Customer.Title
}
});
result.Items = query
.Skip(request.Offset)
.Take(request.Limit)
.ToList();
return(result);
}