public void Button_replace_Click(Object sender, System.EventArgs e) { int wid2; string str1; try { classE1_1.Open(); // add code del current whatif results, //zstblwhatifaudit, clear glngwid, set recalc / save indicators wid2 = classE1_1.glngwid; // replace results classE1_1.runsqlado("DELETE tblRsEquip.WID, tblRsEquip.* FROM tblRsEquip WHERE (((tblRsEquip.WID)=0));"); classE1_1.runsqlado("DELETE tblRsProd.WID, tblRsProd.* FROM tblRsProd WHERE (((tblRsProd.WID)=0));"); classE1_1.runsqlado("DELETE tblRsSummary.WID, tblRsSummary.* FROM tblRsSummary WHERE (((tblRsSummary.WID)=0));"); classE1_1.runsqlado("DELETE tblRsOper.WID, tblRsOper.* FROM tblRsOper WHERE (((tblRsOper.WID)=0));"); classE1_1.runsqlado("DELETE tblRsLabor.WID, tblRsLabor.* FROM tblRsLabor WHERE (((tblRsLabor.WID)=0));"); classE1_1.runsqlado("UPDATE tblRsEquip SET tblRsEquip.WID = 0, tblRsEquip.Whatif = 'Base Case' WHERE (((tblRsEquip.WID)=" + wid2 + ")); "); classE1_1.runsqlado("UPDATE tblRsLabor SET tblRsLabor.WID = 0, tblRsLabor.Whatif = 'Base Case' WHERE (((tblRsLabor.WID)=" + wid2 + ")); "); classE1_1.runsqlado("UPDATE tblRsOper SET tblRsOper.WID = 0, tblRsOper.Whatif = 'Base Case' WHERE (((tblRsOper.WID)=" + wid2 + ")); "); classE1_1.runsqlado("UPDATE tblRsSummary SET tblRsSummary.WID = 0, tblRsSummary.Whatif = 'Base Case' WHERE (((tblRsSummary.WID)=" + wid2 + ")); "); classE1_1.runsqlado("UPDATE tblRsProd SET tblRsProd.WID = 0, tblRsProd.Whatif = 'Base Case' WHERE (((tblRsProd.WID)=" + wid2 + ")); "); classE1_1.DeleteWhatIfAudit(wid2); str1 = "DELETE [ZstblwhatifAudit].* FROM [ZstblwhatifAudit];"; classE1_1.runsqlado(str1); classE1_1.glngwid = 0; classE1_1.saveWid(); classE1_1.saveRecalcNeeded(0, -1); classE1_1.model_modified = -1; classE1_1.saveModel_modified(); Master.PassCurrentWhatifName(""); Master.SetCurrentWhatifLabel(); updatingdatasource(); ShowWhatifs(); classE1_1.dowhatif_all_start(); classE1_1.runsqlado("UPDATE zs0tblWhatif SET display = -1 WHERE WID = 0;"); MPXWhatfcontrolChoices.SetActiveView(PageR1); classE1_1.Close(); } catch (Exception ex) { logFiles.ErrorLog(ex); Master.ShowErrorMessage("MPX internal error has occured."); } }