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