private string Challan(DataSet ds, string BankName, string Date, string ChequeNo) { StringBuilder sb = new StringBuilder(); try { DataTable _dt = ds.Tables[0]; DataTable _dt1 = ds.Tables[1]; sb.Append("<table width='97%' align='center' cellpadding='0' cellspacing='0' style='border:1px solid #000000;font-size:14px;'>"); string strStartFont1 = "<b><font size='2'>"; string strEndFont1 = "</b></font>"; string strStartFont2 = "<font size='1'>"; string strEndFont2 = "</font>"; if (_dt.Rows[0][0].ToString() != "0") { #region Calcaultaion double Account1 = 0; double Account10 = 0; double Account21 = 0; double AccountSN1AC1 = 0; double AccountSN1AC10 = 0; double AccountSN1AC21 = 0; double sn1Total = 0; double AccountSN2AC1 = 0; double sn2Total = 0; double AccountSN3AC2 = 0; double AccountSN3AC22 = 0; double sn3Total = 0; double FRTotal = 0; double FCTotal = 0; double AC1Total = 0; double AC2Total = 0; double AC10Total = 0; double AC21Total = 0; double AC22Total = 0; for (int q = 0; q < _dt1.Rows.Count; q++) { if (Convert.ToDecimal(_dt1.Rows[q]["AllwancesAmt"].ToString()) > 0) { if (Convert.ToDecimal(_dt1.Rows[q]["AllwancesAmt"]) <= 6500) { Account1 = Account1 + Convert.ToDouble(_dt1.Rows[q]["AllwancesAmt"].ToString()); Account10 = Account10 + Convert.ToDouble(_dt1.Rows[q]["AllwancesAmt"].ToString()); Account21 = Account21 + Convert.ToDouble(_dt1.Rows[q]["AllwancesAmt"].ToString()); } else if (Convert.ToDecimal(_dt1.Rows[q]["AllwancesAmt"]) > 6500) { if (Convert.ToDecimal(_dt1.Rows[q]["DedAmount"]) == 780) { Account1 = Account1 + Convert.ToDouble(6500); } else { Account1 = Account1 + Convert.ToDouble(_dt1.Rows[q]["AllwancesAmt"].ToString()); } Account10 = Account10 + Convert.ToDouble(6500); Account21 = Account21 + Convert.ToDouble(6500); } } } Int32 AccountSN1AC1int; AccountSN1AC1 = Convert.ToDouble(Account1) * Convert.ToDouble(3.67) / 100; AccountSN1AC1int = Convert.ToInt32(Math.Round(AccountSN1AC1)); Int32 AccountSN1AC10int; AccountSN1AC10 = Account10 * Convert.ToDouble(8.33) / 100; AccountSN1AC10int = Convert.ToInt32(Math.Round(AccountSN1AC10)); Int32 AccountSN1AC21int; AccountSN1AC21 = Account10 * Convert.ToDouble(0.50) / 100; AccountSN1AC21int = Convert.ToInt32(Math.Round(AccountSN1AC21)); Int32 sn1Totalint; sn1Total = AccountSN1AC1 + AccountSN1AC10 + AccountSN1AC21; sn1Totalint = Convert.ToInt32(Math.Round(sn1Total)); Int32 AccountSN2AC1int; AccountSN2AC1 = Account1 * Convert.ToDouble(12.00) / 100; AccountSN2AC1int = Convert.ToInt32(Math.Round(AccountSN2AC1)); AccountSN2AC1int = AccountSN2AC1int - AccountSN1AC10int; Int32 sn2Totalint; sn2Total = AccountSN2AC1; sn2Totalint = Convert.ToInt32(Math.Round(sn2Total)); Int32 AccountSN3AC2int; AccountSN3AC2 = Account1 * Convert.ToDouble(1.10) / 100; AccountSN3AC2int = Convert.ToInt32(Math.Round(AccountSN3AC2)); Int32 AccountSN3AC22int; AccountSN3AC22 = Account10 * Convert.ToDouble(0.01) / 100; AccountSN3AC22int = Convert.ToInt32(Math.Round(AccountSN3AC22)); if (AccountSN3AC22int < 2) { AccountSN3AC22int = 2; } Int32 sn3Totalint; //sn3Total = AccountSN3AC2 + AccountSN3AC22; // By Shruti sn3Total = AccountSN3AC2 + AccountSN3AC22int; sn3Totalint = Convert.ToInt32(Math.Round(sn3Total)); //Int32 AC1Totalint = AccountSN1AC1int + AccountSN2AC1int; Int32 AC1Totalint = AccountSN1AC1int + Convert.ToInt32(Math.Round(AccountSN2AC1)); Int32 AC2Totalint = AccountSN3AC2int; Int32 AC10Totalint = AccountSN1AC10int; Int32 AC21Totalint = AccountSN1AC21int; Int32 AC22Totalint = AccountSN3AC22int; Int32 FCTotalint = sn1Totalint + sn2Totalint + sn3Totalint; Int32 FRTotalint = AC1Totalint + AC2Totalint + AC10Totalint + AC21Totalint + AC22Totalint; #endregion Calcaultaion sb.Append("<tr>"); sb.Append("<td><img src='../../Images/logo.jpg' width='70' height='70' /></td>"); sb.Append("<td colapan='2' valign='top' align='left'>"); sb.Append(" "); sb.Append(" "); sb.Append(strStartFont2 + "COMBINED CHALLAN oF A/C NO.1,2,10,21 & 22(STATE BANK OF INDIA)" + strEndFont2); sb.Append("<br>" + strStartFont1 + "EMPLOYEE PROVIDENT FUND ORGANIZATION" + strEndFont1); sb.Append(strStartFont2 + "(USE SEPRATE CHALLAN FOR EACH MONTH)" + strEndFont2 + "</td>"); sb.Append("<td align='right'>" + strStartFont2 + "ORIGINAL<br>DUPLICATE<br>TRIPLICATE<br>QUARDUPLICATE" + strEndFont2 + "</td>"); sb.Append("</tr>"); sb.Append("<tr><td colspan='3'><hr></td></tr>"); sb.Append("<tr><td colspan='3'><table width='100%'>"); sb.Append("<tr>"); sb.Append("<td width='17%'>" + strStartFont2 + "ESTABLISHMENT CODE NO." + strEndFont2 + "</td>"); sb.Append("<td width='2%'>:</td>"); sb.Append("<td width='10%'>" + strStartFont2 + "DSSHD0938826" + strEndFont2 + "</td>"); sb.Append("<td width='9%' colspan='2'>" + strStartFont2 + "ACCOUNT GROUP NO." + strEndFont2 + " ......................................</td>"); sb.Append("<td align='left' width='1%'> </td>"); sb.Append("<td width='22%'>" + strStartFont2 + "PAID BY CHEQUE CASH" + '/' + " CASH" + strEndFont2 + " .........................</td>"); sb.Append("</tr>"); sb.Append("<tr><td colspan='6'><br></td></tr>"); sb.Append("<tr>"); sb.Append("<td width='17%'>" + strStartFont2 + "DUES FOR THE MONTH OF" + strEndFont2 + "</td>"); sb.Append("<td width='2%'>:</td>"); sb.Append("<td width='15%' colspan='2'>" + strStartFont2 + "EMPLOYEE SHARE <b>" + ddlMonth.SelectedValue.ToString() + "/" + ddlFinYear.SelectedValue.ToString() + "</b><BR>EMPLOYER SHARE <b>" + ddlMonth.SelectedValue.ToString() + "/" + ddlFinYear.SelectedValue.ToString() + "</b>" + strEndFont2 + "</td>"); sb.Append("<td width='4%'></td>"); sb.Append("<td width='1%'></td>"); sb.Append("<td width='22%'>" + strStartFont2 + "DATE OF PAYMENT" + strEndFont2 + " ...........................................</td>"); sb.Append("</tr>"); sb.Append("<tr><td colspan='6'><br></td></tr>"); sb.Append("<tr>"); sb.Append("<td width='17%'>" + strStartFont2 + "TOTAL NO. OF SUBSCRIBERS<br>TORAL WAGES DUE" + strEndFont2 + "</td>"); sb.Append("<td width='4%'>" + strStartFont2 + " A/c 1" + strEndFont2 + "</td>"); sb.Append("<td width='15%' align='right' style='border-left:1px solid #000000;border-RIGHT:1px solid #000000;'>" + strStartFont2 + _dt.Rows[0][0].ToString() + "<BR>" + Account1 + "" + strEndFont2 + "</td>"); sb.Append("<td width='4%' align='center'>" + strStartFont2 + "A/c 10" + strEndFont2 + "</td>"); sb.Append("<td width='15%' align='right' style='border-left:1px solid #000000;border-RIGHT:1px solid #000000;'>" + strStartFont2 + _dt.Rows[0][0].ToString() + "<BR>" + Account10 + "" + strEndFont2 + "</td>"); sb.Append("<td width='4%' align='center'>" + strStartFont2 + "A/c 21" + strEndFont2 + "</td>"); sb.Append("<td width='15%' align='right' style='border-left:1px solid #000000;border-RIGHT:1px solid #000000;'>" + strStartFont2 + _dt.Rows[0][0].ToString() + "<BR>" + Account21 + "" + strEndFont2 + "</td>"); sb.Append("</tr>"); sb.Append("</table></td></tr>"); sb.Append("<tr><td colspan='3'><b><hr></b></td></tr>"); sb.Append("<tr><td colspan='3'><table width='100%'>"); sb.Append("<tr>"); sb.Append("<td style='border-bottom:1px solid #000000;'><b>" + strStartFont2 + "S.NO." + strEndFont2 + "</b></td>"); sb.Append("<td style='border-bottom:1px solid #000000;'><b>" + strStartFont2 + "PARTICULARS" + strEndFont2 + "</b></td>"); sb.Append("<td style='border-bottom:1px solid #000000;'><b>" + strStartFont2 + "A/c. No.1" + strEndFont2 + "</b></td>"); sb.Append("<td style='border-bottom:1px solid #000000;'><b>" + strStartFont2 + "A/c. No.2" + strEndFont2 + "</b></td>"); sb.Append("<td style='border-bottom:1px solid #000000;'><b>" + strStartFont2 + "A/c. No.10" + strEndFont2 + "</b></td>"); sb.Append("<td style='border-bottom:1px solid #000000;'><b>" + strStartFont2 + "A/c. No.21" + strEndFont2 + "</b></td>"); sb.Append("<td style='border-bottom:1px solid #000000;'><b>" + strStartFont2 + "A/c. No.22" + strEndFont2 + "</b></td>"); sb.Append("<td style='border-bottom:1px solid #000000;'><b>" + strStartFont2 + "TOTAL" + strEndFont2 + "</b></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "1</td>" + strEndFont2 + ""); sb.Append("<td>" + strStartFont2 + "EMPLOYER'S SHARE OF CONT." + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "" + AccountSN1AC1int + "" + strEndFont2 + "</td>"); sb.Append("<td></td>"); sb.Append("<td>" + strStartFont2 + "" + AccountSN1AC10int + "" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "" + AccountSN1AC21int + "" + strEndFont2 + "</td>"); sb.Append("<td></td>"); sb.Append("<td>" + strStartFont2 + "" + sn1Totalint + "" + strEndFont2 + "</td>"); sb.Append("</tr>"); // sb.Append("<tr><td colspan='8'><b><br></b></td></tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "2" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "EMPLOYEE SHARE OF CONT." + strEndFont2 + "</td>"); //sb.Append("<td>" + strStartFont2 + "" + AccountSN2AC1int + "" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "" + AccountSN2AC1 + "" + strEndFont2 + "</td>"); sb.Append("<td></td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("<td>" + strStartFont2 + "" + sn2Totalint + "" + strEndFont2 + "</td>"); sb.Append("</tr>"); // sb.Append("<tr><td colspan='8'><b><br></b></td></tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "3" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "ADMN. CHARGES" + strEndFont2 + "</td>"); sb.Append("<td></td>"); sb.Append("<td>" + strStartFont2 + "" + AccountSN3AC2int + "" + strEndFont2 + "</td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("<td>" + strStartFont2 + "" + AccountSN3AC22int + "" + strEndFont2 + "</td>"); //sb.Append("<td>" + strStartFont2 + "" + sn3Totalint + "" + strEndFont2 + "</td>");//By Shruti sb.Append("<td>" + strStartFont2 + "" + sn3Totalint + "" + strEndFont2 + "</td>"); sb.Append("</tr>"); //sb.Append("<tr><td colspan='8'><b><br></b></td></tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "4" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "INPECTION CHARGES" + strEndFont2 + "</td>"); sb.Append("<td></td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("</tr>"); // sb.Append("<tr><td colspan='8'><b><br></b></td></tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "5" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "PENAL DAMAGES" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("</tr>"); //sb.Append("<tr><td colspan='8'><b><br></b></td></tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "6" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "MISC. PAYMENTS(Past <br>Accumulation only)" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "0.00" + strEndFont2 + "</td>"); sb.Append("</tr>"); // sb.Append("<tr><td colspan='8'><b><br></b></td></tr>"); sb.Append("<tr>"); sb.Append("<td></td>"); sb.Append("<td align='center'>" + strStartFont2 + "TOTAL</td>"); sb.Append("<td>" + strStartFont2 + "" + AC1Totalint + "" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "" + AC2Totalint + "" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "" + AC10Totalint + "" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "" + AC21Totalint + "" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "" + AC22Totalint + "" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + "" + FCTotalint + "" + strEndFont2 + "</td>"); sb.Append("</tr>"); sb.Append("<tr><td colspan='8'><b><br></b></td></tr>"); sb.Append("<tr><td colspan='8' align='center'>" + strStartFont2 + "(AMOUNT IN WORDS)____<b>" + _objConvertMasterManager.changeNumericToWords(FCTotalint) + strEndFont2 + "</b></td></tr>"); sb.Append("</table></td></tr>"); sb.Append("<tr><td colspan='3'><hr></td></tr>"); sb.Append("<tr><td colspan='3'><table width='100%'>"); sb.Append("<tr>"); sb.Append("<td style='border-right:1px solid #000000;'><table width='100%'>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "NAME OF ESTABLISHMENT" + strEndFont2 + "</td>"); sb.Append("<td><b>" + strStartFont2 + txtOrgName.Text + strEndFont2 + "</b></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "ADDRESS" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + txtAddress.Text + strEndFont2 + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "NAME OF DEPOSITOR" + strEndFont2 + "</td>"); sb.Append("<td>.....................................................</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "SIGNATURE OF DEPOSITOR" + strEndFont2 + "</td>"); sb.Append("<td>.....................................................</td>"); sb.Append("</tr>"); sb.Append("</table></td>"); sb.Append("<td><table width='100%'>"); sb.Append("<tr>"); sb.Append("<td colspan='2'><b>" + strStartFont2 + "(FOR BANK USE ONLY)" + strEndFont2 + "</b></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "AMOUNT RECEIVED:RS" + strEndFont2 + "</td>"); sb.Append("<td>..................................</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td colspan='2'>" + strStartFont2 + "FOR CHEQUE ONLY" + strEndFont2 + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "DATE OF PRESENTATION</td>"); sb.Append("<td>..................................</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "DATE OF REALISATION" + strEndFont2 + "</td>"); sb.Append("<td>..................................</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "BRANCH NAME" + strEndFont2 + "</td>"); sb.Append("<td>..................................</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>" + strStartFont2 + "BRANCH CODE NO." + strEndFont2 + "</td>"); sb.Append("<td>..................................</td>"); sb.Append("</tr>"); sb.Append("</table></td>"); sb.Append("</tr>"); sb.Append("</table></td></tr>"); sb.Append("<tr><td colspan='3'><b><hr></b></td></tr>"); sb.Append("<tr><td colspan='3' align='center'><b>" + strStartFont2 + "(TO BE FILLED IN BY EMPLOYEE)" + strEndFont2 + "</b></td></tr>"); sb.Append("<tr><td colspan='3'><table width='100%'>"); sb.Append("<tr>"); sb.Append("<td width='20%'>" + strStartFont2 + "NAME OF THE BANK" + strEndFont2 + "</td>"); sb.Append("<td>" + BankName + "</td>"); sb.Append("<td width='20%'>" + strStartFont2 + "CHEQUE NO." + strEndFont2 + "</td>"); sb.Append("<td>" + ChequeNo + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td width='20%'>" + strStartFont2 + "Date" + strEndFont2 + "</td>"); sb.Append("<td>" + Date + "</td>"); sb.Append("<td width='20%'>" + strStartFont2 + "Amount" + strEndFont2 + "</td>"); sb.Append("<td>" + strStartFont2 + FCTotalint + strEndFont2 + "</td>"); sb.Append("</tr>"); sb.Append("</table></td></tr>"); } else { sb.Append("<tr><td colspan='3'><b>There is no record....</b></td></tr>"); } sb.Append("</table>"); } catch (Exception ex) { lblMsg.Text = "" + ex.Message.ToString(); } return(sb.ToString()); }
public string GenratePaySlip(DataSet ds, string ForMonthYear, decimal PaidSalary) { DataTable _dt = ds.Tables[0]; DataTable _dt1 = ds.Tables[1]; // DataTable _dt2 = ds.Tables[2]; StringBuilder sb = new StringBuilder(); sb.Append("<table width='100%' align='center' cellpadding='5' cellspacing='5' style='padding:20px,20px,20px,20px;' >"); sb.Append("<tr>"); sb.Append("<td width='5%'><img src='../../Images/logo.jpg' width='100' height='100' /></td>"); sb.Append("<td width='95%' align='center' colspan='2' ><b>BROADCAST ENGINEERING CONSULTANTS INDIA LTD.<br>14-B, Ring Road,<br>Indraprastha Estate,<br>New Delhi 110002</b></td>"); //sb.Append("<td width='18%'></td>"); sb.Append("</tr>"); //sb.Append("<tr>"); //sb.Append("<td><img src='../../Images/logo.jpg' width='100' height='100' /></td>"); //sb.Append("<td align='center'>14-B, Ring Road,<br>Indraprastha Estate,<br>New Delhi 110002"); //sb.Append("</td>"); //sb.Append("<td></td>"); //sb.Append("</tr>"); sb.Append("<tr><td><br></td></tr>"); sb.Append("<tr>"); sb.Append("<td></td>"); sb.Append("<td align='center'><b>Pay Slip<br><font size='2'>for " + ForMonthYear + "</font></b></td>"); sb.Append("<td></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td></td>"); sb.Append("<td align='center'><b>" + _dt.Rows[0]["Name"].ToString() + "</b></td>"); sb.Append("<td></td>"); sb.Append("</tr>"); sb.Append("<tr><td colspan='3'><table width='100%' align='center' cellpadding='0' cellspacing='0' style='border:1px solid #000000;font-size:14px;'>"); sb.Append("<tr>"); sb.Append("<td>Employee Number</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["EmployeeId"].ToString() + "</td>"); sb.Append("<td>Income Tax Number(PAN)</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["PANCardNo"].ToString() + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>Function</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["Department"].ToString() + "</td>"); sb.Append("<td>PF Account Number</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["PFNo"].ToString() + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>Designation</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["Designation"].ToString() + "</td>"); sb.Append("<td>ESI Number</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["ESINo"].ToString() + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>Loation</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["ParamAddress"].ToString() + "</td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>Bank Details</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["BankDetail"].ToString() + "</td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>Date of Joining</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + _dt.Rows[0]["JoiningDate"].ToString() + "</td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td>Working Salary</td>"); sb.Append("<td>:</td>"); sb.Append("<td>" + PaidSalary + "</td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("<td></td>"); sb.Append("</tr>"); sb.Append("<tr><td colspan='6'><table width='100%'>"); sb.Append("<hr>"); sb.Append("<tr>"); sb.Append("<th>Earning</th>"); sb.Append("<th>Amount</th>"); sb.Append("<th>Deduction</th>"); sb.Append("<th>Amount</th>"); sb.Append("</tr>"); decimal TotalEarning = 0; decimal TotalDesuction = 0; decimal NetAmount; string AmountinWord; decimal Employee_EPFAmount = 0; for (int i = 0; i < _dt1.Rows.Count; i++) { TotalEarning = TotalEarning + Convert.ToDecimal(_dt1.Rows[i]["AllowancecesAmt"].ToString()); sb.Append("<tr>"); sb.Append("<td align='center'>" + _dt1.Rows[i]["Allowanceces"].ToString() + "</td>"); sb.Append("<td align='center'>" + _dt1.Rows[i]["AllowancecesAmt"].ToString() + "</td>"); sb.Append("<td align='center'>" + _dt1.Rows[i]["Deductions"].ToString() + "</td>"); if (_dt1.Rows[i]["Deductions"].ToString() == "EPF") { Employee_EPFAmount = PaidSalary * Convert.ToDecimal(12.50) / 100; sb.Append("<td align='center'>" + Employee_EPFAmount.ToString("F") + "</td>"); TotalDesuction = TotalDesuction + Employee_EPFAmount; } else if (_dt1.Rows[i]["Deductions"].ToString() == "VPF") { Employee_EPFAmount = PaidSalary * Convert.ToDecimal(12) / 100; sb.Append("<td align='center'>" + Employee_EPFAmount.ToString("F") + "</td>"); TotalDesuction = TotalDesuction + Employee_EPFAmount; } else if (_dt1.Rows[i]["Deductions"].ToString() == "ESI") { Employee_EPFAmount = PaidSalary * Convert.ToDecimal(1.75) / 100; sb.Append("<td align='center'>" + Employee_EPFAmount.ToString("F") + "</td>"); TotalDesuction = TotalDesuction + Employee_EPFAmount; } else if (_dt1.Rows[i]["Deductions"].ToString() == "LWF") { Employee_EPFAmount = PaidSalary * Convert.ToDecimal(12) / 100; sb.Append("<td align='center'>" + Employee_EPFAmount.ToString("F") + "</td>"); TotalDesuction = TotalDesuction + Employee_EPFAmount; } else { sb.Append("<td align='center'>" + 0 + "</td>"); TotalDesuction = TotalDesuction + 0; } sb.Append("</tr>"); } NetAmount = TotalEarning - TotalDesuction; sb.Append("<tr>"); sb.Append("<td align='center'><b>Total Earning</td>"); sb.Append("<td align='center'><b>" + TotalEarning + "<b></td>"); sb.Append("<td align='center'>Total Deduction</td>"); sb.Append("<td align='center'><b>" + TotalDesuction.ToString("F") + "</b></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='center'></td>"); sb.Append("<td align='center'></td>"); sb.Append("<td align='center'>Net Amount</td>"); sb.Append("<td align='center'><b>" + NetAmount.ToString("F") + "</b></td>"); sb.Append("</tr>"); sb.Append("</table></td></tr>"); sb.Append("</table></td></tr>"); AmountinWord = _objConvertMasterManager.changeNumericToWords(Convert.ToDouble(NetAmount.ToString("F"))); sb.Append("<tr>"); sb.Append("<td>Amount(in words)</td>"); sb.Append("<td colspan='2' align='right'><font size='2'>for BROADCAST ENGINEERING CONSULTANTS INDIA LTD.<font></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td colspan='3'><font size='2'>" + AmountinWord + "<font></td>"); sb.Append("<tr><td colspan='3'><br></td></tr>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td colspan='3' align='right'><font size='2'>Authorised Signatory<font></td>"); sb.Append("</tr>"); sb.Append("</table>"); return(sb.ToString()); }
private string Challan(DataSet ds, string BankName, string Date, string ChequeNo) { StringBuilder sb = new StringBuilder(); try { DataTable _dt = ds.Tables[0]; DataTable _dt1 = ds.Tables[1]; sb.Append("<table width='100%' align='center' cellpadding='0' cellspacing='0' style='border:1px solid #000000;font-size:14px; padding-left:10px; padding-right:10px; padding-bottom:10px;'>"); if (_dt.Rows[0][0].ToString() != "0") { #region Calcaultaion double TotalAmt = 0; //double TotalAmt = 0; for (int q = 0; q < _dt1.Rows.Count; q++) { if (Convert.ToString(_dt1.Rows[q]["AllwancesName"].ToString()) != "") { if (Convert.ToDouble(_dt1.Rows[q]["AllwancesAmt"].ToString()) > 0) { TotalAmt = TotalAmt + Convert.ToDouble(_dt1.Rows[q]["AllwancesAmt"].ToString()); } } } double TotalEmpShareAmt = 0; TotalEmpShareAmt = Math.Round(Convert.ToDouble(TotalAmt) * Convert.ToDouble(1.75) / 100); double TotalEmplrShareAmt = 0; TotalEmplrShareAmt = Math.Round(Convert.ToDouble(TotalAmt) * Convert.ToDouble(4.75) / 100); double TotalEsiAmt = 0; TotalEsiAmt = TotalEmpShareAmt + TotalEmplrShareAmt; ConvertMasterManager objConvertMasterManager = new ConvertMasterManager(); string InWordToEsi = objConvertMasterManager.changeNumericToWords(Convert.ToDouble(TotalEsiAmt)); #endregion Calcaultaion // sb.Append("<table width='100%' border='0' cellpadding='0' cellspacing='0' style='border:1px solid #000; padding-left:10px; padding-right:10px;'>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top'>"); sb.Append("<table>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top' style='font-size:13px;'>ORIGINAL<br />DUPLICATE<br />TRIPPLICATE<br />QUARDUPLICATE"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("<td align='left' valign='top'>"); sb.Append("<table>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top' style='font-size:24px; font-weight:bold; padding-left:85px;'>E.S.I.C"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top' style='font-size:16px; font-weight:bold;'>"); sb.Append("<table>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top'>"); sb.Append("<div>Challan No.</div>"); sb.Append("</td>"); sb.Append("<td align='left' valign='top'><div style='border:1px solid #000; width:150px; height:20px;'></div>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='center' valign='top' colspan='2' style=' font-size:14px;'><b>EMPLOYEE'S STATE INSURANCE FUND ACCOUNT NO. -1)<br />PAY-IN SLIP FOR CONTRIBUTIONN<br />STATE OF BANK OF INDIA</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top'>Station ........................................</td>"); sb.Append("<td align='right' valign='top'>Dated " + txtDate.Text + "</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top' height='10'></td>"); sb.Append("<td align='right' valign='top' height='10'></td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top'>"); sb.Append("<table style=' background-color:black;' cellpadding='1' cellspacing='1' height='100'>"); sb.Append("<tr>"); sb.Append("<td align='center' style=' background-color:#ffffff;' valign='top'>Particulars of cash/cheque No."); sb.Append("</td>"); sb.Append("<td align='center' valign='top' style=' background-color:#ffffff;'>Amount Rs.P."); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='center' valign='middel' style=' background-color:#ffffff;'>Total"); sb.Append("</td>"); sb.Append("<td align='center' valign='middle' style=' background-color:#ffffff;'><b> " + TotalEsiAmt.ToString("F") + "</b><div style='border-top:1px solid #000;'><b>" + TotalEsiAmt.ToString("F") + "</b></div>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("<td align='left' valign='top'>"); sb.Append("<table>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top'>Paid into credit of the Employee's State insurance Fund Account No. 1<br /><b style='border-bottom:1px dotted #000;'>Rs. " + TotalEsiAmt.ToString("F") + "</b> (in figures)<br /><div style='border-bottom:1px dotted #000;'><i>" + InWordToEsi + "</i> (in words)</div>in cash/by Cheque (on realistion) of contribution as per details given below under the"); sb.Append("</td>"); sb.Append("<td align='left' valign='top'></td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>E.S.I Act, 1948 for the month of"); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'><b>" + ddlMonth.SelectedItem.Text + "," + ddlFinYear.SelectedItem.Text + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>Employer's Code No."); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;' >"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top'>Deposited By"); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>Name and Address of Factory/ Establishment"); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'><b>" + txtOrgName.Text + "<br>" + txtAddress.Text + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>No of Employees"); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'><b>" + Convert.ToString(_dt.Rows[0]["CntEmployee"].ToString()) + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>Total Wages"); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;' ><b>" + TotalAmt.ToString("F") + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>Employee's Contribution Rs."); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'><b>" + TotalEmpShareAmt.ToString("F") + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>Employer's Contribution Rs."); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'><b>" + TotalEmplrShareAmt.ToString("F") + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>Total Rs."); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'><b>" + TotalEsiAmt.ToString("F") + "</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top' colspan='2' style='border-bottom:1px solid #000; padding-bottom:20px;'>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>(For use in Bank)"); sb.Append("</td>"); sb.Append("<td align='left' valign='top'><b> ( ACKNOWLEDGEMENT )</b>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top' height='10'></td>"); sb.Append("<td align='right' valign='top' height='10'></td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>Recieved payment with Cash/ Cheque / Draf No."); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'><b> " + txtChequeNo.Text + "</b></td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>"); sb.Append("<table>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='bottom'>Dated</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000; margin-left:50px;'>" + txtDate.Text + ""); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("<td align='left' valign='top' >"); sb.Append("<table>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='bottom'>for Rs.</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000; margin-left:50px;'>" + TotalEsiAmt.ToString("F") + ""); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' colspan='2' valign='top' style='border-bottom:1px dotted #000;' ><i>" + InWordToEsi + "</i>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top' colspan='2' ><table width='100%'>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top' width='80%' >"); sb.Append("<table>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='bottom'>Draw on </td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000; margin-left:50px;'>" + txtBankName.Text + ""); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("<td align='right' valign='middle' width='20%'>(Bank in favour of)"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("</table>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>Employee's State Insurance Fund Account No.1"); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'>SL. No in Bank's Scroll"); sb.Append("</td>"); sb.Append("<td align='left' valign='top' style='border-bottom:1px dotted #000;'>"); sb.Append("</td>"); sb.Append("</tr>"); sb.Append("<tr>"); sb.Append("<td align='left' valign='top' height='20'></td>"); sb.Append("<td align='right' valign='top' height='20'></td>"); sb.Append("</tr>"); sb.Append("<tr >"); sb.Append("<td align='left' valign='top'><b> Dated :</b>" + txtDate.Text + ""); sb.Append("</td>"); sb.Append("<td align='right' valign='top'>Aouthorised Signatory of the receiving Bank"); sb.Append("</td>"); sb.Append("</tr>"); //sb.Append("</table>"); } else { sb.Append("<tr><td colspan='3'><b>There is no record....</b></td></tr>"); } sb.Append("</table>"); } catch (Exception ex) { lblMsg.Text = "" + ex.Message.ToString(); } return(sb.ToString()); }