} // end onRegionSelectedIndexChanged private void onAdditional(object sender, EventArgs e) { if (regionList.SelectedItem.ToString() == "10") { // get correct password before continuing PasswordProtect pp = new PasswordProtect(); pp.ShowDialog(); if (pp.passwordResponse != "OK") { Close(); return; } // endif string currentSale = " "; string currentSaleNum = " "; if (templateFlag != 1) { List <SaleDO> sList = bslyr.getSale(); currentSale = sList[0].Name; currentSaleNum = sList[0].SaleNumber; } // endif List <LogMatrixDO> checkMatrix = new List <LogMatrixDO>(); try { // is it empty? checkMatrix = bslyr.getLogMatrix("R008"); if (checkMatrix.Count == 0) { // load default matrix for both reports checkMatrix.Clear(); checkMatrix = loadDefaultMatrix(currentSale, currentSaleNum); // save default matrix bslyr.SaveLogMatrix(checkMatrix, ""); } // endif } catch { // need to create the table and load the default int iDone = bslyr.CreateNewTable("LogMatrix"); checkMatrix = loadDefaultMatrix(currentSale, currentSaleNum); // save default matrix bslyr.SaveLogMatrix(checkMatrix, ""); } // endif // see if log matrix table needs to be updated List <LogMatrixDO> reportMatrix = new List <LogMatrixDO>(); DialogResult dr = MessageBox.Show("Reports R008 and R009 use a log matrix.\nDo you want to update the matrix now?\nNOTE: If the Log Matrix does not exist, the default matrix is used.", "QUESTION", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { DialogResult d8 = MessageBox.Show("The log matrix is different for each report.\nUpdate R008?", "QUESTION", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (d8 == DialogResult.Yes) { reportMatrix = bslyr.getLogMatrix("R008"); LogMatrixUpdate lmu = new LogMatrixUpdate(); lmu.reportMatrix = reportMatrix; lmu.currSaleName = currentSale; lmu.currSaleNumber = currentSaleNum; lmu.currReport = "R008"; lmu.setupDialog(); lmu.ShowDialog(); reportMatrix = lmu.reportMatrix; bslyr.SaveLogMatrix(reportMatrix, "R008"); // need to update R009? DialogResult d9 = MessageBox.Show("Update R009?", "QUESTION", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (d9 == DialogResult.Yes) { // retrieve R009 matrix and update reportMatrix = bslyr.getLogMatrix("R009"); LogMatrixUpdate lmx = new LogMatrixUpdate(); lmx.reportMatrix = reportMatrix; lmx.currSaleNumber = currentSale; lmx.currSaleNumber = currentSaleNum; lmx.currReport = "R009"; lmx.setupDialog(); lmx.ShowDialog(); int rtnResult = lmx.returnValue; if (rtnResult == 1) { reportMatrix = lmx.reportMatrix; bslyr.SaveLogMatrix(reportMatrix, "R009"); } // endif } // endif } else if (d8 == DialogResult.No) { DialogResult d9 = MessageBox.Show("Update R009?", "QUESTION", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (d9 == DialogResult.Yes) { // retrieve R009 matrix and update reportMatrix = bslyr.getLogMatrix("R009"); LogMatrixUpdate lmx = new LogMatrixUpdate(); lmx.reportMatrix = reportMatrix; lmx.currSaleNumber = currentSale; lmx.currSaleNumber = currentSaleNum; lmx.currReport = "R009"; lmx.setupDialog(); lmx.ShowDialog(); int rtnResult = lmx.returnValue; if (rtnResult == 1) { reportMatrix = lmx.reportMatrix; bslyr.SaveLogMatrix(reportMatrix, "R009"); } // endif } // endif } // endif } // endif } // endif if (availableReports.Items[0].ToString().Substring(0, 2) == "EX") { // not yet tested -- January 2012 MessageBox.Show("Under Construction", "INFORMATION", MessageBoxButtons.OK, MessageBoxIcon.Information); additionalData.Enabled = false; //additionalData.Enabled = true; return; /* * // display dialog for capturing export grade values * // first need region number * string currentRegion = ""; * currentRegion = bslyr.findSingleField("Region", "Sale"); * * // need dialog object * ExportDialog ed = new ExportDialog(); * // Then does the ExportValues table exist? Need to fill list with defaults for all regions or Region 10 * bool tableExists = bslyr.doesTableExist("ExportValues"); * if (tableExists == false) * { * // need to create the table * int nResult = bslyr.CreateNewTable("ExportValues"); * // then get defaults to load into dialog for user to update * exportGrades eg = new exportGrades(); * // sort list first * List<exportGrades> egSortList = eg.createDefaultList(currentRegion, "sort"); * List<exportGrades> egGradeList = eg.createDefaultList(currentRegion, "grade"); * * ed.setupDialog(egSortList, egGradeList); * } * else if (tableExists == true) * { * // just get data in the table for display * List<exportGrades> egList = bslyr.GetExportGrade(); * List<exportGrades> dummyList = new List<exportGrades>(); * ed.setupDialog(egList,dummyList); * } // endif tableExists * ed.fileName = fileName; * ed.tableExists = tableExists; * ed.ShowDialog(); * * additionalData.Enabled = false; */ } } // end onAdditional