private void DoDaFix() { // Enter your SQL code here // To run a T-SQL statement with no results, int RecordsAffected = _jurisUtility.ExecuteNonQueryCommand(0, SQL); // To get an ADODB.Recordset, ADODB.Recordset myRS = _jurisUtility.RecordsetFromSQL(SQL); //get all entryids into a list, count them and then send them one at a time to the time/expense processor current = 0; Errors = null; Errors1 = null; if (radioButtonT.Checked) { getTotalRecords(1); TimeProcessor tpThread = new TimeProcessor(_jurisUtility); backgroundWorkerTime.RunWorkerAsync(tpThread); } else if (radioButtonE.Checked) { getTotalRecords(2); ExpenseProcessor epThread = new ExpenseProcessor(_jurisUtility); backgroundWorkerExp.RunWorkerAsync(epThread); } else if (radioButtonTE.Checked) { getTotalRecords(3); BothProcessor bpThread = new BothProcessor(_jurisUtility); backgroundWorkerAll.RunWorkerAsync(bpThread); } else { MessageBox.Show("Please select an Entry Type before continuing", "Selection Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void backgroundWorkerTime_DoWork(object sender, DoWorkEventArgs e) { current = 0; tproc = e.Argument as TimeProcessor; BackgroundWorker worker = sender as BackgroundWorker; try { for (int a = 6; a < 10; a++) { tproc.processTimeEntries(a.ToString()); backgroundWorkerTime.ReportProgress(current); var tlist = tproc.allTimes.ToList(); foreach (TimeEntry tt in tlist) { current++; tproc.compareTimeEntries(tt); backgroundWorkerTime.ReportProgress(current); } } } catch (Exception ex1) { e.Result = ex1; } if (tproc.correctedTimes.Count == 0) { MessageBox.Show("There were no issues found in your time entries," + "\r\n" + "so no changes are needed. The tool will now close"); Environment.ExitCode = 1; Application.Exit(); } else { DataTable dt = ConvertTo(tproc.correctedTimes); Errors = new DataSet(); Errors.Tables.Add(dt); DialogResult tpr = seePreReport(); if (tpr == DialogResult.Yes) { ReportDisplay rpds = new ReportDisplay(Errors, null, 0); rpds.ShowDialog(); for (int d = 0; d < 10; d++) { var typeList = tproc.correctedTimes.Where(c => c.newEntryStatus == d).ToList(); tproc.updateTimeEntries(typeList, d); backgroundWorkerTime.ReportProgress(current); current++; } } else if (tpr == DialogResult.No) { for (int d = 0; d < 10; d++) { var typeList = tproc.correctedTimes.Where(c => c.newEntryStatus == d).ToList(); tproc.updateTimeEntries(typeList, d); backgroundWorkerTime.ReportProgress(current); current++; } } else if (tpr == DialogResult.Cancel) { Environment.ExitCode = 1; Application.Exit(); } } }