using framework_business.objects.custom;
using framework_library;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Reflection;
using System.Text;
using System.Web;

namespace framework_business
{
    public class xSales
    {
        /// <summary>
        /// Adds a note with an attachment after statement has been created
        /// </summary>
        /// <param name="noteEntityId"></param>
        /// <param name="noteTitle"></param>
        /// <param name="noteCaption"></param>
        /// <param name="statementPath"></param>
        /// <param name="statementFile"></param>
        public static void AddCreateStatementNote(int noteEntityId, string noteTitle, string noteCaption, string statementPath, string statementFile,
            int userId, string fieldName)
        {
            try
            {
                /* CVH 2016-04-20 Change from module Procedures to Surface, and type General to Statement */

                oNote note = new oNote();
                note.moduleId = pNums.Module.Surface.GetHashCode();
                note.typeId = pNums.NoteType.Statement.GetHashCode();
                note.entityId = noteEntityId;
                note.title = noteTitle;
                note.caption = noteCaption;
                note.dateSaved = DateTime.Now;
                note.userIdSaved = userId;
                note.isActive = true;
                note.fieldName = fieldName;
                note.recId = xData.SaveTyped("recId", typeof(oNote), note);

                //add statement as attachment to note
                oAttachment noteAtt = new oAttachment();
                noteAtt.dateSaved = DateTime.Now;
                noteAtt.display = note.title;
                noteAtt.entityId = note.recId;
                noteAtt.fileName = noteAtt.entityId + "_" + utils.RandomString(9, true) + statementFile.Substring(statementFile.IndexOf("."), statementFile.Length - statementFile.IndexOf("."));
                noteAtt.folderName = "note/" + note.recId;
                noteAtt.isActive = true;
                noteAtt.moduleId = pNums.Module.Notes.GetHashCode();
                noteAtt.typeId = pNums.AttachmentType.Document.GetHashCode();
                noteAtt.userIdSaved = note.userIdSaved;
                //CVH 2016-10-28 Save PDF to file folder, not straight in root of note item folder
                string copyTo = HttpContext.Current.Server.MapPath("~/upload/" + noteAtt.folderName + "/file/");
                utils.validateFolder(copyTo);
                System.IO.File.Copy(statementPath + statementFile, copyTo + noteAtt.fileName);
                noteAtt.recId = xData.SaveTyped("recId", typeof(oAttachment), noteAtt);
            }
            catch (Exception ex)
            {
                //log don't redirect
                exception.HandleException("enquiry:", MethodBase.GetCurrentMethod().Name, ex, userId);
            }
        }

        /// <summary>
        /// string to build the account lines
        /// </summary>
        /// <param name="accountList"></param>
        /// <param name="balforward">day brough forward</param>
        /// <param name="statementDate"></param>
        /// <param name="includeHidden"></param>
        /// <param name="lineCount"></param>
        /// <param name="fromZero"></param>
        /// <param name="accountMain"></param>
        /// <returns></returns>
        private static string BuildSalesStatementLines(oSales accountMain, ArrayList salesList, ovSalesView salesView, DateTime? statementDateFrom = null, DateTime? statementDateTo = null)
        {
            StringBuilder lineResult = new StringBuilder();
            try
            {
                decimal dOpening = 0M;

                if (statementDateFrom != null)
                {
                    foreach (ovSalesView salesViewItem in salesList)
                    {
                        if (salesViewItem.dateOfService < statementDateFrom)
                        {
                            dOpening = dOpening + salesViewItem.RunningBalance;
                        }
                    }
                }

                //set running balance based on records
                decimal bal = 0;
                foreach (ovSalesView salesViewItem in salesList)
                {
                    if (salesViewItem.itemType != "QT")
                    {
                        bal += salesViewItem.Invoiced;
                        bal += (Math.Abs(salesViewItem.Received) * -1);
                        salesViewItem.RunningBalance = bal;
                    }
                }

                if (handler.ReturnSetup().code == "SHEN-1")
                {
                    lineResult.AppendLine("<br/>");
                    lineResult.AppendLine("<br/>");
                }
                lineResult.AppendLine("<table cellpadding='1' style='width:100%;'>");

                lineResult.AppendLine("<tr style='background-color: #F0F0F0;border-bottom: 1px solid #000000;'>");

                lineResult.AppendLine("<td style='width:15%;'><b>Date</b></td>");
                lineResult.AppendLine("<td style='width:25%;'><b>Activity</b></td>");
                lineResult.AppendLine("<td style='width:15%; text-align:center;'><b>Reference</b></td>");
                lineResult.AppendLine("<td style='width:15%; text-align:right;'><b>Amount</b></td>");
                lineResult.AppendLine("<td style='width:15%; text-align:right;'><b>Payments</b></td>");
                lineResult.AppendLine("<td style='width:15%; text-align:right;'><b>Balance ZAR</b></td>");

                lineResult.AppendLine("</tr>");

                if (statementDateFrom != null)
                {
                    lineResult.AppendLine("<tr>");

                    lineResult.AppendLine($"<td>{((DateTime)statementDateFrom).ToString("dd-MMM-yy")}</td>");
                    lineResult.AppendLine("<td>Opening Balance</td>");
                    lineResult.AppendLine("<td style='text-align:center;'></td>");
                    lineResult.AppendLine("<td style='text-align:right;'></td>");
                    lineResult.AppendLine("<td style='text-align:right;'></td>");
                    lineResult.AppendLine($"<td style='text-align:right;'>{dOpening:F2}</td>");

                    lineResult.AppendLine("</tr>");
                }
                foreach (ovSalesView salesViewItem in salesList)
                {
                    /* CVH 2016-08-18 If printing statement on 2016-08-18, I want to see the invoice that was captured at 11am on that day. Exclude Time from date comparison */
                    //if (salesViewItem.itemType != "QT" && salesViewItem.dateOfService >= statementDateFrom && salesViewItem.dateOfService <= statementDateTo)
                    if (salesViewItem.itemType != "QT" && salesViewItem.dateOfService.Date >= statementDateFrom && salesViewItem.dateOfService.Date <= statementDateTo)
                    {
                        lineResult.AppendLine("<tr>");

                        lineResult.AppendLine($"<td>{salesViewItem.dateOfService.ToString("dd-MMM-yy")}</td>");
                        lineResult.AppendLine($"<td>{salesViewItem.Display}</td>");
                        lineResult.AppendLine($"<td style='text-align:center;'>{salesViewItem.reference}</td>");
                        if (salesViewItem.Invoiced > 0)
                            lineResult.AppendLine($"<td style='text-align:right;'>{salesViewItem.Invoiced:F2}</td>");
                        else
                            lineResult.AppendLine($"<td style='text-align:right;'></td>");
                        if (salesViewItem.Received > 0)
                            lineResult.AppendLine($"<td style='text-align:right;'>{salesViewItem.Received:F2}</td>");
                        else
                            lineResult.AppendLine($"<td style='text-align:right;'></td>");
                        lineResult.AppendLine($"<td style='text-align:right;'>{salesViewItem.RunningBalance:F2}</td>");

                        lineResult.AppendLine("</tr>");
                    }
                }

                lineResult.AppendLine("</table> ");
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
            return lineResult.ToString();
        }

        private static string BuildSalesReceiptLines(oSales accountMain, ArrayList salesList, ovSalesView salesView)
        {
            StringBuilder lineResult = new StringBuilder();
            try
            {
                lineResult.AppendLine("<table cellpadding='1' style='width:100%;'>");

                lineResult.AppendLine("<tr style='background-color: #F0F0F0;border-bottom: 1px solid #000000;'>");

                lineResult.AppendLine("<td style='width:15%;'><b>Date</b></td>");
                lineResult.AppendLine("<td style='width:55%;'><b>Description</b></td>");
                lineResult.AppendLine("<td style='width:15%; text-align:center;'><b>Reference</b></td>");
                lineResult.AppendLine("<td style='width:15%; text-align:right;'><b>Payments</b></td>");

                lineResult.AppendLine("</tr>");

                foreach (ovSalesView salesViewItem in salesList)
                {
                    lineResult.AppendLine("<tr>");

                    lineResult.AppendLine($"<td>{salesViewItem.dateOfService.ToString("dd-MMM-yy")}</td>");
                    lineResult.AppendLine($"<td>{salesViewItem.Display}</td>");
                    lineResult.AppendLine($"<td style='text-align:center;'>{salesViewItem.reference}</td>");
                    lineResult.AppendLine($"<td style='text-align:right;'>{salesViewItem.Received:F2}</td>");

                    lineResult.AppendLine("</tr>");
                }

                lineResult.AppendLine("</table> ");
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
            return lineResult.ToString();
        }



        /// <summary>
        /// Create Statement
        /// </summary>
        /// <param name="accountMain"></param>
        /// <param name="webAddress"></param>
        /// <param name="balforward"></param>
        /// <param name="showHidden"></param>
        /// <param name="lineCount"></param>
        /// <param name="fromZero"></param>
        /// <param name="statementDate"></param>
        /// <param name="statementPath"></param>
        /// <param name="statementFile"></param>
        /// <returns></returns>
        public static bool CreateSalesDocument(oSales salesMain, string webAddress, DateTime documentDate, DateTime? statementDateFrom, DateTime? statementDateTo, ref string statementPath, ref string statementFile, pNums.DocumentType docType, string documentNo = "")
        {
            try
            {
                bool result = false;
                oSetup setup = (oSetup)(xData.GetTypedByCriteriaSpecific("recId", typeof(oSetup), "isActive", "1")[0]);
                string headerData = String.Empty;
                string bodyData = String.Empty;
                ovSalesView salesView = new ovSalesView();
                ArrayList salesItemList = new ArrayList();

                switch (docType)
                {
                    case pNums.DocumentType.Statement:
                        salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(ovSalesView), "surfaceItemId", salesMain.surfaceItemId.ToString(), "dateOfService, CASE WHEN invoiceNo > 0 THEN CAST(invoiceNo AS VARCHAR(20)) ELSE itemType END ", "pal_");
                        if (salesItemList.Count > 0)
                            salesView = (ovSalesView)salesItemList[0];
                        foreach (oSales sale in xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,itemType", salesMain.surfaceItemId.ToString() + ",~<>QT", "dateOfService DESC"))
                        {
                            salesMain = sale;
                            break;
                        }
                        break;
                    case pNums.DocumentType.Invoice:
                        if (handler.ReturnSetup().code == "CAPI-1")
                        {
                            salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oSalesItemsFinal), "ParentSurfaceItemId", salesMain.recId.ToString(), "", "publ_");
                        }
                        else
                        {
                            salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(ovSalesView), "surfaceItemId", salesMain.surfaceItemId.ToString(), "dateOfService, CASE WHEN invoiceNo > 0 THEN CAST(invoiceNo AS VARCHAR(20)) ELSE itemType END ", "pal_");
                        }
                        if (salesItemList.Count > 0)
                            salesView = (ovSalesView)salesItemList[0];
                        salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,invoiceNo,itemType", salesMain.surfaceItemId.ToString() + "," + documentNo + ",TI", "sequence");
                        if (salesItemList.Count > 0)
                            salesMain = (oSales)salesItemList[0];
                        break;

                    case pNums.DocumentType.Quote:
                        if (handler.ReturnSetup().code == "CAPI-1")
                        {
                            salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oQuoteItemsFinal), "ParentSurfaceItemId,isActive,status", salesMain.surfaceItemId.ToString() + ",1,1", "QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalSequenceNumber", "publ_");
                        }
                        else
                        {
                            salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(ovSalesView), "surfaceItemId", salesMain.surfaceItemId.ToString(), "dateOfService, CASE WHEN invoiceNo > 0 THEN CAST(invoiceNo AS VARCHAR(20)) ELSE itemType END ", "pal_");
                        }
                        if (salesItemList.Count > 0)
                            salesView = (ovSalesView)salesItemList[0];
                        salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,invoiceNo,itemType", salesMain.surfaceItemId.ToString() + "," + documentNo + ",QT", "sequence");
                        if (salesItemList.Count > 0 && salesMain == null)
                            salesMain = (oSales)salesItemList[0];
                        break;

