if(a==0){
Sub_Scheme2.Visible = false;
PMU_Address.Visible = false;
Txt_CF.Visible = true;
Txt_RCCF.Visible = true;
Txt_CFClaimforRC.Visible = true;
Lbl_Show_Calculation_Res_CF.Visible = true;
Txt_RCCFClaimforRC.Visible = true;
Lbl_Show_Calculation_Res_RCCF.Visible = true;
Txt_CFClaimforGC.Visible = true;
Lbl_Show_Calculation_Gen_CF.Visible = true;
Txt_RCCFClaimforGC.Visible = true;
Lbl_Show_Calculation_Gen_RCCF.Visible = true;
Txt_TotalCF.Visible = true;
Lbl_TotalCFWords.Visible = true;
Txt_TotalRCCF.Visible = true;
Lbl_TotalRCCFWords.Visible = true;
Invoice_FileName = "TPInvoice-" + PARAInvoiceID + ".pdf";
Response.ContentType = "application/pdf";
StringWriter stringWriter = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
DivIdToPrint.RenderControl(htmlTextWriter);
StringReader stringReader = new StringReader(stringWriter.ToString());
Document Doc = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();
PdfWriter writer = PdfWriter.GetInstance(Doc, memoryStream);
HTMLWorker htmlparser = new HTMLWorker(Doc);
PdfWriter.GetInstance(Doc, Response.OutputStream);
Doc.Open();
BaseFont bfTimes = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, false);
BaseFont bfTimes1 = BaseFont.CreateFont(BaseFont.COURIER, BaseFont.CP1250, false);
iTextSharp.text.Font font = new iTextSharp.text.Font(bfTimes, 10, iTextSharp.text.Font.BOLDITALIC, iTextSharp.text.Color.RED);
iTextSharp.text.Font font1 = new iTextSharp.text.Font(bfTimes, 10, iTextSharp.text.Font.BOLDITALIC, iTextSharp.text.Color.BLACK);
iTextSharp.text.Font font2 = new iTextSharp.text.Font(bfTimes, 10, iTextSharp.text.Font.NORMAL, iTextSharp.text.Color.BLUE);
iTextSharp.text.Font font3 = new iTextSharp.text.Font(bfTimes, 10, iTextSharp.text.Font.NORMAL, iTextSharp.text.Color.BLACK);
iTextSharp.text.Font font4 = new iTextSharp.text.Font(bfTimes1, 10, iTextSharp.text.Font.BOLDITALIC, iTextSharp.text.Color.BLACK);
iTextSharp.text.Font font5 = new iTextSharp.text.Font(bfTimes, 9, iTextSharp.text.Font.NORMAL, iTextSharp.text.Color.BLACK);
PdfPTable table = new PdfPTable(1);
table.TotalWidth = 580f;
table.LockedWidth = true;
PdfPCell header = new PdfPCell(new Phrase("TAX INVOICE/BILL OF SUPPLY", font));
header.HorizontalAlignment = 1;
table.AddCell(header);
table.SpacingAfter = 8f;
Doc.Add(table);
PdfPTable table1 = new PdfPTable(7);
table1.TotalWidth = 580f;
table1.LockedWidth = true;
table1.HorizontalAlignment = 0;
//PdfPCell left = new PdfPCell(new Paragraph("TP NAME: </br> GSTIN:- </br> HSN CODE:-"));
//left.BorderColor = iTextSharp.text.Color.BLACK;
PdfPTable left1 = new PdfPTable(1);
left1.AddCell(new Phrase ("TP NAME:" + Lbl_TP_Name.Text+
"\n GSTIN: " + Lbl_GSTNo.Text + "\n HSN CODE: " + Lbl_HSNCode.Text, font1));
PdfPCell nesthousing = new PdfPCell(left1);
nesthousing.Colspan = 3;
nesthousing.Padding = 0f;
table1.AddCell(nesthousing);
nesthousing.Padding = 0f;
//table1.AddCell(left);
PdfPCell middle1 = new PdfPCell();
table1.AddCell(middle1);
PdfPCell right1 = new PdfPCell(new Phrase("TP-ADDRESS: " + Lbl_Address.Text, font1));
right1.Colspan = 3;
table1.AddCell(right1);
table1.SpacingAfter = 8f;
Doc.Add(table1);
PdfPTable table2 = new PdfPTable(7);
table2.TotalWidth = 580f;
table2.LockedWidth = true;
table2.HorizontalAlignment = 0;
PdfPCell left2 = new PdfPCell(new Phrase("INVOICE NO: " + Lbl_RefNo.Text, font1));
left2.Colspan = 3;
table2.AddCell(left2);
PdfPCell middle2 = new PdfPCell();
table2.AddCell(middle2);
PdfPCell right2 = new PdfPCell(new Phrase("DATE: " + Lbl_CreationDate.Text, font1));
right2.Colspan = 7;
table2.AddCell(right2);
table2.SpacingAfter = 8f;
Doc.Add(table2);
PdfPTable table3 = new PdfPTable(7);
table3.TotalWidth = 580f;
table3.LockedWidth = true;
table3.HorizontalAlignment = 0;
PdfPCell left3 = new PdfPCell(new Phrase("BILL To:" + PMU_Address.InnerText, font1));
left3.Colspan = 3;
table3.AddCell(left3);
PdfPCell middle3 = new PdfPCell();
table3.AddCell(middle3);
PdfPCell right3 = new PdfPCell(new Phrase("Place of Supply:"+
"\n\n\n State Name:" + Lbl_StateName.Text +
"\n State Code:" + Lbl_StateCode.Text, font1));
right3.Colspan = 3;
table3.AddCell(right3);
table3.SpacingAfter = 0f;
Doc.Add(table3);
Paragraph para = new Paragraph("SECTION A", font4);
para.Alignment = Element.ALIGN_LEFT;
para.SpacingAfter = 8f;
Doc.Add(para);
//PdfPTable table4 = new PdfPTable(1);
//table4.TotalWidth = 580f;
//table4.LockedWidth = true;
//PdfPCell header1 = new PdfPCell(new Phrase("1. It is certified that " +Lbl_TP_Name.Text+ " is affiliated with " +Lbl_KIA.Text + ", and the following claim is being made after completion of training, in-line with the scheme Guidelines.", font1));
//header1.HorizontalAlignment = 0;
//table4.AddCell(header1);
PdfPTable table4 = new PdfPTable(4);
table4.TotalWidth = 580f;
table4.LockedWidth = true;
PdfPCell cell = new PdfPCell(new Phrase("1. It is certified that " + Lbl_TP_Name.Text + " is affiliated with " + Lbl_KIA.Text +" " +Scheme2_Name.InnerText + ", and the following claim is being made after completion of training, in-line with the scheme Guidelines.", font1));
cell.Colspan = 4;
cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right
table4.AddCell(cell);
table4.AddCell(new Phrase("2. TP ID", font2));
table4.AddCell(new Phrase(Txt_TpID.Text, font3));
table4.AddCell(new Phrase("3. State Name", font2));
table4.AddCell(new Phrase(Lbl_State_Name.Text, font3));
table4.AddCell(new Phrase("4. Course Code", font2));
table4.AddCell(new Phrase(Txt_CourseCode.Text, font3));
table4.AddCell(new Phrase("5. Course Name", font2));
table4.AddCell(new Phrase(Txt_CourseName.Text, font3));
table4.AddCell(new Phrase("6. Batch ID", font2));
table4.AddCell(new Phrase(Txt_BatchCode.Text, font3));
table4.AddCell(new Phrase("7. Batch Start Date", font2));
table4.AddCell(new Phrase(Txt_BatchStartDate.Text, font3));
table4.AddCell(new Phrase("8. Batch End Date", font2));
table4.AddCell(new Phrase(Txt_BatchEndDate.Text, font3));
table4.AddCell(new Phrase("9. Exam Date", font2));
table4.AddCell(new Phrase(Txt_ExamDate.Text, font3));
table4.AddCell(new Phrase("10.Result Date", font2));
table4.AddCell(new Phrase(Txt_ResultDate.Text, font3));
table4.AddCell(new Phrase("11. Date of issue of Course Certificate", font2));
table4.AddCell(new Phrase(Txt_DateofIssueofCertificate.Text, font3));
table4.AddCell(new Phrase("12. Average Training Hours (excluding break)", font2));
table4.AddCell(new Phrase(Txt_TrainingTimings.Text, font3));
table4.AddCell(new Phrase("13. Total no. of Training days (excluding Holidays)", font2));
table4.AddCell(new Phrase(Txt_TTD.Text, font3));
table4.AddCell(new Phrase("14. Actual Training Hours", font2));
table4.AddCell(new Phrase(Txt_ATH.Text, font3));
table4.AddCell(new Phrase("15. Course Hours as per NSQF", font2));
table4.AddCell(new Phrase(Txt_CHASN.Text, font3));
table4.AddCell(new Phrase("16. Course Fee (CF) Amount \n (as per NSQF Course list)", font2));
table4.AddCell(new Phrase(Txt_CF.Text, font3));
table4.AddCell(new Phrase("17. Registration cum Certification Fee (RCCF) Amount \n (as per NSQF Course list)", font2));
table4.AddCell(new Phrase(Txt_RCCF.Text, font3));
Doc.Add(table4);
table4.SpacingAfter = 8f;
Paragraph para2 = new Paragraph("SECTION B:-DESCRIPTION OF SERVICES", font4);
para2.Alignment = Element.ALIGN_LEFT;
para2.SpacingAfter = 8f;
Doc.Add(para2);
PdfPTable table5 = new PdfPTable(10);
table5.TotalWidth = 580f;
table5.LockedWidth = true;
//table5.AddCell(new Phrase("18. Total Candidates in the batch", font2));
//table5.AddCell(new Phrase(Txt_TotalCandidates.Text, font2));
PdfPCell Cell1 = new PdfPCell(new Phrase("18. Total Candidates in the batch", font2));
Cell1.Colspan = 3;
table5.AddCell(Cell1);
PdfPCell Cell2 = new PdfPCell(new Phrase(Txt_TotalCandidates.Text, font3));
Cell2.Colspan = 1;
table5.AddCell(Cell2);
PdfPCell Cell3 = new PdfPCell(new Phrase("Whether Reverse Charge Applicable " + Lbl_RPStatus.Text, font3));
Cell3.Colspan = 6;
table5.AddCell(Cell3);
PdfPCell Cell4 = new PdfPCell(new Phrase("19. Total Candidates Trained in the batch", font2));
Cell4.Colspan = 3;
table5.AddCell(Cell4);
PdfPCell Cell5 = new PdfPCell(new Phrase(Txt_TotalCandidatesTrained.Text, font3));
Cell5.Colspan = 1;
table5.AddCell(Cell5);
PdfPCell Cell6 = new PdfPCell(new Phrase("", font2));
Cell6.Colspan = 6;
table5.AddCell(Cell6);
PdfPCell Cell7 = new PdfPCell(new Phrase("20. Total No. of Candidates Certified", font2));
Cell7.Colspan = 3;
table5.AddCell(Cell7);
PdfPCell Cell8 = new PdfPCell(new Phrase(Txt_TotalCandidatesCertified.Text, font3));
Cell8.Colspan = 1;
table5.AddCell(Cell8);
PdfPCell Cell9 = new PdfPCell(new Phrase("", font2));
Cell9.Colspan = 6;
table5.AddCell(Cell9);
PdfPCell Cell10 = new PdfPCell(new Phrase("", font2));
Cell10.Colspan = 2;
table5.AddCell(Cell10);
table5.AddCell(new Phrase("Category", font2));
table5.AddCell(new Phrase("No. of Students", font2));
table5.AddCell(new Phrase("CF Rate", font2));
table5.AddCell(new Phrase("RCCF Rate", font2));
PdfPCell Cell38 = new PdfPCell(new Phrase("CF Amount \n (In Rs)", font2));
Cell38.Colspan = 2;
table5.AddCell(Cell38);
//table5.AddCell(new Phrase("CF Amount \n (In Rs)", font2));
PdfPCell Cell39 = new PdfPCell(new Phrase("RCCF Amount \n (In Rs)", font2));
Cell39.Colspan = 2;
table5.AddCell(Cell39);
//table5.AddCell(new Phrase("RCCF Amount \n (In Rs)", font2));
PdfPCell Cell11 = new PdfPCell(new Phrase("20(a).", font2));
Cell11.HorizontalAlignment = 2;
Cell11.Colspan = 2;
table5.AddCell(Cell11);
table5.AddCell(new Phrase("GEN", font2));
table5.AddCell(new Phrase(Txt_CandidatesGC.Text, font3));
if (Lbl_GSTStatus.Text == "Y")
{
table5.AddCell(new Phrase(Txt_Cost_CF_Gen.Text + "\n\n (CF Rate/1.18)", font3));
table5.AddCell(new Phrase(Txt_Cost_RCCF_Gen.Text + "\n\n (RCCF Rate/1.18)", font3));
}
else
{
table5.AddCell(new Phrase(Txt_Cost_CF_Gen.Text, font3));
table5.AddCell(new Phrase(Txt_Cost_RCCF_Gen.Text, font3));
}
PdfPCell Cell40 = new PdfPCell(new Phrase(Txt_CFClaimforGC.Text, font3));
Cell40.Colspan = 2;
table5.AddCell(Cell40);
//table5.AddCell(new Phrase(Txt_CFClaimforGC.Text, font3));
PdfPCell Cell41 = new PdfPCell(new Phrase(Txt_RCCFClaimforGC.Text, font3));
Cell41.Colspan = 2;
table5.AddCell(Cell41);
//table5.AddCell(new Phrase(Txt_RCCFClaimforGC.Text, font3));
PdfPCell Cell12 = new PdfPCell(new Phrase("20(b).", font2));
Cell12.Colspan = 2;
Cell12.HorizontalAlignment = 2;
table5.AddCell(Cell12);
table5.AddCell(new Phrase("SC", font2));
table5.AddCell(new Phrase(Txt_SCCandidates.Text, font3));
if (Lbl_GSTStatus.Text == "Y")
{
table5.AddCell(new Phrase(Txt_Cost_CF_SC.Text + "\n\n (CF Rate/1.18)", font3));
table5.AddCell(new Phrase(Txt_Cost_RCCF_SC.Text + "\n\n (RCCF Rate/1.18)", font3));
}
else
{
table5.AddCell(new Phrase(Txt_Cost_CF_SC.Text, font3));
table5.AddCell(new Phrase(Txt_Cost_RCCF_SC.Text, font3));
}
PdfPCell Cell42 = new PdfPCell(new Phrase(Txt_CFClaimforSC.Text, font3));
Cell42.Colspan = 2;
table5.AddCell(Cell42);
//table5.AddCell(new Phrase(Txt_CFClaimforSC.Text, font3));
PdfPCell Cell43 = new PdfPCell(new Phrase(Txt_RCCFClaimforSC.Text, font3));
Cell43.Colspan = 2;
table5.AddCell(Cell43);
//table5.AddCell(new Phrase(Txt_RCCFClaimforSC.Text, font3));
PdfPCell Cell13 = new PdfPCell(new Phrase("20(c).", font2));
Cell13.Colspan = 2;
Cell13.HorizontalAlignment = 2;
table5.AddCell(Cell13);
table5.AddCell(new Phrase("ST", font2));
table5.AddCell(new Phrase(Txt_STCandidates.Text, font3));
if (Lbl_GSTStatus.Text == "Y")
{
table5.AddCell(new Phrase(Txt_Cost_CF_ST.Text + "\n\n (CF Rate/1.18)", font3));
table5.AddCell(new Phrase(Txt_Cost_RCCF_ST.Text + "\n\n (RCCF Rate/1.18)", font3));
}
else
{
table5.AddCell(new Phrase(Txt_Cost_CF_ST.Text, font3));
table5.AddCell(new Phrase(Txt_Cost_RCCF_ST.Text, font3));
}
PdfPCell Cell44 = new PdfPCell(new Phrase(Txt_CFClaimforST.Text, font3));
Cell44.Colspan = 2;
table5.AddCell(Cell44);
//table5.AddCell(new Phrase(Txt_CFClaimforST.Text, font3));
PdfPCell Cell45 = new PdfPCell(new Phrase(Txt_RCCFClaimforST.Text, font3));
Cell45.Colspan = 2;
table5.AddCell(Cell45);
//table5.AddCell(new Phrase(Txt_RCCFClaimforST.Text, font3));
PdfPCell Cell14 = new PdfPCell(new Phrase("20(d).", font2));
Cell14.HorizontalAlignment = 2;
Cell14.Colspan = 2;
table5.AddCell(Cell14);
table5.AddCell(new Phrase("EWS", font2));
table5.AddCell(new Phrase(Txt_EWSCandidates.Text, font3));
if (Lbl_GSTStatus.Text == "Y")
{
table5.AddCell(new Phrase(Txt_Cost_CF_EWS.Text + "\n\n (CF Rate/1.18)", font3));
table5.AddCell(new Phrase(Txt_Cost_RCCF_EWS.Text + "\n\n (RCCF Rate/1.18)", font3));
}
else
{
table5.AddCell(new Phrase(Txt_Cost_CF_EWS.Text, font3));
table5.AddCell(new Phrase(Txt_Cost_RCCF_EWS.Text, font3));
}
PdfPCell Cell46 = new PdfPCell(new Phrase(Txt_CFClaimforEWS.Text, font3));
Cell46.Colspan = 2;
table5.AddCell(Cell46);
//table5.AddCell(new Phrase(Txt_CFClaimforEWS.Text, font3));
PdfPCell Cell47 = new PdfPCell(new Phrase(Txt_RCCFClaimforEWS.Text, font3));
Cell47.Colspan = 2;
table5.AddCell(Cell47);
//table5.AddCell(new Phrase(Txt_RCCFClaimforEWS.Text, font3));
PdfPCell Cell15 = new PdfPCell(new Phrase("20(e).", font2));
Cell15.HorizontalAlignment = 2;
Cell15.Colspan = 2;
table5.AddCell(Cell15);
table5.AddCell(new Phrase("Total", font2));
table5.AddCell(new Phrase(Txt_TotalCandidate.Text, font3));
table5.AddCell(new Phrase("", font2));
table5.AddCell(new Phrase("", font2));
PdfPCell Cell48 = new PdfPCell(new Phrase(Txt_TotalCF.Text, font3));
Cell48.Colspan = 2;
table5.AddCell(Cell48);
//table5.AddCell(new Phrase(Txt_TotalCF.Text, font3));
PdfPCell Cell49 = new PdfPCell(new Phrase(Txt_TotalRCCF.Text, font3));
Cell49.Colspan = 2;
table5.AddCell(Cell49);
//table5.AddCell(new Phrase(Txt_TotalRCCF.Text, font3));
PdfPCell Cell16 = new PdfPCell(new Phrase("20(f).", font2));
Cell16.HorizontalAlignment = 2;
Cell16.Colspan = 2;
table5.AddCell(Cell16);
PdfPCell Cell17 = new PdfPCell(new Phrase("Total Amount CF+RCCF:", font2));
Cell17.Colspan = 4;
table5.AddCell(Cell17);
PdfPCell Cell18 = new PdfPCell(new Phrase(Lbl_TotalAmount.Text, font3));
Cell18.Colspan = 4;
table5.AddCell(Cell18);
PdfPCell Cell19 = new PdfPCell(new Phrase("20(g).", font2));
Cell19.HorizontalAlignment = 2;
Cell19.Colspan = 2;
table5.AddCell(Cell19);
PdfPCell Cell20 = new PdfPCell(new Phrase("CGST Rate @" + Lbl_CGSTRate.Text + "% if Applicable", font2));
Cell20.Colspan = 4;
table5.AddCell(Cell20);
PdfPCell Cell21 = new PdfPCell(new Phrase(Lbl_CGSTAmount.Text, font3));
Cell21.Colspan = 4;
table5.AddCell(Cell21);
PdfPCell Cell22 = new PdfPCell(new Phrase("20(h).", font2));
Cell22.HorizontalAlignment = 2;
Cell22.Colspan = 2;
table5.AddCell(Cell22);
PdfPCell Cell23 = new PdfPCell(new Phrase("SGST Rate @" + Lbl_SGSTRate.Text + "% if Applicable", font2));
Cell23.Colspan = 4;
table5.AddCell(Cell23);
PdfPCell Cell24 = new PdfPCell(new Phrase(Lbl_SGSTAmount.Text, font3));
Cell24.Colspan = 4;
table5.AddCell(Cell24);
PdfPCell Cell25 = new PdfPCell(new Phrase("20(i).", font2));
Cell25.HorizontalAlignment = 2;
Cell25.Colspan = 2;
table5.AddCell(Cell25);
PdfPCell Cell26 = new PdfPCell(new Phrase("IGST Rate @" + Lbl_IGSTRate.Text + "% if Applicable", font2));
Cell26.Colspan = 4;
table5.AddCell(Cell26);
PdfPCell Cell27 = new PdfPCell(new Phrase(Lbl_IGSTAmount.Text, font3));
Cell27.Colspan = 4;
table5.AddCell(Cell27);
PdfPCell Cell28 = new PdfPCell(new Phrase("20(j).", font2));
Cell28.HorizontalAlignment = 2;
Cell28.Colspan = 2;
table5.AddCell(Cell28);
PdfPCell Cell29 = new PdfPCell(new Phrase("Total Amount of TAX", font2));
Cell29.Colspan = 4;
table5.AddCell(Cell29);
PdfPCell Cell30 = new PdfPCell(new Phrase(Lbl_TaxAmount.Text, font3));
Cell30.Colspan = 4;
table5.AddCell(Cell30);
PdfPCell Cell31 = new PdfPCell(new Phrase("20(k).", font2));
Cell31.HorizontalAlignment = 2;
Cell31.Colspan = 2;
table5.AddCell(Cell31);
PdfPCell Cell32 = new PdfPCell(new Phrase("Total Invoice Value in (Figure)", font2));
Cell32.Colspan = 4;
table5.AddCell(Cell32);
PdfPCell Cell33 = new PdfPCell(new Phrase(Lbl_Total_Invoice_Amount.Text, font3));
Cell33.Colspan = 4;
table5.AddCell(Cell33);
PdfPCell Cell34 = new PdfPCell(new Phrase("", font2));
Cell34.Colspan = 2;
table5.AddCell(Cell34);
PdfPCell Cell35 = new PdfPCell(new Phrase("Total Invoice Value in (Words)", font2));
Cell35.Colspan = 4;
table5.AddCell(Cell35);
PdfPCell Cell36 = new PdfPCell(new Phrase(Lbl_Total_Invoice_Amount_InWords.Text, font5));
Cell36.Colspan = 4;
table5.AddCell(Cell36);
Doc.Add(table5);
Paragraph para3 = new Paragraph("SECTION C", font4);
para3.Alignment = Element.ALIGN_LEFT;
para3.SpacingBefore = 20f;
para3.SpacingAfter = 8f;
Doc.Add(para3);
PdfPTable table6 = new PdfPTable(3);
table6.TotalWidth = 580f;
table6.LockedWidth = true;
table6.AddCell(new Phrase(" \n 21. PAN Number:"+
"\n 22. Bank Details:-" +
"\n\n 22(a). Name of Account Holder: " +
"\n\n 22(b). Name of Bank: " +
"\n 22(c). Branch Name: "+
"\n 22(d). Account Number: "+
"\n 22(e). IFSC Code: ",font2));
table6.AddCell(new Phrase("\n" +Txt_PanNumber.Text +
"\n"+
"\n\n"+ Txt_NameofAH.Text +
"\n\n" + Txt_NameofBank.Text +
"\n"+Txt_BranchName.Text+
"\n"+Txt_AccountNumber.Text+
"\n"+Txt_IFSCCode.Text, font5));
table6.AddCell(new Phrase("\n\n\n\n\n (Stamp and Sign of Authorized Signatory of TP)"+
"\n Name: "+
"\n Designation: "+
"\n Date:", font3));
table6.SpacingAfter = 20f;
Doc.Add(table6);
PdfPTable table7 = new PdfPTable(1);
table7.TotalWidth = 580f;
table7.LockedWidth = true;
PdfPCell header3 = new PdfPCell(new Phrase("UNDERTAKING FROM TRAINING PARTNER", font));
header3.HorizontalAlignment = 1;
table7.AddCell(header3);
Doc.Add(table7);
PdfPTable table8 = new PdfPTable(2);
table8.TotalWidth = 580f;
table8.LockedWidth = true;
PdfPCell Cell37 = new PdfPCell(new Phrase(
"\n\n a.) Having read and understood all terms and conditions of the Undertaking/Code of Ethics (as per Annexure-VII of Guidelines), the said Undertaking/Code of Ethics, duly signed, has been submitted to our KIA " + Lbl_KIA_name_a.Text + "." +
"\n\n b.) Attendance of candidates has been obtained through a bio-metric attendance system and the attendance report in this regard is attached herewith with this Invoice."+
"\n\n c.) All certified candidates, as per this invoice, have been provided with a printed copy of final certification as uploaded by KIA " + Lbl_KIA_Name_c.Text + " in the Scheme Portal." +
"\n\n d.) The details provided in the Invoice are factual and correct and these details also conform to all compliance norms mentioned in the ESDM Scheme Guidelines." +
"\n\n e.) All candidates, details of which are annexed with this invoice comply with the laid down eligibility criteria for the course mentioned at Sr.No.4 & 5 of the Invoice." +
"\n\n f.) The copy of the Caste(SC/ST)/Category(EWS) certificates provided by the candidate have been verified with the original document and the same was valid and legal at the time of enrollment. It is further certified that copy of such certificates have also been uploaded at the ESDM Portal with due diligence." +
"\n\n g.) I understand that if any information/data in this Invoice is found to be incorrect or misleading, I shall be liable for any action as deemed appropriate by NIELIT-PMU/MeitY, which may include for forfeiture of my entire claim or any penalty as deserved appropriate."+
"\n ", font3));
Cell37.Colspan = 2;
Cell37.HorizontalAlignment = PdfPCell.ALIGN_JUSTIFIED;
table8.AddCell(Cell37);
table8.AddCell(new Phrase("\n\n\n\n\n<Revenue Stamp>", font));
table8.AddCell(new Phrase("\n\n\n(Stamp and sign of Authorized Signatory of TP) \n Name: \n Designation: \n Date:", font3));
table8.SpacingAfter = 5f;
Doc.Add(table8);
Paragraph p2 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, CMYKColor.BLACK, Element.ALIGN_LEFT, 1)));
Doc.Add(p2);
Paragraph para1 = new Paragraph("This is system generated Invoice, Send signed hard copy to your KIA", font3);
para1.Alignment = Element.ALIGN_CENTER;
Doc.Add(para1);
Paragraph p3 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, CMYKColor.BLACK, Element.ALIGN_LEFT, 1)));
Doc.Add(p3);
htmlparser.Parse(stringReader);
//Paragraph p1 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(2.0F, 100.0F, CMYKColor.BLACK, Element.ALIGN_LEFT, 1)));
//Doc.Add(p1);
//Paragraph para1 = new Paragraph("This is system generated Invoice, Send signed hard copy to your KIA", FontFactory.GetFont("dax-black"));
//para.Alignment = Element.ALIGN_CENTER;
//Doc.Add(para1);
//Paragraph p = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, CMYKColor.BLACK, Element.ALIGN_LEFT, 1)));
//Doc.Add(p);
Doc.Close();
byte[] bytes = memoryStream.ToArray();
System.IO.File.WriteAllBytes(Server.MapPath("~/View/TrainingPartner/TPDocument/Invoice/") + Invoice_FileName, bytes);
}
else
{
SIA_Address.Visible = false;
PMU_Address.Visible = false;
Sub_Scheme1_RCCF.Visible = true;
Sub_Scheme1_CF.Visible = false;
Txt_CF.Visible = false;
Txt_RCCF.Visible = true;
Txt_CFClaimforRC.Visible = false;
Lbl_Show_Calculation_Res_CF.Visible = false;
Txt_RCCFClaimforRC.Visible = true;
Lbl_Show_Calculation_Res_RCCF.Visible = true;
Txt_CFClaimforGC.Visible = false;
Lbl_Show_Calculation_Gen_CF.Visible = false;
Txt_RCCFClaimforGC.Visible = true;
Lbl_Show_Calculation_Gen_RCCF.Visible = true;
Txt_TotalCF.Visible = false;
Lbl_TotalCFWords.Visible = false;
Txt_TotalRCCF.Visible = true;
Lbl_TotalRCCFWords.Visible = true;
Invoice_FileName = "TPInvoice-" + PARAInvoiceID + ".pdf";
Response.ContentType = "application/pdf";
StringWriter stringWriter = new StringWriter();
HtmlTextWriter htmlTextWriter = new HtmlTextWriter(stringWriter);
DivIdToPrint.RenderControl(htmlTextWriter);
StringReader stringReader = new StringReader(stringWriter.ToString());
Document Doc = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
System.IO.MemoryStream memoryStream = new System.IO.MemoryStream();
PdfWriter writer = PdfWriter.GetInstance(Doc, memoryStream);
HTMLWorker htmlparser = new HTMLWorker(Doc);
PdfWriter.GetInstance(Doc, Response.OutputStream);
Doc.Open();
BaseFont bfTimes = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, false);
BaseFont bfTimes1 = BaseFont.CreateFont(BaseFont.COURIER, BaseFont.CP1250, false);
iTextSharp.text.Font font = new iTextSharp.text.Font(bfTimes, 10, iTextSharp.text.Font.BOLDITALIC, iTextSharp.text.Color.RED);
iTextSharp.text.Font font1 = new iTextSharp.text.Font(bfTimes, 10, iTextSharp.text.Font.BOLDITALIC, iTextSharp.text.Color.BLACK);
iTextSharp.text.Font font2 = new iTextSharp.text.Font(bfTimes, 10, iTextSharp.text.Font.NORMAL, iTextSharp.text.Color.BLUE);
iTextSharp.text.Font font3 = new iTextSharp.text.Font(bfTimes, 10, iTextSharp.text.Font.NORMAL, iTextSharp.text.Color.BLACK);
iTextSharp.text.Font font4 = new iTextSharp.text.Font(bfTimes1, 10, iTextSharp.text.Font.BOLDITALIC, iTextSharp.text.Color.BLACK);
iTextSharp.text.Font font5 = new iTextSharp.text.Font(bfTimes, 9, iTextSharp.text.Font.NORMAL, iTextSharp.text.Color.BLACK);
PdfPTable table = new PdfPTable(1);
table.TotalWidth = 580f;
table.LockedWidth = true;
PdfPCell header = new PdfPCell(new Phrase("TAX INVOICE/BILL OF SUPPLY", font));
header.HorizontalAlignment = 1;
table.AddCell(header);
table.SpacingAfter = 8f;
Doc.Add(table);
PdfPTable table1 = new PdfPTable(7);
table1.TotalWidth = 580f;
table1.LockedWidth = true;
table1.HorizontalAlignment = 0;
//PdfPCell left = new PdfPCell(new Paragraph("TP NAME: </br> GSTIN:- </br> HSN CODE:-"));
//left.BorderColor = iTextSharp.text.Color.BLACK;
PdfPTable left1 = new PdfPTable(1);
left1.AddCell(new Phrase("TP NAME:" + Lbl_TP_Name.Text +
"\n GSTIN: " + Lbl_GSTNo.Text + "\n HSN CODE: " + Lbl_HSNCode.Text, font1));
PdfPCell nesthousing = new PdfPCell(left1);
nesthousing.Colspan = 3;
nesthousing.Padding = 0f;
table1.AddCell(nesthousing);
nesthousing.Padding = 0f;
//table1.AddCell(left);
PdfPCell middle1 = new PdfPCell();
table1.AddCell(middle1);
PdfPCell right1 = new PdfPCell(new Phrase("TP-ADDRESS: " + Lbl_Address.Text, font1));
right1.Colspan = 3;
table1.AddCell(right1);
table1.SpacingAfter = 8f;
Doc.Add(table1);
PdfPTable table2 = new PdfPTable(7);
table2.TotalWidth = 580f;
table2.LockedWidth = true;
table2.HorizontalAlignment = 0;
PdfPCell left2 = new PdfPCell(new Phrase("INVOICE NO: " + Lbl_RefNo.Text, font1));
left2.Colspan = 3;
table2.AddCell(left2);
PdfPCell middle2 = new PdfPCell();
table2.AddCell(middle2);
PdfPCell right2 = new PdfPCell(new Phrase("DATE: " + Lbl_CreationDate.Text, font1));
right2.Colspan = 7;
table2.AddCell(right2);
table2.SpacingAfter = 8f;
Doc.Add(table2);
PdfPTable table3 = new PdfPTable(7);
table3.TotalWidth = 580f;
table3.LockedWidth = true;
table3.HorizontalAlignment = 0;
PdfPCell left3 = new PdfPCell(new Phrase("BILL To:" + PMU_Address.InnerText, font1));
left3.Colspan = 3;
table3.AddCell(left3);
PdfPCell middle3 = new PdfPCell();
table3.AddCell(middle3);
PdfPCell right3 = new PdfPCell(new Phrase("Place of Supply: "+
"\n\n\n State Name:" + Lbl_StateName.Text +
"\n State Code:" + Lbl_StateCode.Text, font1));
right3.Colspan = 3;
table3.AddCell(right3);
table3.SpacingAfter = 0f;
Doc.Add(table3);
Paragraph para = new Paragraph("SECTION A", font4);
para.Alignment = Element.ALIGN_LEFT;
para.SpacingAfter = 8f;
Doc.Add(para);
//PdfPTable table4 = new PdfPTable(1);
//table4.TotalWidth = 580f;
//table4.LockedWidth = true;
//PdfPCell header1 = new PdfPCell(new Phrase("1. It is certified that " +Lbl_TP_Name.Text+ " is affiliated with " +Lbl_KIA.Text + ", and the following claim is being made after completion of training, in-line with the scheme Guidelines.", font1));
//header1.HorizontalAlignment = 0;
//table4.AddCell(header1);
PdfPTable table4 = new PdfPTable(4);
table4.TotalWidth = 580f;
table4.LockedWidth = true;
PdfPCell cell = new PdfPCell(new Phrase("1. It is certified that " + Lbl_TP_Name.Text + " is affiliated with " + Lbl_KIA.Text + " " + Scheme1_Name.InnerText + ", and the following claim is being made after completion of training, in-line with the scheme Guidelines.", font1));
cell.Colspan = 4;
cell.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right
table4.AddCell(cell);
table4.AddCell(new Phrase("2. TP ID", font2));
table4.AddCell(new Phrase(Txt_TpID.Text, font3));
table4.AddCell(new Phrase("3. State Name", font2));
table4.AddCell(new Phrase(Lbl_State_Name.Text, font3));
table4.AddCell(new Phrase("4. Course Code", font2));
table4.AddCell(new Phrase(Txt_CourseCode.Text, font3));
table4.AddCell(new Phrase("5. Course Name", font2));
table4.AddCell(new Phrase(Txt_CourseName.Text, font3));
table4.AddCell(new Phrase("6. Batch ID", font2));
table4.AddCell(new Phrase(Txt_BatchCode.Text, font3));
table4.AddCell(new Phrase("7. Batch Start Date", font2));
table4.AddCell(new Phrase(Txt_BatchStartDate.Text, font3));
table4.AddCell(new Phrase("8. Batch End Date", font2));
table4.AddCell(new Phrase(Txt_BatchEndDate.Text, font3));
table4.AddCell(new Phrase("9. Exam Date", font2));
table4.AddCell(new Phrase(Txt_ExamDate.Text, font3));
table4.AddCell(new Phrase("10. Result Date", font2));
table4.AddCell(new Phrase(Txt_ResultDate.Text, font3));
table4.AddCell(new Phrase("11. Date of issue of Course Certificate", font2));
table4.AddCell(new Phrase(Txt_DateofIssueofCertificate.Text, font3));
table4.AddCell(new Phrase("12. Average Training Hours (excluding break)", font2));
table4.AddCell(new Phrase(Txt_TrainingTimings.Text, font3));
table4.AddCell(new Phrase("13. Total no. of Training days (excluding Holidays)", font2));
table4.AddCell(new Phrase(Txt_TTD.Text, font3));
table4.AddCell(new Phrase("14. Actual Training Hours", font2));
table4.AddCell(new Phrase(Txt_ATH.Text, font3));
table4.AddCell(new Phrase("15. Course Hours as per NSQF", font2));
table4.AddCell(new Phrase(Txt_CHASN.Text, font3));
table4.AddCell(new Phrase("16. Course Fee (CF) Amount \n (as per NSQF Course list)", font2));
table4.AddCell(new Phrase("", font3));
table4.AddCell(new Phrase("17. Registration cum Certification Fee (RCCF) Amount \n (as per NSQF Course list)", font2));
table4.AddCell(new Phrase(Txt_RCCF.Text, font3));
Doc.Add(table4);
table4.SpacingAfter = 8f;
Paragraph para2 = new Paragraph("SECTION B:-DESCRIPTION OF SERVICES", font4);
para2.Alignment = Element.ALIGN_LEFT;
para2.SpacingAfter = 8f;
Doc.Add(para2);
PdfPTable table5 = new PdfPTable(10);
table5.TotalWidth = 580f;
table5.LockedWidth = true;
//table5.AddCell(new Phrase("18. Total Candidates in the batch", font2));
//table5.AddCell(new Phrase(Txt_TotalCandidates.Text, font2));
PdfPCell Cell1 = new PdfPCell(new Phrase("18. Total Candidates in the batch", font2));
Cell1.Colspan = 3;
table5.AddCell(Cell1);
PdfPCell Cell2 = new PdfPCell(new Phrase(Txt_TotalCandidates.Text, font3));
Cell2.Colspan = 1;
table5.AddCell(Cell2);
PdfPCell Cell3 = new PdfPCell(new Phrase("Whether Reverse Charge Applicable " + Lbl_RPStatus.Text, font3));
Cell3.Colspan = 6;
table5.AddCell(Cell3);
PdfPCell Cell4 = new PdfPCell(new Phrase("19. Total Candidates Trained in the batch", font2));
Cell4.Colspan = 3;
table5.AddCell(Cell4);
PdfPCell Cell5 = new PdfPCell(new Phrase(Txt_TotalCandidatesTrained.Text, font3));
Cell5.Colspan = 1;
table5.AddCell(Cell5);
PdfPCell Cell6 = new PdfPCell(new Phrase("", font2));
Cell6.Colspan = 6;
table5.AddCell(Cell6);
PdfPCell Cell7 = new PdfPCell(new Phrase("20. Total No. of Candidates Certified", font2));
Cell7.Colspan = 3;
table5.AddCell(Cell7);
PdfPCell Cell8 = new PdfPCell(new Phrase(Txt_TotalCandidatesCertified.Text, font3));
Cell8.Colspan = 1;
table5.AddCell(Cell8);
PdfPCell Cell9 = new PdfPCell(new Phrase("", font2));
Cell9.Colspan = 6;
table5.AddCell(Cell9);
PdfPCell Cell10 = new PdfPCell(new Phrase("", font2));
Cell10.Colspan = 2;
table5.AddCell(Cell10);
table5.AddCell(new Phrase("Category", font2));
table5.AddCell(new Phrase("No. of Students", font2));
table5.AddCell(new Phrase("CF Rate", font2));
table5.AddCell(new Phrase("RCCF Rate", font2));
PdfPCell Cell76 = new PdfPCell(new Phrase("CF Amount \n (In Rs)", font2));
Cell76.Colspan = 2;
table5.AddCell(Cell76);
//table5.AddCell(new Phrase("CF Amount \n (In Rs)", font2));
PdfPCell Cell77 = new PdfPCell(new Phrase("RCCF Amount \n (In Rs)", font2));
Cell77.Colspan = 2;
table5.AddCell(Cell77);
//table5.AddCell(new Phrase("RCCF Amount \n (In Rs)", font2));
PdfPCell Cell11 = new PdfPCell(new Phrase("20(a).", font2));
Cell11.HorizontalAlignment = 2;
Cell11.Colspan = 2;
table5.AddCell(Cell11);
table5.AddCell(new Phrase("GEN", font2));
table5.AddCell(new Phrase(Txt_CandidatesGC.Text, font3));
table5.AddCell(new Phrase("", font2));
if (Lbl_GSTStatus.Text == "Y")
{
table5.AddCell(new Phrase(Txt_Cost_RCCF_Gen.Text + "\n\n (RCCF Rate/1.18)", font3));
}
else
{
table5.AddCell(new Phrase(Txt_Cost_RCCF_Gen.Text, font3));
}
PdfPCell Cell90 = new PdfPCell(new Phrase("", font3));
Cell90.Colspan = 2;
table5.AddCell(Cell90);
//table5.AddCell(new Phrase("", font2));
PdfPCell Cell78 = new PdfPCell(new Phrase(Txt_RCCFClaimforGC.Text, font3));
Cell78.Colspan = 2;
table5.AddCell(Cell78);
//table5.AddCell(new Phrase(Txt_RCCFClaimforGC.Text, font3));
PdfPCell Cell12 = new PdfPCell(new Phrase("20(b).", font2));
Cell12.Colspan = 2;
Cell12.HorizontalAlignment = 2;
table5.AddCell(Cell12);
table5.AddCell(new Phrase("SC", font2));
table5.AddCell(new Phrase(Txt_SCCandidates.Text, font3));
table5.AddCell(new Phrase("", font2));
if (Lbl_GSTStatus.Text == "Y")
{
table5.AddCell(new Phrase(Txt_Cost_RCCF_SC.Text + "\n\n (RCCF Rate/1.18)", font3));
}
else
{
table5.AddCell(new Phrase(Txt_Cost_RCCF_SC.Text, font3));
}
PdfPCell Cell91 = new PdfPCell(new Phrase("", font3));
Cell91.Colspan = 2;
table5.AddCell(Cell91);
//table5.AddCell(new Phrase("", font2));
PdfPCell Cell79 = new PdfPCell(new Phrase(Txt_RCCFClaimforSC.Text, font3));
Cell79.Colspan = 2;
table5.AddCell(Cell79);
//table5.AddCell(new Phrase(Txt_RCCFClaimforSC.Text, font3));
PdfPCell Cell13 = new PdfPCell(new Phrase("20(c).", font2));
Cell13.Colspan = 2;
Cell13.HorizontalAlignment = 2;
table5.AddCell(Cell13);
table5.AddCell(new Phrase("ST", font2));
table5.AddCell(new Phrase(Txt_STCandidates.Text, font3));
table5.AddCell(new Phrase("", font2));
if (Lbl_GSTStatus.Text == "Y")
{
table5.AddCell(new Phrase(Txt_Cost_RCCF_ST.Text + "\n\n (RCCF Rate/1.18)", font3));
}
else
{
table5.AddCell(new Phrase(Txt_Cost_RCCF_ST.Text, font3));
}
PdfPCell Cell92 = new PdfPCell(new Phrase("", font3));
Cell92.Colspan = 2;
table5.AddCell(Cell92);
//table5.AddCell(new Phrase("", font2));
PdfPCell Cell80 = new PdfPCell(new Phrase(Txt_RCCFClaimforST.Text, font3));
Cell80.Colspan = 2;
table5.AddCell(Cell80);
//table5.AddCell(new Phrase(Txt_RCCFClaimforST.Text, font3));
PdfPCell Cell14 = new PdfPCell(new Phrase("20(d).", font2));
Cell14.HorizontalAlignment = 2;
Cell14.Colspan = 2;
table5.AddCell(Cell14);
table5.AddCell(new Phrase("EWS", font2));
table5.AddCell(new Phrase(Txt_EWSCandidates.Text, font3));
table5.AddCell(new Phrase("", font2));
if (Lbl_GSTStatus.Text == "Y")
{
table5.AddCell(new Phrase(Txt_Cost_RCCF_EWS.Text + "\n\n (RCCF Rate/1.18)", font3));
}
else
{
table5.AddCell(new Phrase(Txt_Cost_RCCF_EWS.Text, font3));
}
PdfPCell Cell93 = new PdfPCell(new Phrase("", font3));
Cell93.Colspan = 2;
table5.AddCell(Cell93);
//table5.AddCell(new Phrase("", font2));
PdfPCell Cell81 = new PdfPCell(new Phrase(Txt_RCCFClaimforEWS.Text, font3));
Cell81.Colspan = 2;
table5.AddCell(Cell81);
//table5.AddCell(new Phrase(Txt_RCCFClaimforEWS.Text, font3));
PdfPCell Cell15 = new PdfPCell(new Phrase("20(e).", font2));
Cell15.HorizontalAlignment = 2;
Cell15.Colspan = 2;
table5.AddCell(Cell15);
table5.AddCell(new Phrase("Total", font2));
table5.AddCell(new Phrase(Txt_TotalCandidate.Text, font3));
table5.AddCell(new Phrase("", font2));
table5.AddCell(new Phrase(Txt_TotalRCCF.Text, font3));
//PdfPCell Cell82 = new PdfPCell(new Phrase(Txt_TotalRCCF.Text, font3));
//Cell82.Colspan = 2;
//table5.AddCell(Cell82);
PdfPCell Cell94 = new PdfPCell(new Phrase("", font3));
Cell94.Colspan = 2;
table5.AddCell(Cell94);
//table5.AddCell(new Phrase(Txt_TotalRCCF.Text, font3));
PdfPCell Cell95 = new PdfPCell(new Phrase("", font3));
Cell95.Colspan = 2;
table5.AddCell(Cell95);
PdfPCell Cell16 = new PdfPCell(new Phrase("20(f).", font2));
Cell16.HorizontalAlignment = 2;
Cell16.Colspan = 2;
table5.AddCell(Cell16);
PdfPCell Cell17 = new PdfPCell(new Phrase("Total Amount RCCF:", font2));
Cell17.Colspan = 4;
table5.AddCell(Cell17);
PdfPCell Cell18 = new PdfPCell(new Phrase(Txt_TotalRCCF.Text, font3));
Cell18.Colspan = 4;
table5.AddCell(Cell18);
PdfPCell Cell19 = new PdfPCell(new Phrase("20(g).", font2));
Cell19.HorizontalAlignment = 2;
Cell19.Colspan = 2;
table5.AddCell(Cell19);
PdfPCell Cell20 = new PdfPCell(new Phrase("CGST Rate @" + Lbl_CGSTRate.Text + "% if Applicable", font2));
Cell20.Colspan = 4;
table5.AddCell(Cell20);
PdfPCell Cell21 = new PdfPCell(new Phrase(Lbl_CGSTAmount.Text, font3));
Cell21.Colspan = 4;
table5.AddCell(Cell21);
PdfPCell Cell22 = new PdfPCell(new Phrase("20(h).", font2));
Cell22.HorizontalAlignment = 2;
Cell22.Colspan = 2;
table5.AddCell(Cell22);
PdfPCell Cell23 = new PdfPCell(new Phrase("SGST Rate @" + Lbl_SGSTRate.Text + "% if Applicable", font2));
Cell23.Colspan = 4;
table5.AddCell(Cell23);
PdfPCell Cell24 = new PdfPCell(new Phrase(Lbl_SGSTAmount.Text, font3));
Cell24.Colspan = 4;
table5.AddCell(Cell24);
PdfPCell Cell25 = new PdfPCell(new Phrase("20(i).", font2));
Cell25.HorizontalAlignment = 2;
Cell25.Colspan = 2;
table5.AddCell(Cell25);
PdfPCell Cell26 = new PdfPCell(new Phrase("IGST Rate @" + Lbl_IGSTRate.Text + "% if Applicable", font2));
Cell26.Colspan = 4;
table5.AddCell(Cell26);
PdfPCell Cell27 = new PdfPCell(new Phrase(Lbl_IGSTAmount.Text, font3));
Cell27.Colspan = 4;
table5.AddCell(Cell27);
PdfPCell Cell28 = new PdfPCell(new Phrase("20(j).", font2));
Cell28.HorizontalAlignment = 2;
Cell28.Colspan = 2;
table5.AddCell(Cell28);
PdfPCell Cell29 = new PdfPCell(new Phrase("Total Amount of TAX", font2));
Cell29.Colspan = 4;
table5.AddCell(Cell29);
PdfPCell Cell30 = new PdfPCell(new Phrase(Lbl_TaxAmount.Text, font3));
Cell30.Colspan = 4;
table5.AddCell(Cell30);
PdfPCell Cell31 = new PdfPCell(new Phrase("20(k).", font2));
Cell31.HorizontalAlignment = 2;
Cell31.Colspan = 2;
table5.AddCell(Cell31);
PdfPCell Cell32 = new PdfPCell(new Phrase("Total Invoice Value in (Figure)", font2));
Cell32.Colspan = 4;
table5.AddCell(Cell32);
PdfPCell Cell33 = new PdfPCell(new Phrase(Lbl_Total_Invoice_Amount_RCCF.Text, font5));
Cell33.Colspan = 4;
table5.AddCell(Cell33);
PdfPCell Cell34 = new PdfPCell(new Phrase("", font2));
Cell34.Colspan = 2;
table5.AddCell(Cell34);
PdfPCell Cell35 = new PdfPCell(new Phrase("Total Invoice Value in (Words)", font2));
Cell35.Colspan = 4;
table5.AddCell(Cell35);
PdfPCell Cell36 = new PdfPCell(new Phrase(Lbl_Total_Invoice_Amount_InWords_RCCF.Text, font3));
Cell36.Colspan = 4;
table5.AddCell(Cell36);
Doc.Add(table5);
Paragraph para3 = new Paragraph("SECTION C", font4);
para3.Alignment = Element.ALIGN_LEFT;
para3.SpacingBefore = 20f;
para3.SpacingAfter = 8f;
Doc.Add(para3);
PdfPTable table6 = new PdfPTable(3);
table6.TotalWidth = 580f;
table6.LockedWidth = true;
table6.AddCell(new Phrase(" \n 21. PAN Number:" +
"\n 22. Bank Details:-" +
"\n\n 22(a). Name of Account Holder: " +
"\n\n\n 22(b). Name of Bank: " +
"\n 22(c). Branch Name: " +
"\n 22(d). Account Number: " +
"\n 22(e). IFSC Code: ", font2));
table6.AddCell(new Phrase("\n" + Txt_PanNumber.Text +
"\n" +
"\n\n" + Txt_NameofAH.Text +
"\n\n" + Txt_NameofBank.Text +
"\n" + Txt_BranchName.Text +
"\n" + Txt_AccountNumber.Text +
"\n" + Txt_IFSCCode.Text, font3));
table6.AddCell(new Phrase("\n\n\n\n\n\n (Stamp and Sign of Authorized Signatory of TP)" +
"\n Name: " +
"\n Designation: " +
"\n Date:", font3));
table6.SpacingAfter = 20f;
Doc.Add(table6);
PdfPTable table7 = new PdfPTable(1);
table7.TotalWidth = 580f;
table7.LockedWidth = true;
PdfPCell header3 = new PdfPCell(new Phrase("UNDERTAKING FROM TRAINING PARTNER", font));
header3.HorizontalAlignment = 1;
table7.AddCell(header3);
Doc.Add(table7);
PdfPTable table8 = new PdfPTable(2);
table8.TotalWidth = 580f;
table8.LockedWidth = true;
PdfPCell Cell37 = new PdfPCell(new Phrase(
"\n\n a.) Having read and understood all terms and conditions of the Undertaking/Code of Ethics (as per Annexure-VII of Guidelines), the said Undertaking/Code of Ethics, duly signed, has been submitted to our KIA " + Lbl_KIA_name_a.Text + "." +
"\n\n b.) Attendance of candidates has been obtained through a bio-metric attendance system and the attendance report in this regard is attached herewith with this Invoice." +
"\n\n c.) All certified candidates, as per this invoice, have been provided with a printed copy of final certification as uploaded by KIA " + Lbl_KIA_Name_c.Text + " in the Scheme Portal." +
"\n\n d.) The details provided in the Invoice are factual and correct and these details also conform to all compliance norms mentioned in the ESDM Scheme Guidelines." +
"\n\n e.) All candidates, details of which are annexed with this invoice comply with the laid down eligibility criteria for the course mentioned at Sr.No.4 & 5 of the Invoice." +
"\n\n f.) The copy of the Caste(SC/ST)/Category(EWS) certificates provided by the candidate have been verified with the original document and the same was valid and legal at the time of enrollment. It is further certified that copy of such certificates have also been uploaded at the ESDM Portal with due diligence." +
"\n\n g.) I understand that if any information/data in this Invoice is found to be incorrect or misleading, I shall be liable for any action as deemed appropriate by NIELIT-PMU/MeitY, which may include for forfeiture of my entire claim or any penalty as deserved appropriate." +
"\n ", font3));
Cell37.Colspan = 2;
Cell37.HorizontalAlignment = PdfPCell.ALIGN_JUSTIFIED;
table8.AddCell(Cell37);
table8.AddCell(new Phrase("\n\n\n\n\n<Revenue Stamp>", font));
table8.AddCell(new Phrase("\n\n\n(Stamp and sign of Authorized Signatory of TP) \n Name: \n Designation: \n Date:", font3));
table8.SpacingAfter = 5f;
Doc.Add(table8);
Paragraph p2 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, CMYKColor.BLACK, Element.ALIGN_LEFT, 1)));
Doc.Add(p2);
Paragraph para1 = new Paragraph("This is system generated Invoice, Send signed hard copy to your KIA", font3);
para1.Alignment = Element.ALIGN_CENTER;
Doc.Add(para1);
Paragraph p3 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, CMYKColor.BLACK, Element.ALIGN_LEFT, 1)));
Doc.Add(p3);
htmlparser.Parse(stringReader);
Doc.Close();
byte[] bytes = memoryStream.ToArray();
System.IO.File.WriteAllBytes(Server.MapPath("~/View/TrainingPartner/TPDocument/Invoice/") + Invoice_FileName, bytes);
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//GetInvoiceDetails(InvoiceID);
SIA_Address.Visible = false;
PMU_Address.Visible = false;
Sub_Scheme1_RCCF.Visible = false;
Sub_Scheme1_CF.Visible = true;
Txt_CF.Visible = true;
Txt_RCCF.Visible = false;
Txt_CFClaimforRC.Visible = true;
Lbl_Show_Calculation_Res_CF.Visible = true;
Txt_RCCFClaimforRC.Visible = false;
Lbl_Show_Calculation_Res_RCCF.Visible = false;
Txt_CFClaimforGC.Visible = true;
Lbl_Show_Calculation_Gen_CF.Visible = true;
Txt_RCCFClaimforGC.Visible = false;
Lbl_Show_Calculation_Gen_RCCF.Visible = false;
Txt_TotalCF.Visible = true;
Lbl_TotalCFWords.Visible = true;
Txt_TotalRCCF.Visible = false;
Lbl_TotalRCCFWords.Visible = false;
Invoice_FileName_CF = "TPInvoiceCF-" + PARAInvoiceID + ".pdf";
StringWriter stringWriter1 = new StringWriter();
HtmlTextWriter htmlTextWriter1 = new HtmlTextWriter(stringWriter1);
DivIdToPrint.RenderControl(htmlTextWriter1);
StringReader stringReader1 = new StringReader(stringWriter1.ToString());
Document Doc1 = new Document(PageSize.A4, 10f, 10f, 10f, 10f);
System.IO.MemoryStream memoryStream1 = new System.IO.MemoryStream();
PdfWriter writer1 = PdfWriter.GetInstance(Doc1, memoryStream1);
HTMLWorker htmlparser1 = new HTMLWorker(Doc1);
PdfWriter.GetInstance(Doc1, Response.OutputStream);
Doc1.Open();
PdfPTable table9 = new PdfPTable(1);
table9.TotalWidth = 580f;
table9.LockedWidth = true;
PdfPCell header4 = new PdfPCell(new Phrase("TAX INVOICE/BILL OF SUPPLY", font));
header4.HorizontalAlignment = 1;
table9.AddCell(header4);
table9.SpacingAfter = 8f;
Doc1.Add(table9);
PdfPTable table10 = new PdfPTable(7);
table10.TotalWidth = 580f;
table10.LockedWidth = true;
table10.HorizontalAlignment = 0;
//PdfPCell left = new PdfPCell(new Paragraph("TP NAME: </br> GSTIN:- </br> HSN CODE:-"));
//left.BorderColor = iTextSharp.text.Color.BLACK;
PdfPTable left4 = new PdfPTable(1);
left4.AddCell(new Phrase("TP NAME:" + Lbl_TP_Name.Text +
"\n GSTIN: " + Lbl_GSTNo.Text + "\n HSN CODE: " + Lbl_HSNCode.Text, font1));
PdfPCell nesthousing1 = new PdfPCell(left4);
nesthousing1.Colspan = 3;
nesthousing1.Padding = 0f;
table10.AddCell(nesthousing1);
nesthousing1.Padding = 0f;
//table1.AddCell(left);
PdfPCell middle4 = new PdfPCell();
table10.AddCell(middle4);
PdfPCell right4 = new PdfPCell(new Phrase("TP-ADDRESS: " + Lbl_Address.Text, font1));
right4.Colspan = 3;
table10.AddCell(right4);
table10.SpacingAfter = 8f;
Doc1.Add(table10);
PdfPTable table11 = new PdfPTable(7);
table11.TotalWidth = 580f;
table11.LockedWidth = true;
table11.HorizontalAlignment = 0;
PdfPCell left5 = new PdfPCell(new Phrase("INVOICE NO: " + Lbl_RefNo.Text, font1));
left5.Colspan = 3;
table11.AddCell(left5);
PdfPCell middle5 = new PdfPCell();
table11.AddCell(middle5);
PdfPCell right5 = new PdfPCell(new Phrase("DATE: " + Lbl_CreationDate.Text, font1));
right5.Colspan = 7;
table11.AddCell(right5);
table11.SpacingAfter = 8f;
Doc1.Add(table11);
PdfPTable table12 = new PdfPTable(7);
table12.TotalWidth = 580f;
table12.LockedWidth = true;
table12.HorizontalAlignment = 0;
PdfPCell left6 = new PdfPCell(new Phrase("BILL To: \n" + Lbl_SIAName.Text+"\n" +Lbl_SIAAddress.Text+"\n"+
Lbl_SIAPerson.Text + "\n" + Lbl_SIANo.Text + "\n" + Lbl_SIAStateName.Text, font1));
left6.Colspan = 3;
table12.AddCell(left6);
PdfPCell middle6 = new PdfPCell();
table12.AddCell(middle6);
PdfPCell right6 = new PdfPCell(new Phrase("Place of Supply: "+
"\n\n\n State Name:" + Lbl_StateName.Text +
"\n State Code:" + Lbl_StateCode.Text, font1));
right6.Colspan = 3;
table12.AddCell(right6);
table12.SpacingAfter = 0f;
Doc1.Add(table12);
Paragraph para4 = new Paragraph("SECTION A", font4);
para4.Alignment = Element.ALIGN_LEFT;
para4.SpacingAfter = 8f;
Doc1.Add(para4);
//PdfPTable table4 = new PdfPTable(1);
//table4.TotalWidth = 580f;
//table4.LockedWidth = true;
//PdfPCell header1 = new PdfPCell(new Phrase("1. It is certified that " +Lbl_TP_Name.Text+ " is affiliated with " +Lbl_KIA.Text + ", and the following claim is being made after completion of training, in-line with the scheme Guidelines.", font1));
//header1.HorizontalAlignment = 0;
//table4.AddCell(header1);
PdfPTable table13 = new PdfPTable(4);
table13.TotalWidth = 580f;
table13.LockedWidth = true;
PdfPCell cell38 = new PdfPCell(new Phrase("1. It is certified that " + Lbl_TP_Name.Text + " is affiliated with " + Lbl_KIA.Text + " " + Scheme1_Name.InnerText + ", and the following claim is being made after completion of training, in-line with the scheme Guidelines.", font1));
cell38.Colspan = 4;
cell38.HorizontalAlignment = 0; //0=Left, 1=Centre, 2=Right
table13.AddCell(cell38);
table13.AddCell(new Phrase("2. TP ID", font2));
table13.AddCell(new Phrase(Txt_TpID.Text, font3));
table13.AddCell(new Phrase("3. State Name", font2));
table13.AddCell(new Phrase(Lbl_State_Name.Text, font3));
table13.AddCell(new Phrase("4. Course Code", font2));
table13.AddCell(new Phrase(Txt_CourseCode.Text, font3));
table13.AddCell(new Phrase("5. Course Name", font2));
table13.AddCell(new Phrase(Txt_CourseName.Text, font3));
table13.AddCell(new Phrase("6. Batch ID", font2));
table13.AddCell(new Phrase(Txt_BatchCode.Text, font3));
table13.AddCell(new Phrase("7. Batch Start Date", font2));
table13.AddCell(new Phrase(Txt_BatchStartDate.Text, font3));
table13.AddCell(new Phrase("8. Batch End Date", font2));
table13.AddCell(new Phrase(Txt_BatchEndDate.Text, font3));
table13.AddCell(new Phrase("9. Exam Date", font2));
table13.AddCell(new Phrase(Txt_ExamDate.Text, font3));
table13.AddCell(new Phrase("10. Result Date", font2));
table13.AddCell(new Phrase(Txt_ResultDate.Text, font3));
table13.AddCell(new Phrase("11. Date of issue of Course Certificate", font2));
table13.AddCell(new Phrase(Txt_DateofIssueofCertificate.Text, font3));
table13.AddCell(new Phrase("12. Average Training Hours (excluding break)", font2));
table13.AddCell(new Phrase(Txt_TrainingTimings.Text, font3));
table13.AddCell(new Phrase("13. Total no. of Training days (excluding Holidays)", font2));
table13.AddCell(new Phrase(Txt_TTD.Text, font3));
table13.AddCell(new Phrase("14. Actual Training Hours", font2));
table13.AddCell(new Phrase(Txt_ATH.Text, font3));
table13.AddCell(new Phrase("15. Course Hours as per NSQF", font2));
table13.AddCell(new Phrase(Txt_CHASN.Text, font3));
table13.AddCell(new Phrase("16. Course Fee (CF) Amount \n (as per NSQF Course list)", font2));
table13.AddCell(new Phrase(Txt_CF.Text, font3));
table13.AddCell(new Phrase("17. Registration cum Certification Fee (RCCF) Amount \n (as per NSQF Course list)", font2));
table13.AddCell(new Phrase("", font3));
Doc1.Add(table13);
table13.SpacingAfter = 8f;
Paragraph para5 = new Paragraph("SECTION B:-DESCRIPTION OF SERVICES", font4);
para5.Alignment = Element.ALIGN_LEFT;
para5.SpacingAfter = 8f;
Doc1.Add(para5);
PdfPTable table14 = new PdfPTable(10);
table14.TotalWidth = 580f;
table14.LockedWidth = true;
//table5.AddCell(new Phrase("18. Total Candidates in the batch", font2));
//table5.AddCell(new Phrase(Txt_TotalCandidates.Text, font2));
PdfPCell Cell39 = new PdfPCell(new Phrase("18. Total Candidates in the batch", font2));
Cell39.Colspan = 3;
table14.AddCell(Cell39);
PdfPCell Cell40 = new PdfPCell(new Phrase(Txt_TotalCandidates.Text, font3));
Cell40.Colspan = 1;
table14.AddCell(Cell40);
PdfPCell Cell41 = new PdfPCell(new Phrase("Whether Reverse Charge Applicable " + Lbl_RPStatus.Text, font3));
Cell41.Colspan = 6;
table14.AddCell(Cell41);
PdfPCell Cell42 = new PdfPCell(new Phrase("19. Total Candidates Trained in the batch", font2));
Cell42.Colspan = 3;
table14.AddCell(Cell42);
PdfPCell Cell43 =new PdfPCell(new Phrase(Txt_TotalCandidatesTrained.Text, font3));
Cell43.Colspan = 1;
table14.AddCell(Cell43);
PdfPCell Cell44 = new PdfPCell(new Phrase("", font2));
Cell44.Colspan = 6;
table14.AddCell(Cell44);
PdfPCell Cell45 = new PdfPCell(new Phrase("20. Total No. of Candidates Certified", font2));
Cell45.Colspan = 3;
table14.AddCell(Cell45);
PdfPCell Cell46 = new PdfPCell(new Phrase(Txt_TotalCandidatesCertified.Text, font3));
Cell46.Colspan = 1;
table14.AddCell(Cell46);
PdfPCell Cell47 = new PdfPCell(new Phrase("", font2));
Cell47.Colspan = 6;
table14.AddCell(Cell47);
PdfPCell Cell48 = new PdfPCell(new Phrase("", font2));
Cell48.Colspan = 2;
table14.AddCell(Cell48);
table14.AddCell(new Phrase("Category", font2));
table14.AddCell(new Phrase("No. of Students", font2));
table14.AddCell(new Phrase("CF Rate", font2));
table14.AddCell(new Phrase("RCCF Rate", font2));
PdfPCell Cell83 = new PdfPCell(new Phrase("CF Amount \n (In Rs)", font2));
Cell83.Colspan = 2;
table14.AddCell(Cell83);
//table14.AddCell(new Phrase("CF Amount \n (In Rs)", font2));
PdfPCell Cell84 = new PdfPCell(new Phrase("RCCF Amount \n (In Rs)", font2));
Cell84.Colspan = 2;
table14.AddCell(Cell84);
//table14.AddCell(new Phrase("RCCF Amount \n (In Rs)", font2));
PdfPCell Cell49 = new PdfPCell(new Phrase("20(a).", font2));
Cell49.HorizontalAlignment = 2;
Cell49.Colspan = 2;
table14.AddCell(Cell49);
table14.AddCell(new Phrase("GEN", font2));
table14.AddCell(new Phrase(Txt_CandidatesGC.Text, font3));
if (Lbl_GSTStatus.Text == "Y")
{
table14.AddCell(new Phrase(Txt_Cost_CF_Gen.Text + "\n\n (CF Rate/1.18)", font3));
}
else
{
table14.AddCell(new Phrase(Txt_Cost_CF_Gen.Text, font3));
}
table14.AddCell(new Phrase("", font2));
PdfPCell Cell85 = new PdfPCell(new Phrase(Txt_CFClaimforGC.Text, font3));
Cell85.Colspan = 2;
table14.AddCell(Cell85);
//table14.AddCell(new Phrase(Txt_CFClaimforGC.Text, font3));
PdfPCell Cell96 = new PdfPCell(new Phrase("", font3));
Cell96.Colspan = 2;
table14.AddCell(Cell96);
//table14.AddCell(new Phrase("", font2));
PdfPCell Cell50 = new PdfPCell(new Phrase("20(b).", font2));
Cell50.Colspan = 2;
Cell50.HorizontalAlignment = 2;
table14.AddCell(Cell50);
table14.AddCell(new Phrase("SC", font2));
table14.AddCell(new Phrase(Txt_SCCandidates.Text, font3));
if (Lbl_GSTStatus.Text == "Y")
{
table14.AddCell(new Phrase(Txt_Cost_CF_SC.Text + "\n\n (CF Rate/1.18)", font3));
}
else
{
table14.AddCell(new Phrase(Txt_Cost_CF_SC.Text, font3));
}
table14.AddCell(new Phrase("", font2));
PdfPCell Cell86 = new PdfPCell(new Phrase(Txt_CFClaimforSC.Text, font3));
Cell86.Colspan = 2;
table14.AddCell(Cell86);
//table14.AddCell(new Phrase(Txt_CFClaimforSC.Text, font3));
PdfPCell Cell97 = new PdfPCell(new Phrase("", font3));
Cell97.Colspan = 2;
table14.AddCell(Cell97);
//table14.AddCell(new Phrase("", font2));
PdfPCell Cell51 = new PdfPCell(new Phrase("20(c).", font2));
Cell51.Colspan = 2;
Cell51.HorizontalAlignment = 2;
table14.AddCell(Cell51);
table14.AddCell(new Phrase("ST", font2));
table14.AddCell(new Phrase(Txt_STCandidates.Text, font3));
if (Lbl_GSTStatus.Text == "Y")
{
table14.AddCell(new Phrase(Txt_Cost_CF_ST.Text + "\n\n (CF Rate/1.18)", font3));
}
else
{
table14.AddCell(new Phrase(Txt_Cost_CF_ST.Text, font3));
}
table14.AddCell(new Phrase("", font2));
PdfPCell Cell87 = new PdfPCell(new Phrase(Txt_CFClaimforST.Text, font3));
Cell87.Colspan = 2;
table14.AddCell(Cell87);
//table14.AddCell(new Phrase(Txt_CFClaimforST.Text, font3));
PdfPCell Cell98 = new PdfPCell(new Phrase("", font3));
Cell98.Colspan = 2;
table14.AddCell(Cell98);
//table14.AddCell(new Phrase("", font2));
PdfPCell Cell52 = new PdfPCell(new Phrase("20(d).", font2));
Cell52.HorizontalAlignment = 2;
Cell52.Colspan = 2;
table14.AddCell(Cell52);
table14.AddCell(new Phrase("EWS", font2));
table14.AddCell(new Phrase(Txt_EWSCandidates.Text, font3));
if (Lbl_GSTStatus.Text == "Y")
{
table14.AddCell(new Phrase(Txt_Cost_CF_EWS.Text + "\n\n (CF Rate/1.18)", font3));
}
else
{
table14.AddCell(new Phrase(Txt_Cost_CF_EWS.Text, font3));
}
table14.AddCell(new Phrase("", font2));
PdfPCell Cell88 = new PdfPCell(new Phrase(Txt_CFClaimforEWS.Text, font3));
Cell88.Colspan = 2;
table14.AddCell(Cell88);
//table14.AddCell(new Phrase(Txt_CFClaimforEWS.Text, font3));
PdfPCell Cell99 = new PdfPCell(new Phrase("", font3));
Cell99.Colspan = 2;
table14.AddCell(Cell99);
//table14.AddCell(new Phrase("", font2));
PdfPCell Cell53 = new PdfPCell(new Phrase("20(e).", font2));
Cell53.HorizontalAlignment = 2;
Cell53.Colspan = 2;
table14.AddCell(Cell53);
table14.AddCell(new Phrase("Total", font2));
table14.AddCell(new Phrase(Txt_TotalCandidate.Text, font3));
table14.AddCell(new Phrase("", font2));
table14.AddCell(new Phrase("", font2));
PdfPCell Cell89 = new PdfPCell(new Phrase(Txt_TotalCF.Text, font3));
Cell89.Colspan = 2;
table14.AddCell(Cell89);
//table14.AddCell(new Phrase(Txt_TotalCF.Text, font3));
PdfPCell Cell100 = new PdfPCell(new Phrase("", font3));
Cell100.Colspan = 2;
table14.AddCell(Cell100);
//table14.AddCell(new Phrase("", font2));
//table14.AddCell(new Phrase("", font2));
PdfPCell Cell54 = new PdfPCell(new Phrase("20(f).", font2));
Cell54.HorizontalAlignment = 2;
Cell54.Colspan = 2;
table14.AddCell(Cell54);
PdfPCell Cell55 = new PdfPCell(new Phrase("Total Amount CF:", font2));
Cell55.Colspan = 4;
table14.AddCell(Cell55);
PdfPCell Cell56 = new PdfPCell(new Phrase(Txt_TotalCF.Text, font3));
Cell56.Colspan = 4;
table14.AddCell(Cell56);
PdfPCell Cell57 = new PdfPCell(new Phrase("20(g).", font2));
Cell57.HorizontalAlignment = 2;
Cell57.Colspan = 2;
table14.AddCell(Cell57);
PdfPCell Cell58 = new PdfPCell(new Phrase("CGST Rate @" + Lbl_CGSTRate.Text + "% if Applicable", font2));
Cell58.Colspan = 4;
table14.AddCell(Cell58);
PdfPCell Cell59 = new PdfPCell(new Phrase(Lbl_CGSTAmount_CF.Text, font3));
Cell59.Colspan = 4;
table14.AddCell(Cell59);
PdfPCell Cell60 = new PdfPCell(new Phrase("20(h).", font2));
Cell60.HorizontalAlignment = 2;
Cell60.Colspan = 2;
table14.AddCell(Cell60);
PdfPCell Cell61 = new PdfPCell(new Phrase("SGST Rate @" + Lbl_SGSTRate.Text + "% if Applicable", font2));
Cell61.Colspan = 4;
table14.AddCell(Cell61);
PdfPCell Cell62 = new PdfPCell(new Phrase(Lbl_SGSTAmount_CF.Text, font3));
Cell62.Colspan = 4;
table14.AddCell(Cell62);
PdfPCell Cell63 = new PdfPCell(new Phrase("20(i).", font2));
Cell63.HorizontalAlignment = 2;
Cell63.Colspan = 2;
table14.AddCell(Cell63);
PdfPCell Cell64 = new PdfPCell(new Phrase("IGST Rate @" + Lbl_IGSTRate.Text + "% if Applicable", font2));
Cell64.Colspan = 4;
table14.AddCell(Cell64);
PdfPCell Cell65 = new PdfPCell(new Phrase(Lbl_IGSTAmount_CF.Text, font3));
Cell65.Colspan = 4;
table14.AddCell(Cell65);
PdfPCell Cell66 = new PdfPCell(new Phrase("20(j).", font2));
Cell66.HorizontalAlignment = 2;
Cell66.Colspan = 2;
table14.AddCell(Cell66);
PdfPCell Cell67 = new PdfPCell(new Phrase("Total Amount of TAX", font2));
Cell67.Colspan = 4;
table14.AddCell(Cell67);
PdfPCell Cell68 = new PdfPCell(new Phrase(Lbl_TaxAmount_CF.Text, font3));
Cell68.Colspan = 4;
table14.AddCell(Cell68);
PdfPCell Cell69 = new PdfPCell(new Phrase("20(k).", font2));
Cell69.HorizontalAlignment = 2;
Cell69.Colspan = 2;
table14.AddCell(Cell69);
PdfPCell Cell70 = new PdfPCell(new Phrase("Total Invoice Value in (Figure)", font2));
Cell70.Colspan = 4;
table14.AddCell(Cell70);
PdfPCell Cell71 = new PdfPCell(new Phrase(Lbl_Total_Invoice_Amount_CF.Text, font3));
Cell71.Colspan = 4;
table14.AddCell(Cell71);
PdfPCell Cell72 = new PdfPCell(new Phrase("", font2));
Cell72.Colspan = 2;
table14.AddCell(Cell72);
PdfPCell Cell73 = new PdfPCell(new Phrase("Total Invoice Value in (Words)", font2));
Cell73.Colspan = 4;
table14.AddCell(Cell73);
PdfPCell Cell74 = new PdfPCell(new Phrase(Lbl_Total_Invoice_Amount_InWords_CF.Text, font5));
Cell74.Colspan = 4;
table14.AddCell(Cell74);
Doc1.Add(table14);
Paragraph para6 = new Paragraph("SECTION C", font4);
para6.Alignment = Element.ALIGN_LEFT;
para6.SpacingBefore = 30f;
para6.SpacingAfter = 8f;
Doc1.Add(para6);
PdfPTable table15 = new PdfPTable(3);
table15.TotalWidth = 580f;
table15.LockedWidth = true;
table15.AddCell(new Phrase(" \n 21. PAN Number:" +
"\n 22. Bank Details:-" +
"\n\n 22(a). Name of Account Holder: " +
"\n\n\n 22(b). Name of Bank: " +
"\n 22(c). Branch Name: " +
"\n 22(d). Account Number: " +
"\n 22(e). IFSC Code: ", font2));
table15.AddCell(new Phrase("\n" + Txt_PanNumber.Text +
"\n" +
"\n\n" + Txt_NameofAH.Text +
"\n\n" + Txt_NameofBank.Text +
"\n" + Txt_BranchName.Text +
"\n" + Txt_AccountNumber.Text +
"\n" + Txt_IFSCCode.Text, font3));
table15.AddCell(new Phrase("\n\n\n\n\n\n (Stamp and Sign of Authorized Signatory of TP)" +
"\n Name: " +
"\n Designation: " +
"\n Date:", font3));
table15.SpacingAfter = 20f;
Doc1.Add(table15);
PdfPTable table16 = new PdfPTable(1);
table16.TotalWidth = 580f;
table16.LockedWidth = true;
PdfPCell header5 = new PdfPCell(new Phrase("UNDERTAKING FROM TRAINING PARTNER", font));
header5.HorizontalAlignment = 1;
table16.AddCell(header5);
Doc1.Add(table16);
PdfPTable table17 = new PdfPTable(2);
table17.TotalWidth = 580f;
table17.LockedWidth = true;
PdfPCell Cell75 = new PdfPCell(new Phrase(
"\n\n a.) Having read and understood all terms and conditions of the Undertaking/Code of Ethics (as per Annexure-VII of Guidelines), the said Undertaking/Code of Ethics, duly signed, has been submitted to our KIA " + Lbl_KIA_name_a.Text + "." +
"\n\n b.) Attendance of candidates has been obtained through a bio-metric attendance system and the attendance report in this regard is attached herewith with this Invoice." +
"\n\n c.) All certified candidates, as per this invoice, have been provided with a printed copy of final certification as uploaded by KIA " + Lbl_KIA_Name_c.Text + " in the Scheme Portal." +
"\n\n d.) The details provided in the Invoice are factual and correct and these details also conform to all compliance norms mentioned in the ESDM Scheme Guidelines." +
"\n\n e.) All candidates, details of which are annexed with this invoice comply with the laid down eligibility criteria for the course mentioned at Sr.No.4 & 5 of the Invoice." +
"\n\n f.) The copy of the Caste(SC/ST)/Category(EWS) certificates provided by the candidate have been verified with the original document and the same was valid and legal at the time of enrollment. It is further certified that copy of such certificates have also been uploaded at the ESDM Portal with due diligence." +
"\n\n g.) I understand that if any information/data in this Invoice is found to be incorrect or misleading, I shall be liable for any action as deemed appropriate by NIELIT-PMU/MeitY, which may include for forfeiture of my entire claim or any penalty as deserved appropriate." +
"\n ", font3));
Cell75.Colspan = 2;
Cell75.HorizontalAlignment = PdfPCell.ALIGN_JUSTIFIED;
table17.AddCell(Cell75);
table17.AddCell(new Phrase("\n\n\n\n\n<Revenue Stamp>", font));
table17.AddCell(new Phrase("\n\n\n(Stamp and sign of Authorized Signatory of TP) \n Name: \n Designation: \n Date:", font3));
table17.SpacingAfter = 5f;
Doc1.Add(table17);
Paragraph p4 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, CMYKColor.BLACK, Element.ALIGN_LEFT, 1)));
Doc1.Add(p4);
Paragraph para7 = new Paragraph("This is system generated Invoice, Send signed hard copy to your KIA", font3);
para7.Alignment = Element.ALIGN_CENTER;
Doc1.Add(para7);
Paragraph p5 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, CMYKColor.BLACK, Element.ALIGN_LEFT, 1)));
Doc1.Add(p5);
htmlparser1.Parse(stringReader1);
Doc1.Close();
byte[] bytes1 = memoryStream1.ToArray();
System.IO.File.WriteAllBytes(Server.MapPath("~/View/TrainingPartner/TPDocument/Invoice/") + Invoice_FileName_CF, bytes1);
}
ref:- https://stackoverflow.com/questions/10463553/how-to-print-a-grid-view-using-itextsharp
test
ReplyDelete