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()); }