public ActionResult ShowAdvanceFilter(Spartan_BR_ConditionAdvanceSearchModel model) { if (ModelState.IsValid) { Session["AdvanceSearch"] = model; 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 ActionResult ShowAdvanceFilter(string previousFilters = "") { if (!_tokenManager.GenerateToken()) { return(Json(null, JsonRequestBehavior.AllowGet)); } var previousFiltersObj = new Spartan_BR_ConditionAdvanceSearchModel(); if (previousFilters != "") { previousFiltersObj = (Spartan_BR_ConditionAdvanceSearchModel)(Session["AdvanceSearch"] ?? new Spartan_BR_ConditionAdvanceSearchModel()); } 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)); }
public string GetAdvanceFilter(Spartan_BR_ConditionAdvanceSearchModel filter) { var where = ""; if (!string.IsNullOrEmpty(filter.FromConditionId) || !string.IsNullOrEmpty(filter.ToConditionId)) { if (!string.IsNullOrEmpty(filter.FromConditionId)) { where += " AND Spartan_BR_Condition.ConditionId >= " + filter.FromConditionId; } if (!string.IsNullOrEmpty(filter.ToConditionId)) { where += " AND Spartan_BR_Condition.ConditionId <= " + filter.ToConditionId; } } if (!string.IsNullOrEmpty(filter.Description)) { switch (filter.DescriptionFilter) { case Models.Filters.BeginWith: where += " AND Spartan_BR_Condition.Description LIKE '" + filter.Description + "%'"; break; case Models.Filters.EndWith: where += " AND Spartan_BR_Condition.Description LIKE '%" + filter.Description + "'"; break; case Models.Filters.Exact: where += " AND Spartan_BR_Condition.Description = '" + filter.Description + "'"; break; case Models.Filters.Contains: where += " AND Spartan_BR_Condition.Description LIKE '%" + filter.Description + "%'"; break; } } if (!string.IsNullOrEmpty(filter.Implementation_Code)) { switch (filter.Implementation_CodeFilter) { case Models.Filters.BeginWith: where += " AND Spartan_BR_Condition.Implementation_Code LIKE '" + filter.Implementation_Code + "%'"; break; case Models.Filters.EndWith: where += " AND Spartan_BR_Condition.Implementation_Code LIKE '%" + filter.Implementation_Code + "'"; break; case Models.Filters.Exact: where += " AND Spartan_BR_Condition.Implementation_Code = '" + filter.Implementation_Code + "'"; break; case Models.Filters.Contains: where += " AND Spartan_BR_Condition.Implementation_Code LIKE '%" + filter.Implementation_Code + "%'"; break; } } where = new Regex(Regex.Escape("AND ")).Replace(where, "", 1); return(where); }