protected void SaveDefaultView() { try { string sXML = GenerateSavedSearch(true); Guid gID = Guid.Empty; // 12/17/2007 Paul. The default view must include the SearchModule in the name so that it does not get confused. DataView vwSavedSearch = new DataView(SplendidCache.SavedSearch(sSEARCH_VIEW)); vwSavedSearch.RowFilter = "NAME is null"; if (vwSavedSearch.Count > 0) { gID = Sql.ToGuid(vwSavedSearch[0]["ID"]); } SqlProcs.spSAVED_SEARCH_Update(ref gID, Security.USER_ID, String.Empty, sSEARCH_VIEW, sXML, String.Empty); // 12/09/2007 Paul. If the default already exists, then just update its contents, saving us from having to clear the cache. if (vwSavedSearch.Count == 0) { SplendidCache.ClearSavedSearch(sSEARCH_VIEW); } else { vwSavedSearch[0]["CONTENTS"] = sXML; } } catch (Exception ex) { SplendidError.SystemError(new StackTrace(true).GetFrame(0), ex); } }
public void RefreshSavedSearches(Guid gID) { txtSavedSearchName.Text = String.Empty; lstColumns.SelectedIndex = 0; radSavedSearchASC.Checked = true; SplendidCache.ClearSavedSearch(m_sMODULE); DataView vwSavedSearch = new DataView(SplendidCache.SavedSearch(m_sMODULE)); vwSavedSearch.RowFilter = "NAME is not null"; lstSavedSearches.DataSource = vwSavedSearch; lstSavedSearches.DataBind(); lstSavedSearches.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), "")); if (Sql.IsEmptyGuid(gID)) { lstSavedSearches.SelectedIndex = 0; } else { lstSavedSearches.SelectedValue = gID.ToString(); } lstSavedSearches_Changed(lstSavedSearches, null); }