public Dictionary <string, string> TokenData(int plotId, string tokenTemplate)
{
string appPath = ConfigurationManager.AppSettings["AppPath"];
if (!ConfigurationManager.AppSettings.AllKeys.Any(a => a == "AppPath"))
{
throw new Exception("AppPath not defined in web.config file.");
}
string FaceImage = appPath + "Content/Images/photo.jpg";
string ThumbImage = appPath + "Content/Images/thumb.jpg";
TemplateService templateService = new TemplateService();
Dictionary <string, string> tokens = templateService.GetTokensByModulName(tokenTemplate);
using (var ctx = new AppDb())
{
tokens["Common.CurrentDate"] = DateTime.Now.ToString("dd-MM-yyyy");
var plotDetails = ctx.plot.First(f => f.Id == plotId);
if (plotDetails != null)
{
tokens["Payment.Floor"] = plotDetails.Floor;
tokens["Payment.Unit.No"] = plotDetails.PlotNo;
tokens["Payment.CarpetArea"] = plotDetails.CarpetArea;
tokens["Payment.Construction.Area"] = plotDetails.ConstructionArea;
tokens["Payment.ConstructionArea"] = plotDetails.ConstructionArea;
tokens["Payment.UndividedLand"] = plotDetails.UndividedLand;
tokens["Payment.SuperBuildUp"] = plotDetails.SuperBuildUp;
tokens["Payment.Proportionate.Land"] = plotDetails.ProportionateLand;
tokens["Payment.DirectionsNorth"] = plotDetails.DirectionsNorth;
tokens["Payment.DirectionsSouth"] = plotDetails.DirectionsSouth;
tokens["Payment.DirectionsEast"] = plotDetails.DirectionsEast;
tokens["Payment.DirectionsWest"] = plotDetails.DirectionsWest;
tokens["Payment.RegNo"] = plotDetails.RegNo;
tokens["Payment.RegDate"] = plotDetails.RegDate.HasValue ? plotDetails.RegDate.Value.ToString("dd-MM-yyyy") : "";
tokens["Payment.AllotmentLtDt"] = plotDetails.AllotmentLtDt.HasValue ? plotDetails.AllotmentLtDt.Value.ToString("dd-MM-yyyy") : "";
tokens["Payment.TitleClearFrom"] = plotDetails.TitleClearFrom.HasValue ? plotDetails.TitleClearFrom.Value.ToString("dd-MM-yyyy") : "";
tokens["Payment.TitleClearDt"] = plotDetails.TitleClearDt.HasValue ? plotDetails.TitleClearDt.Value.ToString("dd-MM-yyyy") : "";
tokens["Maintenance.Amount"] = plotDetails.MaintenanceAmount.HasValue ? plotDetails.MaintenanceAmount.Value.ToString("#.##") : "0.00";
tokens["Maintenance.Amount.word"] = NumberToWords(Convert.ToInt32(plotDetails.MaintenanceAmount ?? 0));
tokens["Sale.Amount"] = plotDetails.SellAmount.ToString("#.##");
tokens["Sale.Amount.word"] = NumberToWords(Convert.ToInt32(plotDetails.SellAmount));
double outstanding = plotDetails.SellAmount - (plotDetails.SellAmount * 0.10);
tokens["Amount.Outstanding"] = outstanding.ToString("#.##");
tokens["Amount.Outstanding.word"] = NumberToWords(Convert.ToInt32(outstanding));
tokens["Amount.10"] = (plotDetails.SellAmount * 0.10).ToString("#.##");
tokens["Amount.10.word"] = NumberToWords(Convert.ToInt32(plotDetails.SellAmount * 0.10));
tokens["Amount.30"] = (plotDetails.SellAmount * 0.20).ToString("#.##");
tokens["Amount.30.word"] = NumberToWords(Convert.ToInt32(plotDetails.SellAmount * 0.20));
tokens["Amount.45"] = (plotDetails.SellAmount * 0.15).ToString("#.##");
tokens["Amount.45.word"] = NumberToWords(Convert.ToInt32(plotDetails.SellAmount * 0.15));
tokens["Amount.70"] = (plotDetails.SellAmount * 0.25).ToString("#.##");
tokens["Amount.70.word"] = NumberToWords(Convert.ToInt32(plotDetails.SellAmount * 0.25));
double slabAmount = (plotDetails.SellAmount * 0.25);
tokens["Amount.FirstSlab"] = (slabAmount * 0.40).ToString("#.##");
tokens["Amount.FirstSlab.word"] = NumberToWords(Convert.ToInt32((slabAmount * 0.40)));
tokens["Amount.ThirdSlab"] = (slabAmount * 0.40).ToString("#.##");
tokens["Amount.ThirdSlab.word"] = NumberToWords(Convert.ToInt32((slabAmount * 0.40)));
tokens["Amount.FifthSlab"] = (slabAmount * 0.20).ToString("#.##");
tokens["Amount.FifthSlab.word"] = NumberToWords(Convert.ToInt32((slabAmount * 0.20)));
tokens["Amount.75"] = (plotDetails.SellAmount * 0.05).ToString("#.##");
tokens["Amount.75.word"] = NumberToWords(Convert.ToInt32((plotDetails.SellAmount * 0.05)));
tokens["Amount.80"] = (plotDetails.SellAmount * 0.05).ToString("#.##");
tokens["Amount.80.word"] = NumberToWords(Convert.ToInt32((plotDetails.SellAmount * 0.05)));
tokens["Amount.85"] = (plotDetails.SellAmount * 0.05).ToString("#.##");
tokens["Amount.85.word"] = NumberToWords(Convert.ToInt32((plotDetails.SellAmount * 0.05)));
tokens["Amount.95"] = (plotDetails.SellAmount * 0.10).ToString("#.##");
tokens["Amount.95.word"] = NumberToWords(Convert.ToInt32((plotDetails.SellAmount * 0.10)));
tokens["Amount.5"] = (plotDetails.SellAmount * 0.05).ToString("#.##");
tokens["Amount.5.word"] = NumberToWords(Convert.ToInt32((plotDetails.SellAmount * 0.05)));
List <customer> customers = ctx.customer.Where(f => f.PlotID == plotDetails.Id).ToList();
string saleDeedSignature = "";
string customerDetails = "<table cellspacing ='5' cellpadding='5' style='width:80%; border-collapse: collapse; margin : 20px 10px;'>";
foreach (var item in customers.Select((val, i) => new { val, i }))
{
customerDetails += "<tr><td>" + (item.i + 1) + ".</td><td>";
customerDetails += "<table cellspacing ='5' cellpadding='5'>";
customerDetails += "<tr>";
customerDetails += "<td>" + item.val.CustomerName + ", Aged: Adult (" + item.val.Age + " years), Occuption:" + item.val.Occupation + "</td>";
customerDetails += "</tr><tr>";
customerDetails += "<td>PAN: " + item.val.PANCard + ", ADHAR CARD:" + item.val.AdharCard + "</td>";
customerDetails += "</tr><tr>";
customerDetails += "<td>Email ID: " + item.val.Email + "</td>";
customerDetails += "</tr></table>";
customerDetails += "</td></tr>";
saleDeedSignature += @"<div style='margin-top: 50px;'><br />
<table style='width:100%;'>
<thead>
<tr>
<th scope='col' style='width:40%'>Signature</th>
<th scope='col' style='text-align:center; width:30%'>Photo</th>
<th scope='col' style='text-align:center; width:30%'>Left Hand Thumb</th>
</tr>
</thead>
<tbody>
<tr>
<td> </td>
<td style='text-align:center'><img alt='' src='{{Face.Image}}' style='height:170px; width:150px' /></td>
<td style='text-align:center'><img alt='' src='{{Thumb.Image}}' style='height:150px; width:150px' /></td>
</tr>" ;
saleDeedSignature += @"<tr>
<td>_________________________<br /></td>
<td style='text-align:center'></td>
<td style='text-align:center'></td>
</tr>" ;
saleDeedSignature += @"<tr><td><br />(" + item.val.CustomerName + ")</td></tr>";
saleDeedSignature += @"</tbody></table></div>";
}
saleDeedSignature = saleDeedSignature.Replace("{{Face.Image}}", FaceImage).Replace("{{Thumb.Image}}", ThumbImage);
tokens["SaleDeed.Signature"] = saleDeedSignature;
customerDetails += "</table>";
tokens["Customer.Details"] = customerDetails;
var customer = customers.FirstOrDefault();
tokens["Payment.Customer"] = customer.CustomerName;
tokens["Customer.Name"] = customer.CustomerName;
tokens["Customer.Age"] = Convert.ToString(customer.Age);
tokens["Customer.Address"] = Convert.ToString(customer.Address);
tokens["Customer.PANNo"] = Convert.ToString(customer.PANCard);
tokens["Customer.AdharNo"] = Convert.ToString(customer.AdharCard);
tokens["Customer.Email"] = Convert.ToString(customer.Email);
var siteDetails = ctx.site.First(f => f.Id == plotDetails.SiteID);
Random random = new Random();
int randomNumber = random.Next(0, 1000);
tokens["Site.Logo"] = appPath + "Content/Images/SiteLogos/" + plotDetails.SiteID + ".png?v=" + randomNumber;
tokens["Site.Address"] = siteDetails.Address;
tokens["Site.Developer"] = siteDetails.Developer;
tokens["Site.WebSite"] = siteDetails.WebSite;
}
var objPay = ctx.payment.FirstOrDefault(f => f.PlotID == plotId);
if (objPay != null)
{
tokens["Payment.Id"] = Convert.ToString(objPay.Id);
tokens["Payment.Amount"] = Convert.ToString(objPay.Amount);
tokens["Payment.ChaqueueNo"] = Convert.ToString(objPay.ChequeNo);
tokens["Payment.ChaqueueDate"] = objPay.ChequeDateformate;
tokens["Payment.Drawn.On"] = objPay.DateOfIssueformate;
tokens["Payment.Bank"] = objPay.Bank;
tokens["Payment.Part"] = objPay.Part;
tokens["Payment.Amount.word"] = NumberToWords(objPay.Amount ?? 0).ToUpperInvariant() + " Only/-";
}
string paymentTable = @"<table border='1' cellpadding='2' style='width:90%; border-collapse:collapse; margin : 10px 10px;'><tr><th>Sr.No.</th> <th>Amount (Rs.)</th> <th>Cheque No.</th> <th>Cheque Date</th> <th>Bank</th></tr>";
double totPay = 0;
var objPayList = ctx.payment.Where(f => f.PlotID == plotId).ToList();
foreach (var item in objPayList.Select((val, i) => new { val, i }))
{
totPay += item.val.Amount ?? 0;
paymentTable += "<tr> <th>" + (item.i + 1) + "</th> <th>" + item.val.Amount + "</th> <th>" + item.val.ChequeNo + "</th> <th>" + item.val.ChequeDateformate + "</th> <th>" + item.val.Bank + "</th> </tr>";
}
paymentTable += "</table>";
tokens["Payment.Table"] = paymentTable;
tokens["Payment.TotalPayment"] = tokens["Payment.Total"] = Convert.ToString(totPay);
tokens["Payment.TotalPayment.word"] = tokens["Payment.Total.word"] = NumberToWords(Convert.ToInt32(totPay));
tokens["Face.Image"] = appPath + "Content/Images/photo.jpg";
tokens["Thumb.Image"] = appPath + "Content/Images/thumb.jpg";
}
return(tokens);
}