private void Database_WriteBack(Brother currentParent)
{
MySqlCommand sqlCommand = null;
try
{
if( databaseConnection == null ) return;
if( currentParent.HasChild() )
{
Database_WriteBack( (Brother) currentParent.GetFirstChild() );
}
if( currentParent.HasRightSibling() )
{
Database_WriteBack( (Brother) currentParent.GetRightSibling() );
}
if( currentParent == Root ) return;
databaseConnection.Open();
sqlCommand = new MySqlCommand(Util.GetLocalizedString("SQLInsertIntoBrothers"), databaseConnection);
sqlCommand.Prepare();
sqlCommand.Parameters.AddWithValue( "@Last", currentParent.LastName );
sqlCommand.Parameters.AddWithValue( "@First", currentParent.FirstName );
sqlCommand.Parameters.AddWithValue( "@IniMonth", currentParent.InitiationTerm.ToString() );
sqlCommand.Parameters.AddWithValue( "@IniYear", currentParent.InitiationYear );
sqlCommand.Parameters.AddWithValue( "@Big",
currentParent.HasParent()
? ((Brother) currentParent.GetParent()).ToString()
: string.Empty );
sqlCommand.Parameters.AddWithValue( "@NextSibling",
currentParent.HasRightSibling()
? ((Brother) currentParent.GetRightSibling()).ToString()
: string.Empty );
sqlCommand.Parameters.AddWithValue( "@FirstLittle",
currentParent.HasChild()
? ((Brother) currentParent.GetFirstChild()).ToString()
: string.Empty );
sqlCommand.ExecuteNonQuery();
databaseConnection.Close();
}
catch ( Exception exception )
{
var message = exception.Message;
if( sqlCommand != null )
{
message += '\n';
message += sqlCommand.CommandText;
}
MessageBox.Show(message);
}
}
