private void btnRunDataDBScript_Click(object sender, EventArgs e) { string connString = GetConnectionString(tbDataDBName.Text); DBHandler dbMan = new DBHandler(connString); string filePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location) + "\\BGT_Data_DB_Script.sql"; try { string query = File.ReadAllText(filePath); query = query.Replace("AOXX", tbDataDBName.Text); dbMan.ExecuteNonQuery(query); } catch (Exception ex) { MessageBox.Show("Error occured while excuting script:" + 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()); } }