/// <summary>
/// Get all UserSettings
/// </summary>
/// <returns>A UserSettingsTD</returns>
public static DataSet GetUserSettings()
{
using (new TransactionScope(TransactionScopeOption.Suppress))
{
var ds = new UserSettingsTD();
var ta = new UserSettingsTDTableAdapters.UserSettingsTableAdapter();
ta.Fill(ds.UserSettings);
return(ds);
}
}
/// <summary>
/// Service callable code to Delete/Insert/Update User Settings
/// </summary>
/// <param name="ds">A DataSet of type UserSettingsCD</param>
/// <returns>A UserSettingsCD. If ALL updated OK contains updated data, if not contains the RowErrors</returns>
public static UserSettingsCD UpdateUserSettings(DataSet ds)
{
if (ds == null || ds.Tables["UserSettings"] == null)
{
throw new Exception("The DataSet and/or DataTable is null.");
}
var clientDataSet = new UserSettingsCD();
clientDataSet.Merge(ds, false, MissingSchemaAction.Ignore);
if (clientDataSet.UserSettings.Select("", "", DataViewRowState.Deleted).Length > 0 ||
clientDataSet.UserSettings.Select("", "", DataViewRowState.Added).Length > 0 ||
clientDataSet.UserSettings.Select("", "", DataViewRowState.ModifiedCurrent).Length > 0)
{
var tblDataSet = new UserSettingsTD.UserSettingsDataTable();
if (clientDataSet.UserSettings.Select("", "", DataViewRowState.ModifiedCurrent).Length > 0)
{
var modifiedUserSetting = new UserSettingsDataTable();
foreach (UserSettingsRow modifiedRow in clientDataSet.UserSettings.Select("", "", DataViewRowState.ModifiedCurrent))
{
modifiedUserSetting.Clear();
modifiedUserSetting.ImportRow(modifiedRow);
tblDataSet.Merge(UserSettingsTD.GetUserSetting(modifiedRow.UserName));
tblDataSet.Merge(modifiedUserSetting, false, MissingSchemaAction.Ignore);
}
}
var userSettingsTD = new UserSettingsTD();
userSettingsTD.UserSettings.BeginLoadData();
userSettingsTD.UserSettings.Merge(clientDataSet.UserSettings, false, MissingSchemaAction.Ignore);
userSettingsTD.UserSettings.Merge(tblDataSet, false, MissingSchemaAction.Ignore);
using (var ts = new TransactionScope(TransactionScopeOption.Required))
{
UserSettingsTD.UpdateUserSettings(userSettingsTD);
ts.Complete();
}
}
return(clientDataSet);
}
