public Error CreateOrderConfirmationPdf(SalesOrderHeaderModel soh, DocumentTemplateModel template,
string pdfFile,
bool showCancelledItems,
ref string outputFile,
int maxItems = Int32.MaxValue)
{
var error = new Error();
string tempFile = MediaService.MediaService.GetTempFile(".html");
if (string.IsNullOrEmpty(pdfFile))
{
outputFile = MediaService.MediaService.GetTempFile().FolderName() + "\\" + soh.OrderNumber + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf";
}
else
{
outputFile = pdfFile;
}
// Insert the lines
decimal subTotal = 0,
subTotalIncGst = 0,
freightTotal = 0;
CompanyService.CompanyService companyService = new CompanyService.CompanyService(db);
var company = companyService.FindCompanyModel(soh.CompanyId);
CustomerService.CustomerService customerService = new CustomerService.CustomerService(db);
var customer = customerService.FindCustomerModel(soh.CustomerId == null ? 0 : soh.CustomerId.Value,
company);
var paymentTerms = LookupService.FindPaymentTermModel(soh.TermsId == null ? 0 : soh.TermsId.Value);
var taxCode = LookupService.FindTaxCodeModel(customer.TaxCodeId);
subTotalIncGst = subTotal + (taxCode.TaxPercentageRate == null ? 0 : (subTotal / 100 * taxCode.TaxPercentageRate.Value));
var currency = LookupService.FindCurrencyModel(company.DefaultCurrencyID == null ? 0 : company.DefaultCurrencyID.Value);
Dictionary <string, string> headerProps = new Dictionary <string, string>();
List <Dictionary <string, string> > records = new List <Dictionary <string, string> >();
AddCompanyInformation(company, headerProps);
headerProps.AddProperty("ORDERNUMBER", soh.OrderNumber.ToString());
headerProps.AddProperty("CUSTPO", soh.CustPO);
headerProps.AddProperty("ORDERDATE", formatDate(soh.OrderDate, company.DateFormat));
headerProps.AddProperty("PAYMENTTERMS", paymentTerms.TermText);
var salesMgr = customerService.FindBrandCategorySalesPersonsModel(company, customer, soh.BrandCategoryId.Value, SalesPersonType.AccountAdmin).FirstOrDefault();
if (salesMgr != null)
{
headerProps.AddProperty("ACCOUNTMANAGER", salesMgr.UserName);
}
else
{
headerProps.AddProperty("ACCOUNTMANAGER", "");
}
headerProps.AddProperty("CUSTOMERNAME", customer.Name);
var contact = customerService.FindPrimaryCustomerContactsModel(customer)
.FirstOrDefault();
headerProps.AddProperty("CUSTOMERCONTACT", contact.ContactFirstname + " " + contact.ContactSurname);
var addrs = customerService.FindCurrentCustomerAddresses(customer, AddressType.Billing)
.FirstOrDefault();
if (addrs == null)
{
addrs = new CustomerAddressModel();
}
headerProps.AddProperty("STREET", addrs.Street);
headerProps.AddProperty("CITY", addrs.City);
headerProps.AddProperty("STATE", addrs.State);
headerProps.AddProperty("POSTCODE", addrs.Postcode);
headerProps.AddProperty("COUNTRY", addrs.CountryName);
headerProps.AddProperty("PHONENO", contact.ContactPhone1);
headerProps.AddProperty("FAXNUMBER", contact.ContactFax);
headerProps.AddProperty("DELIVERYADDRESS", soh.FullAddress.Replace("\r\n", "<br/>"));
headerProps.AddProperty("TAXNAME", taxCode.TaxCode);
headerProps.AddProperty("CURRENCYSYMBOL", currency.CurrencySymbol);
var shipMethod = LookupService.FindLOVItemModel((soh.ShippingMethodId == null ? 0 : soh.ShippingMethodId.Value),
LOVName.ShippingMethod);
headerProps.AddProperty("DELIVERYVIA", shipMethod.ItemText);
string deliveryWindow = "";
if (soh.DeliveryWindowOpen != null)
{
deliveryWindow = soh.DeliveryWindowOpen.Value.ToString(company.DateFormat);
}
if (soh.DeliveryWindowClose != null)
{
if (!string.IsNullOrEmpty(deliveryWindow))
{
deliveryWindow += " - ";
}
deliveryWindow += soh.DeliveryWindowClose.Value.ToString(company.DateFormat);
}
headerProps.AddProperty("DELIVERYWINDOW", deliveryWindow);
headerProps.AddProperty("SALESPERSON", soh.SalesPersonName);
// Add items
int itemCount = 1;
foreach (var sod in FindSalesOrderDetailListModel(company, soh))
{
if (sod.LineStatusId != (int)SalesOrderLineStatus.Cancelled || showCancelledItems)
{
decimal unitPriceExTax = (sod.UnitPriceExTax == null ? 0 : sod.UnitPriceExTax.Value);
decimal discountPc = (sod.DiscountPercent == null ? 0 : sod.DiscountPercent.Value);
decimal linePrice = (sod.OrderQty.Value * unitPriceExTax - ((sod.OrderQty.Value * unitPriceExTax) / 100 * discountPc));
Dictionary <string, string> line = new Dictionary <string, string>();
line.AddProperty("ORDERQTY", sod.OrderQty);
var product = ProductService.FindProductModel(sod.ProductId == null ? 0 : sod.ProductId.Value,
null, company);
line.AddProperty("ITEMNUMBER", product.ItemNumber);
line.AddProperty("DESCRIPTION", itemCount.ToString() + " " + sod.ProductDescription);
var ecd = AllocationService.CalculateExpectedCompletionDate(sod);
if (ecd != null)
{
line.AddProperty("INSTOCK", ecd.Value.ToString(company.DateFormat));
}
else
{
line.AddProperty("INSTOCK", "");
}
line.AddProperty("UNITPRICEEXTAX", unitPriceExTax.ToString("#,##0.000"));
line.AddProperty("DISCOUNTPERCENT", discountPc.ToString("#,##0.00"));
line.AddProperty("LINEPRICE", linePrice.ToString("#,##0.000"));
subTotal += linePrice;
records.Add(line);
itemCount++;
}
}
headerProps.AddProperty("TAXNAME", taxCode.TaxCode);
headerProps.AddProperty("CURRENCYSYMBOL", currency.CurrencySymbol);
headerProps.AddProperty("SALEAMOUNTEX", subTotal.ToString("#,##0.00"));
freightTotal = CalculateEstimatedFreight(soh, customer);
headerProps.AddProperty("ESTIMATEDFREIGHT", freightTotal.ToString("#,##0.00"));
subTotal += freightTotal;
subTotalIncGst = subTotal + (taxCode.TaxPercentageRate == null ? 0 : (subTotal / 100 * taxCode.TaxPercentageRate.Value));
headerProps.AddProperty("SALEAMOUNTINC", subTotalIncGst.ToString("#,##0.00"));
headerProps.AddProperty("GST", (subTotalIncGst - subTotal).ToString("#,##0.00"));
return(DocumentService.CreateDocumentPdf(headerProps, records, template.QualTemplateFile, outputFile, maxItems));
}
// This method is called by others in this module to provide a single point
// fo creating sales-related PDFs
private Error createSalesOrderPdf(SalesOrderHeaderModel soh, DocumentTemplateModel template,
string pdfFile, bool showCancelledItems,
ref string outputFile, int maxItems = Int32.MaxValue)
{
var error = new Error();
string tempFile = MediaService.MediaService.GetTempFile(".html");
if (string.IsNullOrEmpty(pdfFile))
{
outputFile = MediaService.MediaService.GetTempFile().FolderName() + "\\" + soh.OrderNumber + "_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".pdf";
}
else
{
outputFile = pdfFile;
}
// Insert the lines
decimal subTotal = 0,
subTotalIncGst = 0,
freightTotal = 0;
CompanyService.CompanyService companyService = new CompanyService.CompanyService(db);
var company = companyService.FindCompanyModel(soh.CompanyId);
CustomerService.CustomerService customerService = new CustomerService.CustomerService(db);
var customer = customerService.FindCustomerModel(soh.CustomerId == null ? 0 : soh.CustomerId.Value,
company);
var paymentTerms = LookupService.FindPaymentTermModel(soh.TermsId == null ? 0 : soh.TermsId.Value);
var taxCode = LookupService.FindTaxCodeModel(customer.TaxCodeId);
var currency = LookupService.FindCurrencyModel(company.DefaultCurrencyID == null ? 0 : company.DefaultCurrencyID.Value);
Dictionary <string, string> headerProps = new Dictionary <string, string>();
List <Dictionary <string, string> > records = new List <Dictionary <string, string> >();
AddCompanyInformation(company, headerProps);
headerProps.AddProperty("ORDERNUMBER", soh.OrderNumber.ToString());
headerProps.AddProperty("CUSTPO", soh.CustPO);
headerProps.AddProperty("ORDERDATE", formatDate(soh.OrderDate, company.DateFormat));
headerProps.AddProperty("PAYMENTTERMS", paymentTerms.TermText);
var salesMgr = customerService.FindBrandCategorySalesPersonsModel(company, customer, soh.BrandCategoryId.Value, SalesPersonType.AccountAdmin).FirstOrDefault();
if (salesMgr != null)
{
headerProps.AddProperty("ACCOUNTMANAGER", salesMgr.UserName);
}
else
{
headerProps.AddProperty("ACCOUNTMANAGER", "");
}
headerProps.AddProperty("CUSTOMERNAME", customer.Name);
var contact = customerService.FindPrimaryCustomerContactsModel(customer)
.FirstOrDefault();
headerProps.AddProperty("CUSTOMERCONTACT", contact.ContactFirstname + " " + contact.ContactSurname);
var addrs = customerService.FindCurrentCustomerAddresses(customer, AddressType.Billing)
.FirstOrDefault();
if (addrs == null)
{
addrs = new CustomerAddressModel();
}
headerProps.AddProperty("STREET", addrs.Street);
headerProps.AddProperty("CITY", addrs.City);
headerProps.AddProperty("STATE", addrs.State);
headerProps.AddProperty("POSTCODE", addrs.Postcode);
headerProps.AddProperty("COUNTRY", addrs.CountryName);
headerProps.AddProperty("PHONENO", contact.ContactPhone1);
headerProps.AddProperty("FAXNUMBER", contact.ContactFax);
headerProps.AddProperty("DELIVERYADDRESS", soh.FullAddress.Replace("\r\n", "<br/>"));
headerProps.AddProperty("TAXNAME", taxCode.TaxCode);
headerProps.AddProperty("CURRENCYSYMBOL", currency.CurrencySymbol);
var shipMethod = LookupService.FindLOVItemModel((soh.ShippingMethodId == null ? 0 : soh.ShippingMethodId.Value),
LOVName.ShippingMethod);
headerProps.AddProperty("DELIVERYVIA", shipMethod.ItemText);
headerProps.AddProperty("REQUIREDDATE", (soh.RequiredDate == null ? "" : soh.RequiredDate.Value.ToString(company.DateFormat)));
headerProps.AddProperty("SALESPERSON", soh.SalesPersonName);
// Add items
var barCodeService = new BarCodeService.BarCodeService(db);
int itemCount = 1;
foreach (var sod in FindSalesOrderDetailListModel(company, soh))
{
if ((template.TemplateType == DocumentTemplateType.SaleCancellation && sod.LineStatusId == (int)SalesOrderLineStatus.Cancelled) ||
(template.TemplateType != DocumentTemplateType.SaleCancellation && (sod.LineStatusId != (int)SalesOrderLineStatus.Cancelled || showCancelledItems)))
{
decimal unitPriceExTax = (sod.UnitPriceExTax == null ? 0 : sod.UnitPriceExTax.Value);
decimal discountPc = (sod.DiscountPercent == null ? 0 : sod.DiscountPercent.Value);
decimal orderQty = (sod.OrderQty == null ? 0 : sod.OrderQty.Value);
decimal totalExTax = unitPriceExTax * orderQty;
decimal linePrice = (orderQty * unitPriceExTax - ((orderQty * unitPriceExTax) / 100 * discountPc));
Dictionary <string, string> line = new Dictionary <string, string>();
line.AddProperty("ORDERQTY", sod.OrderQty);
var product = ProductService.FindProductModel(sod.ProductId.Value, null, company, false);
string mediaImage = ProductService.GetProductImage(product, MediaSize.Large, 640, 480, false);
line.AddProperty("PRODUCTIMAGE", mediaImage);
line.AddProperty("ITEMNUMBER", product.ItemNumber);
line.AddProperty("ITEMNAME", product.ItemName);
line.AddProperty("DESCRIPTION", itemCount.ToString() + " " + sod.ProductDescription);
line.AddProperty("UNITPRICEEXTAX", unitPriceExTax.ToString("#,##0.00"));
line.AddProperty("TOTALEXTAX", totalExTax.ToString("#,##0.00"));
line.AddProperty("DISCOUNTPERCENT", discountPc.ToString("#,##0.00"));
line.AddProperty("LINEPRICE", linePrice.ToString("#,##0.00"));
//line.AddProperty("RRP", "");
line.AddProperty("BRANDNAME", product.BrandName);
line.AddProperty("CATEGORY", product.Category); // NOT Brand Category
string dimensions = "";
if (product.Length != null && product.Width != null && product.Height != null)
{
if (company.UnitOfMeasure == UnitOfMeasure.Imperial)
{
dimensions = product.Length.CmToInches().ToString();
dimensions += " x " + product.Width.CmToInches().ToString();
dimensions += " x " + product.Height.CmToInches().ToString();
dimensions += " " + company.LengthUnit;
}
else
{
dimensions = product.Length.ToString();
dimensions += " x " + product.Width.ToString();
dimensions += " x " + product.Height.ToString();
dimensions += " " + company.LengthUnit;
}
}
line.AddProperty("DIMENSIONS", dimensions);
string barCodeFile = "";
if (!string.IsNullOrEmpty(product.BarCode))
{
barCodeFile = barCodeService.GetBarCode(product.BarCode, true);
if (!string.IsNullOrEmpty(barCodeFile))
{
line.AddProperty("BARCODE", $"<img src=\"{barCodeFile}\"/>");
}
else
{
line.AddProperty("BARCODE", "");
}
}
else
{
line.AddProperty("BARCODE", "");
}
line.AddProperty("MINSALEQTY", product.MinSaleQty.ToString());
line.AddProperty("MATERIAL", product.MaterialText);
subTotal += linePrice;
records.Add(line);
itemCount++;
}
}
headerProps.AddProperty("TAXNAME", taxCode.TaxCode);
headerProps.AddProperty("CURRENCYSYMBOL", currency.CurrencySymbol);
headerProps.AddProperty("CURRENCYCODE", currency.CurrencyCode);
headerProps.AddProperty("SALEAMOUNTEX", subTotal.ToString("#,##0.00"));
if (template.TemplateType == DocumentTemplateType.ProFormaInvoice ||
template.TemplateType == DocumentTemplateType.OrderConfirmation)
{
freightTotal = CalculateEstimatedFreight(soh, customer);
}
headerProps.AddProperty("ESTIMATEDFREIGHT", freightTotal.ToString("#,##0.00"));
subTotal += freightTotal;
subTotalIncGst = subTotal + (taxCode.TaxPercentageRate == null ? 0 : (subTotal / 100 * taxCode.TaxPercentageRate.Value));
headerProps.AddProperty("SALEAMOUNTINC", subTotalIncGst.ToString("#,##0.00"));
headerProps.AddProperty("GST", (subTotalIncGst - subTotal).ToString("#,##0.00"));
return(DocumentService.CreateDocumentPdf(headerProps, records, template.QualTemplateFile, outputFile, maxItems));
}