Report.cs

//
// Copyright (c) 2022 by Acentus
// Developed by: Luis Cabrera
// gigocabrera@outlook.com
//

using System;
using System.Configuration;
using System.Data;
using System.Threading.Tasks;

namespace CoreOrderConfirmationEmailToPatient
{
    class Report
    {
        JobCenterHistoryLogger logHeader = new JobCenterHistoryLogger();
        JobCenterHistoryLoggerDetails logDetails = new JobCenterHistoryLoggerDetails();

        private DataAccess db = new DataAccess();

        public async Task RunReport()
        {
            try
            {
                //
                // START LOGGING
                //
                logHeader = new JobCenterHistoryLogger(DateTime.Now, DateTime.Now, JobCenterHistoryLogger.StatusEnum.Running, "Report started");
                logDetails = new JobCenterHistoryLoggerDetails(logHeader.HistoryId, "Test Mode: " + ConfigurationManager.AppSettings["TestMode"]);
                logDetails = new JobCenterHistoryLoggerDetails(logHeader.HistoryId, "Subject: " + ConfigurationManager.AppSettings["subject"]);
                logDetails = new JobCenterHistoryLoggerDetails(logHeader.HistoryId, "Email From: " + ConfigurationManager.AppSettings["emailFrom"]);
                logDetails = new JobCenterHistoryLoggerDetails(logHeader.HistoryId, "Email To: " + ConfigurationManager.AppSettings["emailTo"]);
                logDetails = new JobCenterHistoryLoggerDetails(logHeader.HistoryId, "Report Date: " + DateTime.Today.ToShortDateString());

                // Get HTML template for report
                string htmlPatient = Utils.GetTemplate("EmailTemplate.html");
                string htmlList = Utils.GetTemplate("EmailList.html");

                // Get data
                DataTable dt = db.GetData();


                // Populate template
                await PopulateTemplate(dt, htmlList);

                logDetails = new JobCenterHistoryLoggerDetails(logHeader.HistoryId, "Email: Sent Successfully");

                logHeader.EndTime = DateTime.Now;
                logHeader.Message = "Report Completed";
                logHeader.Status = JobCenterHistoryLogger.StatusEnum.Success;
                logHeader.Update();
            }
            catch (Exception ex)
            {
                Log.write(string.Format("REPORT EXCEPTION: " + ex.Message));

                logHeader.EndTime = DateTime.Now;
                logHeader.Status = JobCenterHistoryLogger.StatusEnum.Error;
                logHeader.Message = ex.Message;
                logHeader.Update();
                throw;
            }
        }

