public JsonResult ObtenerLista(DraftLawFiltersViewModel ofilters, [Bind(Include = "period_id")] GeneralFilterViewModel generalfiltros)//DataTableAjaxPostModel model
{
DraftLawBL oDraftLawBL = new DraftLawBL();
//DraftLawFiltersViewModel ofilters = new DraftLawFiltersViewModel();
GridModel <DraftLawViewModel> grid = oDraftLawBL.ObtenerLista(ofilters, generalfiltros);
return(Json(new
{
// this is what datatables wants sending back
draw = ofilters.draw,
recordsTotal = grid.total,
recordsFiltered = grid.recordsFiltered,
data = grid.rows
}));
}
public ActionResult Index()
{
PeriodBL oPeriodBL = new PeriodBL();
PeriodViewModel oPeriod = oPeriodBL.ObtenerVigente();
SelectorBL oSelectorBL = new SelectorBL();
List <SelectOptionItem> oPeriods = oSelectorBL.PeriodsSelector();
List <SelectListItem> periods = Helper.ConstruirDropDownList <SelectOptionItem>(oPeriods, "Value", "Text", "", false, "", "");
ViewBag.periods = periods;
GeneralFilterViewModel oGeneralFilterViewModel = new GeneralFilterViewModel();
oGeneralFilterViewModel.period_id = oPeriod.period_id;
return(View(oGeneralFilterViewModel));
}
public JsonResult ObtenerLista(DraftLawFiltersViewModel ofilters, [Bind(Include = "period_id")] GeneralFilterViewModel generalfiltros)//DataTableAjaxPostModel model
{
DraftLawBL oDraftLawBL = new DraftLawBL();
//DraftLawFiltersViewModel ofilters = new DraftLawFiltersViewModel();
UserBL oUserBL = new UserBL();
InvestigatorViewModel oInvestigatorViewModel = oUserBL.ObtenerInvestigator(AuthorizeUserAttribute.UsuarioLogeado().investigator_id);
GridModel <DraftLawViewModel> grid = oDraftLawBL.ObtenerMisProyectosLey(ofilters, oInvestigatorViewModel.commissions, oInvestigatorViewModel.interest_areas, generalfiltros);
return(Json(new
{
// this is what datatables wants sending back
draw = ofilters.draw,
recordsTotal = grid.total,
recordsFiltered = grid.recordsFiltered,
data = grid.rows
}));
}
public GridModel <ConceptViewModel> ObtenerRepositorio(DataTableAjaxPostModel filters, GeneralFilterViewModel generalfiltros)
{
return(oRepositorio.ObtenerRepositorio(filters, generalfiltros));
}
public GridModel <ConceptViewModel> ObtenerRecibidos(DataTableAjaxPostModel ofilters, int user_id, GeneralFilterViewModel generalfiltros)
{
return(oRepositorio.ObtenerRecibidos(ofilters, user_id, generalfiltros));
}
public GridModel <ConceptViewModel> ObtenerCertificados(DataTableAjaxPostModel ofilters, int investigator_id, GeneralFilterViewModel generalfiltros)
{
return(oRepositorio.ObtenerCertificados(ofilters, investigator_id, generalfiltros));
}
public GridModel <DraftLawViewModel> ObtenerLista(DataTableAjaxPostModel filters, GeneralFilterViewModel generalfiltro)
{
var searchBy = (filters.search != null) ? filters.search.value : null;
string sortBy = "";
string sortDir = "";
if (filters.order != null)
{
// in this example we just default sort on the 1st column
sortBy = filters.columns[filters.order[0].column].data;
sortDir = filters.order[0].dir.ToLower();
}
GridModel <DraftLawViewModel> resultado = new GridModel <DraftLawViewModel>();
IQueryable <draft_laws> queryFilters = Set;
queryFilters = queryFilters.Where(a => a.active == true && a.period_id == generalfiltro.period_id);
int count_records = queryFilters.Count();
int count_records_filtered = count_records;
if (String.IsNullOrWhiteSpace(searchBy) == false)
{
// as we only have 2 cols allow the user type in name 'firstname lastname' then use the list to search the first and last name of dbase
var searchTerms = searchBy.Split(' ').ToList().ConvertAll(x => x.ToLower());
queryFilters = queryFilters.Where(s => searchTerms.Any(srch => s.title.ToLower().Contains(srch) || s.author.ToLower().Contains(srch) ||
s.origins.name.ToLower().Contains(srch) || s.commissions.name.ToLower().Contains(srch) || s.interest_areas.name.ToLower().Contains(srch) ||
s.draft_laws_status.name.ToLower().Contains(srch) || s.draft_law_number.ToString().ToLower().Contains(srch)));
count_records_filtered = queryFilters.Count();
}
var query = queryFilters.Select(a => new DraftLawViewModel
{
draft_law_id = a.draft_law_id,
draft_law_number = a.draft_law_number,
title = a.title,
author = a.author,
origin = a.origins.name,
origin_id = a.origin_id,
date_presentation = a.date_presentation,
commission_id = a.commission_id,
commission = a.commissions.name,
debate_speaker = a.debate_speaker,
debate_speaker2 = a.debate_speaker2,
status = a.draft_laws_status.name,
status_comment = a.status_comment,
interest_area_id = a.interest_area_id,
interest_area = a.interest_areas.name,
initiative = a.initiative,
summary = a.summary,
link = a.link,
});
if (String.IsNullOrEmpty(sortBy))
{
sortBy = "draft_law_id";
}
if (String.IsNullOrEmpty(sortDir))
{
sortDir = "asc";
}
string sortExpression = sortBy.Trim() + " " + sortDir.Trim();
if (sortExpression.Trim() != "")
{
query = OrderByDinamic.OrderBy <DraftLawViewModel>(query, sortExpression.Trim());
}
resultado.rows = query.Skip(filters.start).Take(filters.length).ToList();
resultado.total = count_records;
resultado.recordsFiltered = count_records_filtered;
return(resultado);
}
public GridModel <DraftLawViewModel> ObtenerLista(DraftLawFiltersViewModel filters, GeneralFilterViewModel generalfiltros)
{
return(oRepositorio.ObtenerLista(filters, generalfiltros));
}
public GridModel <DraftLawViewModel> ObtenerMisProyectosLey(DraftLawFiltersViewModel ofilters, List <int> commissions, List <int> interest_areas, GeneralFilterViewModel generalfiltros)
{
return(oRepositorio.ObtenerMisProyectosLey(ofilters, commissions, interest_areas, generalfiltros));
}
