private void frmSricptRunner_Load(object sender, EventArgs e)
{
tbProjectDB.Select();
DBHandler dbMan = new DBHandler(Config.GetSuperConnectionString());
try
{
DataTable dtDatabases = dbMan.GetDataTable(queryProvider.GetSQLFor_GetAllDatabase());
BindCombo(dtDatabases);
cbMethod.SelectedIndex = 6;
SetComboItem();
}
catch (Exception ex)
{
MessageBox.Show("Error while loading database info:" + ex.Message);
}
}
private void RollBack()
{
try
{
string sysScriptPath1 = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\Scripts\\Sys_BGT_DB\\1BGT_Sys_DB_Script_DELETE.sql";
DBHandler dbMan = new DBHandler(Config.GetSysDBConnectionString());
string sysDBQuery = File.ReadAllText(sysScriptPath1);
sysDBQuery = sysDBQuery.Replace("AOXX", ProjectDBName.ToUpper());
sysDBQuery = sysDBQuery.Replace("SuperUserIDXX", TeamleadUserID);
sysDBQuery = sysDBQuery.Replace("GuestUserIDXX", GuestUserID);
dbMan.ExecuteNonQuery(sysDBQuery);
//delete the project db
if (!_dbInstall.DeleteDB(Config.GetSuperConnectionString(), ProjectDBName.ToUpper()))
{
//ErrorMsg = string.Format("Can not delete database: {0}. Please delete the database manually and run installer again.", ProjectDBName);
}
}
catch (Exception ex)
{
LogWrite(ex.Message.ToString());
}
}
