public void Button_saveClose_Click(Object sender, System.EventArgs e)
{
int lngid;
string str1;
string str2;
string str3;
try {
classE1_1.Open();
classE1_1.SetBasicModelInfo(); // sets glngwid etc.
classE1_1.SaveWhatIfAudit(classE1_1.glngwid);
classE1_1.LoadBaseCase();
classE1_1.model_modified = -1;
classE1_1.saveModel_modified();
classE1_1.dowhatif_all_start();
classE1_1.Close();
Master.PassCurrentWhatifName("");
Master.SetCurrentWhatifLabel();
MPXWhatfcontrolChoices.SetActiveView(PageR1);
} catch (Exception ex) {
logFiles.ErrorLog(ex);
Master.ShowErrorMessage("MPX internal error has occured.");
}
}
protected void Page_Load(Object sender, System.EventArgs e) //Handles Me.Load
{
base.Page_Load(sender, e);
classE1_1.Open();
classE1_1.username = username;
// Load the first page
string str1;
if (!Page.IsPostBack)
{
SetLotsizesData();
}
//test
//classE1_1.UpdateMPX();
try {
classE1_1.SetBasicModelInfo(); // sets glngwid etc.
whatif_err = CalcClass.WHATIFSTOP_FLAG;
if (!Page.IsPostBack)
{
MPXRunChoices.SetActiveView(PageR1);
SetActiveView(0);
SetCalculationLabels();
RadioButtonList1.Items[0].Selected = true;
RadioButtonList2.Items[0].Selected = true;
RadioButtonList3.Items[0].Selected = true;
}
} catch (Exception ex) {
Master.ShowErrorMessage("MPX internal error has occured.");
}
classE1_1.Close();
if (!Page.IsPostBack)
{
txtResults.Text = GetResMessage();
txtErrors.Text = GetErrMessage();
pnlResults.Visible = true;
bool vis1 = !txtErrors.Text.Equals(String.Empty);
if (vis1 == true)
{
pnlErrors.Visible = true;
pnlResults.BorderColor = Color.Black;
pnlResults.BorderWidth = 3;
pnlResults.BorderStyle = BorderStyle.Solid;
}
else
{
pnlErrors.Visible = false;
pnlResults.BorderStyle = BorderStyle.None;
}
}
} // end sub
public static bool isReCalcNecessary(string username, string path)
{
Boolean resultMessage;
if (isCalculating(path))
{
resultMessage = false;
}
else
{
ClassF classE1_1 = new ClassF(path);
classE1_1.Open();
try
{
int totalCalc = 0;
classE1_1.username = username;
classE1_1.SetBasicModelInfo();
classE1_1.calc_return = 0; //0 - none, 1 labor, 2 eq over util, 4 warnings 8 errors
ADODB.Recordset recNeedCalc = new ADODB.Recordset();
//check if basecase needs recalc and add to totalCalc
DbUse.open_ado_rec(classE1_1.globaldb, ref recNeedCalc, "SELECT * FROM zs0tblWhatIf WHERE zs0tblWhatIf.WID=0;");
int basecaserecalc = Convert.ToInt32(recNeedCalc.Fields["recalc"].Value);
if (basecaserecalc != 0)
{
totalCalc++;
}
bool recOpened = DbUse.OpenAdoRec(classE1_1.globaldb, recNeedCalc, "SELECT * FROM tblWhatIf WHERE FamilyID = 0 AND recalc = true AND display = -1;");
while (!recNeedCalc.EOF)
{
totalCalc++;
recNeedCalc.MoveNext();
}
DbUse.CloseAdoRec(recNeedCalc);
if (totalCalc > 0)
{
resultMessage = true;
}
else
{
resultMessage = false;
}
}
catch (Exception)
{
resultMessage = false;
}
classE1_1.Close();
}
return(resultMessage);
}
public static string RunAll(string username, string path, string sessionID)
{
string resultMessage = "";
var resultArray = new List <string[]>();
if (isCalculating(path))
{
resultMessage = "Calculations are still in process from the previous run, please wait";
}
else
{
int ret;
DbUse.CreateRunFile(path, username);
ClassF classE1_1 = new ClassF(path);
classE1_1.Open();
try
{
int totalCalc = 0;
int currentCalc = -1;
classE1_1.username = username;
classE1_1.SetBasicModelInfo();
classE1_1.calc_return = 0; //0 - none, 1 labor, 2 eq over util, 4 warnings 8 errors
ADODB.Recordset recNeedCalc = new ADODB.Recordset();
//check if basecase needs recalc and add to totalCalc
DbUse.open_ado_rec(classE1_1.globaldb, ref recNeedCalc, "SELECT * FROM zs0tblWhatIf WHERE zs0tblWhatIf.WID=0;");
totalCalc++;
bool recOpened = DbUse.OpenAdoRec(classE1_1.globaldb, recNeedCalc, "SELECT * FROM tblWhatIf WHERE FamilyID = 0 AND display = -1;");
//bool recOpened = DbUse.OpenAdoRec(classE1_1.globaldb, recNeedCalc, "SELECT * FROM tblWhatIf;");
while (!recNeedCalc.EOF)
{
totalCalc++;
recNeedCalc.MoveNext();
}
DbUse.CloseAdoRec(recNeedCalc);
DbUse.RunMysql("INSERT INTO usercalc (id) SELECT userlist.id FROM userlist WHERE userlist.sessionid = '" + sessionID + "';");
DbUse.RunMysql("UPDATE usercalc INNER JOIN userlist ON usercalc.id = userlist.id SET total = " + totalCalc + ", calc = " + currentCalc + ", lastCheck = " + DateTime.Now.Ticks + ", cancel = 0, timePerCalc = 100000000 WHERE userlist.sessionid = '" + sessionID + "';");
classE1_1.global_runalldone = false;
classE1_1.global_initwid = classE1_1.glngwid;
classE1_1.errorMessageGlobal = "";
while (classE1_1.global_runalldone == false)
{
classE1_1.calc_return = 0;
//classE1_1.Run_All_ReCalc(1);
resultArray = classE1_1.CalculateResults(1, sessionID);
}
if (classE1_1.global_initwid != classE1_1.glngwid)
{
if (classE1_1.global_initwid != 0)
{
classE1_1.LoadBaseCase();
ret = classE1_1.LoadWhatIf(classE1_1.global_initwid);
}
else
{
classE1_1.LoadBaseCase();
}
}
;
resultMessage = CalcClass.GetErrorMessage(classE1_1);
if (resultMessage.Trim().Equals(String.Empty))
{
foreach (var result in resultArray)
{
if (result[4].Equals("true"))
{
resultMessage += "<span style='color:#27ae60;'>";
}
else
{
resultMessage += "<span style='color:#c0392b;'>";
}
resultMessage += result[0] + ": ";
if (!String.IsNullOrEmpty(result[1]))
{
resultMessage += result[1];
}
if (!String.IsNullOrEmpty(result[2]))
{
resultMessage += result[2];
}
if (!String.IsNullOrEmpty(result[3]))
{
resultMessage += result[3];
}
resultMessage += "</span>";
}
}
//if (resultMessage.Trim().Equals(String.Empty))
//{
// if ((classE1_1.calc_return & CalcClass.ERR_FLAG) > 0)
// {
// resultMessage = CalcClass.do_calc_msg(classE1_1.calc_return, 0);
// }
// else
// {
// resultMessage = CalcClass.do_calc_msg(classE1_1.calc_return, 1);
// }
//}
classE1_1.runsqlado("UPDATE zs0tblWhatif SET display = -1 WHERE WID = " + classE1_1.glngwid + ";");
}
catch (Exception)
{
resultMessage = "MPX internal error has occured";
}
classE1_1.Close();
DbUse.RunMysql("DELETE usercalc.* FROM usercalc INNER JOIN userlist ON usercalc.id = userlist.id WHERE userlist.sessionid = '" + sessionID + "';");
DbUse.DeleteRunFile(path, username);
}
return(resultMessage);
}
public static CalculationResult CalculateResults(ClassF classE1_1)
{
LogFiles logFiles = new LogFiles(classE1_1.username);
if (DbUse.InRunProcess(classE1_1.varlocal, true))
{
logFiles.DuplicateRunEndLog();
throw new Exception("Cannot start verification and calculations. The verification and calculations are still in process from the previous run. Please wait.");
}
DbUse.RunMysql("INSERT INTO usercalc (id) SELECT userlist.id FROM userlist WHERE userlist.sessionid = '" + HttpContext.Current.Session.SessionID + "';");
DbUse.RunMysql("UPDATE usercalc INNER JOIN userlist ON usercalc.id = userlist.id SET total = 1, calc = 1, lastCheck = " + DateTime.Now.Ticks + ", cancel = 0 WHERE userlist.sessionid = '" + HttpContext.Current.Session.SessionID + "';");
DbUse.CreateRunFile(classE1_1.varlocal, classE1_1.username);
classE1_1.Open();
classE1_1.SetBasicModelInfo(); // sets glngwid etc.
classE1_1.calc_return = 0; //0 - none, 1 labor, 2 eq over util, 4 warnings 8 errors
string errorsMessage = "";
string resultsMessage = "";
try
{
classE1_1.RunDLL();
if (!classE1_1.errorMessageGlobal.Equals(""))
{
string errorMessageGlobal = classE1_1.errorMessageGlobal;
classE1_1.errorMessageGlobal = "";
throw new Exception("The calculations were unsuccessful. " + errorMessageGlobal);
}
if ((classE1_1.calc_return & CalcClass.ERR_FLAG) > 0)
{
resultsMessage = do_calc_msg(classE1_1.calc_return, 0);
}
else
{
resultsMessage = do_calc_msg(classE1_1.calc_return, 1);
}
errorsMessage = GetErrorMessage(classE1_1);
save_errors_results(classE1_1, resultsMessage, errorsMessage);
classE1_1.runsqlado("UPDATE zs0tblWhatif SET display = -1 WHERE WID = " + classE1_1.glngwid + ";");
classE1_1.Close();
}
catch (Exception ex)
{
logFiles.ErrorLog(ex);
classE1_1.Close();
DbUse.DeleteRunFile(classE1_1.varlocal, classE1_1.username);
logFiles.RunEndLog();
DbUse.RunMysql("DELETE usercalc.* FROM usercalc INNER JOIN userlist ON usercalc.id = userlist.id WHERE userlist.sessionid = '" + HttpContext.Current.Session.SessionID + "';");
throw new Exception("MPX internal error has occured in calculations. Cannot calculate results. " + classE1_1.errorMessageGlobal);
}
DbUse.DeleteRunFile(classE1_1.varlocal, classE1_1.username);
DbUse.RunMysql("DELETE usercalc.* FROM usercalc INNER JOIN userlist ON usercalc.id = userlist.id WHERE userlist.sessionid = '" + HttpContext.Current.Session.SessionID + "';");
logFiles.RunEndLog();
CalculationResult calcResult = new CalculationResult(resultsMessage, errorsMessage);
return(calcResult);
}
