public PagedListResponse <Dtos.PautaItem> GetItemsByFilter(Dtos.Filters.FilterPautaItems filter)
{
var pautaId = filter.PautaId.HasValue ? filter.PautaId.Value : PdmContext.Pautas.Single(e => string.Equals(e.Codigo, filter.PautaCodigo)).Id;
var query = PdmContext
.PautasItem.Include(p => p.Tarifa)
.Where(t => t.Pauta.Id == pautaId && t.Pauta.Campania.Codigo == filter.CampaniaCodigo)
.OrderBy(t => t.CodigoPrograma)
.AsQueryable();
return(new PagedListResponse <Dtos.PautaItem>
{
Count = query.Count(),
Data = Mapper.Map <IList <Entities.PautaItem>, IList <Dtos.PautaItem> >(query.Skip(filter.PageSize * (filter.CurrentPage - 1)).Take(filter.PageSize).ToList())
});
}
public PagedListResponse <Dtos.PautaDetail> GetPautasByFilter(Dtos.Filters.FilterPautaItems filter)
{
var query = PdmContext
.Pautas.Include(e => e.Campania)
.Where(e => e.Estado == EstadoPauta.Aprobada || e.Estado == EstadoPauta.Cerrada || e.Estado == EstadoPauta.Pendiente)
.OrderBy(t => t.Campania.Nombre)
.AsQueryable();
if (filter.CampaniaCodigo > 0)
{
query = query.Where(e => e.Campania.Codigo == filter.CampaniaCodigo).AsQueryable();
}
return(new PagedListResponse <Dtos.PautaDetail>
{
Count = query.Count(),
Data = Mapper.Map <IList <Entities.Pauta>, IList <Dtos.PautaDetail> >(query.Skip(filter.PageSize * (filter.CurrentPage - 1)).Take(filter.PageSize).ToList())
});
}