private void LoadPage() { var p = Attendance.GetCurrentPayPeriod(); _attendance = new Attendance(Aid, p.month, p.period, p.year); RefreshData(); }
public void LoadPage() { if (!Name.Equals("Archived")) { var p = Attendance.GetCurrentPayPeriod(); _attendance = new Attendance(Aid, p.month, p.period, p.year); } RefreshDutyDetails(); RefreshCurrent(); RefreshData(); }
public void ExportToPayslipPDF(DataTable approvedList, bool printFlag) { int gid, month, period, year; int i; string filePath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\" + "MSAMIS Reports"; var PrintTable = new PdfPTable(2); var alignTable = new PdfPTable(2); Document pdfDoc = getPDFSize(approvedList.Rows.Count); alignTable.DefaultCell.Padding = 3; alignTable.WidthPercentage = 100; alignTable.DefaultCell.BorderWidth = 0; //alignTable.LockedWidth = true; Paragraph par = new Paragraph(); PrintTable.DefaultCell.Padding = 3; PrintTable.WidthPercentage = 100; PrintTable.DefaultCell.BorderWidth = 0; if (approvedList.Rows.Count != 1) { fileName = "PayslipBatchPrintTemp.pdf"; } //rylui.RylMessageBox.ShowDialog("Flag boiii"); for (i = 0; i < approvedList.Rows.Count; i++) { alignTable = new PdfPTable(2); alignTable.HorizontalAlignment = Element.ALIGN_LEFT; alignTable.DefaultCell.Padding = 3; alignTable.WidthPercentage = 45; alignTable.DefaultCell.BorderWidth = 0; gid = Convert.ToInt32(approvedList.Rows[i][0]); month = Convert.ToInt32(approvedList.Rows[i][1]); period = Convert.ToInt32(approvedList.Rows[i][2]); year = Convert.ToInt32(approvedList.Rows[i][3]); var newLine = Environment.NewLine; PayrollReport pr = new PayrollReport(gid, year, month, period); Attendance.Period p = Attendance.GetCurrentPayPeriod(); //Content //Name String GuardFullName = pr.LN.ToUpper() + ", " + pr.FN.ToUpper() + " " + pr.MN[0].ToString().ToUpper() + "."; Phrase Name = new Phrase(GuardFullName + newLine, boldfontPayslip); //rylui.RylMessageBox.ShowDialog(GuardFullName); Phrase Header = new Phrase("THIS IS TO CERTIFY THAT I'VE RECEIVED THE FULL" + newLine + " AMOUNT OF MY SALARY FOR THE PERIOD OF " + newLine, myfontPayslip); Chunk ChunkHeader2 = new Chunk(($@"{(p.period == 1 ? "1ST HALF" : "2ND HALF")} OF {p.month}/{p.year}") + newLine + newLine, boldfontPayslip); Header.Add(ChunkHeader2); //deductions alignTable.AddCell(new Phrase("DEDUCTIONS:" + newLine, boldunderfontPayslip)); alignTable.AddCell(new Phrase(" ", boldunderfontPayslip)); alignTable.AddCell(new Phrase("SSS: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.Sss.ToString("0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("PHIC: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.PHIC.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Tax Withhold: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.Withtax.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Pag-Ibig: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.HDMF.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Cash Advance: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.CashAdvance.ToString("₱0.00"), myfontPayslip)); double TotalDedVal = pr.Sss + pr.PHIC + pr.Withtax + pr.HDMF + pr.CashAdvance; alignTable.AddCell(new Phrase("Total Deductions: ", boldfontPayslip)); alignTable.AddCell(new Phrase("Php " + TotalDedVal.ToString("₱0.00"), boldfontPayslip)); alignTable.AddCell(new Phrase(" ")); alignTable.AddCell(new Phrase(" ")); //Bonuses alignTable.AddCell(new Phrase("BONUSES:", boldunderfontPayslip)); alignTable.AddCell(new Phrase("", boldunderfontPayslip)); alignTable.AddCell(new Phrase("Thirteenth Month: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.ThirteenthMonthPay.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Cola: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.Cola.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Cash Bond: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.CashBond.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Emergency Allowance: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.EmergencyAllowance.ToString("₱0.00"), myfontPayslip)); double TotalBonVal = pr.ThirteenthMonthPay + pr.Cola + pr.CashBond + pr.EmergencyAllowance; alignTable.AddCell(new Phrase("Total Bonuses: ", boldfontPayslip)); alignTable.AddCell(new Phrase("Php " + TotalBonVal.ToString("₱0.00"), boldfontPayslip)); alignTable.DefaultCell.Colspan = 2; alignTable.AddCell(new Phrase(" ")); alignTable.AddCell(new Phrase("PLEASE COUNT YOUR MONEY BEFORE LEAVING", myfontPayslip)); alignTable.AddCell(new Phrase(" ")); alignTable.AddCell(new Phrase("TOTAL PAY: Php " + pr.NetAmountPaid.ToString("₱0.00") + newLine + newLine, boldunderfontPayslip)); alignTable.DefaultCell.Colspan = 1; //Export Content if (approvedList.Rows.Count == 1) { fileName = "Payslip" + pr.LN + pr.FN + pr.MN + ($@"{p.year}-{p.month}-{(p.period == 1 ? "1st_Half" : "2nd_Half")}") + ".pdf"; } if (!Directory.Exists(filePath)) { Directory.CreateDirectory(filePath); } if (File.Exists(filePath + "\\" + fileName)) { File.Delete(filePath + "\\" + fileName); } par.Add(Name); par.Add(Header); par.Add(alignTable); } using (FileStream stream = new FileStream(filePath + "\\" + fileName, FileMode.Create)) { //pdfDoc = new Document(); PdfWriter.GetInstance(pdfDoc, stream); pdfDoc.Open(); pdfDoc.Add(par); pdfDoc.Close(); stream.Close(); } if (printFlag == true) { PrintPDF(fileName); } }
public void ExportToPayslipPDFOne(DataTable approvedList, string file) { int i; var PrintTable = new PdfPTable(2); var alignTable = new PdfPTable(2); alignTable.DefaultCell.Padding = 3; alignTable.WidthPercentage = 100; alignTable.DefaultCell.BorderWidth = 0; //alignTable.LockedWidth = true; PrintTable.DefaultCell.Padding = 3; PrintTable.WidthPercentage = 100; PrintTable.DefaultCell.BorderWidth = 0; //rylui.RylMessageBox.ShowDialog("Flag boiii"); for (i = 0; i < approvedList.Rows.Count; i++) { var gid = Convert.ToInt32(approvedList.Rows[i][0]); var month = Convert.ToInt32(approvedList.Rows[i][1]); var period = Convert.ToInt32(approvedList.Rows[i][2]); var year = Convert.ToInt32(approvedList.Rows[i][3]); var newLine = Environment.NewLine; var pr = new PayrollReport(gid, year, month, period); var p = Attendance.GetCurrentPayPeriod(); //Content //Name var GuardFullName = pr.LN.ToUpper() + ", " + pr.FN.ToUpper() + " " + pr.MN[0].ToString().ToUpper() + "."; var Name = new Phrase(GuardFullName + newLine, boldfontPayslip); var Header = new Phrase("THIS IS TO CERTIFY THAT I'VE RECEIVED THE FULL AMOUNT OF MY SALARY FOR THE PERIOD OF ", myfontPayslip); var ChunkHeader2 = new Chunk(($@"{(p.period == 1 ? "1ST HALF" : "2ND HALF")} OF {p.month}/{p.year}") + newLine + newLine, boldfontPayslip); Header.Add(ChunkHeader2); //deductions alignTable.AddCell(new Phrase("DEDUCTIONS:" + newLine, boldunderfontPayslip)); alignTable.AddCell(new Phrase(" ", boldunderfontPayslip)); alignTable.AddCell(new Phrase("SSS: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.Sss.ToString("0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("PHIC: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.PHIC.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Tax Withhold: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.Withtax.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Pag-Ibig: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.HDMF.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Cash Advance: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.CashAdvance.ToString("₱0.00"), myfontPayslip)); var TotalDedVal = pr.Sss + pr.PHIC + pr.Withtax + pr.HDMF + pr.CashAdvance; alignTable.AddCell(new Phrase("Total Deductions: ", boldfontPayslip)); alignTable.AddCell(new Phrase("Php " + TotalDedVal.ToString("₱0.00"), boldfontPayslip)); alignTable.AddCell(new Phrase(" ")); alignTable.AddCell(new Phrase(" ")); //Bonuses alignTable.AddCell(new Phrase("BONUSES:", boldunderfontPayslip)); alignTable.AddCell(new Phrase("", boldunderfontPayslip)); alignTable.AddCell(new Phrase("Thirteenth Month: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.ThirteenthMonthPay.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Cola: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.Cola.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Cash Bond: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.CashBond.ToString("₱0.00"), myfontPayslip)); alignTable.AddCell(new Phrase("Emergency Allowance: ", myfontPayslip)); alignTable.AddCell(new Phrase("Php " + pr.EmergencyAllowance.ToString("₱0.00"), myfontPayslip)); var TotalBonVal = pr.ThirteenthMonthPay + pr.Cola + pr.CashBond + pr.EmergencyAllowance; alignTable.AddCell(new Phrase("Total Bonuses: ", boldfontPayslip)); alignTable.AddCell(new Phrase("Php " + TotalBonVal.ToString("₱0.00"), boldfontPayslip)); alignTable.DefaultCell.Colspan = 2; alignTable.AddCell(new Phrase(" ")); alignTable.AddCell(new Phrase("PLEASE COUNT YOUR MONEY BEFORE LEAVING", myfontPayslip)); alignTable.AddCell(new Phrase(" ")); alignTable.AddCell(new Phrase("TOTAL PAY: Php " + pr.NetAmountPaid.ToString("₱0.00"), boldunderfontPayslip)); //Export Content using (var stream = new FileStream(file, FileMode.Create)) { var pdfDoc = getPDFSize(approvedList.Rows.Count);// new Document(PageSize.A8, 10f, 10f, 10f, 10f); PdfWriter.GetInstance(pdfDoc, stream); pdfDoc.Open(); pdfDoc.Add(Name); pdfDoc.Add(Header); pdfDoc.Add(alignTable); pdfDoc.Close(); stream.Close(); } } }