public static ActionResult ExecuteSQLScripts(Session session) { try { // Active message only for debugging developing // MessageBox.Show ( " ExecuteSQLScripts : To debug in VS Net, on the Debug menu, ' Attach to process ' // Msiexec.exe and rundll32.exe " DEBUG : ExecuteSQLScripts " , MessageBoxButtons.OK , MessageBoxIcon.Information ); MessageResult iResult; string sInstallLocation, sServer, sDatabase, sMessage; int iTotalTicks, iTickIncrement = 1; bool isCustomActionData = true; if (session == null) { throw new ArgumentNullException("session"); } sInstallLocation = GetSessionProperty(session, "INSTALLLOCATION", isCustomActionData); sServer = GetSessionProperty(session, "DATABASE_SERVERNAME", isCustomActionData); sDatabase = GetSessionProperty(session, "DATABASE_NAME", isCustomActionData); List <DataBasePathTO> listPaths = GetCustomTableDataBasePaths(session, isCustomActionData); var listF = session.CustomActionData.GetObject <List <FeatureInstallTO> >("DATABASE_FEACTURESCRIPTS"); iTotalTicks = listF.Count; InstallUtilities.WriteLogInstall(session, "Initialised ExecuteSQLScripts ...", null, true); iResult = InstallProgress.ResetProgress(session, iTotalTicks); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } sMessage = "Executed Script on SQL Server: " + sServer; iResult = InstallProgress.DisplayStatusActionStart(session, sMessage, sMessage, "[1] / [2]: [3]"); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } iResult = InstallProgress.NumberOfTicksPerActionData(session, iTickIncrement, true); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } for (int i = 0; i < listF.Count; i++) { ExecuteSQLScript(session, listF[i].DirectoryPath, listF[i].FileName, isCustomActionData); iResult = InstallProgress.DisplayActionData3(session, (i + 1).ToString(), iTotalTicks.ToString(), InstallUtilities.Right(Path.Combine(listF[i].DirectoryPath, listF[i].FileName), 200)); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } } return(ActionResult.Success); } catch (Exception ex) { InstallUtilities.WriteLogInstall(session, @"Exception executing script against the database", ex, true); MessageBox.Show(ex.Message, @"Error while executing scripts", MessageBoxButtons.OK, MessageBoxIcon.Error); return(ActionResult.Failure); } }
public static ActionResult ExecuteSQLScripts(Session session) { try { MessageResult iResult; string sInstallLocation, sServidor, sBaseDatos, sMensaje; int iTotalTicks, iTickIncrement = 1; bool isCustomActionData = true; if (session == null) { throw new ArgumentNullException("session"); } sInstallLocation = GetSessionProperty(session, "INSTALLLOCATION", isCustomActionData); sServidor = GetSessionProperty(session, "DATABASE_SERVERNAME", isCustomActionData); sBaseDatos = GetSessionProperty(session, "DATABASE_NAME", isCustomActionData); List <DataBasePathTO> listPaths = GetCustomTableDataBasePaths(session, isCustomActionData); List <FeactureInstallTO> listF = session.CustomActionData.GetObject <List <FeactureInstallTO> >("DATABASE_FEACTURESCRIPTS"); iTotalTicks = listF.Count; InstallUtilities.WriteLogInstall(session, "Starting ExecuteSQLScripts ...", null, true); iResult = InstallProgress.ResetProgress(session, iTotalTicks); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } sMensaje = "SQL Server: " + sServidor; iResult = InstallProgress.DisplayStatusActionStart(session, sMensaje, sMensaje, "[1] / [2]: [3]"); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } iResult = InstallProgress.NumberOfTicksPerActionData(session, iTickIncrement, true); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } for (int i = 0; i < listF.Count; i++) { ExecuteSQLScript(session, listF[i].DirectoryPath, listF[i].FileName, isCustomActionData); iResult = InstallProgress.DisplayActionData3(session, (i + 1).ToString(), iTotalTicks.ToString(), InstallUtilities.Right(Path.Combine(listF[i].DirectoryPath, listF[i].FileName), 200)); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } } return(ActionResult.Success); } catch (Exception ex) { InstallUtilities.WriteLogInstall(session, "Exception raised when execute database script", ex, true); MessageBox.Show(ex.Message, "Error of scripts execution (ExecuteSQLScripts(Session session))", MessageBoxButtons.OK, MessageBoxIcon.Error); return(ActionResult.Failure); } }
public static ActionResult ExecuteSQLScripts(Session session) { var data = new CustomActionData(); try { // Active message only for debugging developing // MessageBox.Show("SwhowPathInstall: For debugging , the Debug menu, ' Attach to process ' ate processes : msiexec.exe y rundll32.exe.", // "Depurar: SwhowPathInstall", MessageBoxButtons.OK, MessageBoxIcon.Information); //bool isCustomActionData = false; //List<DataBasePathTO> listPaths; List <FeatureInstallTO> listFeactureScripts; var listFeactureNames = new List <string>(); InstallUtilities.WriteLogInstall(session, "Initialised SwhowPathInstall ...", null, true); if (session == null) { throw new ArgumentNullException("session"); } // Setup Routes taken from CustomTable Id = " TABLE_DATABASE_PATHS " and set default route //listPaths = GetCustomTableDataBasePaths(session, isCustomActionData); // Open the user form to change installation paths database . /* * var frmA = new frmPaths(listPaths); * if (frmA.ShowDialog() != DialogResult.OK) * { * MessageBox.Show("Error"); * throw new InstallerException("ConfiguraciĆ³n de rutas de instalaciĆ³n no realizada"); * } */ // / Prepare CustomActionData for deferred CustomAction // Update CustomTable Id = " TABLE_DATABASE_PATHS " with modified routes // UpdateCustomTableDataBasePaths (session , listPaths , isCustomActionData ); // Prepare list of paths to be sent to CustomActionData for deferred CustomAction //data.AddObject("DATABASE_PATHS", listPaths); // Add the route list as a session property // Data.Add ( " DATABASE_PATHS " JsonConvert.SerializeObject ( listPaths ) ) ; // To retrieve the serialized property // List <DataBasePathTO> JsonConvert.DeserializeObject listPaths = < List <DataBasePathTO> > ( session.CustomActionData [" DATABASE_PATHS "] ); // Prepare properties to be sent to CustomActionData for deferred CustomAction SetCustomActionData(session, "INSTALLLOCATION", data); SetCustomActionData(session, "DATABASE_SERVERNAME", data); SetCustomActionData(session, "DATABASE_NAME", data); SetCustomActionData(session, "DATABASE_WINDOWSAUTHENTICATION", data); SetCustomActionData(session, "DATABASE_AUTHENTICATEDATABASE", data); SetCustomActionData(session, "DATABASE_EXECUTESCRIPTS", data); SetCustomActionData(session, "DATABASE_USERNAME", data); SetCustomActionData(session, "DATABASE_PASSWORD", data); SetCustomActionData(session, "DATABASE_PROXYPASSWORD", data); SetCustomActionData(session, "DATABASE_MAILPROFILENAME", data); SetCustomActionData(session, "DATABASE_MAILBOX", data); SetCustomActionData(session, "DATABASE_MAILIP", data); SetCustomActionData(session, "DATABASE_OPERATORNAMENAME", data); SetCustomActionData(session, "DATABASE_OPERATORMAILBOX", data); SetCustomActionData(session, "DATABASE_PROXYWINDOWSUSER", data); // / Database Scripts to be installed, taken from the MSI Feature using sql files * . foreach (FeatureInfo fi in session.Features) { if (fi.RequestState == InstallState.Local || fi.RequestState == InstallState.Source || fi.RequestState == InstallState.Default) { listFeactureNames.Add(fi.Name); InstallUtilities.WriteLogInstall(session, "FEATURE fi.Name: " + fi.Name + ", fi.CurrentState: " + fi.CurrentState + ", fi.RequestState:" + fi.RequestState, null, false); } } listFeactureScripts = GetFeatureScriptDataBase(session, listFeactureNames); data.AddObject("DATABASE_FEACTURESCRIPTS", listFeactureScripts); // Add all the properties in a single variable //session["CUSTOMACTIONDATA_PROPERTIES"] = data.ToString(); // Schedule deferred actions //session.DoAction("CA_DataBaseExecuteScripts", data); //return ActionResult.Success; } catch (Exception ex) { InstallUtilities.WriteLogInstall(session, "Exception to establish installation paths for database.", ex, true); return(ActionResult.Failure); } try { // Active message only for debugging developing // MessageBox.Show ( " ExecuteSQLScripts : To debug in VS Net, on the Debug menu, ' Attach to process ' // Msiexec.exe and rundll32.exe " DEBUG : ExecuteSQLScripts " , MessageBoxButtons.OK , MessageBoxIcon.Information ); MessageResult iResult; string sInstallLocation, sServer, sDatabase, sMessage; int iTotalTicks, iTickIncrement = 1; bool isCustomActionData = true; if (session == null) { throw new ArgumentNullException("session"); } // sInstallLocation = GetSessionProperty(session, "INSTALLLOCATION", isCustomActionData); sServer = GetSessionProperty(session, "DATABASE_SERVERNAME", false); //PRESET TO STANDARD DATABASE NAME //sDatabase = GetSessionProperty(session, "DATABASE_NAME", isCustomActionData); //List<DataBasePathTO> listPaths = GetCustomTableDataBasePaths(session, isCustomActionData); var listF = data.GetObject <List <FeatureInstallTO> >("DATABASE_FEACTURESCRIPTS"); iTotalTicks = listF.Count; InstallUtilities.WriteLogInstall(session, "Initialised ExecuteSQLScripts ...", null, true); iResult = InstallProgress.ResetProgress(session, iTotalTicks); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } sMessage = "Executed Script on SQL Server: " + sServer; iResult = InstallProgress.DisplayStatusActionStart(session, sMessage, sMessage, "[1] / [2]: [3]"); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } iResult = InstallProgress.NumberOfTicksPerActionData(session, iTickIncrement, true); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } for (int i = 0; i < listF.Count; i++) { ExecuteSQLScript(session, listF[i].DirectoryPath, listF[i].FileName, isCustomActionData); iResult = InstallProgress.DisplayActionData3(session, (i + 1).ToString(), iTotalTicks.ToString(), InstallUtilities.Right(Path.Combine(listF[i].DirectoryPath, listF[i].FileName), 200)); if (iResult == MessageResult.Cancel) { return(ActionResult.UserExit); } } } catch (Exception ex) { InstallUtilities.WriteLogInstall(session, @"Exception executing script against the database", ex, true); MessageBox.Show(ex.Message, @"Error while executing scripts", MessageBoxButtons.OK, MessageBoxIcon.Error); return(ActionResult.Failure); } return(ActionResult.Success); }