private void SQLTestButton_Click(object sender, System.EventArgs e)
{
// Test the connection string
// Attempt to open a connection to make sure we will work?
BuildConnectionString();
// SqlConnection myConnection = new SqlConnection(mConnectString);
// try
// {
// myConnection.Open();
// }
// catch(Exception ex)
if (!MOG_ControllerSystem.InitializeDatabase(mConnectString, "", ""))
{
//MOG_Report.ReportMessage("SQL Database", "Could not open SQL database!", MOGPromptButtons.OK);
Utils.ShowMessageBoxExclamation("Couldn't connect to SQL database " + this.SQLDatabaseComboBox.Text + " on server " + SQLServerComboBox.Text, "Connection Failure");
return;
}
//MOG_Report.ReportMessage("SQL Database", "Successfully connected to SQL database " + SQLServerComboBox.Text + "!",MOGPromptButtons.OK);
Utils.ShowMessageBoxInfo("Successfully connected to SQL database " + this.SQLDatabaseComboBox.Text + " on server " + SQLServerComboBox.Text, "Connection Successful");
// notify others that we clicked the Test button
OnTestButtonClicked();
}
private void SQLOkButton_Click(object sender, System.EventArgs e)
{
// Test the connection string
// Attempt to open a connection to make sure we will work?
BuildConnectionStringNoCatalog();
string databaseName = this.SQLDatabaseComboBox.Text;
// Is this a 'Create new' database
if (this.SQLCreateDatabaseRadioButton.Checked)
{
try
{
if (MOG.DATABASE.MOG_DBAPI.DatabaseExists(mConnectString, this.SQLDatabaseTextBox.Text) == false)
{
if (MOG_Prompt.PromptResponse("Create new Database?", "We will need to create this database to test this connection.\n\n\tDATABASE NAME: " + this.SQLDatabaseTextBox.Text + "\n\nIs it ok to proceed?", MOGPromptButtons.OKCancel) == MOGPromptResult.OK)
{
if (MOG.DATABASE.MOG_DBAPI.CreateDatabase(mConnectString, this.SQLDatabaseTextBox.Text))
{
databaseName = SQLDatabaseTextBox.Text;
}
else
{
if (MOG_Prompt.PromptResponse("Create Database", "Unable to create database! \n\nDo you want to continue and save these new settings?", MOGPromptButtons.YesNo) == MOGPromptResult.No)
{
return;
}
}
}
else
{
return;
}
}
}
catch (Exception ex)
{
MOG_Prompt.PromptMessage("Create Database", "Unable to check or create database with the following message:\n\n" + ex.Message, ex.StackTrace, MOG_ALERT_LEVEL.ERROR);
return;
}
}
BuildConnectionString();
if (!MOG_ControllerSystem.InitializeDatabase(mConnectString, "", ""))
{
MOG_Prompt.PromptResponse("Connection Failure", "Couldn't connect to SQL database " + databaseName + " on server " + SQLServerComboBox.Text);
return;
}
// notify others that we clicked the OK button
OnOKClicked();
}
static public bool MOGGlobalSQLLogin()
{
// Attempt to get our SQL connection string
string mConnectionString = "";
MOG_Ini config = new MOG_Ini(MOG_Main.GetExecutablePath() + "\\MOG.ini");
SQLConnectForm sql = new SQLConnectForm();
if (sql.ShowDialog() == DialogResult.OK)
{
mConnectionString = sql.mConnectString;
config.PutString("SQL", "ConnectionString", mConnectionString);
config.Save();
config = null;
return(MOG_ControllerSystem.InitializeDatabase(mConnectionString, "", ""));
}
return(false);
}
private void SQLTestButton_Click(object sender, System.EventArgs e)
{
try
{
string OriginalConnectionString = MOG_ControllerSystem.GetDB() != null?MOG_ControllerSystem.GetDB().GetConnectionString() : "";
// Test the connection string
// Attempt to open a connection to make sure we will work?
BuildConnectionStringNoCatalog();
string databaseName = GetDatabaseName();
// Is this a 'Create new' database
if (this.SQLCreateDatabaseRadioButton.Checked)
{
try
{
// Test to see if we can get to the server
if (MOG.DATABASE.MOG_DBAPI.TestServerConnection(mConnectString))
{
if (MOG.DATABASE.MOG_DBAPI.TestDatabaseConnection(mConnectString, this.SQLDatabaseTextBox.Text) == false)
{
if (MOG_Prompt.PromptResponse("Create new Database?", "We will need to create this database to test this connection.\n\n\tDATABASE NAME: " + this.SQLDatabaseTextBox.Text + "\n\nIs it ok to proceed?", MOGPromptButtons.OKCancel) == MOGPromptResult.OK)
{
if (MOG.DATABASE.MOG_DBAPI.CreateDatabase(mConnectString, this.SQLDatabaseTextBox.Text))
{
databaseName = SQLDatabaseTextBox.Text;
}
}
else
{
return;
}
}
}
else
{
MOG_Prompt.PromptMessage("Create Database", "Unable to access server: " + this.ServerName);
return;
}
}
catch (Exception ex)
{
MOG_Prompt.PromptMessage("Create Database", "Unable to check or create database with the following message:\n\n" + ex.Message, ex.StackTrace, MOG_ALERT_LEVEL.ERROR);
return;
}
}
// Build the full connection string
BuildConnectionString();
try
{
if (!MOG_ControllerSystem.InitializeDatabase(mConnectString, "", ""))
{
MOG_Prompt.PromptResponse("Connection Failure", "Couldn't connect to SQL database " + databaseName + " on server " + SQLServerComboBox.Text);
throw new Exception();
}
else
{
MOG_Prompt.PromptResponse("Connection Successful", "Successfully connected to SQL database " + databaseName + " on server " + SQLServerComboBox.Text);
}
}
catch
{
}
finally
{
if (OriginalConnectionString.Length > 0)
{
// Restore the original DBbase
mConnectString = OriginalConnectionString;
if (!MOG_ControllerSystem.InitializeDatabase(mConnectString, "", ""))
{
MOG_Prompt.PromptResponse("Connection Failure", "Couldn't restore to original SQL database (" + mConnectString + ")");
}
}
}
}
catch (Exception outer)
{
MOG_Prompt.PromptMessage("Error", outer.Message, outer.StackTrace, MOG_ALERT_LEVEL.ERROR);
return;
}
// notify others that we clicked the Test button
OnTestButtonClicked();
}
static public void MOGGlobalLaunchProjectLogin(string projectName, bool forceLogin)
{
// Launch the login dialog
LoginForm login = new LoginForm(projectName);
mainForm.Enabled = false;
Login:
// Show the dialog
if (login.ShowDialog(mainForm) == DialogResult.OK)
{
try
{
// Login to the specified Project
if (guiProject.SetLoginProject(login.LoginProjectsComboBox.Text, login.LoginBranchesComboBox.Text))
{
// Set the login user
guiUser guiUsers = new guiUser(mainForm);
if ((string.Compare(login.LoginUsersComboBox.Text, "Choose Valid User", true) == 0) || (login.LoginUsersComboBox.Text.Length == 0))
{
MessageBox.Show("A valid user must be selected!", "Missing User");
goto Login;
}
if (guiUsers.SetLoginUser(login.LoginUsersComboBox.Text))
{
mainForm.Enabled = true;
// Disable the Change SQL Server menu item if the logged in user is not an administrator
MOGGlobalSetSQLConnectionMenuItemEnabled(login.LoginUsersComboBox.Text);
// Disable the Configure Project menu item if the logged in user is not an administrator
MOGGlobalSetToolsConfigureProjectMenuItemEnabled(login.LoginUsersComboBox.Text);
// Disable the Set MOG Repository menu item if the logged in user is not an administrator
MOGGlobalSetFileMOGRepositoryMenuItemEnabled(login.LoginUsersComboBox.Text);
}
else
{
MessageBox.Show("A valid user must be selected!", "Login Error");
goto Login;
}
}
else
{
MessageBox.Show("A valid project and branch must be selected!", "Login Error");
goto Login;
}
}
catch (Exception e)
{
MOG_Report.ReportMessage("Login Project", e.Message, e.StackTrace, MOG.PROMPT.MOG_ALERT_LEVEL.ERROR);
goto Login;
}
}
else if (login.DialogResult == DialogResult.Cancel && forceLogin)
{
if (MessageBox.Show(mainForm, "Do you wish to exit MOG?", "Exit?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
mainForm.Close();
mainForm.Shutdown();
}
else
{
goto Login;
}
}
else
{
if (!MOG_ControllerProject.IsProject() || !MOG_ControllerProject.IsUser())
{
MessageBox.Show("A valid project and user must be selected!", "Missing Project or User");
goto Login;
}
mainForm.Enabled = true;
}
// Always initialize our Database before leaving because the dialog loads projects that will leave us in a dirty state
MOG_ControllerSystem.InitializeDatabase("", MOG_ControllerProject.GetProjectName(), MOG_ControllerProject.GetBranchName());
}
