public String HTMLBody(int QuoteID, String imgFile, String bottomBanner)
{
String output = String.Empty;
String WhichDB = String.Empty;
String EmailHeader = String.Empty;
String EmailFooter = String.Empty;
EmailHeader = quoteDAL.getEmailHeaderText(QuoteID);
EmailFooter = quoteDAL.getEmailFooterText(QuoteID);
List <QuoteItems> quoteList = new List <QuoteItems>();
quoteList = getOrderedList(QuoteID);
WhichDB = quoteDAL.getWhichDBToQuery(QuoteID);
var quoteUser = quoteDAL.getOrderOwner(QuoteID);
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 + EmailHeader.Replace(Environment.NewLine, "<br/>") + "</td></tr><tr><td> </td></tr><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:100px;text-align:center;font-family:Calibri;'>";
//output = output + "Price ex. GST</td><td style='width:100px;text-align:center;font-family:Calibri;'>";
//output = output + "Price inc. GST</td></tr><tr><td><hr></td><td><hr></td><td><hr></td><td><hr></td></tr>";
output = output + "Unit Price Inc.GST</td><td style='width:100px;text-align:center;font-family:Calibri;'>";
output = output + "Total Price inc. GST</td></tr><tr><td><hr></td><td><hr></td><td><hr></td><td><hr></td></tr>";
foreach (QuoteItems item in quoteList)
{
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.Quantity + "</td>";
float theUnitPrice = item.UnitPrice;
float totalPrice = theUnitPrice * item.Quantity;
//float theUnitPrice = item.UnitPrice;
//float exGSTUnitPrice = theUnitPrice - ((theUnitPrice * 10) / 100);
output = output + "<td style='width:100px;text-align:center;font-family:Calibri;'>" + String.Format("{0:C2}", item.UnitPrice) + "</td>";
output = output + "<td style='width:100px;text-align:center;font-family:Calibri;'>" + String.Format("{0:C2}", totalPrice) + "</td></tr>";
}
output = output + "<tr><td> </td><tr> </td><td> </td><td> </td></tr>";
String ShippingCost = String.Empty;
ShippingCost = quoteDAL.getShippingCost(QuoteID);
String Quotetotal = String.Empty;
Quotetotal = quoteDAL.getTotal(QuoteID);
var quoteMember = "SALES TEAM";
if (!string.IsNullOrEmpty(quoteUser))
{
quoteMember = quoteUser;
}
Char spacer = (char)13;
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;'>" + String.Format("{0:C2}", float.Parse(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;'>" + String.Format("{0:C2}", float.Parse(Quotetotal)) + "</td></tr>";
output = output + "</table></td></tr><tr><td> </td></tr><tr><td style='font-family:Calibri;'>" + EmailFooter.Replace(spacer.ToString(), "<br/>") + "</td></tr>";
output = output + "<tr><td> </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;'>" + quoteMember + "</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>";
return(output);
}
