/// <summary>
/// Saves a 'DTNDatabase' object into the database.
/// This method calls the 'Insert' or 'Update' method.
/// </summary>
/// <param name='dTNDatabase'>The 'DTNDatabase' object to save.</param>
/// <returns>True if successful or false if not.</returns>
public bool Save(ref DTNDatabase dTNDatabase)
{
// Initial value
bool saved = false;
// If the dTNDatabase exists.
if (dTNDatabase != null)
{
// Is this a new DTNDatabase
if (dTNDatabase.IsNew)
{
// Insert new DTNDatabase
int newIdentity = this.Insert(dTNDatabase);
// if insert was successful
if (newIdentity > 0)
{
// Update Identity
dTNDatabase.UpdateIdentity(newIdentity);
// Set return value
saved = true;
}
}
else
{
// Update DTNDatabase
saved = this.Update(dTNDatabase);
}
}
// return value
return(saved);
}
/// <summary>
/// This method loads a 'DTNDatabase' object
/// from the dataRow passed in.
/// </summary>
/// <param name='dataRow'>The 'DataRow' to load from.</param>
/// <returns>A 'DTNDatabase' DataObject.</returns>
public static DTNDatabase Load(DataRow dataRow)
{
// Initial Value
DTNDatabase dTNDatabase = new DTNDatabase();
// Create field Integers
int authenticationTypefield = 0;
int connectionStringfield = 1;
int databaseIdfield = 2;
int databaseNamefield = 3;
int databaseTypefield = 4;
int dBPasswordfield = 5;
int excludefield = 6;
int pathfield = 7;
int projectIdfield = 8;
int serializablefield = 9;
int serverNamefield = 10;
int userIdfield = 11;
try
{
// Load Each field
dTNDatabase.AuthenticationType = DataHelper.ParseInteger(dataRow.ItemArray[authenticationTypefield], 0);
dTNDatabase.ConnectionString = DataHelper.ParseString(dataRow.ItemArray[connectionStringfield]);
dTNDatabase.UpdateIdentity(DataHelper.ParseInteger(dataRow.ItemArray[databaseIdfield], 0));
dTNDatabase.DatabaseName = DataHelper.ParseString(dataRow.ItemArray[databaseNamefield]);
dTNDatabase.DatabaseType = DataHelper.ParseInteger(dataRow.ItemArray[databaseTypefield], 0);
dTNDatabase.DBPassword = DataHelper.ParseString(dataRow.ItemArray[dBPasswordfield]);
dTNDatabase.Exclude = DataHelper.ParseInteger(dataRow.ItemArray[excludefield], 0);
dTNDatabase.Path = DataHelper.ParseString(dataRow.ItemArray[pathfield]);
dTNDatabase.ProjectId = DataHelper.ParseInteger(dataRow.ItemArray[projectIdfield], 0);
dTNDatabase.Serializable = DataHelper.ParseBoolean(dataRow.ItemArray[serializablefield], false);
dTNDatabase.ServerName = DataHelper.ParseString(dataRow.ItemArray[serverNamefield]);
dTNDatabase.UserId = DataHelper.ParseString(dataRow.ItemArray[userIdfield]);
}
catch
{
}
// return value
return(dTNDatabase);
}
