protected void LoadCustomUserFilters() { try { DataTable dtCustomFilter = Filtering.GetCustomFilters(); dtCustomFilter = BuildCustomFilterTable(dtCustomFilter, parentModule); ddlSavedFilters.DataSource = dtCustomFilter; ddlSavedFilters.DataValueField = "FilterString"; ddlSavedFilters.DataTextField = "CollectionName"; ddlSavedFilters.DataBind(); } catch (Exception ex) { LogUtility.LogException(ex); } }
public static string SaveCustomFilter(string collectionName, bool deleteFilter, string module, dynamic filters) { Dictionary <string, string> result = new Dictionary <string, string>() { { "saved", "false" }, { "collectionName", collectionName }, { "customFilter", "" }, { "error", "" } }; bool saved = false; string errorMsg = string.Empty; try { if (filters != null) { dynamic fields = JsonConvert.DeserializeObject <Dictionary <string, object> >(filters); saved = Filtering.SaveCustomFilters(collectionName: collectionName, deleteFilter: deleteFilter, module: module, filters: fields); } if (!deleteFilter) { DataTable dtCustomFilter = Filtering.GetCustomFilters(collectionName, module); dtCustomFilter = BuildCustomFilterTable(dtCustomFilter, module); result["collectionName"] = dtCustomFilter.Rows[0]["CollectionName"].ToString(); result["customFilter"] = dtCustomFilter.Rows[0]["FilterString"].ToString(); } } catch (Exception ex) { LogUtility.LogException(ex); saved = false; errorMsg = ex.Message; } result["saved"] = saved.ToString(); result["error"] = errorMsg; return(JsonConvert.SerializeObject(result, Formatting.None)); }