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);
            }
        }
Пример #2
0
        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);
        }