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