public string GetInvoiceHtmlString(SalesInvoiceModel salesInvoiceModel)
{
var sb = new StringBuilder();
decimal total = (decimal)salesInvoiceModel.SalesInvoiceDetails.Count;
int totalRow = (int)total;
decimal rowCount = total / 15;
int noOfPages = (int)Math.Ceiling(rowCount);
int limit = 15, start = 0;
int logoTop = 35;
//HTML
sb.Append(@"<html><body style='font-family:Helvetica; font-size:16px;'>");
for (int j = 1; j <= noOfPages; j++)
{
//Header Start
string HtmlHeader = @"<table style='border:0px solid black;' width='1280' Height='200'>
<tr style='border:0px solid black;' align='center' Height='50'>
<td style='font-size:20px; border:0px solid black; vertical-align:top;padding-top:15px;'>
<div style='text-align:center; padding-top:20px; position: rela1tive;'>
<img src='http://shayona.rocketpos.uk/img/clientlogo.jpg' width='350' height='140' style='position: absolute; left: 15px; top: " + logoTop + @"px' >" +
@"<div style='font-size:28px; font-weigth:bold'><b>" + salesInvoiceModel.InvoiceHeader + @"</b></div>
<div style='font-size:22px;'>" + salesInvoiceModel.OutletAddress1 +
"</br>" + salesInvoiceModel.OutletAddress2 +
"</br>" + salesInvoiceModel.OutletEmail +
"</br>" + salesInvoiceModel.OutletPhone +
"</div></div></div>" +
"</td></tr></table>";
sb.Append(HtmlHeader);
//Invoice Title
sb.Append(@"<table style='border-right:1px solid;border-left:1px solid;border-top:1px solid' width='1280' Height='35'>
<tr align='center'>
<td style='font-size:22px;'><b>INVOICE <b></td>
</tr>
</table>");
//Buyer name & two empty column
sb.Append(@"<table style='font-size:21px;border-right:1px solid;border-left:1px solid;border-top:1px solid' width='1280' Height='170'>
<tr>
<td style='padding-left:5px; border-right:1px solid;' width='398'> <b> Buyer</b></br> " + salesInvoiceModel.CustomerName + "</br> " + salesInvoiceModel.CustomerAddress1 + "</br> " + salesInvoiceModel.CustomerAddress2 + "</br> " + salesInvoiceModel.CustomerEmail + @"</br></br></td>
<td style='padding-left:5px;border-right:1px solid;' width='397'></td>
<td width='400'></td>
</tr>
</table>");
//Invoice no, Order No., Invoice Date, Page No
sb.Append(@"<table style='font-size:20px;border-right:1px solid;border-left:1px solid;border-top:1px solid' width='1280' Height='50'>
<tr>
<td style='padding-left:5px; border-right:1px solid;' width='400'><b>Invoice No.</b></br> " + salesInvoiceModel.ReferenceNo + @"</td>");
if (salesInvoiceModel.DeliveryNoteNumber != null)
{
if (salesInvoiceModel.DeliveryNoteNumber != "")
{
sb.Append(@"<td style='padding-left:5px; border-right:1px solid;' width='400'><b>Order No. </b></br> " + salesInvoiceModel.DeliveryNoteNumber + @"</td>");
}
else
{
sb.Append(@"<td style='padding-left:5px; border-right:1px solid;' width='400'></td>");
}
}
else
{
sb.Append(@"<td style='padding-left:5px; border-right:1px solid;' width='400'></td>");
}
sb.Append(@"<td width='400' style='padding-left:5px;'><b>Invoice Date </b></br><div style='float:left'>" + salesInvoiceModel.SalesInvoiceDate.ToShortDateString() + @"</div><div style='float:right'>" +
@"Page " + j.ToString() + @" of " + noOfPages.ToString() + @"</div>
</tr>
</table>");
//Item List
sb.Append(@"<table style='font-size:20px;border-right:1px solid;border-left:1px solid;border-top:1px solid' width='1280'>
<tr Height='42' >
<td style='padding-left:5px;;width:1.5%;text-align: right; padding-right:15px'><b>No</b></td>
<td style='width:66.5%;text-align: left; padding-right:15px'><b>Description of Goods</b></td>
<td style='width:7%;text-align: right; padding-right:40px'><b>Quantity</b></td>
<td style='width:7%;text-align: left; padding-right:20px'><b>UoM</b></td>
<td style='width:8%;text-align: right; padding-right:30px'><b>Rate</b></td>
<td style='width:10%;text-align: right; padding-right:15px'><b>Amount</b></td>
</tr>");
if (noOfPages == 1)
{
limit = 15;
if (totalRow < limit)
{
limit = totalRow;
}
}
else
{
limit = (j * 15);
if (totalRow < limit)
{
limit = totalRow - ((j - 1) * 15);
}
if (limit > 15)
{
limit = 15;
}
}
int i = 1;
for (; i <= limit; i++)
{
var item = salesInvoiceModel.SalesInvoiceDetails[start];
start++;
sb.AppendFormat(@"<tr Height='42'>
<td style='padding-left:5px; width:1.5%;text-align: right; padding-right:15px'>{0}</td>
<td style='width:66.5%;text-align: left; padding-right:15px'>{1}</td>
<td style='width:7%;text-align: right; padding-right:40px'>{2}</td>
<td style='width:7%;text-align: left; padding-right:20px'>{3}</td>
<td style='width:8%;text-align: right; padding-right:30px'>{4}</td>
<td style='width:10%;text-align: right; padding-right:15px'>{5}</td>
</tr>",
item.SrNumber, item.FoodMenuName, item.InvoiceQty.ToString("0.00"), item.UnitName, item.UnitPrice, item.GrossAmount);
}
for (; i <= 15; i++)
{
sb.AppendFormat(@"<tr Height='42'>
<td style='padding-left:5px; width:1.5%;text-align: right; padding-right:5px'></td>
<td style='width:58.5%;text-align: left; padding-right:5px'></td>
<td style='width:10%;text-align: right; padding-right:20px'></td>
<td style='width:12%;text-align: left; padding-right:20px'></td>
<td style='width:8%;text-align: right; padding-right:20px'></td>
<td style='width:10%;text-align: right; padding-right:15px'></td>
</tr>");
}
//emplty row
sb.AppendFormat(@"<table style='border-right:1px solid;border-left:1px solid;border-top:0px' Height='42' width = '1280'><tr></tr></table>");
string strAmountWord = "", VatableAmount = "", NonVatableAmount = "", TaxAmount = "", TotalAmount = "";
if (j == noOfPages)
{
strAmountWord = NumberToWords.ConvertAmount((double)salesInvoiceModel.TotalAmount) + " KENYAN SHILLINGS";
if (salesInvoiceModel.CustomerTaxInclusive)
{
VatableAmount = salesInvoiceModel.VatableAmount.ToString("0.00");
NonVatableAmount = salesInvoiceModel.NonVatableAmount.ToString("0.00");
TaxAmount = salesInvoiceModel.TaxAmount.ToString("0.00");
}
TotalAmount = salesInvoiceModel.TotalAmount.ToString("0.00");
}
//Reamrks & Totals
sb.Append(@"<table style='font-size:22px;border-right:1px solid;border-left:1px solid;border-top:1px solid' width = '1280' Height = '119' >
<tr Height='40'>
<td rowspan=2 style='padding-left:5px; width:76%; vertical-align:top; text-align : left;font-size:12px'>
<b>Remarks : </b></br>" + salesInvoiceModel.Notes + @"</td>
<td style='width:12%; text-align:right; border-left:1px solid; border-right:1px solid; border-bottom:1px solid; padding-right:15px;font-size:20px'><b>Vatable:</b></td >
<td style='width:12%; text-align:right;; border-bottom:1px solid; padding-right:15px;font-size:20px'><b>" + VatableAmount + @"</b></td>
</tr>
<tr Height='40'>
<td style='width:12%; text-align:right; border-right:1px solid; border-left:1px solid; border-bottom:1px solid; padding-right:15px;font-size:20px'><b>NON-VAT:</b></td>
<td style='width:12%; text-align:right;; border-bottom:1px solid; padding-right:15px;font-size:20px'><b>" + NonVatableAmount + @"</b></td>
</tr>
<tr Height='40'>
<td rowspan=2><div style='vertical-align:bottom;text-align:left;padding-left:5px; '>" + strAmountWord.ToString().ToUpper() + @"</div></td>
<td style='width:12%; text-align:right; border-right:1px solid; border-left:1px solid; border-bottom:1px solid; padding-right:15px;font-size:20px'><b>VAT Total:</b></td>
<td style='width:12%; text-align:right; border-bottom:1px solid; padding-right:15px;font-size:20px'><b>" + TaxAmount + @"</b></td>
</tr>
<tr Height='40' style='border:0px'>
<td style='width:12%; text-align:right; border-left:1px solid; border-right:1px solid;; padding-right:15px;font-size:20px'><b>Total</b></td>
<td style='width:12%; text-align:right; padding-right:15px;font-size:20px'><b>" + TotalAmount + @"</b></td>
</tr>
</table>");
//Terms and condition
sb.Append(@"<table style='font-size:20px;border:1px solid; ' width = '1280' Height = '220'>
<tr Height='50'>
<td colspan='7' style='padding-left:5px; vertical-align:top;'><b>Terms and Conditions: </b>");
string strInvoiceTerms = LoginInfo.InvoiceTerms;
string[] strSplit = strInvoiceTerms.Split('\n');
for (i = 0; i < strSplit.Length; i++)
{
sb.Append(@"</br>" + strSplit[i]);
}
sb.Append(@"</td>
</tr>
</table>");
//emplty row
sb.AppendFormat(@"<table style='border:0px solid;' Height='40'></table>");
//logo at header settings
logoTop = logoTop + 1654 + (j * 14);
}
//end of body and html
sb.Append(@"</body></html>");
return(sb.ToString());
}
public ActionResult InvoicePrintold(int id)
{
int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString());
int companyid = Convert.ToInt32(Session["CurrentCompanyID"].ToString());
NumberToWords _numtoword = new NumberToWords();
ViewBag.Customer = db.CustomerMasters.ToList();
ViewBag.Movement = db.CourierMovements.ToList();
var _invoice = db.CustomerInvoices.Find(id);
CustomerInvoiceVM _custinvoice = new CustomerInvoiceVM();
_custinvoice.CustomerInvoiceID = _invoice.CustomerInvoiceID;
_custinvoice.InvoiceDate = _invoice.InvoiceDate;
_custinvoice.CustomerInvoiceNo = _invoice.CustomerInvoiceNo;
_custinvoice.CustomerID = _invoice.CustomerID;
var _cust = db.CustomerMasters.Find(_invoice.CustomerID);
_custinvoice.CustomerName = _cust.CustomerName;
_custinvoice.CustomerCountryName = _cust.CountryName;
_custinvoice.CustomerCityName = _cust.CityName;
_custinvoice.CustomerPhoneNo = _cust.Phone;
_custinvoice.CustomerCode = _cust.CustomerCode;
_custinvoice.CustomerTRNNo = _cust.VATTRN;
_custinvoice.InvoiceTotal = _invoice.InvoiceTotal;
//_custinvoice.invoiceFooter = (from c in db.GeneralSetups join d in db.GeneralSetupTypes on c.SetupID equals d.ID where d.TypeName == "Invoicefooter" select c.Text1).FirstOrDefault();
_custinvoice.generalSetup = (from c in db.GeneralSetups join d in db.GeneralSetupTypes on c.SetupID equals d.ID where d.TypeName == "InvoiceFooter" && c.BranchId == branchid select c).FirstOrDefault();
var comp = db.AcCompanies.Find(companyid);
_custinvoice.CurrencyName = db.CurrencyMasters.Find(comp.CurrencyID).Symbol;
if (comp.LogoFileName == "" || comp.LogoFileName == null)
{
ViewBag.LogoPath = "/UploadFiles/" + "defaultlogo.png";
}
else
{
ViewBag.LogoPath = "/UploadFiles/" + comp.LogoFileName;
}
string monetaryunit = Session["MonetaryUnit"].ToString();
_custinvoice.InvoiceTotalInWords = NumberToWords.ConvertAmount(Convert.ToDouble(_custinvoice.InvoiceTotal), monetaryunit);
List <CustomerInvoiceDetailVM> _details = new List <CustomerInvoiceDetailVM>();
_details = RevenueDAO.GenerateInvoice(DateTime.Now, DateTime.Now, _invoice.CustomerID, 0, _invoice.CustomerInvoiceID);
int _index = 0;
foreach (var item in _details)
{
_details[_index].AWBChecked = true;
_custinvoice.TotalCharges += _details[_index].TotalCharges;
_index++;
}
_custinvoice.CustomerInvoiceDetailsVM = _details;
_custinvoice.CustomerInvoiceDetailsVM = _details;
Session["InvoiceListing"] = _details;
return(View(_custinvoice));
}
