/// <summary> /// This is the core automation routine that checks for appointments and processes each. /// </summary> private void RunAutomationCycle() { List <int> apptIDs = new List <int>(); /*********************** get appointments to automate ********************/ SqlDataReader reader; string CustomAutomationString = Configurator.getNodeValue("DatabaseInfo", "AUTOMATION_SQL"); if (string.IsNullOrEmpty(CustomAutomationString) == false) { reader = BCDB2.Instance.ExecuteReader(CustomAutomationString); } else { reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_Automation", null); } try { while (reader.Read()) { if (reader.IsDBNull(0) == false) { apptIDs.Add(reader.GetInt32(0)); } } } catch (Exception e) { Logger.Instance.WriteToLog("Error getting appointment IDs: " + e.ToString()); } finally { if (reader != null) { reader.Close(); } } backgroundWorker1.ReportProgress(0, apptIDs.Count.ToString() + " appointments are marked for automation - " + DateTime.Now.ToString()); /*********************** automation cycle ********************/ foreach (int apptid in apptIDs) { if (backgroundWorker1.CancellationPending) { break; } /*********************** Get Unitnum & set active patient ********************/ string unitnum = ""; ParameterCollection pc = new ParameterCollection("apptID", apptid); using (reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_GetUnitnum", pc)) { if (reader != null && reader.Read()) { unitnum = reader.GetValue(0).ToString(); } } SessionManager.Instance.SetActivePatientNoCallback(unitnum, (int)apptid); /*********************** Risk Calculations ********************/ try { backgroundWorker1.ReportProgress(1, "Running risk calculations for appointment: " + apptid.ToString() + "."); SessionManager.Instance.GetActivePatient().RecalculateRisk(); } catch (Exception e) { backgroundWorker1.ReportProgress(1, "Risk calculations FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } /*********************** Update BigQueue ********************/ try { backgroundWorker1.ReportProgress(1, "Updating BigQueue for appointment: " + apptid.ToString() + "."); pc = new ParameterCollection("unitnum", unitnum); BCDB2.Instance.RunSPWithParams("sp_3_populateBigQueue", pc); } catch (Exception e) { backgroundWorker1.ReportProgress(1, "Updating BigQueue FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } /*********************** Process Queue Documents ********************/ backgroundWorker1.ReportProgress(1, "Processing Queue Documents for appointment: " + apptid.ToString() + "."); pc = new ParameterCollection("apptID", apptid); BCDB2.Instance.RunSPWithParams("sp_processQueueDocuments", pc); /*********************** Run Automation Stored Procedures ********************/ backgroundWorker1.ReportProgress(1, "Run Automation Stored Procedures : " + apptid.ToString() + "."); RiskAppCore.ApptUtils.runAutomationStoredProcedures(apptid); /*********************** export HL7 files ********************/ backgroundWorker1.ReportProgress(1, "Export HL7 File: " + apptid.ToString() + "."); RiskModels.RiskService.exportHL7File(apptid); /*********************** Process Batch Print Queue Documents ********************/ backgroundWorker1.ReportProgress(1, "Processing batch print queue documents for appointment: " + apptid.ToString() + "."); // Make batch + printing a single progress report ??? RiskAppCore.ApptUtils.saveAutomationDocumentsToPrintQueue(apptid); /*********************** Print Documents ********************/ string print_report = ""; try { backgroundWorker1.ReportProgress(1, "Printing documents for appointment: " + apptid.ToString() + "."); // Make batch + printing a single progress report ??? ParameterCollection printDocArgs = new ParameterCollection(); printDocArgs.Add("apptid", apptid); reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_AutomationHtmlDocsToPrint", printDocArgs); while (reader.Read()) { int templateID = -1; string printer = ""; string documentType = ""; string saveLocation = ""; if (reader.IsDBNull(0) == false) { templateID = reader.GetInt32(0); } if (reader.IsDBNull(1) == false) { printer = reader.GetString(1); } if (reader.IsDBNull(2) == false) { documentType = reader.GetString(2); } if (reader.IsDBNull(3) == false) { saveLocation = reader.GetString(3); } /////////////////////////////////////////////////// // documentType defaults to HTML in V3 Automation // /////////////////////////////////////////////////// if (string.IsNullOrEmpty(documentType)) { documentType = "HTML"; } RiskApps3.Model.Clinic.Letters.PrintUtils printUtils = new RiskApps3.Model.Clinic.Letters.PrintUtils(printer); if (printer.ToLower().StartsWith("save as")) { if (string.IsNullOrEmpty(saveLocation) == false) { if (documentType.ToUpper() == "HTML") { if (string.Compare(printer, "save as pdf", true) == 0) { if (printUtils.savePdfDoc(apptid, unitnum, templateID, saveLocation) == true) { print_report += "Saved document template " + templateID.ToString() + " in " + saveLocation + "<br/>"; } } else { if (printUtils.saveHtmlDoc(apptid, unitnum, templateID, saveLocation) == true) { print_report += "Saved document template " + templateID.ToString() + " in " + saveLocation + "<br/>"; } } } else if (documentType.ToUpper() == "WORD") { if (printUtils.saveWordDoc(apptid, unitnum, templateID, saveLocation) == true) { print_report += "Saved document template " + templateID.ToString() + " in " + saveLocation + "<br/>"; } } } } else if (printer == "BATCH") { pc = new ParameterCollection(); pc.Add("apptid", apptid); pc.Add("dateTime", DateTime.Now); pc.Add("templateID", templateID); pc.Add("unitnum", unitnum); pc.Add("documentType", documentType); string sqlStr = "INSERT INTO tblPrintQueue (apptID, created, documentTemplateID, unitnum, automationPrint, automationSave, documentType) VALUES (@apptid, @dateTime, @templateID, @unitnum, 0, 0, @documentType)"; int rowsAffected = BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); print_report += "Sent document template " + templateID.ToString() + " to the batch print queue." + "<br/>"; backgroundWorker1.ReportProgress(2, "Appt " + apptid.ToString() + ":<br/>" + print_report); } else if (printer == "") { } else if (string.IsNullOrEmpty(printer) == false) { if (documentType.ToUpper() == "WORD") { if (printUtils.printWordDoc(apptid, unitnum, templateID)) { print_report += "Sent document template " + templateID.ToString() + " to printer: " + printUtils.getPrinter() + "<br/>"; pc = new ParameterCollection(); pc.Add("apptid", apptid); pc.Add("templateID", templateID); pc.Add("dateTime", DateTime.Now); string sqlStr = "INSERT INTO tblDocuments([apptID],[documentTemplateID],[created],[createdBy]) VALUES(@apptid, @templateID, @dateTime, 'AUTOMATION');"; BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); } else { print_report += "Failed sending document template " + templateID.ToString() + " to printer: " + printUtils.getPrinter() + "<br/>"; } backgroundWorker1.ReportProgress(2, "Appt " + apptid.ToString() + ":<br/>" + print_report); } else if (documentType.ToUpper() == "HTML") { HraHtmlDocument hdoc; if ((hdoc = printUtils.printHtmlDoc(apptid, unitnum, templateID)) != null) { print_report += "Sent document template " + templateID.ToString() + " to printer: " + hdoc.targetPrinter + "<br/>"; pc = new ParameterCollection(); pc.Add("apptid", hdoc.apptid); pc.Add("templateID", hdoc.template.documentTemplateID); pc.Add("dateTime", DateTime.Now); string sqlStr = "INSERT INTO tblDocuments([apptID],[documentTemplateID],[created],[createdBy]) VALUES(@apptid, @templateID, @dateTime, 'AUTOMATION');"; int rowsAffected = BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); backgroundWorker1.ReportProgress(2, hdoc.template.htmlText + Environment.NewLine + "Appt " + apptid.ToString() + ":<br/>" + print_report); } else { print_report += "Failed to send document template " + templateID.ToString() + " to printer: " + printUtils.getPrinter() + "<br/>"; backgroundWorker1.ReportProgress(2, "Appt " + apptid.ToString() + ":<br/>" + print_report); } } else if (documentType != "HTML" && documentType != "WORD") { print_report += "Could not process document: templateID " + templateID.ToString() + ", printer: " + printer + ", UNKOWN DOCUMENT TYPE: \"" + documentType + "\"<br/>"; backgroundWorker1.ReportProgress(2, "Appt " + apptid.ToString() + ":<br/>" + print_report); } } } } catch (Exception e) { backgroundWorker1.ReportProgress(1, "Printing FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } finally { if (reader != null) { reader.Close(); } } /*********************** Mark as printed to complete automation ********************/ try { pc = new ParameterCollection("apptid", apptid); String sqlStr = "UPDATE tblRiskData SET printed = 1 WHERE apptid = @apptid"; int rowsAffected = BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); } catch (Exception e) { backgroundWorker1.ReportProgress(1, ("Automation - unable to update appt id=" + apptid.ToString() + " printed=1.\n" + e.ToString())); } if (status != null) { try { status.LogStatus(idString, "Automation", "Ok", ("Appt " + apptid + " " + print_report).Trim()); } catch (System.Web.Services.Protocols.SoapException e) { //do nothing } catch (Exception ex) { Logger.Instance.WriteToLog(ex.ToString()); } } } }
private void printSelectedBackgroundWorker_DoWork(object sender, DoWorkEventArgs e) { if (printSelectedBackgroundWorker.CancellationPending) { e.Cancel = true; return; } float i = 0; float count = selectedList.Count; foreach (PrintQueueEntry pqe in selectedList) { if (printSelectedBackgroundWorker.CancellationPending) { e.Cancel = true; return; } int percent = (int)((++i * 100.0f) / count); int apptID = -1; int documentTemplateID = -1; int ID = -1; string unitnum = ""; apptID = pqe.apptID; documentTemplateID = pqe.documentTemplateID; ID = pqe.ID; unitnum = pqe.unitnum; if (string.IsNullOrEmpty(unitnum) || apptID < 1 || ID < 1 || documentTemplateID < 1) { string mrn = string.IsNullOrEmpty(unitnum) ? "" : unitnum; Logger.Instance.WriteToLog("RiskApps3 PrintQueueForm: Cannot print document { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); printSelectedBackgroundWorker.ReportProgress(percent, "RiskApps3 PrintQueueForm: Cannot print document { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); continue; } bool printFailed = false; Model.Clinic.Letters.PrintUtils printUtils = new Model.Clinic.Letters.PrintUtils(); //////////////////////////////////////////////////////// // documentType defaults to WORD in V3 Batch Printing // //////////////////////////////////////////////////////// if (string.IsNullOrEmpty(pqe.docType)) { pqe.docType = "WORD"; } if (pqe.docType.ToUpper() == "HTML") { if (printUtils.printHtmlDoc(apptID, unitnum, documentTemplateID) == null) { printFailed = true; string mrn = string.IsNullOrEmpty(unitnum) ? "" : unitnum; Logger.Instance.WriteToLog("RiskApps3 PrintQueueForm: Printing failed for { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); printSelectedBackgroundWorker.ReportProgress(percent, "RiskApps3 PrintQueueForm: HTML printing failed for { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); } } else if (pqe.docType.ToUpper() == "WORD") { if (printUtils.printWordDoc(apptID, unitnum, documentTemplateID) == false) { printFailed = true; string mrn = string.IsNullOrEmpty(unitnum) ? "" : unitnum; Logger.Instance.WriteToLog("RiskApps3 PrintQueueForm: Printing failed for { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); printSelectedBackgroundWorker.ReportProgress(percent, "RiskApps3 PrintQueueForm: Word printing failed for { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); } } if (printFailed == false) { ParameterCollection pc = new ParameterCollection(); pc.Add("apptID", apptID); pc.Add("documentTemplateID", documentTemplateID); pc.Add("dateTime", DateTime.Now); string sqlStr = "INSERT INTO tblDocuments([apptID],[documentTemplateID],[created],[createdBy]) VALUES(@apptID, @documentTemplateID, @dateTime, 'BatchPrint');"; BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); pc.Clear(); pc.Add("ID", ID); sqlStr = "UPDATE tblPrintQueue SET printed='" + DateTime.Now + "' WHERE ID = @ID;"; BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); printSelectedBackgroundWorker.ReportProgress(percent, "Printed document: template " + documentTemplateID.ToString() + "\r\nFor appt " + apptID.ToString() + " (MRN: " + unitnum + ")"); } else { printSelectedBackgroundWorker.ReportProgress(percent, "Failed to print document: template " + documentTemplateID.ToString() + "\r\nFor appt " + apptID.ToString() + " (MRN: " + unitnum + ")"); } //Thread.Sleep(1000); } }
private void printSelectedBackgroundWorker_DoWork(object sender, DoWorkEventArgs e) { if (printSelectedBackgroundWorker.CancellationPending) { e.Cancel = true; return; } float i = 0; float count = selectedList.Count; foreach (PrintQueueEntry pqe in selectedList) { if (printSelectedBackgroundWorker.CancellationPending) { e.Cancel = true; return; } int percent = (int)((++i * 100.0f) / count); int apptID = -1; int documentTemplateID = -1; int ID = -1; string unitnum = ""; apptID = pqe.apptID; documentTemplateID = pqe.documentTemplateID; ID = pqe.ID; unitnum = pqe.unitnum; if (string.IsNullOrEmpty(unitnum) || apptID < 1 || ID < 1 || documentTemplateID < 1) { string mrn = string.IsNullOrEmpty(unitnum) ? "" : unitnum; Logger.Instance.WriteToLog("RiskApps3 PrintQueueForm: Cannot print document { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); printSelectedBackgroundWorker.ReportProgress(percent, "RiskApps3 PrintQueueForm: Cannot print document { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); continue; } bool printFailed = false; Model.Clinic.Letters.PrintUtils printUtils = new Model.Clinic.Letters.PrintUtils(); //////////////////////////////////////////////////////// // documentType defaults to WORD in V3 Batch Printing // //////////////////////////////////////////////////////// if (string.IsNullOrEmpty(pqe.docType)) { pqe.docType = "WORD"; } if (pqe.docType.ToUpper() == "HTML") { if (printUtils.printHtmlDoc(apptID, unitnum, documentTemplateID) == null) { printFailed = true; string mrn = string.IsNullOrEmpty(unitnum) ? "" : unitnum; Logger.Instance.WriteToLog("RiskApps3 PrintQueueForm: Printing failed for { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); printSelectedBackgroundWorker.ReportProgress(percent, "RiskApps3 PrintQueueForm: HTML printing failed for { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); } } else if (pqe.docType.ToUpper() == "WORD") { if (printUtils.printWordDoc(apptID, unitnum, documentTemplateID) == false) { printFailed = true; string mrn = string.IsNullOrEmpty(unitnum) ? "" : unitnum; Logger.Instance.WriteToLog("RiskApps3 PrintQueueForm: Printing failed for { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); printSelectedBackgroundWorker.ReportProgress(percent, "RiskApps3 PrintQueueForm: Word printing failed for { unitnum=" + mrn + ", apptID=" + apptID.ToString() + ", documentTemplateID=" + documentTemplateID.ToString() + " }"); } } if (printFailed == false) { ParameterCollection pc = new ParameterCollection(); pc.Add("apptID", apptID); pc.Add("documentTemplateID", documentTemplateID); pc.Add("dateTime", DateTime.Now); string sqlStr = "INSERT INTO tblDocuments([apptID],[documentTemplateID],[created],[createdBy]) VALUES(@apptID, @documentTemplateID, @dateTime, 'BatchPrint');"; BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); pc.Clear(); pc.Add("ID", ID); sqlStr = "UPDATE tblPrintQueue SET printed='" + DateTime.Now + "' WHERE ID = @ID;"; BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); printSelectedBackgroundWorker.ReportProgress(percent, "Printed document: template " + documentTemplateID.ToString() + "\r\nFor appt " + apptID.ToString() + " (MRN: " + unitnum + ")"); } else { printSelectedBackgroundWorker.ReportProgress(percent, "Failed to print document: template " + documentTemplateID.ToString() + "\r\nFor appt " + apptID.ToString() + " (MRN: " + unitnum + ")"); } //Thread.Sleep(1000); } }
/// <summary> /// This is the core automation routine that checks for appointments and processes each. /// </summary> private void RunAutomationCycle() { List<int> apptIDs = new List<int>(); /*********************** get appointments to automate ********************/ SqlDataReader reader; string CustomAutomationString = Configurator.getNodeValue("DatabaseInfo", "AUTOMATION_SQL"); if (string.IsNullOrEmpty(CustomAutomationString) == false) { reader = BCDB2.Instance.ExecuteReader(CustomAutomationString); } else { reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_Automation", null); } try { while (reader.Read()) { if (reader.IsDBNull(0) == false) apptIDs.Add(reader.GetInt32(0)); } } catch (Exception e) { Logger.Instance.WriteToLog("Error getting appointment IDs: " + e.ToString()); } finally { if (reader != null) reader.Close(); } backgroundWorker1.ReportProgress(0, apptIDs.Count.ToString() + " appointments are marked for automation - " + DateTime.Now.ToString()); /*********************** automation cycle ********************/ foreach (int apptid in apptIDs) { if (backgroundWorker1.CancellationPending) break; /*********************** Get Unitnum & set active patient ********************/ string unitnum = ""; ParameterCollection pc = new ParameterCollection("apptID", apptid); using (reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_3_GetUnitnum", pc)) { if (reader != null && reader.Read()) { unitnum = reader.GetValue(0).ToString(); } } SessionManager.Instance.SetActivePatientNoCallback(unitnum, (int)apptid); /*********************** Risk Calculations ********************/ try { backgroundWorker1.ReportProgress(1, "Running risk calculations for appointment: " + apptid.ToString() + "."); SessionManager.Instance.GetActivePatient().RecalculateRisk(); } catch (Exception e) { backgroundWorker1.ReportProgress(1, "Risk calculations FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } /*********************** Update BigQueue ********************/ try { backgroundWorker1.ReportProgress(1, "Updating BigQueue for appointment: " + apptid.ToString() + "."); pc = new ParameterCollection("unitnum", unitnum); BCDB2.Instance.RunSPWithParams("sp_3_populateBigQueue", pc); } catch (Exception e) { backgroundWorker1.ReportProgress(1, "Updating BigQueue FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } /*********************** Process Queue Documents ********************/ backgroundWorker1.ReportProgress(1, "Processing Queue Documents for appointment: " + apptid.ToString() + "."); pc = new ParameterCollection("apptID", apptid); BCDB2.Instance.RunSPWithParams("sp_processQueueDocuments", pc); /*********************** Run Automation Stored Procedures ********************/ backgroundWorker1.ReportProgress(1, "Run Automation Stored Procedures : " + apptid.ToString() + "."); RiskAppCore.ApptUtils.runAutomationStoredProcedures(apptid); /*********************** export HL7 files ********************/ backgroundWorker1.ReportProgress(1, "Export HL7 File: " + apptid.ToString() + "."); RiskModels.RiskService.exportHL7File(apptid); /*********************** Process Batch Print Queue Documents ********************/ backgroundWorker1.ReportProgress(1, "Processing batch print queue documents for appointment: " + apptid.ToString() + "."); // Make batch + printing a single progress report ??? RiskAppCore.ApptUtils.saveAutomationDocumentsToPrintQueue(apptid); /*********************** Print Documents ********************/ string print_report = ""; try { backgroundWorker1.ReportProgress(1, "Printing documents for appointment: " + apptid.ToString() + "."); // Make batch + printing a single progress report ??? ParameterCollection printDocArgs = new ParameterCollection(); printDocArgs.Add("apptid", apptid); reader = BCDB2.Instance.ExecuteReaderSPWithParams("sp_AutomationHtmlDocsToPrint", printDocArgs); while (reader.Read()) { int templateID = -1; string printer = ""; string documentType = ""; string saveLocation = ""; if (reader.IsDBNull(0) == false) { templateID = reader.GetInt32(0); } if (reader.IsDBNull(1) == false) { printer = reader.GetString(1); } if (reader.IsDBNull(2) == false) { documentType = reader.GetString(2); } if (reader.IsDBNull(3) == false) { saveLocation = reader.GetString(3); } /////////////////////////////////////////////////// // documentType defaults to HTML in V3 Automation // /////////////////////////////////////////////////// if (string.IsNullOrEmpty(documentType)) { documentType = "HTML"; } RiskApps3.Model.Clinic.Letters.PrintUtils printUtils = new RiskApps3.Model.Clinic.Letters.PrintUtils(printer); if (printer.ToLower().StartsWith("save as")) { if (string.IsNullOrEmpty(saveLocation) == false) { if (documentType.ToUpper() == "HTML") { if (string.Compare(printer, "save as pdf", true) == 0) { if (printUtils.savePdfDoc(apptid, unitnum, templateID, saveLocation) == true) { print_report += "Saved document template " + templateID.ToString() + " in " + saveLocation + "<br/>"; } } else { if (printUtils.saveHtmlDoc(apptid, unitnum, templateID, saveLocation) == true) { print_report += "Saved document template " + templateID.ToString() + " in " + saveLocation + "<br/>"; } } } else if (documentType.ToUpper() == "WORD") { if (printUtils.saveWordDoc(apptid, unitnum, templateID, saveLocation) == true) { print_report += "Saved document template " + templateID.ToString() + " in " + saveLocation + "<br/>"; } } } } else if (printer == "BATCH") { pc = new ParameterCollection(); pc.Add("apptid", apptid); pc.Add("dateTime", DateTime.Now); pc.Add("templateID", templateID); pc.Add("unitnum", unitnum); pc.Add("documentType", documentType); string sqlStr = "INSERT INTO tblPrintQueue (apptID, created, documentTemplateID, unitnum, automationPrint, automationSave, documentType) VALUES (@apptid, @dateTime, @templateID, @unitnum, 0, 0, @documentType)"; int rowsAffected = BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); print_report += "Sent document template " + templateID.ToString() + " to the batch print queue." + "<br/>"; backgroundWorker1.ReportProgress(2, "Appt " + apptid.ToString() + ":<br/>" + print_report); } else if (printer == "") { } else if (string.IsNullOrEmpty(printer) == false) { if (documentType.ToUpper() == "WORD") { if (printUtils.printWordDoc(apptid, unitnum, templateID)) { print_report += "Sent document template " + templateID.ToString() + " to printer: " + printUtils.getPrinter() + "<br/>"; pc = new ParameterCollection(); pc.Add("apptid", apptid); pc.Add("templateID", templateID); pc.Add("dateTime", DateTime.Now); string sqlStr = "INSERT INTO tblDocuments([apptID],[documentTemplateID],[created],[createdBy]) VALUES(@apptid, @templateID, @dateTime, 'AUTOMATION');"; BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); } else { print_report += "Failed sending document template " + templateID.ToString() + " to printer: " + printUtils.getPrinter() + "<br/>"; } backgroundWorker1.ReportProgress(2, "Appt " + apptid.ToString() + ":<br/>" + print_report); } else if (documentType.ToUpper() == "HTML") { HraHtmlDocument hdoc; if ((hdoc = printUtils.printHtmlDoc(apptid, unitnum, templateID)) != null) { print_report += "Sent document template " + templateID.ToString() + " to printer: " + hdoc.targetPrinter + "<br/>"; pc = new ParameterCollection(); pc.Add("apptid", hdoc.apptid); pc.Add("templateID", hdoc.template.documentTemplateID); pc.Add("dateTime", DateTime.Now); string sqlStr = "INSERT INTO tblDocuments([apptID],[documentTemplateID],[created],[createdBy]) VALUES(@apptid, @templateID, @dateTime, 'AUTOMATION');"; int rowsAffected = BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); backgroundWorker1.ReportProgress(2, hdoc.template.htmlText + Environment.NewLine + "Appt " + apptid.ToString() + ":<br/>" + print_report); } else { print_report += "Failed to send document template " + templateID.ToString() + " to printer: " + printUtils.getPrinter() + "<br/>"; backgroundWorker1.ReportProgress(2, "Appt " + apptid.ToString() + ":<br/>" + print_report); } } else if (documentType != "HTML" && documentType != "WORD") { print_report += "Could not process document: templateID " + templateID.ToString() + ", printer: " + printer + ", UNKOWN DOCUMENT TYPE: \"" + documentType + "\"<br/>"; backgroundWorker1.ReportProgress(2, "Appt " + apptid.ToString() + ":<br/>" + print_report); } } } } catch (Exception e) { backgroundWorker1.ReportProgress(1, "Printing FAILED for appointment: " + apptid.ToString() + ". " + e.ToString()); } finally { if (reader != null) reader.Close(); } /*********************** Mark as printed to complete automation ********************/ try { pc = new ParameterCollection("apptid", apptid); String sqlStr = "UPDATE tblRiskData SET printed = 1 WHERE apptid = @apptid"; int rowsAffected = BCDB2.Instance.ExecuteNonQueryWithParams(sqlStr, pc); } catch (Exception e) { backgroundWorker1.ReportProgress(1, ("Automation - unable to update appt id=" + apptid.ToString() + " printed=1.\n" + e.ToString())); } if (status != null) { try { status.LogStatus(idString, "Automation", "Ok", ("Appt " + apptid + " " + print_report).Trim()); } catch (System.Web.Services.Protocols.SoapException e) { //do nothing } catch (Exception ex) { Logger.Instance.WriteToLog(ex.ToString()); } } } }