private void createSchema_Click(object sender, EventArgs e)
{
DatabaseFunctions.CreateFdpsSchema();
DBStatus.Text = @"Schema successfully created";
DBStatus.Update();
InitializedatatableComboBox();
}
private void dropSchema_Click(object sender, EventArgs e)
{
DatabaseFunctions.DropFdpsSchema();
DBStatus.Text = @"Schema successfully dropped";
DBStatus.Update();
ClearComboBoxes();
}
private void truncateDB_Click(object sender, EventArgs e)
{
DatabaseFunctions.TruncateFdpsTables();
DBStatus.Text = @"Database tables successfully truncated";
DBStatus.Update();
ClearComboBoxes();
InitializedatatableComboBox();
}
private void createDB_Click(object sender, EventArgs e)
{
var dbExists = DatabaseFunctions.CreateFdpsDb();
if (dbExists == 1)
{
DBStatus.Text = @"FDPS Database already exists";
DatabaseFunctions.DropFdpsSchema();
}
else
{
DBStatus.Text = @"FDPS Database successfully created";
}
DatabaseFunctions.CreateFdpsSchema();
DBStatus.Update();
}
private void dropDB_Click(object sender, EventArgs e)
{
DatabaseFunctions.DropFdpsDb();
DBStatus.Text = @"FDPS database successfully dropped";
DBStatus.Update();
}