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