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