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); }
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
protected bool SaveModel(int saveMode, string name, bool showMessage) { string currDbDir = GetDirectory() + userDir; string modelDir = currDbDir + MODELS + "\\"; string modelName = modelDir + name; string modelInitialName; string originalModel = Master.GetCurrentModel(); if (saveMode == SaveMode.CURRENT_MODEL || saveMode == SaveMode.RENAME_MODEL) { modelInitialName = modelDir + CURRENT_DATABASE; { ClassF classF = new ClassF(GetDirectory() + userDir); classF.Open(); classF.eliminate_nulls0(); classF.check_dock_stock(); //classF.checkDOCKSTOCK(); //classF.clear_all_id_name_flags(); ????? CANNOT FIND classF.set_ids2names(); classF.Close(); } } else if (saveMode == SaveMode.NEW_MODEL) { modelInitialName = modelDir + NEW_MODEL_DATABASE; } string message = "Model '" + name + "'"; try { if (saveMode == SaveMode.NEW_MODEL) { if (!File.Exists(currDbDir + NEW_MODEL_DATABASE)) { File.Copy(GetDirectory() + NEW_MODEL_DATABASE, currDbDir + NEW_MODEL_DATABASE, true); } File.Copy(currDbDir + NEW_MODEL_DATABASE, modelName, true); // save the model message += " was created "; //File.Move(modelInitialName, modelName); } else { if (saveMode == SaveMode.CURRENT_MODEL) { File.Copy(currDbDir + CURRENT_DATABASE, modelName, true); // save the model } else if (saveMode == SaveMode.RENAME_MODEL) { File.Copy(currDbDir + CURRENT_DATABASE, modelName, true); // save the model File.Delete(modelDir + originalModel); // delete the original model } message += " saved successfuly."; } SetModelModified(false); } catch (Exception ex) { logFiles.ErrorLog(ex); if (showMessage) { message += " could not save. "; Master.ShowErrorMessage("An error has occured." + message); } return(false); } CleanUpAfterSave(saveMode, originalModel, name, message, showMessage); return(true); }
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); }
// GREG - please add dowhatif_all_start() and dowhatif_all_end() where applicable protected void Page_Load(object sender, EventArgs e) { base.Page_Load(sender, e); string str1 = ""; short x1; int ret; //if (DbUse.InRunProcess(userDir)) { // ShowWhatifs(); // Master.ShowErrorMessage("Cannot load information about What-If Scenarios because calculations are still running in the current model. Please wait and come back later."); // return; //} try { classE1_1.Open(); ret = classE1_1.testresetwid(classE1_1.glngwid); /// sees if glngwid has a record in tblwhatif ... if (ret == 0) { classE1_1.glngwid = 0; // duplicate here !!! } if (!Page.IsPostBack) { // add test for glngwid in tblwhatif!!!! else set to 0 // when saving model, closing, ... check if glngwid != 0 give user choice of save, quit or new whatif name ShowWhatifs(); if (classE1_1.glngwid == 0) { classE1_1.dowhatif_all_start(); MPXWhatfcontrolChoices.SetActiveView(PageR1); } else { set_page2_words(); RefreshWhatifRecords(); SetWhatifRecordsData(); MPXWhatfcontrolChoices.SetActiveView(PageR2); //set words for whatif name, comment etc... } } else { updatingdatasource(); SetWhatifRecordsData(); /* // notupdating datasource!!! * * AccessDataSource1.UpdateCommand = "SELECT [WID], [Name] FROM [tblWhatIf]"; * AccessDataSource1.DataFile = classE1_1.varlocal + "\\mpxmdb.mdb"; * AccessDataSource1.Update(); * AccessDataSource1.DataBind(); * AccessDataSource1.Update(); */ } classE1_1.Close(); } catch (Exception ex) { logFiles.ErrorLog(ex); Master.ShowErrorMessage("MPX internal error has occured."); } }
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); }