public void SaveGridSettings(string sName, GridSortCommandEventArgs e)
{
// We're only saving the sorting on the master table, not child 'detail' tables
if (e.Item.OwnerTableView.Name != "Detail")
{
var oIAUserSettingsGrid = DataAccess.IAUserSettingsGrids.SingleOrDefault(row => row.MPUserID == MemberProtect.CurrentUser.UserID && row.Name == sName);
if (oIAUserSettingsGrid == null)
{
oIAUserSettingsGrid = new IAUserSettingsGrid();
DataAccess.IAUserSettingsGrids.InsertOnSubmit(oIAUserSettingsGrid);
oIAUserSettingsGrid.MPUserID = MemberProtect.CurrentUser.UserID;
oIAUserSettingsGrid.Name = sName;
oIAUserSettingsGrid.Filters = string.Empty;
}
oIAUserSettingsGrid.SortExpression = e.SortExpression;
if (e.NewSortOrder == GridSortOrder.Ascending)
{
oIAUserSettingsGrid.SortExpression += " ASC";
}
else if (e.NewSortOrder == GridSortOrder.Descending)
{
oIAUserSettingsGrid.SortExpression += " DESC";
}
DataAccess.SubmitChanges();
}
}
public void SaveGridSettings(string sName, string sFilterString)
{
var oIAUserSettingsGrid = DataAccess.IAUserSettingsGrids.SingleOrDefault(row => row.MPUserID == MemberProtect.CurrentUser.UserID && row.Name == sName);
if (oIAUserSettingsGrid == null)
{
oIAUserSettingsGrid = new IAUserSettingsGrid();
DataAccess.IAUserSettingsGrids.InsertOnSubmit(oIAUserSettingsGrid);
oIAUserSettingsGrid.MPUserID = MemberProtect.CurrentUser.UserID;
oIAUserSettingsGrid.Name = sName;
oIAUserSettingsGrid.SortExpression = string.Empty;
}
oIAUserSettingsGrid.Filters = sFilterString;
DataAccess.SubmitChanges();
}
