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); }