public static string BusinessPermitApprovedTemplate(BusinessPermit.Models.BusinessPermit permit, List <Fee> fees)
{
// Thank you for using the service. Have a nice day!
string result = String.Format(@"<br>
Good Day!
<br/>
<br/>
<br/>
<br/>
<div style=""margin-left:30px;"">
This is to inform you that your application for <b>Business Permit</b> has been <b>APPROVED</b>.
<br/>
<br/>
Your Reference Number for the permits payment is <b>{0}</b>
<br/>
<br/>
The following are your fees for this application:
<br/>
<br/>", permit.PaymentReference);
float total = 0;
foreach (var item in fees)
{
total += item.Price;
result += string.Format("P{0} - {1} <br/><br/>", item.Price, item.Description);
}
result += "P" + total + " - <b>TOTAL</b> <br/><br/> ";
result += String.Format("For us to verify your payment, kindly click this <a href=\"{0}\">link</a> upon settling your account. <br/><br/>", GetPaymentUrl());
result += " </div><br/><br/><br/><br/> Thank you for using the service. Have a nice day!";
return(result);
}
// GET: /aw/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BusinessPermit.Models.BusinessPermit businesspermit = db.BusinessPermits.Find(id);
if (businesspermit == null)
{
return(HttpNotFound());
}
return(View(businesspermit));
}
private async Task ApproveBusiness(Payment payment)
{
BusinessPermit.Models.BusinessPermit permit = await db.BusinessPermits.Include(b => b.ZoningClearance).SingleOrDefaultAsync(z => z.PaymentReference == payment.ReferenceNumber);
if (permit != null)
{
permit.Status = "Paid";
payment.Status = "Confirmed";
payment.TotalPayment = permit.TotalPayment;
db.Entry(permit).State = EntityState.Modified;
db.Entry(payment).State = EntityState.Modified;
await db.SaveChangesAsync();
// email ung attachment with congratulations
EmailSender.SendMail(permit.ZoningClearance.EmailAddress, "Business Permit Certification", EmailSender.LocationalClearanceCertifyTemplate(), EmailSender.CreateAttachment(permit));
}
}
public ActionResult ApproveApplication(int?id)
{
var permitQuery = db.BusinessPermits.Include(b => b.ZoningClearance);
BusinessPermit.Models.BusinessPermit permit = permitQuery.FirstOrDefault(p => p.Id == id);
List <Fee> fees = db.Fees.Include(p => p.ApplicationType).Where(p => p.ApplicationType.Description.Contains("Business")).ToList();
if (permit == null)
{
return(HttpNotFound());
}
permit.Status = "Approved";
permit.PaymentReference = base.RandomString();
db.Entry(permit).State = EntityState.Modified;
permit.TotalPayment = fees.Sum(f => f.Price);
db.SaveChanges();
EmailSender.SendMail(permit.ZoningClearance.EmailAddress, "Business Permit Application : Approved", EmailSender.BusinessPermitApprovedTemplate(permit, fees));
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "Id,IsNew,BusinessAccountNumber,DateApplied,BusinessName,OwnerName,BusinessAddress,BusinessNature,DeliveryVehicles,TotalAreaBusiness,ContactNumber,TotalEmployee,RentedOwnerName,MonthlyRental,JanGrossReceipt,FebGrossReceipt,MarGrossReceipt,AprGrossReceipt,MayGrossReceipt,JunGrossReceipt,JulGrossReceipt,AugGrossReceipt,SepGrossReceipt,OctGrossReceipt,NovGrossReceipt,DecGrossReceipt,TotalGrossReceipt,CapitalInvestment,DateStartedRemarks,CapitalInvestmentRemarks,AreaRemarks,GrossSalesPerDay,GrossSalesPerYear,PreviousBasisLicenseTax,CurrentBasisLicenseTax,AssessedAmount,Status,ZoningClearanceReferenceNumber")] BusinessPermit.Models.BusinessPermit businesspermit, HttpPostedFileBase uploadFile)
{
if (uploadFile != null)
{
businesspermit.Attachments = base.GetFileBytes(uploadFile);
businesspermit.DateApplied = DateTime.Now;
businesspermit.Status = "Pending";
ZoningClearance zoning = db.ZoningClearance.Where(z => z.ApplicationNumber == businesspermit.ZoningClearanceReferenceNumber).FirstOrDefault();
if (zoning == null)
{
return(View(businesspermit));
}
if (businesspermit.IsNew == false)
{
BusinessPermit.Models.BusinessPermit previous = db.BusinessPermits.Where(z => z.BusinessAccountNumber == businesspermit.BusinessAccountNumber).OrderBy(p => p.DateApplied).FirstOrDefault();
if (previous != null)
{
if (previous.TotalGrossReceipt > businesspermit.TotalGrossReceipt)
{
businesspermit.TotalGrossReceipt = previous.TotalGrossReceipt;
}
}
}
businesspermit.BusinessAddress = zoning.BusinessAddress;
businesspermit.BusinessName = zoning.BusinessName;
businesspermit.BusinessNature = zoning.BusinessNature;
businesspermit.OwnerName = zoning.OwnerName;
businesspermit.ZoningClearanceId = zoning.ZoningClearanceId;
db.BusinessPermits.Add(businesspermit);
db.SaveChanges();
return(RedirectToAction("ApplicationSuccess"));
}
return(View(businesspermit));
}
public static Attachment CreateAttachment(BusinessPermit.Models.BusinessPermit building)
{
Document doc = new Document(new Rectangle(PageSize.A4));
//Create PDF Table
PdfPTable tableLayout = new PdfPTable(4);
string fileName = string.Format("BusinessPermit-{0}-{1}.pdf", building.BusinessAccountNumber, DateTime.Now.ToShortDateString().Replace("/", ""));
string path = HttpContext.Current.Server.MapPath(string.Format("~/App_Data/{0}", fileName));
FileStream fm = new FileStream(path, FileMode.Create);
//Create a PDF file in specific path
PdfWriter.GetInstance(doc, fm);
//Open the PDF document
doc.Open();
Paragraph para = new Paragraph(@"BUSINESS PERMIT AND LICENSE OFFICE",
new Font(Font.FontFamily.TIMES_ROMAN, 14f, Font.BOLD, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para.Alignment = Element.ALIGN_CENTER;
doc.Add(para);
Paragraph para1 = new Paragraph(@"BUSINESS PERMIT",
new Font(Font.FontFamily.TIMES_ROMAN, 14f, Font.BOLD, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para1.Alignment = Element.ALIGN_CENTER;
doc.Add(para1);
Paragraph para9 = new Paragraph("THIS IS TO CERTIFY THAT.",
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.NORMAL, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para9.SpacingBefore = 30;
para9.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para9);
Paragraph para8 = new Paragraph(building.BusinessName,
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.UNDERLINE, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para8.SpacingBefore = 5;
para8.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para8);
Paragraph para10 = new Paragraph(@"(Business Trade Name)",
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.NORMAL, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para10.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para10);
Paragraph para11 = new Paragraph(building.OwnerName,
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.UNDERLINE, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para11.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para11);
Paragraph para14 = new Paragraph(@"(Business Owner's Name)",
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.NORMAL, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para14.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para14);
Paragraph para15 = new Paragraph(building.BusinessAddress,
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.UNDERLINE, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para15.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para15);
Paragraph para16 = new Paragraph(@"(Business Address)",
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.NORMAL, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para16.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para16);
Paragraph para7 = new Paragraph(@"is hereby granted this permit nad license to operate and/or establish his/her business in the city subject to the provisions of the City Revenue Code of Marikina and other ordinances/laws/regulations pertinent thereto.",
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.NORMAL, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para7.SpacingBefore = 10;
para7.Alignment = Element.ALIGN_JUSTIFIED_ALL;
// Adding this 'para' to the Document object
doc.Add(para7);
Image sign = Image.GetInstance(HttpContext.Current.Server.MapPath(string.Format("~/Images/Other.png")));
sign.SpacingBefore = 40;
sign.Alignment = Element.ALIGN_LEFT;
sign.ScaleToFit(140f, 120f);
doc.Add(sign);
Paragraph para12 = new Paragraph("Atty. Nancy V. Taylan Marcelino Teodoro",
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.BOLD, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para12.Alignment = Element.ALIGN_LEFT;
// Adding this 'para' to the Document object
doc.Add(para12);
Paragraph para13 = new Paragraph("Locational Administrator/Business Permit Licensing Office Honorable City Mayor",
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.NORMAL, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para13.Alignment = Element.ALIGN_LEFT;
// Adding this 'para' to the Document object
doc.Add(para13);
Paragraph para17 = new Paragraph("ERASURES OR ALTERATIONS WILL INVALIDATE THIS PERMIT",
new Font(Font.FontFamily.TIMES_ROMAN, 12f, Font.BOLD, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para17.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para17);
Paragraph para18 = new Paragraph(@"this PERMIT should be conspicuously at the place when the business before is/are being conducted and shall be presented and/or surrendered to concerened authorities upon demand. This permit is revocable and is null and void if t he permittee violates any applicable law ordinance and/or regulation or if he fails to pay any tax and fee charges as they become due.",
new Font(Font.FontFamily.TIMES_ROMAN, 10f, Font.NORMAL, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para18.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para18);
Paragraph para19 = new Paragraph(@"In case of business closer/retirment, please surrender this permit to the office of BPLO twenty (20) days after said closure to avoid penalty.",
new Font(Font.FontFamily.TIMES_ROMAN, 10f, Font.NORMAL, BaseColor.BLACK));
// Setting paragraph's text alignment using iTextSharp.text.Element class
para19.Alignment = Element.ALIGN_CENTER;
// Adding this 'para' to the Document object
doc.Add(para19);
// Closing the document
doc.Close();
ContentType ct = new ContentType(System.Net.Mime.MediaTypeNames.Application.Pdf);
Attachment attachment = new Attachment(path);
attachment.ContentDisposition.FileName = fileName + ".pdf";
return(attachment);
}