        private async Task PopulateTemplate(DataTable listItems, string htmlList)
        {
            int iTotal = 0;
            string tr = string.Empty;
            string reportDate = DateTime.Today.ToShortDateString();
            string strDetails = GetDetailsTemplate(ref htmlList);
            string strThisDetails = strDetails;
            string list1 = string.Empty;
            string thisHtml = htmlList;

            if (listItems != null && listItems.Rows.Count > 0)
            {
                Log.write("Records returned: " + listItems.Rows.Count.ToString());

                int prevPatientId = 0;
                string prevPONUmber = string.Empty;
                DateTime prevServiceDate = DateTime.MinValue;

                foreach (DataRow item in listItems.Rows)
                {
                    iTotal++;

                    int thisPatientId = item.Field<int>("PATIENTID");
                    string FullName = item.Field<string>("FULLNAME");
                    string thisPONumber = item.Field<string>("INVOICENO");
                    DateTime thisAddedDate = item.Field<DateTime>("ADDEDONDATE");
                    DateTime thisServiceDate = item.Field<DateTime>("SVCDATE");
                    string thisEmail = item.Field<string>("EMAIL");

                    // Logic when there are multiple service dates for the same patient, invoice number, and added on date
                    string strServiceDates = thisServiceDate.ToShortDateString();
                    string strComma = ", ";
                    if (thisPatientId == prevPatientId)
                    {
                        if (thisPONumber != prevPONUmber)
                        {
                            if (thisServiceDate != prevServiceDate)
                            {
                                strServiceDates += strComma + prevServiceDate.ToShortDateString();
                            }
                        }
                    }

                    string emailTemplateHtml = Utils.GetTemplate("emailTemplate.html");
                    emailTemplateHtml = emailTemplateHtml.Replace("[PATIENT_NAME]", FullName);
                    emailTemplateHtml = emailTemplateHtml.Replace("[ADDED_DATE]", thisAddedDate.ToShortDateString());
                    emailTemplateHtml = emailTemplateHtml.Replace("[SERVICE_DATE]", strServiceDates);
                    
                    if (!string.IsNullOrEmpty(thisEmail))
                    {
                        try
                        {
                            // Send confirmation email to customer
                            SendEmailToPatient(thisPatientId.ToString(), emailTemplateHtml, thisServiceDate.ToShortDateString(), thisEmail);
                            InsertContactNoteToPatient(thisPatientId.ToString(), strServiceDates, emailTemplateHtml);
                        }
                        catch
                        {
                            // Let the application continue
                        }
                    }
                    
                    // Populate the main report
                    strThisDetails = strDetails;
                    strThisDetails = strThisDetails.Replace("[PATIENT_ID]", thisPatientId.ToString());
                    strThisDetails = strThisDetails.Replace("[PATIENT_NAME]", FullName);
                    strThisDetails = strThisDetails.Replace("[EMAIL]", thisEmail);
                    strThisDetails = strThisDetails.Replace("[INVOICE_NUMBER]", thisPONumber);
                    strThisDetails = strThisDetails.Replace("[ADDED_ON_DATE]", thisAddedDate.ToShortDateString());
                    strThisDetails = strThisDetails.Replace("[SERVICE_DATE]", strServiceDates);
                    tr += strThisDetails;

                    prevPatientId = thisPatientId;
                    prevPONUmber = thisPONumber;
                    prevServiceDate = thisServiceDate;
                }

                //
                // Prepare report details
                //
                thisHtml = thisHtml.Replace("[TOTAL_PATIENTS]", iTotal.ToString());
                thisHtml = thisHtml.Replace("[GRID_HERE]", tr);
                thisHtml = thisHtml.Replace("[REPORT_DATE]", App.DateSpan);
                thisHtml = thisHtml.Replace("[DETAILS1_HERE]", tr);

                // only send report if there is data
                if (iTotal > 0)
                {
                    await Utils.SendEmailWithModernAuthentication("0000", thisHtml, "Confirmation Email to Patients Report", "");
                    Log.write("Report completed");
                }
                else
                {
                    Log.write("Report not sent - NO DATA");
                }
            }
            else
            {
                Log.write("No data found for the report that matched the criteria specified");
            }
        }

        private string GetDetailsTemplate(ref string html)
        {
            int iFirstIndex = html.IndexOf("[DETAIL1_START]");
            int iFirstIndexDetails = iFirstIndex + 15;
            int iLastIndexDetails = html.IndexOf("[/DETAIL1_END]");
            int iLastIndex = iLastIndexDetails + 14;
            int iTotalLenght = html.Length;
            string strTemplate = html.Substring(iFirstIndexDetails, iLastIndexDetails - iFirstIndexDetails);
            html = html.Substring(0, iFirstIndex) + "[DETAILS1_HERE]" + html.Substring(iLastIndex, iTotalLenght - iLastIndex);
            return strTemplate;
        }

        private async void SendEmailToPatient(string id, string html, string serviceDate, string emailTo)
        {
            await Utils.SendEmailWithModernAuthentication(id, html, "Acentus Order Confirmation", emailTo);
        }

        private void InsertContactNoteToPatient(string id, string serviceDate, string html)
        {
            string testMode = System.Configuration.ConfigurationManager.AppSettings["TestMode"];
            if (testMode == "True")
            {
                // Do nothing. 
            }
            else
            {
                string note = "ORDER CONFIRMATION EMAIL SENT CONFIRMING PATIENT’S AUTHORIZATION TO SHIP FOR NEXT DOS OF " + serviceDate;
                db.InsertNote(id, note, html);
                Log.write("Contact note added successfully to : " + id + " - " + id);
            }            
        }
    }
}