/*This method construct the HTML */
public String HTMLBODY(int OrderID, String DTSNumber, String Imgfile, String bottomBanner)
{
String output = String.Empty;
String OrderOwner = String.Empty;
String PaymentTerms = String.Empty;
String OrderAccountOwner = String.Empty;
List <DeltoneItem> orderlist = new List <DeltoneItem>();
orderlist = getOrderedList(OrderID);
OrderOwner = orderDAL.getContactPersonForOrder(OrderID);
PaymentTerms = orderDAL.getPaymentTerms(OrderID);
OrderAccountOwner = orderDAL.getOrderCreatedBy(OrderID);
var typeOfCall = orderDAL.getTypeOfCall(OrderID);
output = "<!DOCTYPE HTML PUBLIC ' -//W3C//DTD HTML 3.2//EN'><html >";
output = output + "<body style='font-family:Calibri;'><table align='center' cellpadding='0' cellspacing='0' width='100%'><tr><td><table align='center' cellpadding='0' cellspacing='0' width='780px' height='85px'>";
output = output + "<tr><td>" + Imgfile + "</td></tr><tr><td> </td></tr><tr><td style='font-family:Calibri;'>";
output = output + "Dear " + OrderOwner + "</td></tr><tr><td> </td></tr><tr><td style='font-family:Calibri;'>";
if (typeOfCall == "Exchange")
{
output = output + "Thanks for contacting Deltone Solutions. <br />";
output = output + "<br /> Please find below the exchange order you placed with us today. A credit may be applicable to this order once the credit is approved. </td></tr>";
}
else
{
output = output + "Thanks for the order you placed with us today. <br />";
}
if (PaymentTerms == "1")
{
output = output + "<br /> We will dispatch the following goods and process your payment on the credit card provided.</td></tr>";
}
else
{
output = output + "<br /> We will dispatch the following goods on a " + PaymentTerms + " day account.</td></tr>";
}
output = output + "<tr><td> </td></tr><tr><td> </td></tr>";
output = output + "<tr><td><table style='width:720px;'><tr>";
output = output + "<td style='width:320px;text-align:left;font-family:Calibri;'><span style:'color:blue;font-family:Calibri;'>";
output = output + "Model - Deltone Brand</span></td><td style='width:200px;text-align:center;font-family:Calibri;'>";
output = output + "Quantity</td><td style='width:200px;text-align:center;font-family:Calibri;'>";
//output = output + "Unit Price Inc.GST</td></tr><tr><td><hr></td><td><hr></td><td><hr></td></tr>";
//output = output + "Total Price inc. GST</td></tr><tr><td><hr></td><td><hr></td><td><hr></td></tr>";
//output= "<table><tr><td colspan='2'>" + Imgfile + "</td></tr><tr><td colspan='2'>THANK YOU FOR ORDERING WITH DELTONE SOLUTIONS.</td></tr><tr><td><b>ORDER NO:</b></td><td>" + DTSNumber + "</td></tr><tr><td colspan='2'>ORDER SUMMERY</td></tr></table>";
output = output + "Unit Price Inc.GST</td><td style='width:200px;text-align:center;font-family:Calibri;'>";
output = output + "Total Price inc. GST</td></tr><tr><td style='width:200px;text-align:center;font-family:Calibri;'><hr></td><td><hr></td><td><hr></td><td><hr></td></tr>";
//output = output + "<table><thead><tr><td>DESCRIPTION</td><td>QUANTITY</td><td>UNIT AMOUNT</td></tr></thead><tbody>";
float UnitPriceFloat = 0;
String ConvertedUnitPrice = String.Empty;
// Create the Ordered Table
foreach (DeltoneItem item in orderlist)
{
output = output + "<tr><td style='width:320px;text-align:left;font-family:Calibri;'>" + item.ItemDescription + "</td>";
output = output + "<td style='width:200px;text-align:center;font-family:Calibri;'>" + item.Qty + "</td>";
decimal theUnitPrice = item.UnitPrice;
decimal totalPrice = theUnitPrice * item.Qty;
var unitPriceFormat = String.Format("{0:C2}", item.UnitPrice);
var totaPriceFormat = String.Format("{0:C2}", totalPrice);
//float theUnitPrice = item.UnitPrice;
//float exGSTUnitPrice = theUnitPrice - ((theUnitPrice * 10) / 100);
output = output + "<td style='width:200px;text-align:center;font-family:Calibri;'>" + unitPriceFormat + "</td>";
output = output + "<td style='width:200px;text-align:center;font-family:Calibri;'>" + totaPriceFormat + "</td></tr>";
}
output = output + "<tr><td> </td><td> </td><td> </td></tr>";
String ShippingCost = String.Empty;
ShippingCost = orderDAL.getCustomerShippingCost(OrderID);
String OrderTotal = String.Empty;
OrderTotal = orderDAL.getOrderTotal(OrderID);
String Urgency = orderDAL.getOrderUrgency(OrderID);
String UrgencyText = String.Empty;
String FooterText = String.Empty;
if (Urgency == "Standard")
{
UrgencyText = "in 2-4 business days";
FooterText = "within the next 2-4 days";
}
else if (Urgency == "Urgent")
{
UrgencyText = "in 1-2 business days";
FooterText = "within the next 2-4 days";
}
else if (Urgency == "End of Month")
{
UrgencyText = "at the end of the month";
FooterText = "at the end of the month";
}
else
{
UrgencyText = "in 2-4 business days";
FooterText = "within the next 2-4 days";
}
//output = output + "<tr><td style='width:320px;text-align:left;font-family:Calibri;'>DELIVERY & HANDLING</td><td style='width:200px;text-align:center;font-family:Calibri;'> </td><td style='width:200px;text-align:center;font-family:Calibri;'>" + ShippingCost + "</td></tr>";
//output = output + "<tr><td><hr></td><td><hr></td><td><hr></td></tr>";
//output = output + "<tr><td> </td><td style='width:200px;text-align:center;font-family:Calibri;'>TOTAL</td><td style='width:200px;text-align:center;font-family:Calibri;'>" + OrderTotal + "</td></tr>";
output = output + "<tr><td style='width:320px;text-align:left;font-family:Calibri;'>DELIVERY & HANDLING</td><td style='width:200px;text-align:center;font-family:Calibri;'> </td><td style='width:200px;text-align:center;font-family:Calibri;'> </td><td style='width:200px;text-align:center;font-family:Calibri;'>" + ShippingCost + "</td></tr>";
output = output + "<tr><td><hr></td><td><hr></td><td><hr></td><td><hr></td></tr>";
output = output + "<tr><td> </td><td> </td><td style='width:200px;text-align:center;font-family:Calibri;'>TOTAL INC.GST</td><td style='width:200px;text-align:center;font-family:Calibri;'>" + OrderTotal + "</td></tr>";
output = output + "</table></td></tr><tr><td> </td></tr><tr><td style='font-family:Calibri;'>Your order should arrive " + UrgencyText + " to the address below. </td></tr>";
String CompanyID = String.Empty;
CompanyID = orderDAL.getCompanyIDFromOrder(OrderID);
String CompanyName = String.Empty;
CompanyName = companyDAL.getCompanyNameByID(CompanyID);
String ContactID = String.Empty;
ContactID = orderDAL.getContactPersonID(OrderID);
String ContactAddressLine1 = String.Empty;
ContactAddressLine1 = contactDAL.getContactAddressLine1(ContactID);
String ContactAddressLine2 = String.Empty;
ContactAddressLine2 = contactDAL.getContactSubStaPost(ContactID);
output = output + "<tr><td> </td></tr><tr><td style='font-family:Calibri;'><strong>" + CompanyName + "<br/>Attn: " + OrderOwner + "<br/>" + ContactAddressLine1 + "<br/>" + ContactAddressLine2;
if (PaymentTerms == "1")
{
output = output + "</strong></td></tr><tr><td> </td></tr><tr><td style='font-family:Calibri;'>An invoice and payment receipt will be emailed to you shortly. Please don’t hesitate to contact us if you have any questions or queries. </td></tr><tr><td> </td></tr>";
}
else
{
output = output + "</strong></td></tr><tr><td> </td></tr><tr><td style='font-family:Calibri;'>An invoice will be emailed and posted to you " + FooterText + ". Please don’t hesitate to contact us if you have any questions or queries. </td></tr><tr><td> </td></tr>";
}
output = output + "<tr><td style='font-family:Calibri;'>Kind Regards</td></tr><tr><td> </td></tr><tr><td style='font-family:Calibri;'>" + OrderAccountOwner + "</td></tr><tr><td style='font-family:Calibri;'><strong>1300 787 783</strong></td></tr><tr><td> </td></tr><tr><td style='font-family:Calibri;'>" + bottomBanner + "</td></tr></table></td></tr><tr><td> </td></tr><tr><td> </td></tr></table></body></html>";
//output = output + "</tbody></table>";
//End Creating Order Table
return(output);
}