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(); } _ISpartan_Format_Permission_TypeApiConsumer.SetAuthHeader(_tokenManager.Token); var Spartan_Format_Permission_Types = _ISpartan_Format_Permission_TypeApiConsumer.SelAll(true); if (Spartan_Format_Permission_Types != null && Spartan_Format_Permission_Types.Resource != null) { ViewBag.Spartan_Format_Permission_Types = Spartan_Format_Permission_Types.Resource.Select(m => new SelectListItem { Text = m.Description.ToString(), Value = Convert.ToString(m.PermissionTypeId) }).ToList(); } var previousFiltersObj = new Spartan_Format_PermissionsAdvanceSearchModel(); if (previousFilters != "") { previousFiltersObj = (Spartan_Format_PermissionsAdvanceSearchModel)(Session["AdvanceSearch"] ?? new Spartan_Format_PermissionsAdvanceSearchModel()); } 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_Format_PermissionsAdvanceSearchModel filter) { var where = ""; if (!string.IsNullOrEmpty(filter.FromPermissionId) || !string.IsNullOrEmpty(filter.ToPermissionId)) { if (!string.IsNullOrEmpty(filter.FromPermissionId)) { where += " AND Spartan_Format_Permissions.PermissionId >= " + filter.FromPermissionId; } if (!string.IsNullOrEmpty(filter.ToPermissionId)) { where += " AND Spartan_Format_Permissions.PermissionId <= " + filter.ToPermissionId; } } 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_Permissions.Format In (" + FormatIds + ")"; } if (!string.IsNullOrEmpty(filter.AdvancePermission_Type)) { switch (filter.Permission_TypeFilter) { case Models.Filters.BeginWith: where += " AND Spartan_Format_Permission_Type.Description LIKE '" + filter.AdvancePermission_Type + "%'"; break; case Models.Filters.EndWith: where += " AND Spartan_Format_Permission_Type.Description LIKE '%" + filter.AdvancePermission_Type + "'"; break; case Models.Filters.Exact: where += " AND Spartan_Format_Permission_Type.Description = '" + filter.AdvancePermission_Type + "'"; break; case Models.Filters.Contains: where += " AND Spartan_Format_Permission_Type.Description LIKE '%" + filter.AdvancePermission_Type + "%'"; break; } } else if (filter.AdvancePermission_TypeMultiple != null && filter.AdvancePermission_TypeMultiple.Count() > 0) { var Permission_TypeIds = string.Join(",", filter.AdvancePermission_TypeMultiple); where += " AND Spartan_Format_Permissions.Permission_Type In (" + Permission_TypeIds + ")"; } if (filter.Apply != RadioOptions.NoApply) { where += " AND Spartan_Format_Permissions.Apply = " + Convert.ToInt32(filter.Apply); } if (!string.IsNullOrEmpty(filter.FromSpartan_User_Role) || !string.IsNullOrEmpty(filter.ToSpartan_User_Role)) { if (!string.IsNullOrEmpty(filter.FromSpartan_User_Role)) { where += " AND Spartan_Format_Permissions.Spartan_User_Role >= " + filter.FromSpartan_User_Role; } if (!string.IsNullOrEmpty(filter.ToSpartan_User_Role)) { where += " AND Spartan_Format_Permissions.Spartan_User_Role <= " + filter.ToSpartan_User_Role; } } where = new Regex(Regex.Escape("AND ")).Replace(where, "", 1); return(where); }