public ActionResult ShowAdvanceFilter(MarcaAdvanceSearchModel model, int idFilter = -1)
{
if (ModelState.IsValid)
{
Session["AdvanceSearch"] = model;
if (idFilter != -1)
{
Session["AdvanceReportFilter"] = GetAdvanceFilter(model);
return RedirectToAction("Index", "Report", new { id = idFilter });
}
return RedirectToAction("Index");
}
ViewBag.Filter = new List<SelectListItem>
{
new SelectListItem() {Text = Resources.Resources.BeginWith, Value = "1"},
new SelectListItem() {Text = Resources.Resources.EndWith, Value = "2"},
new SelectListItem() {Text = Resources.Resources.Contains, Value = "4"},
new SelectListItem() {Text = Resources.Resources.Exact, Value = "3"},
};
if (!_tokenManager.GenerateToken())
return Json(null, JsonRequestBehavior.AllowGet);
return View(model);
}
public string GetAdvanceFilter(MarcaAdvanceSearchModel filter)
{
var where = "";
if (!string.IsNullOrEmpty(filter.FromClave) || !string.IsNullOrEmpty(filter.ToClave))
{
if (!string.IsNullOrEmpty(filter.FromClave))
where += " AND Marca.Clave >= " + filter.FromClave;
if (!string.IsNullOrEmpty(filter.ToClave))
where += " AND Marca.Clave <= " + filter.ToClave;
}
if (!string.IsNullOrEmpty(filter.Descripcion))
{
switch (filter.DescripcionFilter)
{
case Models.Filters.BeginWith:
where += " AND Marca.Descripcion LIKE '" + filter.Descripcion + "%'";
break;
case Models.Filters.EndWith:
where += " AND Marca.Descripcion LIKE '%" + filter.Descripcion + "'";
break;
case Models.Filters.Exact:
where += " AND Marca.Descripcion = '" + filter.Descripcion + "'";
break;
case Models.Filters.Contains:
where += " AND Marca.Descripcion LIKE '%" + filter.Descripcion + "%'";
break;
}
}
where = new Regex(Regex.Escape("AND ")).Replace(where, "", 1);
return where;
}
public ActionResult ShowAdvanceFilter(string previousFilters = "")
{
if (!_tokenManager.GenerateToken())
return Json(null, JsonRequestBehavior.AllowGet);
var previousFiltersObj = new MarcaAdvanceSearchModel();
if (previousFilters != "")
{
previousFiltersObj = (MarcaAdvanceSearchModel)(Session["AdvanceSearch"] ?? new MarcaAdvanceSearchModel());
}
ViewBag.Filter = new List<SelectListItem>
{
new SelectListItem() {Text = Resources.Resources.BeginWith, Value = "1"},
new SelectListItem() {Text = Resources.Resources.EndWith, Value = "2"},
new SelectListItem() {Text = Resources.Resources.Contains, Value = "4"},
new SelectListItem() {Text = Resources.Resources.Exact, Value = "3"},
};
return View(previousFiltersObj);
}
