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)); }