public ActionResult ShowAdvanceFilter(string previousFilters = "") { if (!_tokenManager.GenerateToken()) { return(Json(null, JsonRequestBehavior.AllowGet)); } _ISpartan_FormatApiConsumer.SetAuthHeader(_tokenManager.Token); var Spartan_Formats = _ISpartan_FormatApiConsumer.SelAll(true); if (Spartan_Formats != null && Spartan_Formats.Resource != null) { ViewBag.Spartan_Formats = Spartan_Formats.Resource.Select(m => new SelectListItem { Text = m.Format_Name.ToString(), Value = Convert.ToString(m.FormatId) }).ToList(); } var previousFiltersObj = new Spartan_Format_FieldAdvanceSearchModel(); if (previousFilters != "") { previousFiltersObj = (Spartan_Format_FieldAdvanceSearchModel)(Session["AdvanceSearch"] ?? new Spartan_Format_FieldAdvanceSearchModel()); } 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 ActionResult ShowAdvanceFilter(Spartan_Format_FieldAdvanceSearchModel 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)); } _ISpartan_FormatApiConsumer.SetAuthHeader(_tokenManager.Token); var Spartan_Formats = _ISpartan_FormatApiConsumer.SelAll(true); if (Spartan_Formats != null && Spartan_Formats.Resource != null) { ViewBag.Spartan_Formats = Spartan_Formats.Resource.Select(m => new SelectListItem { Text = m.Format_Name.ToString(), Value = Convert.ToString(m.FormatId) }).ToList(); } return(View(model)); }
public string GetAdvanceFilter(Spartan_Format_FieldAdvanceSearchModel filter) { var where = ""; if (!string.IsNullOrEmpty(filter.FromFormatFieldId) || !string.IsNullOrEmpty(filter.ToFormatFieldId)) { if (!string.IsNullOrEmpty(filter.FromFormatFieldId)) { where += " AND Spartan_Format_Field.FormatFieldId >= " + filter.FromFormatFieldId; } if (!string.IsNullOrEmpty(filter.ToFormatFieldId)) { where += " AND Spartan_Format_Field.FormatFieldId <= " + filter.ToFormatFieldId; } } if (!string.IsNullOrEmpty(filter.AdvanceFormat)) { switch (filter.FormatFilter) { case Models.Filters.BeginWith: where += " AND Spartan_Format.Format_Name LIKE '" + filter.AdvanceFormat + "%'"; break; case Models.Filters.EndWith: where += " AND Spartan_Format.Format_Name LIKE '%" + filter.AdvanceFormat + "'"; break; case Models.Filters.Exact: where += " AND Spartan_Format.Format_Name = '" + filter.AdvanceFormat + "'"; break; case Models.Filters.Contains: where += " AND Spartan_Format.Format_Name LIKE '%" + filter.AdvanceFormat + "%'"; break; } } else if (filter.AdvanceFormatMultiple != null && filter.AdvanceFormatMultiple.Count() > 0) { var FormatIds = string.Join(",", filter.AdvanceFormatMultiple); where += " AND Spartan_Format_Field.Format In (" + FormatIds + ")"; } if (!string.IsNullOrEmpty(filter.Field_Path)) { switch (filter.Field_PathFilter) { case Models.Filters.BeginWith: where += " AND Spartan_Format_Field.Field_Path LIKE '" + filter.Field_Path + "%'"; break; case Models.Filters.EndWith: where += " AND Spartan_Format_Field.Field_Path LIKE '%" + filter.Field_Path + "'"; break; case Models.Filters.Exact: where += " AND Spartan_Format_Field.Field_Path = '" + filter.Field_Path + "'"; break; case Models.Filters.Contains: where += " AND Spartan_Format_Field.Field_Path LIKE '%" + filter.Field_Path + "%'"; break; } } if (!string.IsNullOrEmpty(filter.Physical_Field_Name)) { switch (filter.Physical_Field_NameFilter) { case Models.Filters.BeginWith: where += " AND Spartan_Format_Field.Physical_Field_Name LIKE '" + filter.Physical_Field_Name + "%'"; break; case Models.Filters.EndWith: where += " AND Spartan_Format_Field.Physical_Field_Name LIKE '%" + filter.Physical_Field_Name + "'"; break; case Models.Filters.Exact: where += " AND Spartan_Format_Field.Physical_Field_Name = '" + filter.Physical_Field_Name + "'"; break; case Models.Filters.Contains: where += " AND Spartan_Format_Field.Physical_Field_Name LIKE '%" + filter.Physical_Field_Name + "%'"; break; } } if (!string.IsNullOrEmpty(filter.Logical_Field_Name)) { switch (filter.Logical_Field_NameFilter) { case Models.Filters.BeginWith: where += " AND Spartan_Format_Field.Logical_Field_Name LIKE '" + filter.Logical_Field_Name + "%'"; break; case Models.Filters.EndWith: where += " AND Spartan_Format_Field.Logical_Field_Name LIKE '%" + filter.Logical_Field_Name + "'"; break; case Models.Filters.Exact: where += " AND Spartan_Format_Field.Logical_Field_Name = '" + filter.Logical_Field_Name + "'"; break; case Models.Filters.Contains: where += " AND Spartan_Format_Field.Logical_Field_Name LIKE '%" + filter.Logical_Field_Name + "%'"; break; } } if (!string.IsNullOrEmpty(filter.FromCreation_Date) || !string.IsNullOrEmpty(filter.ToCreation_Date)) { var Creation_DateFrom = DateTime.ParseExact(filter.FromCreation_Date, ConfigurationProperty.DateFormat, CultureInfo.InvariantCulture as IFormatProvider); var Creation_DateTo = DateTime.ParseExact(filter.ToCreation_Date, ConfigurationProperty.DateFormat, CultureInfo.InvariantCulture as IFormatProvider); if (!string.IsNullOrEmpty(filter.FromCreation_Date)) { where += " AND Spartan_Format_Field.Creation_Date >= '" + Creation_DateFrom.ToString("MM-dd-yyyy") + "'"; } if (!string.IsNullOrEmpty(filter.ToCreation_Date)) { where += " AND Spartan_Format_Field.Creation_Date <= '" + Creation_DateTo.ToString("MM-dd-yyyy") + "'"; } } if (!string.IsNullOrEmpty(filter.FromCreation_Hour) || !string.IsNullOrEmpty(filter.ToCreation_Hour)) { if (!string.IsNullOrEmpty(filter.FromCreation_Hour)) { where += " AND Convert(TIME,Spartan_Format_Field.Creation_Hour) >='" + filter.FromCreation_Hour + "'"; } if (!string.IsNullOrEmpty(filter.ToCreation_Hour)) { where += " AND Convert(TIME,Spartan_Format_Field.Creation_Hour) <='" + filter.ToCreation_Hour + "'"; } } if (!string.IsNullOrEmpty(filter.FromCreation_User) || !string.IsNullOrEmpty(filter.ToCreation_User)) { if (!string.IsNullOrEmpty(filter.FromCreation_User)) { where += " AND Spartan_Format_Field.Creation_User >= " + filter.FromCreation_User; } if (!string.IsNullOrEmpty(filter.ToCreation_User)) { where += " AND Spartan_Format_Field.Creation_User <= " + filter.ToCreation_User; } } if (!string.IsNullOrEmpty(filter.Properties)) { switch (filter.PropertiesFilter) { case Models.Filters.BeginWith: where += " AND Spartan_Format_Field.Properties LIKE '" + filter.Properties + "%'"; break; case Models.Filters.EndWith: where += " AND Spartan_Format_Field.Properties LIKE '%" + filter.Properties + "'"; break; case Models.Filters.Exact: where += " AND Spartan_Format_Field.Properties = '" + filter.Properties + "'"; break; case Models.Filters.Contains: where += " AND Spartan_Format_Field.Properties LIKE '%" + filter.Properties + "%'"; break; } } where = new Regex(Regex.Escape("AND ")).Replace(where, "", 1); return(where); }