                    case pNums.DocumentType.Receipt:
                        //CVH 2016-09-20 Get salesView and salesMain for specific document number
                        //salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oSalesView), "surfaceItemId,itemType", salesMain.surfaceItemId.ToString() + ",PM", "dateOfService, CASE WHEN invoiceNo > 0 THEN CAST(invoiceNo AS VARCHAR(20)) ELSE itemType END ", "pal_");
                        salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(ovSalesView), "surfaceItemId,itemType,receiptNo", salesMain.surfaceItemId.ToString() + ",PM," + documentNo, "dateOfService, CASE WHEN invoiceNo > 0 THEN CAST(invoiceNo AS VARCHAR(20)) ELSE itemType END ", "pal_");
                        if (salesItemList.Count > 0)
                            salesView = (ovSalesView)salesItemList[0];
                        foreach (oSales sale in xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,itemType,receiptNo", salesMain.surfaceItemId.ToString() + ",PM," + documentNo, "dateOfService DESC"))
                        {
                            salesMain = sale;
                            break;
                        }
                        break;
                    case pNums.DocumentType.CreditNote:
                        salesItemList = xData.GetTypedByCriteriaSpecific("recId", typeof(ovSalesView), "surfaceItemId,itemType,invoiceNo", salesMain.surfaceItemId.ToString() + ",CN," + documentNo, "dateOfService", "pal_");
                        if (salesItemList.Count > 0)
                            salesView = (ovSalesView)salesItemList[0];
                        foreach (oSales sale in xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,itemType,invoiceNo", salesMain.surfaceItemId.ToString() + ",CN," + documentNo, "dateOfService DESC"))
                        {
                            salesMain = sale;
                            break;
                        }
                        break;
                    default:
                        break;
                }

                //get templates
                foreach (oTemplate template in xData.GetTypedByCriteriaSpecific("recId", typeof(oTemplate), "templateTypeId", pNums.TemplateType.Sales.GetHashCode().ToString(), "templateName"))
                {
                    if (template.templateName.ToLower().Contains("header"))
                    {
                        headerData = template.templateContent;
                    }
                    else if (template.templateName.ToLower().Contains("body"))
                    {
                        bodyData = template.templateContent;
                    }
                }

                //set TO/FROM labels
                headerData = headerData.Replace("{To}", docType == pNums.DocumentType.Receipt ? "From" : "To");
                headerData = headerData.Replace("{From}", docType == pNums.DocumentType.Receipt ? "To" : "From");

                //JR 2019-04-27 Contact Details
                StringBuilder sbContactDetails = new StringBuilder();
                sbContactDetails.Append("<b>Contact Details</b><br/>");
                sbContactDetails.Append(setup.tel + "<br/>");
                sbContactDetails.Append(setup.email + "<br/>");

                headerData = headerData.Replace("{contactDetails}", sbContactDetails.ToString());

                //CVH 2016-09-14 Build transaction number with padded 0's 
                switch (docType)
                {
                    case pNums.DocumentType.Statement:
                        headerData = headerData.Replace("{DocDate}", "<span class='subheading'>Statement Date:</span><br/>" + DateTime.Now.ToString("yyyy/MM/dd") + "<br/>");
                        headerData = headerData.Replace("{DocNum}", "");
                        break;
                    case pNums.DocumentType.Invoice:
                        headerData = headerData.Replace("{DocNum}", "<span class='subheading'>Invoice Number:</span><br/>" + BuildNextTransactionNumber(setup.saleINVPrefix, setup.saleINVNumLength, salesMain.invoiceNo) + "<br/>");
                        headerData = headerData.Replace("{DocDate}", "<span class='subheading'>Invoice Date:</span><br/>" + DateTime.Now.ToString("yyyy/MM/dd") + "<br/>");
                        break;
                    case pNums.DocumentType.Quote:
                        headerData = headerData.Replace("{DocNum}", "<span class='subheading'>Quote Number:</span><br/>" + BuildNextTransactionNumber(setup.saleQTEPrefix, setup.saleQTENumLength, salesMain.invoiceNo) + "<br/>");
                        headerData = headerData.Replace("{DocDate}", "<span class='subheading'>Quote Date:</span><br/>" + DateTime.Now.ToString("yyyy/MM/dd") + "<br/>");
                        break;
                    case pNums.DocumentType.Receipt:
                        headerData = headerData.Replace("{DocNum}", "<span class='subheading'>Receipt Number:</span><br/>" + BuildNextTransactionNumber(setup.saleRCTPrefix, setup.saleRCTNumLength, salesMain.receiptNo) + "<br/>");
                        headerData = headerData.Replace("{DocDate}", "<span class='subheading'>Receipt Date:</span><br/>" + DateTime.Now.ToString("yyyy/MM/dd") + "<br/>");
                        break;
                    case pNums.DocumentType.CreditNote:
                        headerData = headerData.Replace("{DocNum}", "<span class='subheading'>Credit Note Number:</span><br/>" + BuildNextTransactionNumber(setup.saleCRNPrefix, setup.saleCRNNumLength, salesMain.invoiceNo) + "<br/>");
                        headerData = headerData.Replace("{DocDate}", "<span class='subheading'>Credit Note Date:</span><br/>" + DateTime.Now.ToString("yyyy/MM/dd") + "<br/>");
                        break;
                    default:
                        headerData = headerData.Replace("{DocNum}", "").Replace("{DocDate}", "");
                        break;
                }
                headerData = headerData.Replace("{AccountNumber}", "<span class='subheading'>Account No:</span><br/>" + salesMain.accountNo + "<br/>");

                if ((docType == pNums.DocumentType.Invoice || docType == pNums.DocumentType.Quote) && salesMain.reference != string.Empty)
                    headerData = headerData.Replace("{Reference}", "<span class='subheading'>Reference:</span><br/>" + salesMain.reference + "<br/>");
                else
                    headerData = headerData.Replace("{Reference}", "");


                string attentionContact = salesMain.surname;
                if (attentionContact == string.Empty)
                    headerData = headerData.Replace("{Attention}", "");
                else
                    headerData = headerData.Replace("{Attention}", "<span class='subheading'>Attention:</span><br/>" + attentionContact + "<br/>");

                /* CVH 2016-08-15 Add address line 5 & 6 (Province/State & Country in line 4 & 5, Postal Code line 6) */
                //replace address breaks
                salesMain.postalAddress = salesMain.postalAddress.Replace("\n", "<br/>").Replace("~|~", "<br/>").Replace("~1~", "").Replace("~2~", "").Replace("~3~", "").Replace("~4~", "").Replace("~5~", "").Replace("~6~", "");

                /* CVH 2016-09-13 Add trading as name to company name */
                string companyName = setup.customer;
                if (setup.tradingAs != String.Empty && !companyName.Contains(" t/a "))
                    companyName += " t/a " + setup.tradingAs;
                headerData = headerData.Replace("{FromName}", companyName);
                headerData = headerData.Replace("{FromAddress}", setup.postalStreet + "<br/>" + setup.postalSuburb + "<br/>" + setup.postalCity + "<br/>" + setup.postalProvinceState + "<br/>" + setup.postalCountry + "<br/>" + setup.postalCode);

                if (setup.vatRegistered)
                {
                    //merge header values
                    headerData = headerData.Replace("{FromTaxDisplayname}", "VAT Number:");
                    headerData = headerData.Replace("{FromTaxDisplayNumber}", setup.vatRegistrationNumber);
                    headerData = headerData.Replace("{SetupVATNumberLabel}", "VAT Number:");
                }
                else
                {
                    headerData = headerData.Replace("{FromTaxDisplayNumber}", "");
                    headerData = headerData.Replace("{FromTaxDisplayname}", "");
                }


                //get item from customers
                string customerVatNumber = string.Empty;
                if (handler.ReturnSetup().code == "CAPI-1")
                {
                    customerVatNumber = GetSalesCustomerVatNumber(salesMain.name);
                }
                else
                {
                    customerVatNumber  = salesMain.vatNum;
                }

                if (customerVatNumber != string.Empty && customerVatNumber != "No")
                {
                    headerData = headerData.Replace("{ToTaxDisplayname}", "VAT Number:");
                    headerData = headerData.Replace("{ToTaxNumber}", customerVatNumber);
                }
                else
                {
                    headerData = headerData.Replace("{ToTaxDisplayname}", "");
                    headerData = headerData.Replace("{ToTaxNumber}", "");
                }

                headerData = headerData.Replace("{oSales.title}", salesMain.title);
                headerData = headerData.Replace("{oSales.name}", salesMain.name);
                headerData = headerData.Replace("{oSales.surname}", salesMain.surname);
                headerData = headerData.Replace("{oSales.postalAddress}", salesMain.postalAddress.Replace(",", "<br/>"));

                utils.MergeHTMData(ref headerData, utils.BuildFieldCodeList(setup, true));
                utils.MergeHTMData(ref headerData, utils.BuildFieldCodeList(salesMain, true));
                //custom values
                headerData = headerData.Replace("{heading}", docType == pNums.DocumentType.Invoice ? "TAX INVOICE" : utils.SplitWords(Enum.GetName(typeof(pNums.DocumentType), docType.GetHashCode())).ToUpper());
                headerData = headerData.Replace("{Date}", documentDate.ToString("yyyy/MM/dd"));

                headerData = headerData.Replace("{WebAddress}", "");
                //cater for image paths
                headerData = headerData.Replace("/images/", webAddress + "/images/");
                headerData = headerData.Replace("/upload/image/", webAddress + "/upload/image/");

                //CVH 2016-09-15 If no logo uploaded, build company name in box
                if (setup.logoUploaded == String.Empty)
                    headerData = headerData.Replace("<td class=\"heading\">{logo}</td>", "<td class=\"heading\" valign=\"middle\"><h2><span style=\"font-family:'MS Sans Serif'; \">" + companyName + "</span></h2></td>");
                else
                    headerData = headerData.Replace("{logo}", "<img src='" + webAddress + "/upload/image/" + setup.logoUploaded + "' style=\"height:85px;\"/>");

                //merge body values
                switch (docType)
                {
                    case pNums.DocumentType.Statement:
                        bodyData = bodyData.Replace("{AccountLines}", BuildSalesStatementLines(salesMain, salesItemList, salesView, statementDateFrom, statementDateTo));
                        bodyData = bodyData.Replace("{Totals}", BuildSalesTotals(salesItemList, docType, statementDateTo));
                        break;
                    case pNums.DocumentType.Invoice:
                        bodyData = bodyData.Replace("{AccountLines}", BuildSalesInvoiceLines(salesItemList, pNums.TemplateType.Sales, true, null, docType));
                        bodyData = bodyData.Replace("{Totals}", BuildSalesTotals(salesItemList, docType, statementDateTo));
                        break;
                    case pNums.DocumentType.Quote:
                        bodyData = bodyData.Replace("{AccountLines}", BuildSalesInvoiceLines(salesItemList, pNums.TemplateType.Sales, true, null, docType));
                        bodyData = bodyData.Replace("{Totals}", BuildSalesTotals(salesItemList, docType, statementDateTo, salesMain));
                        break;
                    case pNums.DocumentType.Receipt:
                        bodyData = bodyData.Replace("{AccountLines}", BuildSalesReceiptLines(salesMain, salesItemList, salesView));
                        bodyData = bodyData.Replace("{Totals}", BuildSalesTotals(salesItemList, docType, statementDateTo));
                        break;
                    case pNums.DocumentType.CreditNote:
                        bodyData = bodyData.Replace("{AccountLines}", BuildSalesReceiptLines(salesMain, salesItemList, salesView));
                        bodyData = bodyData.Replace("{Totals}", BuildSalesTotals(salesItemList, docType, statementDateTo));
                        break;
                    default:
                        break;
                }
                bodyData = bodyData.Replace("{FootNotes}", BuildFootNotes(salesItemList, setup, docType));

                string additionalNotes = "<br/><br/><br/><br/><br/><br/><br/><br/>";

                if (docType == pNums.DocumentType.Receipt)
                    additionalNotes = BuildAdditionalNotes(docType, salesMain.receiptNo);
                else
                    additionalNotes = BuildAdditionalNotes(docType, salesMain.invoiceNo);

                if (handler.ReturnSetup().code == "SHEN-1")
                {
                    bodyData = bodyData.Replace("{AdditionalNotes}", string.Empty);
                }
                else
                {
                    bodyData = bodyData.Replace("{AdditionalNotes}", additionalNotes);
                }

                statementFile = Enum.GetName(typeof(pNums.DocumentType), docType.GetHashCode()) + "_" + salesMain.surfaceItemId + "_" + DateTime.Now.ToString("yyyy-MM-dd-hh-mm") + ".pdf";
                statementPath = HttpContext.Current.Server.MapPath("~/upload/documents/");

                utils.validateFolder(statementPath);

                string columnHeaders = string.Empty;
                columnHeaders = @"<body class='RadEditorContentStyle'>" + GetColumnHeaders(pNums.TemplateType.Sales, true, null) + "</body>";

                result = utils.ConvertHTMLToPDFFile(bodyData, statementPath + statementFile, true, headerData, "", true, "", columnHeaders);

                return result;
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
        }

        public static string BuildFootNotes(ArrayList salesItemList, oSetup setup, pNums.DocumentType docType)
        {
            string returnString = string.Empty;
            StringBuilder footBuilder = new StringBuilder();



            footBuilder.AppendLine("<table><tr><td>");

            /* CVH 2018-08-11 Bank details contained in setup.notesInvoices */
            switch (docType)
            {
                case pNums.DocumentType.Statement:
                    footBuilder.AppendLine(setup.notesStatements);
                    break;
                case pNums.DocumentType.Invoice:
                    DateTime dueDate = new DateTime();
                    foreach (oSales salesItem in salesItemList)
                    {
                        dueDate = salesItem.dateDue;
                    }
                    if (handler.ReturnSetup().code == "SHEN-1")
                    {
                        setup.notesInvoices = setup.notesInvoices.Replace("{DueDate}", dueDate.ToString("dd-MMM-yy"));
                        
                    }
                    else
                    {
                        footBuilder.AppendLine($"<b>Due Date: {dueDate.ToShortDateString()}</b></br>");
                    }
                    footBuilder.AppendLine(setup.notesInvoices);
                    break;
                case pNums.DocumentType.Quote:
                    footBuilder.AppendLine(setup.notesQuotes);
                    break;
                case pNums.DocumentType.Receipt:
                    footBuilder.AppendLine(setup.notesReceipts);
                    break;
                case pNums.DocumentType.CreditNote:
                    footBuilder.AppendLine(setup.notesCreditNotes);
                    break;
                default:
                    break;
            }

            footBuilder.Replace("{oSetup.email}", setup.email);

            /*
            footBuilder.AppendLine("<br/><b>Payment Details</b><br/>");
            footBuilder.AppendLine($"Bank: {setup.bankName}<br/>");
            footBuilder.AppendLine($"A/c No: {setup.bankAccountNumber}<br/>");
            footBuilder.AppendLine($"Branch: {setup.bankBranch}<br/>");
            footBuilder.AppendLine($"Branch Code: {setup.bankBranchCode}<br/>");
            footBuilder.AppendLine($"Swift Code: {setup.bankSwift}<br/>");
            footBuilder.AppendLine("<br/><b>Use your invoice or account number as reference.</b>");
            footBuilder.AppendLine($"<br/><b>Please send proof of payment to {setup.email}</b>");
            */
            footBuilder.AppendLine("</td></tr></table>");


            returnString = footBuilder.ToString();

            return returnString;
        }

        public static string BuildSalesInvoiceLines(ArrayList salesItemList, pNums.TemplateType templateType, bool isSupplierLocal, string currency, pNums.DocumentType docType = pNums.DocumentType.Statement)
        {
            StringBuilder lineResult = new StringBuilder();
            try
            {
                oSetup setup = (oSetup)(xData.GetTypedByCriteriaSpecific("recId", typeof(oSetup), "isActive", "1")[0]);

                lineResult.AppendLine(GetColumnHeaders(templateType, isSupplierLocal, currency));

                if (handler.ReturnSetup().code == "CAPI-1" && docType.Equals(pNums.DocumentType.Invoice))
                {
                    foreach (oSalesItemsFinal salesItem in salesItemList)
                    {
                        //show amounts as exclusive of VAT if there is a Vat Rate on the line
                        decimal unitFeeExclusive = salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalUnitPriceZAR;
                        decimal amountExclusive = salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalTotalPriceZAR;

                        //if (setup.vatRegistered && setup.vatRate > 0)
                        //{
                        //    unitFeeExclusive = (100.00m / (100.00m + setup.vatRate)) * salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalUnitPriceZAR;
                        //    amountExclusive = unitFeeExclusive * salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalQuantityRequired;
                        //}

                        lineResult.AppendLine("<tr style='border-bottom: 0.5px solid #F0F0F0;'>");
                        lineResult.AppendLine("<td>" + salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalPartNumber + "</td>");
                        lineResult.AppendLine("<td>" + salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalMasterPartNumber + "</td>");
                        lineResult.AppendLine("<td>" + salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalDescription + "</td>");
                        lineResult.AppendLine("<td>" + salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalBrand + "</td>");
                        lineResult.AppendLine("<td>" + salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalCondition + "</td>");
                        lineResult.AppendLine("<td>" + salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalLeadTime + "</td>");
                        lineResult.AppendLine("<td>" + salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalWeightKG + "</td>");
                        lineResult.AppendLine("<td style='text-align:center;'>" + salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalQuantityRequired + "</td>");
                        lineResult.AppendLine("<td style='text-align:right;'>" + utils.returnFormattedDecimal(Convert.ToString(decimal.Round(unitFeeExclusive, 2))).Replace(" ", ",") + "</td>");
                        //lineResult.AppendLine("<td style='text-align:right;'></td>");
                        lineResult.AppendLine("<td style='text-align:right;'>" + utils.returnFormattedDecimal(Convert.ToString(decimal.Round(amountExclusive, 2))).Replace(" ", ",") + "</td>");
                        lineResult.AppendLine("</tr>");

                    }
                }
                else if (handler.ReturnSetup().code == "CAPI-1" && docType.Equals(pNums.DocumentType.Quote))
                {
                    foreach (oQuoteItemsFinal quoteItem in salesItemList)
                    {
                        //show amounts as exclusive of VAT if there is a Vat Rate on the line
                        decimal unitFeeExclusive = quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalUnitPriceZAR;
                        decimal amountExclusive = quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalTotalPriceZAR;

                        if (templateType.Equals(pNums.TemplateType.PurchaseOrder))
                        {
                            if (!isSupplierLocal)
                            {
                                unitFeeExclusive = quoteItem.CostPriceFOREX;
                                amountExclusive = quoteItem.CostPriceFOREX * quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalQuantityAvailable;
                            }
                            else
                            {
                                unitFeeExclusive = quoteItem.CostPriceZAR;
                                amountExclusive = quoteItem.CostPriceZAR * quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalQuantityAvailable;
                            }
                        }

                        //if (setup.vatRegistered && setup.vatRate > 0)
                        //{
                        //    unitFeeExclusive = (100.00m / (100.00m + setup.vatRate)) * quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalUnitPriceZAR;
                        //    amountExclusive = unitFeeExclusive * quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalQuantityAvailable;

                        //}

                        lineResult.AppendLine("<tr style='border-bottom: 0.5px solid #F0F0F0;'>");
                        lineResult.AppendLine("<td>" + quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalPartNumber + "</td>");
                        lineResult.AppendLine("<td>" + quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalMasterPartNumber + "</td>");
                        lineResult.AppendLine("<td>" + quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalDescription + "</td>");
                        lineResult.AppendLine("<td>" + quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalBrand + "</td>");
                        lineResult.AppendLine("<td>" + quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalCondition + "</td>");
                        if(templateType.Equals(pNums.TemplateType.Sales))
                            lineResult.AppendLine("<td>" + quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalLeadTime + "</td>");
                        lineResult.AppendLine("<td>" + quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalWeightKG + "</td>");
                        if (templateType.Equals(pNums.TemplateType.PurchaseOrder))
                        {
                            lineResult.AppendLine("<td style='text-align:center;'>" + quoteItem.WarehouseLocation + "</td>");
                        }
                        if (!templateType.Equals(pNums.TemplateType.StockPick))
                        {
                            lineResult.AppendLine("<td style='text-align:center;'>" + quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalQuantityAvailable + "</td>");
                        }
                        else
                        {
                            var oPickingSlipItem = (oPurchaseOrderPickingSlipQuoteItemFinal)quoteItem;
                            lineResult.AppendLine("<td style='text-align:center;'>" + oPickingSlipItem.Available + "</td>");
                        }
                        if (!templateType.Equals(pNums.TemplateType.StockPick))
                        {
                            lineResult.AppendLine("<td style='text-align:right;'>" + utils.returnFormattedDecimal(Convert.ToString(decimal.Round(unitFeeExclusive, 2))).Replace(" ", ",") + "</td>");
                            lineResult.AppendLine("<td style='text-align:right;'>" + utils.returnFormattedDecimal(Convert.ToString(decimal.Round(amountExclusive, 2))).Replace(" ", ",") + "</td>");
                        }
                        else
                        {
                            lineResult.AppendLine("<td style='text-align:center;'>" + quoteItem.WarehouseLocation + "</td>");
                            lineResult.AppendLine("<td style='text-align:center;'>" + quoteItem.Location + "</td>");
                            var oPickingSlipItem = (oPurchaseOrderPickingSlipQuoteItemFinal)quoteItem;
                            lineResult.AppendLine("<td style='text-align:center;'>" + 
                                (quoteItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalQuantityAvailable - oPickingSlipItem.Available) + "</td>");
                            lineResult.AppendLine("<td style='text-align:center;'>" + oPickingSlipItem.Available + "</td>");
                            lineResult.AppendLine("<td style='text-align:center;'>" + oPickingSlipItem.LocationBin + "</td>");
                        }
                        lineResult.AppendLine("</tr>");

                    }
                }

                else
                {
                    foreach (oSales salesItem in salesItemList)
                    {
                        //show amounts as exclusive of VAT if there is a Vat Rate on the line
                        decimal unitFeeExclusive = salesItem.unitFee;
                        decimal amountExclusive = salesItem.amount;

                        if (setup.vatRegistered && setup.vatRate > 0)
                        {
                            unitFeeExclusive = (100.00m / (100.00m + setup.vatRate)) * salesItem.unitFee;
                            amountExclusive = unitFeeExclusive * salesItem.qty;
                        }

                        lineResult.AppendLine("<tr style='border-bottom: 0.5px solid #F0F0F0;'>");

                        //CVH 2016-09-21 Saved item description as main description, user description on second line 
                        //lineResult.AppendLine("<td>" + salesItem.itemDescription + "</td>");
                        string desc = salesItem.itemCode;
                        foreach (oSalesItem item in xData.GetTypedByCriteriaSpecific("recId", typeof(oSalesItem), "code,isDeleted", salesItem.itemCode + ",0"))
                        {
                            if (desc != String.Empty)
                                desc += " - ";
                            desc += item.description;
                        }
                        lineResult.AppendLine("<td>" + desc);
                        string secondDescription = salesItem.itemDescription.Replace(desc, string.Empty).Trim();
                        if (secondDescription != string.Empty)
                        {
                            secondDescription = secondDescription.StartsWith("-") ? secondDescription.Substring(1) : secondDescription;
                            lineResult.AppendLine("<br /><span style='font-size: 0.8em;'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + secondDescription + "</span>");
                        }

                        lineResult.AppendLine("</td>");
                        lineResult.AppendLine("<td style='text-align:left;'>" + salesItem.qty + "</td>");
                        lineResult.AppendLine("<td style='text-align:left;'>" + utils.returnFormattedDecimal(Convert.ToString(decimal.Round(unitFeeExclusive, 2))).Replace(" ", ",") + "</td>");
                        if (handler.ReturnSetup().code != "SHEN-1")
                        {
                            lineResult.AppendLine("<td style='text-align:left;'></td>");
                        }
                        lineResult.AppendLine("<td style='text-align:right;padding-right:8px;'>" + utils.returnFormattedDecimal(Convert.ToString(decimal.Round(amountExclusive, 2))).Replace(" ", ",") + "</td>");
                        lineResult.AppendLine("</tr>");
                    }
                }
                lineResult.AppendLine("</table> ");
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
            return lineResult.ToString();
        }

        public static string GetColumnHeaders(pNums.TemplateType templateType, bool isLocalSupplier, string currency)
        {
            StringBuilder lineResult = new StringBuilder();

            lineResult.AppendLine("<table cellpadding='1' style='width:100%;'>");
            lineResult.AppendLine("<tr style='background-color: #FAFAFA;border-bottom: 1px solid #777;'>");

            if (handler.ReturnSetup().code == "CAPI-1")
            {
                lineResult.AppendLine("<td class='subInfo' style='width:10%;'><b>Part No</b></td>");
                lineResult.AppendLine("<td class='subInfo' style='width:10%;'><b>Master No</b></td>");
                lineResult.AppendLine("<td class='subInfo' style='width:24%;'><b>Description</b></td>");
                lineResult.AppendLine("<td class='subInfo' style='width:8%;'><b>Brand</b></td>");
                lineResult.AppendLine("<td class='subInfo' style='width:8%;'><b>Condition</b></td>");
                if (templateType.Equals(pNums.TemplateType.Sales))
                    lineResult.AppendLine("<td class='subInfo' style='width:8%;'><b>Lead Time</b></td>");
                lineResult.AppendLine("<td class='subInfo' style='width:6%;'><b>KG</b></td>");
                if (templateType.Equals(pNums.TemplateType.PurchaseOrder))
                {
                    lineResult.AppendLine("<td class='subInfo' style='width:6%; text-align:center;'><b>Notes</b></td>");
                }
                lineResult.AppendLine("<td class='subInfo' style='width:6%; text-align:center;'><b>Qty</b></td>");
                if (!templateType.Equals(pNums.TemplateType.StockPick))
                {
                    lineResult.AppendLine("<td class='subInfo' style='width:10%; text-align:right;'><b>Unit Price</b></td>");
                    if (!isLocalSupplier)
                        lineResult.AppendLine("<td class='subInfo' style='width:10%; text-align:right;'><b>Amount " + currency + "</b></td>");
                    else
                        lineResult.AppendLine("<td class='subInfo' style='width:10%; text-align:right;'><b>Amount ZAR</b></td>");
                }
                else
                {
                    lineResult.AppendLine("<td class='subInfo' style='width:10%; text-align:center;'><b>Warehouse</b></td>");
                    lineResult.AppendLine("<td class='subInfo' style='width:10%; text-align:center;'><b>Bin</b></td>");
                    lineResult.AppendLine("<td class='subInfo' style='width:10%; text-align:center;'><b>Picked</b></td>");
                    lineResult.AppendLine("<td class='subInfo' style='width:10%; text-align:center;'><b>Outstanding</b></td>");
                    lineResult.AppendLine("<td class='subInfo' style='width:10%; text-align:center;'><b>Tote /Bin</b></td>");
                }
            }
            else
            {
                lineResult.AppendLine("<td class='subInfo' style='width:40%;'><b>Description</b></td>");
                lineResult.AppendLine("<td class='subInfo' style='width:15%;'><b>Quantity</b></td>");
                lineResult.AppendLine("<td class='subInfo' style='width:15%;'><b>Unit Price</b></td>");
                if (handler.ReturnSetup().code != "SHEN-1")
                {
                    lineResult.AppendLine("<td class='subInfo' style='width:15%;'><b>Discount %</b></td>");
                }
                lineResult.AppendLine("<td class='subInfo' style='width:15%;text-align:center;'><b>Amount ZAR</b></td>");                
            }
            lineResult.AppendLine("</tr>");            
            return lineResult.ToString();
        }

        private static string BuildSalesTotals(ArrayList salesItemList, pNums.DocumentType docType, DateTime? statementDateTo, oSales sale = null)
        {
            StringBuilder totalsBuilder = new StringBuilder();
            try
            {

                string currency = "ZAR";
                decimal dSubTotal = 0M;
                decimal dVAT = 0M;
                decimal dTotalAmount = 0M;
                decimal dTotalPayments = 0M;
                decimal dAmountDue = 0M;
                decimal dTotalWeight = 0M;
                int surfaceItemId = 0;

                oSetup setup = (oSetup)(xData.GetTypedByCriteriaSpecific("recId", typeof(oSetup), "isActive", "1")[0]);

                switch (docType)
                {
                    case pNums.DocumentType.Statement:

                        if (salesItemList == null || salesItemList.Count <= 0)
                        {
                            decimal accBal = 0;
                            totalsBuilder.AppendLine("<table style=width:100%>");
                            totalsBuilder.AppendLine("<tr><td style='width: 10%'>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='width: 90%; border-top:solid 1px #777; text-align:right; font-size:medium;'>");
                            totalsBuilder.AppendLine($"<b>Balance Due: {accBal:F2}</b></td>");
                        }
                        else
                        {
                            salesItemList.Reverse();
                            ovSalesView salesView = (ovSalesView)salesItemList[0];
                            decimal accBal = xData.GetSalesBalance(salesView.surfaceItemId, statementDateTo);

                            totalsBuilder.AppendLine("<br/><table style=width:100%>");
                            totalsBuilder.AppendLine("<tr><td style='width: 10%'>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='width: 90%; border-top:solid 1px #777; text-align:right; font-size:medium;'>");
                            totalsBuilder.AppendLine($"<b>Balance Due: {accBal:F2}</b></td>");
                        }
                        break;

                    case pNums.DocumentType.Receipt:
                        totalsBuilder.AppendLine("<br/>");
                        break;

                    case pNums.DocumentType.Invoice:

                        decimal exclBalance = 0M;
                        if (handler.ReturnSetup().code == "CAPI-1")
                        {

                            foreach (oSalesItemsFinal salesItem in salesItemList)
                            {
                                dSubTotal += salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalTotalPriceZAR;
                                dTotalWeight += salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalWeightKG * salesItem.SalesItemsFinal_SalesItemsFinal_SalesItemsFinalQuantityRequired;
                                //surfaceItemId = salesItem.surfaceItemId;
                            }
                        }
                        else
                        {
                            foreach (oSales salesItem in salesItemList)
                            {
                                dSubTotal += salesItem.amount;
                                surfaceItemId = salesItem.surfaceItemId;
                            }
                        }

                        if (sale != null)
                        {
                            exclBalance = dSubTotal;// (100.00m / (100.00m + setup.vatRate)) * dSubTotal;
                            //dVAT = dSubTotal - ((100.00m / (100.00m + setup.vatRate)) * dSubTotal);
                            dTotalAmount = exclBalance + dVAT;

                            dVAT = (dSubTotal / 100) * sale.vatRate;
                            dTotalAmount = dSubTotal + dVAT;
                        }
                        else if (setup.vatRegistered && setup.vatRate > 0)
                        {
                            exclBalance = dSubTotal;// (100.00m / (100.00m + setup.vatRate)) * dSubTotal;
                            //dVAT = dSubTotal - ((100.00m / (100.00m + setup.vatRate)) * dSubTotal);
                            dTotalAmount = exclBalance + dVAT;

                            dVAT = (dSubTotal / 100) * setup.vatRate;
                            dTotalAmount = dSubTotal + dVAT;

                        }
                        else
                        {
                            exclBalance = dSubTotal;
                            dVAT = 0M;
                            dTotalAmount = exclBalance + dVAT;
                        }


                        //dVAT = (dSubTotal / 100) * vatRate;
                        //dTotalAmount = dSubTotal + dVAT;

                        //foreach (oSales paymentItems in xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,itemType", surfaceItemId.ToString() + ",PM"))
                        //{
                        //    foreach (string paymentAllocId in paymentItems.allocatedReference.Split(','))
                        //    {
                        //        foreach (oSales salesItem in salesItemList)
                        //        {
                        //            if (paymentAllocId.Contains(':'))
                        //            {
                        //                if (salesItem.recId.ToString() == paymentAllocId.Substring(0, paymentAllocId.IndexOf(':')))
                        //                    dTotalPayments += Convert.ToDecimal(paymentAllocId.Substring(paymentAllocId.IndexOf(':') + 1));
                        //            }
                        //            else if (salesItem.recId.ToString() == paymentAllocId)
                        //                dTotalPayments += paymentItems.amount;
                        //        }
                        //    }
                        //}

                        dAmountDue = dTotalAmount + dTotalPayments;

                        totalsBuilder.AppendLine("<br/><table style=width:100%>");

                        if (sale != null)
                        {
                            totalsBuilder.AppendLine("<tr><td style='width: 10%'>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("<b>Nett Amount</b></td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{exclBalance:N2}</b>");
                            totalsBuilder.AppendLine("</td></tr>");

                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("VAT @ " + sale.vatRate + "%</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"{dVAT:N2}");
                            totalsBuilder.AppendLine("</td></tr>");
                        }
                        else if (setup.vatRegistered && setup.vatRate > 0)
                        {
                            totalsBuilder.AppendLine("<tr><td style='width: 10%'>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("<b>Nett Amount</b></td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{exclBalance:N2}</b>");
                            totalsBuilder.AppendLine("</td></tr>");

                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("VAT @ " + setup.vatRate + "%</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"{dVAT:N2}");
                            totalsBuilder.AppendLine("</td></tr>");
                        }

                        totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                        totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                        totalsBuilder.AppendLine("<b>Total Amount " + currency + "</b></td>");
                        totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                        totalsBuilder.AppendLine($"<b>{dTotalAmount:N2}</b>");
                        totalsBuilder.AppendLine("</td></tr>");
                        
                        if (handler.ReturnSetup().code == "CAPI-1") 
                        {
                            totalsBuilder.AppendLine("<tr><td colspan='3'>&nbsp;</td></tr>");
                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='text-align:right;'>");
                            totalsBuilder.AppendLine("<b>Total Weight</b></td>");
                            totalsBuilder.AppendLine("<td style='text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{dTotalWeight:N2} kg</b>");
                            totalsBuilder.AppendLine("</td></tr>");
                            totalsBuilder.AppendLine("<tr><td colspan='3'>&nbsp;</td></tr>");
                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td>");
                            totalsBuilder.AppendLine("Total Payments</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"{dTotalPayments:N2}");
                            totalsBuilder.AppendLine("</td></tr>");
                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("<b>Amount Due " + currency + "</b></td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{dAmountDue:N2}</b>");
                            totalsBuilder.AppendLine("</td></tr>");
                            totalsBuilder.AppendLine("</table>");
                        }
                        break;
                    case pNums.DocumentType.Quote:

                        if (handler.ReturnSetup().code == "CAPI-1")
                        {
                            foreach (oQuoteItemsFinal salesItem in salesItemList)
                            {
                                dSubTotal += salesItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalTotalPriceZAR;
                                dTotalWeight += salesItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalWeightKG * salesItem.QuoteItemsFinal_QuoteItemsFinal_QuoteItemsFinalQuantityAvailable;
                                //surfaceItemId = salesItem.surfaceItemId;
                            }
                        }
                        else
                        {
                            foreach (oSales salesItem in salesItemList)
                            {
                                dSubTotal += salesItem.amount;
                                surfaceItemId = salesItem.surfaceItemId;
                            }
                        }

                        if (sale != null)
                        {
                            exclBalance = dSubTotal;
                            dTotalAmount = exclBalance + dVAT;
                            dVAT = (dSubTotal / 100) *sale.vatRate;
                            dTotalAmount = dSubTotal + dVAT;
                        }
                        else if (setup.vatRegistered && setup.vatRate > 0)
                        {
                            //exclBalance = (100.00m / (100.00m + setup.vatRate)) * dSubTotal;
                            // dVAT = dSubTotal - ((100.00m / (100.00m + setup.vatRate)) * dSubTotal);
                            //dTotalAmount = exclBalance + dVAT;
                            exclBalance = dSubTotal;// (100.00m / (100.00m + setup.vatRate)) * dSubTotal;
                            //dVAT = dSubTotal - ((100.00m / (100.00m + setup.vatRate)) * dSubTotal);
                            dTotalAmount = exclBalance + dVAT;

                            dVAT = (dSubTotal / 100) * setup.vatRate;
                            dTotalAmount = dSubTotal + dVAT;
                        }
                        else
                        {
                            exclBalance = dSubTotal;
                            dVAT = 0M;
                            dTotalAmount = exclBalance + dVAT;
                        }

                        //foreach (oSales salesItem in salesItemList)
                        //{
                        //    dSubTotal += salesItem.amount;
                        //    surfaceItemId = salesItem.surfaceItemId;
                        //}

                        //if (setup.vatRegistered && setup.vatRate > 0)
                        //{
                        //    exclBalance = (100.00m / (100.00m + setup.vatRate)) * dSubTotal;
                        //    dVAT = dSubTotal - ((100.00m / (100.00m + setup.vatRate)) * dSubTotal);
                        //    dTotalAmount = exclBalance + dVAT;
                        //}
                        //else
                        //{
                        //    exclBalance = dSubTotal;
                        //    dVAT = 0M;
                        //    dTotalAmount = exclBalance + dVAT;
                        //}

                        //calculation to add Vat to Amounts Exclusive of VAT
                        //dVAT = (dSubTotal / 100) * vatRate;
                        //dTotalAmount = dSubTotal + dVAT;

                        foreach (oSales paymentItems in xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,itemType", surfaceItemId.ToString() + ",PM"))
                        {
                            foreach (string paymentAllocId in paymentItems.allocatedReference.Split(','))
                            {
                                foreach (oSales salesItem in salesItemList)
                                {
                                    if (paymentAllocId.Contains(':'))
                                    {
                                        if (salesItem.recId.ToString() == paymentAllocId.Substring(0, paymentAllocId.IndexOf(':')))
                                            dTotalPayments += Convert.ToDecimal(paymentAllocId.Substring(paymentAllocId.IndexOf(':') + 1));
                                    }
                                    else if (salesItem.recId.ToString() == paymentAllocId)
                                        dTotalPayments += salesItem.amount;
                                }
                            }
                        }

                        dAmountDue = dTotalAmount - dTotalPayments;

                        totalsBuilder.AppendLine("<br/><table style=width:100%>");

                        if (sale != null)
                        {
                            totalsBuilder.AppendLine("<tr><td style='width: 10%'>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            if (handler.ReturnSetup().code == "CAPI-1")
                            {
                                totalsBuilder.AppendLine("<b>Subtotal</b></td>");
                            }
                            else
                            {
                                totalsBuilder.AppendLine("<b>Nett Amount</b></td>");
                            }
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{exclBalance:N2}</b>");
                            totalsBuilder.AppendLine("</td></tr>");

                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("VAT @ " + sale.vatRate + "%</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"{dVAT:N2}");
                            totalsBuilder.AppendLine("</td></tr>");
                        }
                        else if (setup.vatRegistered && setup.vatRate > 0)
                        {
                            totalsBuilder.AppendLine("<tr><td style='width: 10%'>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            if (handler.ReturnSetup().code == "CAPI-1")
                            {
                                totalsBuilder.AppendLine("<b>Subtotal</b></td>");
                            }
                            else
                            {
                                totalsBuilder.AppendLine("<b>Nett Amount</b></td>");
                            }
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{exclBalance:N2}</b>");
                            totalsBuilder.AppendLine("</td></tr>");

                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("VAT @ " + setup.vatRate + "%</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"{dVAT:N2}");
                            totalsBuilder.AppendLine("</td></tr>");
                        }

                        totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                        totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                        totalsBuilder.AppendLine("<b>Total Amount " + currency + "</b></td>");
                        totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                        totalsBuilder.AppendLine($"<b>{dTotalAmount:N2}</b>");
                        totalsBuilder.AppendLine("</td></tr>");

                        if (handler.ReturnSetup().code == "CAPI-1")
                        {
                            totalsBuilder.AppendLine("<tr><td colspan='3'>&nbsp;</td></tr>");
                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='text-align:right;'>");
                            totalsBuilder.AppendLine("<b>Total Weight</b></td>");
                            totalsBuilder.AppendLine("<td style='text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{dTotalWeight:N2} kg</b>");
                            totalsBuilder.AppendLine("</td></tr>");
                        }
                        totalsBuilder.AppendLine("</table>");
                        break;


                    case pNums.DocumentType.CreditNote:

                        decimal exclBalanceCN = 0M;
                        foreach (ovSalesView salesItem in salesItemList)
                        {
                            dSubTotal += salesItem.Received;
                            surfaceItemId = salesItem.surfaceItemId;
                        }


                        if (setup.vatRegistered && setup.vatRate > 0)
                        {
                            exclBalanceCN = (100.00m / (100.00m + setup.vatRate)) * dSubTotal;
                            dVAT = dSubTotal - ((100.00m / (100.00m + setup.vatRate)) * dSubTotal);
                            dTotalAmount = exclBalanceCN + dVAT;
                        }
                        else
                        {
                            exclBalanceCN = dSubTotal;
                            dVAT = 0M;
                            dTotalAmount = exclBalanceCN + dVAT;
                        }

                        dAmountDue = dTotalAmount + dTotalPayments;

                        totalsBuilder.AppendLine("<br/><table style=width:100%>");

                        if (sale != null)
                        {
                            totalsBuilder.AppendLine("<tr><td style='width: 10%'>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("<b>Nett Amount</b></td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{exclBalanceCN:F2}</b>");
                            totalsBuilder.AppendLine("</td></tr>");

                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("VAT @ " + sale.vatRate + "%</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"{dVAT:F2}");
                            totalsBuilder.AppendLine("</td></tr>");
                        }
                        else if (setup.vatRegistered && setup.vatRate > 0)
                        {
                            totalsBuilder.AppendLine("<tr><td style='width: 10%'>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("<b>Nett Amount</b></td>");
                            totalsBuilder.AppendLine("<td style='width: 45%; border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"<b>{exclBalanceCN:F2}</b>");
                            totalsBuilder.AppendLine("</td></tr>");

                            totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine("VAT @ " + setup.vatRate + "%</td>");
                            totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                            totalsBuilder.AppendLine($"{dVAT:F2}");
                            totalsBuilder.AppendLine("</td></tr>");
                        };

                        totalsBuilder.AppendLine("<tr><td>&nbsp;</td>");
                        totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                        totalsBuilder.AppendLine("<b>Total Amount " + currency + "</b></td>");
                        totalsBuilder.AppendLine("<td style='border-top:solid 1px #777; text-align:right;'>");
                        totalsBuilder.AppendLine($"<b>{dTotalAmount:F2}</b>");
                        totalsBuilder.AppendLine("</td></tr>");
                        totalsBuilder.AppendLine("</table>");
                        break;
                    default:
                        break;
                }
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
            return totalsBuilder.ToString();
        }

        private static string BuildAdditionalNotes(pNums.DocumentType docType, int number)
        {
            StringBuilder addBuilder = new StringBuilder();
            try
            {
                foreach (oSalesExtraNote note in xData.GetTypedByCriteriaSpecific("recId", typeof(oSalesExtraNote), "type,number", docType.GetHashCode().ToString() + "," + number))
                {
                    if (addBuilder.Length == 0)
                        addBuilder.AppendLine("<br/><b>Note:</b><br/>");
                    addBuilder.AppendLine(note.note + "<br/><br/><br/>");
                    break;
                }

            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
            return addBuilder.ToString();
        }

        /// <summary>
        /// Email sales document
        /// </summary>
        /// <returns>Success</returns>
        public static bool EmailSalesDocument(oSales account,
            string configFrom, string subject, string emailTo, string emailCc, string emailBcc, string emailBody,
            string configWebAddress, int userId, DateTime documentDate,
            DateTime? statementDateFrom, DateTime? statementDateTo, pNums.DocumentType docType, string documentNo,
            string fromDisplayName, string noteSurfaceFieldName)
        {
            try
            {
                string file = String.Empty;
                string path = string.Empty;

                if (CreateSalesDocument(account, configWebAddress, documentDate, statementDateFrom,
                    statementDateTo, ref path, ref file, docType, documentNo))
                {
                    /* CVH 2016-09-02 Use template from calling method, user allowed to edit before send. All {placeholder}'s have already been replaced before showing in modal */
                    string emailTemplate = emailBody;

                    oEmail mail = new oEmail();
                    mail.Body = emailTemplate;
                    mail.Attachments.Add(path + file);

                    mail.Subject = subject;

                    mail.fromAddress = configFrom;

                    mail.toAddress = emailTo;

                    mail.ccAddress = emailCc;

                    mail.bccAddress = emailBcc;

                    if (communication.SendAnEmail(mail, fromDisplayName))
                    {
                        //Add note with statement as attachment
                        AddCreateStatementNote(account.surfaceItemId, mail.Subject, mail.Body, path, file, userId,
                            noteSurfaceFieldName);

                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
                else
                    return false;


            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
        }

        public static string BuildEmailTemplate(string emailTemplate, oSales account, oSetup setup, string configWebAddress)
        {
            try
            {
                string primaryContact = "";
                string emailDocNumber = "";
                string documentType = "";
                if (account != null)
                {
                    // In the case of a Quote, xSales.GetSalesPrimaryContact
                    // does not make sense since no column ending with
                    // _PrimaryContact exists
                    primaryContact = !"QT".Equals(account.itemType)
                        ? xSales.GetSalesPrimaryContact(account.surfaceItemId)
                        : string.Empty;

                    //primaryContact = xSales.GetSalesPrimaryContact(account.surfaceItemId);
                    utils.MergeHTMData(ref emailTemplate, utils.BuildFieldCodeList(account, true));
                    //CVH 2016-09-14 Build transaction number with padded 0's 
                    switch (account.itemType)
                    {
                        case "CN":
                            emailDocNumber = BuildNextTransactionNumber(setup.saleCRNPrefix, setup.saleCRNNumLength, account.invoiceNo);
                            documentType = "Credit Note";
                            break;
                        case "TI":
                            emailDocNumber = BuildNextTransactionNumber(setup.saleINVPrefix, setup.saleINVNumLength, account.invoiceNo);
                            documentType = "Invoice";
                            break;
                        case "QT":
                            emailDocNumber = BuildNextTransactionNumber(setup.saleQTEPrefix, setup.saleQTENumLength, account.invoiceNo);
                            documentType = "Quote";
                            break;
                        case "PM":
                            emailDocNumber = BuildNextTransactionNumber(setup.saleRCTPrefix, setup.saleRCTNumLength, account.receiptNo);
                            documentType = "Receipt";
                            break;
                    }
                }

                /* CVH 2016-09-13 Add trading as name to company name */
                string companyName = setup.customer;
                if (setup.tradingAs != String.Empty && !companyName.Contains(" t/a "))
                    companyName += " t/a " + setup.tradingAs;

                emailTemplate = emailTemplate.Replace("{Date}", System.DateTime.Now.ToString("yyyy/MM/dd"));
                emailTemplate = emailTemplate.Replace("src=\"/images/", "src=\"" + configWebAddress + "/images/");
                emailTemplate = emailTemplate.Replace("src=\"/upload/image/", "src=\"" + configWebAddress + "/upload/image/");
                if (setup.logoUploaded == String.Empty)
                    emailTemplate = emailTemplate.Replace("{Logo Name}\"", "\" style='display:none'");
                else
                    emailTemplate = emailTemplate.Replace("{Logo Name}", setup.logoUploaded);
                emailTemplate = emailTemplate.Replace("{Primary Contact Name}", primaryContact);
                emailTemplate = emailTemplate.Replace("{Document Number}", emailDocNumber);
                emailTemplate = emailTemplate.Replace("{Document Type}", documentType);
                emailTemplate = emailTemplate.Replace("{Company Name}", companyName);
                emailTemplate = emailTemplate.Replace("{Company E-mail Address}", setup.email);
            }
            catch (Exception ex)
            {
                exception.HandleException("sales:", MethodBase.GetCurrentMethod().Name, ex, 0);
            }

            return emailTemplate;
        }

        public static string GetSalesPrimaryContact(int contactSurfaceItemId)
        {
            string contact = "";
            try
            {
                /* CVH 2016-09-02 Primary contact no longer set on Child Surface. There is a surface field on the Contact surface called "Primary Person" */
                //List<oDynamicParam> list = new List<oDynamicParam>();
                //oDynamicParam par1 = new oDynamicParam();
                //par1.paramDisplayName = "parentSurfaceItemId";
                //par1.paramObject = contactSurfaceItemId;
                //list.Add(par1);
                //DataTable surfaceData = xData.GetTypedTableByProc("recId", typeof(oSurfaceFieldData), "sp_GetSalesPrimaryContact", list);
                //if (surfaceData != null && surfaceData.Rows.Count > 0)
                //    contact = surfaceData.Rows[0][0].ToString();

                ArrayList itemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oSurfaceItem), "recId", contactSurfaceItemId.ToString());
                if (itemList == null || itemList.Count <= 0)
                    throw new Exception("Contact surface item not found.");
                oSurfaceItem item = (oSurfaceItem)itemList[0];

                DataTable surfaceItemData = xData.GetSurfaceItemData(item.surfaceId, contactSurfaceItemId);

                foreach (DataRow row in surfaceItemData.Rows)
                {
                    foreach (DataColumn col in surfaceItemData.Columns)
                    {
                        //name
                        if (col.ColumnName.EndsWith("_PrimaryPerson"))
                        {
                            contact = row[col].ToString();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }

            return contact;
        }

        private static string GetSalesCustomerVatNumber(int customerSurfaceItemId)
        {
            string vatNumber = string.Empty;

            try
            {
                ArrayList itemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oSurfaceItem), "recId", customerSurfaceItemId.ToString());
                if (itemList == null || itemList.Count <= 0)
                    throw new Exception("Customer surface item not found.");
                oSurfaceItem item = (oSurfaceItem)itemList[0];

                DataTable surfaceItemData = xData.GetSurfaceItemData(item.surfaceId, customerSurfaceItemId);
                foreach (DataRow row in surfaceItemData.Rows)
                {
                    foreach (DataColumn col in surfaceItemData.Columns)
                    {
                        //vatnum
                        if (col.ColumnName.EndsWith("_CustomerVATRegistered"))
                        {
                            vatNumber = row[col].ToString();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }

            return vatNumber;
        }

        public static string GetSalesCustomerVatNumber(string customername)
        {
            string vatNumber = string.Empty;

            try
            {
                DataTable customerData = xData.GetCustomerFromTradingName(customername);
                foreach (DataRow row in customerData.Rows)
                {
                    foreach (DataColumn col in customerData.Columns)
                    {
                        //vatnum
                        if (col.ColumnName.EndsWith("_CustomerVATRegistered"))
                        {
                            vatNumber = row[col].ToString();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }

            return vatNumber;
        }

        public static string GetSalesCcEmailAddresses(int contactSurfaceItemId)
        {
            string cc = "";
            try
            {
                /* CVH 2016-08-16 Get CC email addresses */
                List<oDynamicParam> list = new List<oDynamicParam>();
                oDynamicParam par1 = new oDynamicParam();
                par1.paramDisplayName = "parentSurfaceItemId";
                par1.paramObject = contactSurfaceItemId;
                list.Add(par1);
                DataTable surfaceData = xData.GetTypedTableByProc("recId", typeof(oSurfaceFieldData), "sp_GetSalesCcEmailAddresses", list);
                foreach (DataRow row in surfaceData.Rows)
                {
                    string ccEmail = row[0].ToString();
                    if (utils.validateEmail(ccEmail))
                    {
                        if (cc == String.Empty)
                            cc = ccEmail;
                        else
                            cc += ";" + ccEmail;
                    }
                }
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }

            return cc;
        }

        public static oSales SetSalesContact(int itemId)
        {
            ArrayList itemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oSurfaceItem), "recId", itemId.ToString());
            if (itemList == null || itemList.Count <= 0)
                throw new Exception("Contact surface item not found.");
            oSurfaceItem item = (oSurfaceItem)itemList[0];

            DataTable surfaceItemData = xData.GetSurfaceItemData(item.surfaceId, itemId);

            oSales sales = new oSales();
            sales.surfaceItemId = itemId;

            foreach (DataRow row in surfaceItemData.Rows)
            {
                foreach (DataColumn col in surfaceItemData.Columns)
                {
                    //trading name
                    if (col.ColumnName.EndsWith("_CustomerTradingName"))
                    {
                        sales.name = row[col].ToString();
                        if (sales.name.Length > 1)
                        {
                            sales.name = sales.name.Substring(0, 1).ToUpper() + sales.name.Substring(1).ToLower();
                        }
                    }

                    //name
                    if (string.IsNullOrEmpty(sales.name) && col.ColumnName.EndsWith("Name"))
                    {
                        sales.name = row[col].ToString();
                        if (sales.name.Length > 1)
                        {
                            sales.name = sales.name.Substring(0, 1).ToUpper() + sales.name.Substring(1).ToLower();
                        }
                    }                   

                    //primary email
                    if (col.ColumnName.EndsWith("_CustomerPrimaryEmail"))
                    {
                        sales.email = row[col].ToString();
                    }

                    //email
                    if (string.IsNullOrEmpty(sales.email) && col.ColumnName.EndsWith("_Email"))
                    {
                        sales.email = row[col].ToString();
                    }

                    //vat Number
                    if (col.ColumnName.EndsWith("_CustomerVATRegistered"))
                    {
                        sales.vatNum = row[col].ToString();
                        if (sales.vatNum == "Yes" || sales.vatNum == "No")
                            sales.vatNum = "";
                    }

                    //postal address
                    if (col.ColumnName.EndsWith("_CustomerPostalAddress"))
                        sales.postalAddress = row[col].ToString();

                    /* CVH 2016-08-23 Contact Code no longer a field on surface, needs to be auto calculated based on Company Name, first 3 char + numeric */
                    /* CVH 2016-09-05 Account Code is now a field on the Contacts Surface. */
                    //account number
                    if (col.ColumnName.EndsWith("_CustomerCode"))
                        sales.accountNo = row[col].ToString();
                }
            }

            /* CVH 2016-08-16 Get CC email addresses */
            sales.emailCC = GetSalesCcEmailAddresses(itemId);

            return sales;
        }

        public static oSales SetSalesCustomer(int itemId)
        {
            ArrayList itemList = xData.GetTypedByCriteriaSpecific("recId", typeof(oSurfaceItem), "recId", itemId.ToString());
            if (itemList == null || itemList.Count <= 0)
                throw new Exception("Customer surface item not found.");
            oSurfaceItem item = (oSurfaceItem)itemList[0];

            DataTable surfaceItemData = xData.GetSurfaceItemData(item.surfaceId, itemId);

            oSales sales = new oSales();
            sales.surfaceItemId = itemId;

            foreach (DataRow row in surfaceItemData.Rows)
            {
                foreach (DataColumn col in surfaceItemData.Columns)
                {
                    //name
                    if (col.ColumnName.EndsWith("_CustomerTradingName"))
                    {
                        sales.name = row[col].ToString();
                        if (sales.name.Length > 1)
                            sales.name = sales.name.Substring(0, 1).ToUpper() + sales.name.Substring(1).ToLower();
                    }

                    //email
                    if (col.ColumnName.EndsWith("_CustomerPrimaryEmail"))
                        sales.email = row[col].ToString();

                    //vat Number
                    if (col.ColumnName.EndsWith("_CustomerVATRegistered"))
                    {
                        sales.vatNum = row[col].ToString();
                        if (sales.vatNum == "Yes" || sales.vatNum == "No")
                            sales.vatNum = "";
                    }

                    //postal address
                    if (col.ColumnName.EndsWith("_CustomerPostalAddress"))
                        sales.postalAddress = row[col].ToString();

                    /* CVH 2016-08-23 Contact Code no longer a field on surface, needs to be auto calculated based on Company Name, first 3 char + numeric */
                    /* CVH 2016-09-05 Account Code is now a field on the Contacts Surface. */
                    //account number
                    if (col.ColumnName.EndsWith("_CustomerCode"))
                        sales.accountNo = row[col].ToString();
                }
            }

            /* CVH 2016-08-16 Get CC email addresses */
            sales.emailCC = GetSalesCcEmailAddresses(itemId);

            return sales;
        }

        /// <summary>
        /// Save Sale 
        /// </summary>
        /// <param name="isDraft"></param>
        /// <param name="sale"></param>
        /// <param name="transactionType"></param>
        private bool SaveSale(bool isDraft, oSales sale, string transactionType)
        {
            try
            {
                bool result = false;

                //switch (transactionType)
                //{
                //    case "PM":
                //        result = PostReceiptLine(isDraft, sale, transactionType);
                //        break;
                //    case "A":
                //        result = PostReceiptLine(isDraft, sale, transactionType);
                //        break;
                //    case "AC":
                //        result = PostReceiptLine(isDraft, sale, transactionType);
                //        break;
                //    case "CN":
                //        result = PostReceiptLine(isDraft, sale, transactionType);
                //        break;
                //    default:
                //        result = FinaliseTransaction(isDraft, sale);
                //        break;
                //}

                if (result)
                {
                    //CVH 2016-09-14 Update Next Transaction number in company setup. Get current db setup
                    oSetup setupUpdate = handler.ReturnSetup();
                    setupUpdate = (oSetup)(xData.GetTypedByCriteriaSpecific("recId", typeof(oSetup), "isActive", "1")[0]);
                    setupUpdate.saleQTENextNum = xData.GetQuoteNoSales();
                    setupUpdate.saleINVNextNum = xData.GetInvoiceNoSales("TI");
                    setupUpdate.saleRCTNextNum = xData.GetNextRecNoSales();
                    setupUpdate.saleCRNNextNum = xData.GetInvoiceNoSales("CN");
                    xData.UpdateTyped("recId", setupUpdate.recId.ToString(), typeof(oSetup), setupUpdate);
                }
                return result;
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
        }

        public static string BuildNextTransactionNumber(string prefix, int length, int nextNum)
        {
            try
            {
                if (nextNum <= 0)
                    nextNum = 1;
                string number = prefix;
                if (length > prefix.Length + nextNum.ToString().Length)
                    number = number.PadRight(length - nextNum.ToString().Length, '0');
                number += nextNum;
                return number;
            }
            catch (Exception ex)
            {
                throw new Exception(MethodBase.GetCurrentMethod().Name + ":" + ex.Message);
            }
        }

        /// <summary>
        /// Update all running totals for sales
        /// </summary>
        /// <param name="sale"></param>
        public static void UpdateRunningTotals(string surfaceItemId)
        {
            decimal bal = 0;
            if (surfaceItemId != String.Empty)
            {
                foreach (oSales sales in xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,itemType", surfaceItemId + ",~<>QT", "dateOfService,sequence"))
                {
                    bal += sales.amount;
                    sales.runningBal = bal;

                    xData.UpdateTyped("recId", sales.recId.ToString(), typeof(oSales), sales);
                }

                bal = 0;
                //quoteItems running balance
                foreach (oSales quoteItems in xData.GetTypedByCriteriaSpecific("recId", typeof(oSales), "surfaceItemId,itemType", surfaceItemId + ",QT", "dateOfService,sequence"))
                {
                    bal += quoteItems.amount;
                    quoteItems.runningBal = bal;

                    xData.UpdateTyped("recId", quoteItems.recId.ToString(), typeof(oSales), quoteItems);
                }
            }
        }
    }
}