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);
}
