public IHttpActionResult DraftLaw(DraftLawFilterLiteViewModel filter)
{
DraftLawBL oBL = new DraftLawBL();
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
filter.period_id = oPeriod.period_id;
List <DraftLawLiteViewModel> lista = oBL.ObtenerProyectosLeyConConceptosPorCalificar(filter);
var result = new
{
// this is what datatables wants sending back
data = lista
};
return(Ok(result));
}
public List <DraftLawLiteViewModel> ObtenerProyectosLeyConConceptosPorCalificar(DraftLawFilterLiteViewModel filter)
{
IQueryable <draft_laws> queryFilters = Set;
/* queryFilters = queryFilters.Where(a => a.period_id == filter.period_id &&
* a.concepts.Where(c => c.concept_debate_speakers.Select(d => d.user_id).Contains(filter.user_id) &&
* (c.concept_status_id == 2 || (c.concept_status_id == 4) || (c.concept_status_id == 5 && c.concepts_status_logs.Where(l => l.concept_status_id == 5 && l.user_id_created == filter.user_id).Count() == 0))
* ).Count() > 0);*/
queryFilters = queryFilters.Where(a => a.period_id == filter.period_id &&
a.concepts.Where(c => c.concept_debate_speakers.Select(d => d.user_id).Contains(filter.user_id) &&
(c.concept_status_id == 2 || (c.concept_status_id == 4) || (c.concept_status_id == 5) || (c.concept_status_id == 6))
).Count() > 0);
var query = queryFilters.Select(a => new DraftLawLiteViewModel
{
draft_law_number = a.draft_law_number,
title = a.title,
link = a.link,
period_id = a.period_id
}).Distinct();
return(query.ToList());
}
public List <DraftLawLiteViewModel> ObtenerProyectosLeyConConceptosPorCalificar(DraftLawFilterLiteViewModel filter)
{
return(oRepositorio.ObtenerProyectosLeyConConceptosPorCalificar(filter));
}
