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