public IHttpActionResult DraftLawSearch(DraftLawSearchFilterLiteViewModel filter)
{
DraftLawBL oBL = new DraftLawBL();
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
filter.period_id = oPeriod.period_id;
List <DraftLawLiteViewModel> lista = oBL.ObtenerProyectosLeyMovil(filter);
var result = new
{
// this is what datatables wants sending back
data = lista
};
return(Ok(result));
}
public List <DraftLawLiteViewModel> ObtenerProyectosLeyMovil(DraftLawSearchFilterLiteViewModel filter)
{
IQueryable <draft_laws> queryFilters = Set;
queryFilters = queryFilters.Where(a => a.period_id == filter.period_id);
if (!String.IsNullOrEmpty(filter.draft_law_title))
{
queryFilters = queryFilters.Where(a => a.title.ToUpper().Contains(filter.draft_law_title.ToUpper()));
}
if (!String.IsNullOrEmpty(filter.commission))
{
queryFilters = queryFilters.Where(a => a.commissions.name.ToUpper().Contains(filter.commission.ToUpper()));
}
if (!String.IsNullOrEmpty(filter.origin))
{
queryFilters = queryFilters.Where(a => a.origins.name.ToUpper().Contains(filter.origin.ToUpper()));
}
if (filter.draft_law_number > 0)
{
queryFilters = queryFilters.Where(a => a.draft_law_number == filter.draft_law_number);
}
var query = queryFilters.Select(a => new DraftLawLiteViewModel
{
draft_law_number = a.draft_law_number,
title = a.title,
period_id = a.period_id,
link = a.link
}).Distinct();
return(query.ToList());
}
public List <DraftLawLiteViewModel> ObtenerProyectosLeyMovil(DraftLawSearchFilterLiteViewModel filter)
{
return(oRepositorio.ObtenerProyectosLeyMovil(filter));
}
