public override DataTable Clone()
{
UserSettingsDataTable cln = ((UserSettingsDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
internal void InitVars(bool initTable) {
this.tableUserSettings = ((UserSettingsDataTable)(base.Tables["UserSetting"]));
if ((initTable == true)) {
if ((this.tableUserSettings != null)) {
this.tableUserSettings.InitVars();
}
}
}
internal void InitVars()
{
this.tableUserSettings = ((UserSettingsDataTable)(this.Tables["UserSetting"]));
if ((this.tableUserSettings != null))
{
this.tableUserSettings.InitVars();
}
}
private void InitClass() {
this.DataSetName = "UserSettingSchema";
this.Prefix = "";
this.Namespace = "http://tempuri.org/UserSettingSchema.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
this.tableUserSettings = new UserSettingsDataTable();
base.Tables.Add(this.tableUserSettings);
}
private void InitClass()
{
this.DataSetName = "UserSettingSchema";
this.Prefix = "";
this.Namespace = "http://tempuri.org/UserSettingSchema.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableUserSettings = new UserSettingsDataTable();
this.Tables.Add(this.tableUserSettings);
}
private void InitClass()
{
this.DataSetName = "UserSettingData";
this.Prefix = "";
this.Namespace = "http://tempuri.org/UserSettingData.xsd";
this.Locale = new global::System.Globalization.CultureInfo("en-US");
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableUserSettings = new UserSettingsDataTable();
base.Tables.Add(this.tableUserSettings);
}
/// <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);
}
/// <summary>
/// Service callable code to Delete/Insert/Update UserSettings
/// </summary>
/// <returns>A UserSettingsTD. If ALL updated OK contains updated data, if not contains the RowErrors</returns>
public static DataSet UpdateUserSettings(DataSet userSettingsDataSet)
{
if (userSettingsDataSet == null || userSettingsDataSet.Tables["UserSettings"] == null)
{
throw new Exception("The DataSet and/or DataTable is null.");
}
var dtUserSettings = new UserSettingsDataTable();
dtUserSettings.BeginLoadData();
dtUserSettings.Merge(userSettingsDataSet.Tables["UserSettings"], false, MissingSchemaAction.Error);
using (var ts = new TransactionScope(TransactionScopeOption.Required))
{
var taUserSettings = new UserSettingsTDTableAdapters.UserSettingsTableAdapter();
#region do deletes
foreach (UserSettingsRow deletedRow in dtUserSettings.Select("", "", DataViewRowState.Deleted))
{
// get the primary key value(s) from the Original version (for child deletes)
var userName = (string)deletedRow["UserName", DataRowVersion.Original];
// do child deletes (if any exist)
//SettingsChildrenDataSet.UpdateSettingsChildren
// delete the row
taUserSettings.Delete(userName);
}
#endregion
#region do inserts
foreach (UserSettingsRow insertedRow in dtUserSettings.Select("", "", DataViewRowState.Added))
{
//insertedRow["SubmitDt"] = DBNull.Value; // for testing SetDefaultValues
insertedRow.SetDefaultValues();
if (insertedRow.IsValidRow())
{
taUserSettings.Update(insertedRow);
}
else
{
throw new Exception("A row to be inserted contains invalid data. Entire transaction cancelled.");
}
}
#endregion
#region do updates
foreach (UserSettingsRow modifiedRow in dtUserSettings.Select("", "", DataViewRowState.ModifiedCurrent))
{
// get the primary key value(s) from the Original version
var userName = (string)modifiedRow["UserName", DataRowVersion.Original];
// do not allow key changes
var userNameCurr = (string)modifiedRow["UserName", DataRowVersion.Current];
if (userName != userNameCurr)
{
throw new Exception("Change of primary key(s) is not permitted. Entire transaction cancelled.");
}
if (modifiedRow.IsValidRow())
{
taUserSettings.Update(modifiedRow);
}
else
{
throw new Exception("A row to be modified contains invalid data. Entire transaction cancelled.");
}
}
#endregion
ts.Complete();
}
dtUserSettings.AcceptChanges();
userSettingsDataSet.Tables["UserSettings"].Merge(dtUserSettings, false, MissingSchemaAction.Ignore);
return(userSettingsDataSet);
}
internal UserSetting(DataRowBuilder rb) :
base(rb)
{
this.tableUserSettings = ((UserSettingsDataTable)(this.Table));
}
public override System.Data.DataTable Clone() {
UserSettingsDataTable cln = ((UserSettingsDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
internal UserSettingsRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableUserSettings = ((UserSettingsDataTable)(this.Table));
}
