private void btnEmailResults_Click(object sender, EventArgs e)
{
frmExportEmail frmExport = new frmExportEmail();
frmExport.Text = "Email Results";
frmExport.ChangeButtonText("Email Results");
frmExport.CompanyCode = "";
frmExport.ShowDialog();
}
private void btnSaveResults_Click(object sender, EventArgs e)
{
frmExportEmail frmExport = new frmExportEmail();
frmExport.Text = "Save Results";
frmExport.ChangeButtonText("Save Results");
frmExport.ExchequerPath = ExchequerPath;
frmExport.VersionInfo = tssVersion.Text;
frmExport.ExchequerCommonSQLConnection = ExchequerCommonSQLConnection;
frmExport.ShowDialog();
}
private void btnSaveResults_Click(object sender, EventArgs e)
{
frmExportEmail frmExport = new frmExportEmail();
frmExport.Text = "Save Results";
frmExport.ChangeButtonText("Save Results");
frmExport.ExchequerPath = ExchequerPath;
frmExport.VersionInfo = tssVersion.Text;
frmExport.ExchequerCommonSQLConnection = ExchequerCommonSQLConnection;
//SS:01/03/2018:2018-R1:ABSEXCH-19796: When Running the ExchDVT.exe, SQL Admin Passwords are visible in dump file.
frmExport.ConnPassword = connPassword;
frmExport.ShowDialog();
}
private void PostingEnabledDisabled(bool EnableDisable, bool Cancelled)
{
Int32 Long1 = 0;
Int32 Long2 = 0;
Int32 Long3 = 0;
clsToolkit.EncodeOpCode(97, out Long1, out Long2, out Long3);
IToolkit2 oToolkit2 = (IToolkit2) new Enterprise01.Toolkit();
int resToolkit = oToolkit2.OpenToolkit();
if (resToolkit == 0)
{
IHashFunctions oHashFunctions = (IHashFunctions)oToolkit2.Functions;
clsIniFile ini = new clsIniFile();
ini.IniFiles(ExchequerPath + "\\SQLConfig.ini");
if (EnableDisable)
{
// Posting Enabled String
string CompStatus = CompanyCode.TrimEnd() + "=1";
ini.WriteString("Posting", "SQLDaybookPosting-" + CompanyCode.TrimEnd(), oHashFunctions.HashText(CompStatus, ""));
MessageBox.Show("SQL Posting Optimisations are enabled for this company", "Exchequer SQL Data Validation Tool", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
// if not cancelled show message or export file
if (!Cancelled)
{
string CompStatus = CompanyCode.TrimEnd() + "=2";
ini.WriteString("Posting", "SQLDaybookPosting-" + CompanyCode.TrimEnd(), oHashFunctions.HashText(CompStatus, ""));
if (!HookEnabled)
{
MessageBox.Show("Unfortunately due to High Severity items being found you will be unable to use the SQL Posting Optimisations." + "\n" + "Please send the results to your Exchequer support provider to allow the issues to be investigated.", "Exchequer SQL Data Validation Tool", MessageBoxButtons.OK, MessageBoxIcon.Warning);
frmExportEmail frmExport = new frmExportEmail();
frmExport.Text = "Save Results";
frmExport.ChangeButtonText("Save Results");
frmExport.ExchequerPath = ExchequerPath;
frmExport.VersionInfo = tssVersion.Text;
frmExport.ExchequerCommonSQLConnection = ExchequerCommonSQLConnection;
frmExport.CompanyCode = CompanyCode;
// ABSEXCH-20380 - NullReferenceException when saving results in DVT following database connection changes
frmExport.ConnPassword = connPassword;
frmExport.ShowDialog();
}
}
else
{
string CompStatus = CompanyCode.TrimEnd() + "=0";
ini.WriteString("Posting", "SQLDaybookPosting-" + CompanyCode.TrimEnd(), oHashFunctions.HashText(CompStatus, ""));
}
}
}
}
