protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strParams = Request.QueryString["params"]; string[] strVal = strParams.Split(','); dtEmployee = objPayRptMgr.GetEmployeeDataForITStatement(strVal[0], strVal[2], strVal[1]); dtFestival = objPayRptMgr.GetBonusAllowanceYearlyEmpWise(strVal[1], strVal[0]); if (dtEmployee.Rows.Count > 0) { lblEmp.Text = dtEmployee.Rows[0]["FULLNAME"].ToString().Trim() + ", ID - " + dtEmployee.Rows[0]["EMPID"].ToString().Trim(); //lblJoin.Text = string.IsNullOrEmpty(dtEmployee.Rows[0]["JOININGDATE"].ToString().Trim()) == false ? Common.DisplayDate(dtEmployee.Rows[0]["JOININGDATE"].ToString().Trim()) : "N/A"; lblFisYear.Text = strVal[3]; lblFisYear1.Text = strVal[3]; lblFisYear2.Text = strVal[4]; //lblYear.Text = "30-06-" + strVal[4]; //lblTIN.Text = dtEmployee.Rows[0]["TINNO"].ToString().Trim(); lblDate.Text = Common.DisplayDate(DateTime.Today.ToShortDateString()); //if (string.IsNullOrEmpty(dtEmployee.Rows[0]["Gender"].ToString().Trim()) == false) //{ // lblGender.Text = dtEmployee.Rows[0]["Gender"].ToString().Trim() == "M" ? "his" : "her"; //} //else //{ // lblGender.Text = "his/her"; //} // Payroll data dtPayrollDet = objPayRptMgr.GetPayrollDataForITStatement(strVal[0], strVal[1]); DataTable dtPayrollSum = dtPayrollDet.Clone(); decimal dclPayAmt = 0; decimal pfBothAmt = 0; decimal tamt = 0; foreach (DataRow dRow in dtPayrollDet.Rows) { dclPayAmt = 0; //if (Convert.ToInt32(dRow["SHEADID"].ToString().Trim()) <= 9) //{ switch (dRow["SHEADID"].ToString().Trim()) { case "1": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "1"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Basic Salary"); break; case "2": //case "20": dclPayAmt = (this.GetSalHeadAmt(dtPayrollDet, strVal[0], "2")) * 50 / 100; //dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "20"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Housing Allowance"); dclPayAmt = (this.GetSalHeadAmt(dtPayrollDet, strVal[0], "2")) * 10 / 100; //dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "20"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Medical Allowance"); dclPayAmt = (this.GetSalHeadAmt(dtPayrollDet, strVal[0], "2")) * 5 / 100; //dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "20"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Conveyance"); break; case "19": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "19"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Festival Bonus"); break; //case "3": ////case "21": // dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "3"); // // dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "21"); // this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Basic Salary"); // break; //case "4": ////case "22": // dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "4"); // //dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "22"); // this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Basic Salary"); // break; case "13": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "13"); lblPFBoth.Text = (Math.Abs(dclPayAmt) * 2).ToString(); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Provident Fund(Employee Contribution)"); break; //case "6": // //dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "6"); // if (dtFestival.Rows.Count > 0) // { // dclPayAmt = Common.RoundDecimal(dtFestival.Rows[0]["PAYAMT"].ToString(), 0); // } // else // dclPayAmt = 0; // this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Basic Salary"); // break; //case "7": //case "23": // dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "7"); // dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "23"); // this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Basic Salary"); // break; case "8": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "8"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Overtime"); break; //case "9": //case "24": // dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "9"); // dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "24"); // this.AddNewRow(dtPayrollSum, dclPayAmt, dRow, "Basic Salary"); // break; } tamt = Math.Round(tamt + dclPayAmt); //} } //TotalAmt.Text = tamt.ToString(); dtPayrollSum.AcceptChanges(); grPayroll.DataSource = dtPayrollSum; grPayroll.DataBind(); foreach (GridViewRow gRow in grPayroll.Rows) { // gRow.Cells[1].Text = "Tk."; } if (grPayroll.Rows.Count > 0) { //lblPayrollInWord.Text =objCashWord.getCashWord(this.GetSummaryTotal(grPayroll, 1,0,"Total Amount",0)); this.GetSummaryTotal(grPayroll, 2, 0, "Gross Total", 0); } //grPayroll.FooterRow.Cells[2].Text = pfBothAmt.ToString(); //grPayroll.FooterRow.Cells[2].HorizontalAlign = HorizontalAlign.Right; //grPayroll.FooterRow.Cells[1].Text = "Tk."; //grPayroll.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Right; //grPayroll.FooterRow.Cells[0].Text = "Both Employer and Employee Contribution"; //grPayroll.FooterRow.Cells[0].HorizontalAlign = HorizontalAlign.Left; // this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); // pfBothAmt // Challan Data dtChallan = objPayRptMgr.GetChallanDataForITStatement(strVal[0], strVal[1]); grChallan.DataSource = dtChallan; grChallan.DataBind(); foreach (GridViewRow gRow in grChallan.Rows) { if (Common.CheckNullString(gRow.Cells[4].Text.Trim()) != "") { gRow.Cells[4].Text = Convert.ToString(Math.Round(Convert.ToDecimal(gRow.Cells[4].Text.Trim()), 0)); } gRow.Cells[3].Text = "Tk."; } if (grChallan.Rows.Count > 0) { this.GetSummaryTotal(grChallan, 4, 1, "Total Tax paid ", 2); // this.GetSummaryTotal(grChallan, 4, 1, "Total Tax deposited from July-" + Convert.ToString(Convert.ToInt32(strVal[4]) - 1) + " thru " + "Jun-" + strVal[4], 2); grChallan.FooterRow.Cells.RemoveAt(1); grChallan.FooterRow.Cells[0].ColumnSpan = 2; //lblTotalChallanAmt.Text = this.GetSummaryTotal(grChallan, 2,1); //lblChallanInWord.Text = objCashWord.getCashWord(lblTotalChallanAmt.Text.Trim()); //lblChallanBankName.Text = dtChallan.Rows[0]["BANKNAME"].ToString().Trim(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string strParams = Request.QueryString["params"]; string[] strVal = strParams.Split(','); dtEmployee = objPayRptMgr.GetEmployeeDataForITStatement(strVal[0], strVal[2], strVal[1]); dtFestival = objPayRptMgr.GetBonusAllowanceYearlyEmpWise(strVal[1], strVal[0]); if (dtEmployee.Rows.Count > 0) { lblEmp.Text = dtEmployee.Rows[0]["FULLNAME"].ToString().Trim() + " # " + dtEmployee.Rows[0]["EMPID"].ToString().Trim(); //lblJoin.Text = string.IsNullOrEmpty(dtEmployee.Rows[0]["JOININGDATE"].ToString().Trim()) == false ? Common.DisplayDate(dtEmployee.Rows[0]["JOININGDATE"].ToString().Trim()) : "N/A"; //lblFiscalYear.Text = strVal[3]; lblYear.Text = "30-06-" + strVal[4]; lblTIN.Text = dtEmployee.Rows[0]["TINNO"].ToString().Trim(); lblDate.Text = Common.DisplayDate(DateTime.Today.ToShortDateString()); if (string.IsNullOrEmpty(dtEmployee.Rows[0]["SEX"].ToString().Trim()) == false) { lblGender.Text = dtEmployee.Rows[0]["SEX"].ToString().Trim() == "M" ? "his" : "her"; } else { lblGender.Text = "his/her"; } // Payroll data dtPayrollDet = objPayRptMgr.GetPayrollDataForITStatement(strVal[0], strVal[1]); DataTable dtPayrollSum = dtPayrollDet.Clone(); decimal dclPayAmt = 0; foreach (DataRow dRow in dtPayrollDet.Rows) { dclPayAmt = 0; if (Convert.ToInt32(dRow["SHEADID"].ToString().Trim()) <= 9) { switch (dRow["SHEADID"].ToString().Trim()) { case "1": case "19": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "1"); dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "19"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); break; case "2": case "20": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "2"); dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "20"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); break; case "3": case "21": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "3"); dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "21"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); break; case "4": case "22": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "4"); dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "22"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); break; case "6": //dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "6"); if (dtFestival.Rows.Count > 0) { dclPayAmt = Common.RoundDecimal(dtFestival.Rows[0]["PAYAMT"].ToString(), 0); } else { dclPayAmt = 0; } this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); break; case "7": case "23": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "7"); dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "23"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); break; case "8": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "8"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); break; case "9": case "24": dclPayAmt = this.GetSalHeadAmt(dtPayrollDet, strVal[0], "9"); dclPayAmt = dclPayAmt + this.GetSalHeadAmt(dtPayrollDet, strVal[0], "24"); this.AddNewRow(dtPayrollSum, dclPayAmt, dRow); break; } } } dtPayrollSum.AcceptChanges(); grPayroll.DataSource = dtPayrollSum; grPayroll.DataBind(); foreach (GridViewRow gRow in grPayroll.Rows) { gRow.Cells[1].Text = "Tk."; } if (grPayroll.Rows.Count > 0) { //lblPayrollInWord.Text =objCashWord.getCashWord(this.GetSummaryTotal(grPayroll, 1,0,"Total Amount",0)); this.GetSummaryTotal(grPayroll, 2, 0, "Total Amount", 0); } // Challan Data dtChallan = objPayRptMgr.GetChallanDataForITStatement(strVal[0], strVal[1]); grChallan.DataSource = dtChallan; grChallan.DataBind(); foreach (GridViewRow gRow in grChallan.Rows) { if (Common.CheckNullString(gRow.Cells[4].Text.Trim()) != "") { gRow.Cells[4].Text = Convert.ToString(Math.Round(Convert.ToDecimal(gRow.Cells[4].Text.Trim()), 0)); } gRow.Cells[3].Text = "Tk."; } if (grChallan.Rows.Count > 0) { this.GetSummaryTotal(grChallan, 4, 1, "Total Tax deposited from July-" + Convert.ToString(Convert.ToInt32(strVal[4]) - 1) + " thru " + "Jun-" + strVal[4], 2); grChallan.FooterRow.Cells.RemoveAt(1); grChallan.FooterRow.Cells[0].ColumnSpan = 2; //lblTotalChallanAmt.Text = this.GetSummaryTotal(grChallan, 2,1); //lblChallanInWord.Text = objCashWord.getCashWord(lblTotalChallanAmt.Text.Trim()); // lblChallanBankName.Text = dtChallan.Rows[0]["BANKNAME"].ToString().Trim(); } } } }
protected void OpenRecord() { string strGenFor = ""; if (ddlGroup.SelectedValue.Trim() == "A") { if (ddlLocation.SelectedValue.Trim() != "-1") { strGenFor = "O"; } else { //lblMsg.Text = "No value is selected. Please select either DOS or Office to generate the report."; //return; strGenFor = "A"; } } else { strGenFor = "D"; } DataTable dtEmp = new DataTable(); DataTable dtDate = new DataTable(); DataTable dtRecords = new DataTable(); if (strGenFor != "A") { dtEmp = objITMgr.GetDistinctEmpoyeeData("-1", ddlLocation.SelectedValue.Trim(), ddlFinYear.SelectedValue.Trim(), strGenFor); dtDate = objITMgr.GetDistinctDate("-1", ddlLocation.SelectedValue.Trim(), ddlFinYear.SelectedValue.Trim(), strGenFor); dtRecords = objITMgr.GetDetailsData("-1", ddlLocation.SelectedValue.Trim(), ddlFinYear.SelectedValue.Trim(), strGenFor); } else { dtEmp = objITMgr.GetDistinctEmpoyeeDataAll(ddlFinYear.SelectedValue.Trim()); dtDate = objITMgr.GetDistinctDateAll(ddlFinYear.SelectedValue.Trim()); dtRecords = objITMgr.GetDetailsDataAll(ddlFinYear.SelectedValue.Trim()); } // Payroll data DataTable dtPayrollDet = objPayRptMgr.GetPayrollDataForITStatement(ddlFinYear.SelectedValue.Trim()); DataTable dtBenefitsHead = objPayrollMgr.GetSalaryBenefitsHead(); DataRow[] fPayrollDet; lblFiscalYear.Text = ddlFinYear.SelectedItem.Text.Trim(); // Data Filling for Report if (dtDate.Rows.Count == 0) { lblMsg.Text = "No deposited reocrds found. Please use IT deposit Records screen to input the data."; grEmployee.DataSource = null; grEmployee.DataBind(); return; } this.IniReportDataTable(dtDate.Rows.Count + 3 + dtBenefitsHead.Rows.Count + 3 + 4); int inSL = 1; int i = 2; decimal decTotal = 0; decimal decBfTotal = 0; foreach (DataRow dEmpRow in dtEmp.Rows) { DataRow nRow = dtReport.NewRow(); nRow[0] = inSL.ToString(); nRow[1] = dEmpRow["EMPID"].ToString().Trim(); nRow[2] = dEmpRow["FULLNAME"].ToString().Trim(); nRow[3] = dEmpRow["JobTitleName"].ToString().Trim(); nRow[4] = dEmpRow["PostingDivName"].ToString().Trim(); nRow[5] = Common.SetDate(dEmpRow["JOININGDATE"].ToString().Trim()); i = 6; decBfTotal = 0; foreach (DataRow dBfRows in dtBenefitsHead.Rows) { fPayrollDet = dtPayrollDet.Select("EMPID='" + dEmpRow["EMPID"].ToString().Trim() + "' AND SHEADID=" + dBfRows["SHEADID"].ToString().Trim()); if (fPayrollDet.Length > 0) { nRow[i] = Common.RoundDecimal(fPayrollDet[0]["PAYAMT"].ToString().Trim(), 0).ToString(); decBfTotal = decBfTotal + Common.RoundDecimal(fPayrollDet[0]["PAYAMT"].ToString().Trim(), 0); } else { nRow[i] = "0"; } i++; fPayrollDet = null; } nRow[i] = decBfTotal.ToString(); i++; nRow[i] = objCashWord.getCashWord(decBfTotal.ToString() + ".00"); i++; decTotal = 0; foreach (DataRow dDateRow in dtDate.Rows) { DataRow[] foundRows = dtRecords.Select("EMPID='" + dEmpRow["EMPID"].ToString().Trim() + "' AND CHALLANDATE='" + dDateRow["CHALLANDATE"].ToString().Trim() + "'"); if (foundRows.Length > 0) { nRow[i] = foundRows[0]["PAYAMT"].ToString().Trim(); decTotal = decTotal + Convert.ToDecimal(foundRows[0]["PAYAMT"].ToString().Trim()); } else { nRow[i] = "0"; } i++; } inSL++; nRow[i] = decTotal.ToString(); i++; nRow[i] = objCashWord.getCashWord(decTotal.ToString() + ".00"); dtReport.Rows.Add(nRow); dtReport.AcceptChanges(); } grEmployee.DataSource = dtReport; grEmployee.DataBind(); if (grEmployee.Rows.Count > 0) { grEmployee.HeaderRow.Cells[0].Text = "SL#"; grEmployee.HeaderRow.Cells[0].HorizontalAlign = HorizontalAlign.Left; grEmployee.HeaderRow.Cells[0].VerticalAlign = VerticalAlign.Top; grEmployee.HeaderRow.Cells[1].Text = "Employee ID"; grEmployee.HeaderRow.Cells[1].HorizontalAlign = HorizontalAlign.Left; grEmployee.HeaderRow.Cells[2].Text = "Employee Name"; grEmployee.HeaderRow.Cells[2].HorizontalAlign = HorizontalAlign.Left; grEmployee.HeaderRow.Cells[3].Text = "Designation"; grEmployee.HeaderRow.Cells[3].HorizontalAlign = HorizontalAlign.Left; grEmployee.HeaderRow.Cells[4].Text = "Office"; grEmployee.HeaderRow.Cells[4].HorizontalAlign = HorizontalAlign.Left; grEmployee.HeaderRow.Cells[5].Text = "Joining Date"; grEmployee.HeaderRow.Cells[5].HorizontalAlign = HorizontalAlign.Left; int j = 6; foreach (DataRow dBfRows in dtBenefitsHead.Rows) { grEmployee.HeaderRow.Cells[j].Text = dBfRows["HeadName"].ToString(); grEmployee.HeaderRow.Cells[j].HorizontalAlign = HorizontalAlign.Right; j++; } grEmployee.HeaderRow.Cells[j].Text = "Total Remuneration "; grEmployee.HeaderRow.Cells[j].HorizontalAlign = HorizontalAlign.Right; j++; grEmployee.HeaderRow.Cells[j].Text = "In Word"; grEmployee.HeaderRow.Cells[j].HorizontalAlign = HorizontalAlign.Left; j++; for (i = j; i < dtReport.Columns.Count - 2; i++) { grEmployee.HeaderRow.Cells[i].Text = Common.DisplayDate(dtDate.Rows[i - j]["CHALLANDATE"].ToString().Trim()) + "<br><br>" + dtDate.Rows[i - j]["CHALLANNO"].ToString().Trim(); grEmployee.HeaderRow.Cells[i].HorizontalAlign = HorizontalAlign.Right; } grEmployee.HeaderRow.Cells[dtReport.Columns.Count - 2].Text = "Total Tax"; grEmployee.HeaderRow.Cells[dtReport.Columns.Count - 2].HorizontalAlign = HorizontalAlign.Right; grEmployee.HeaderRow.Cells[dtReport.Columns.Count - 2].VerticalAlign = VerticalAlign.Top; grEmployee.HeaderRow.Cells[dtReport.Columns.Count - 1].Text = "In Word"; grEmployee.HeaderRow.Cells[dtReport.Columns.Count - 1].HorizontalAlign = HorizontalAlign.Left; grEmployee.HeaderRow.Cells[dtReport.Columns.Count - 1].VerticalAlign = VerticalAlign.Top; } //// Summary Total //decimal dclFooterTotal = 0; //int j = 0; //grEmployee.FooterRow.Cells[1].Text = "Total :"; //grEmployee.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Left; //for (i = 2; i < dtReport.Columns.Count; i++) //{ // dclFooterTotal = 0; // for (j = 0; j < grEmployee.Rows.Count;j++ ) // { // dclFooterTotal = dclFooterTotal + Convert.ToDecimal(grEmployee.Rows[j].Cells[i].Text.Trim()); // grEmployee.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Right; // if (Convert.ToDecimal(grEmployee.Rows[j].Cells[i].Text.Trim()) == 0) // grEmployee.Rows[j].Cells[i].Text = "-"; // } // grEmployee.FooterRow.Cells[i].Text = dclFooterTotal.ToString(); // grEmployee.FooterRow.Cells[i].HorizontalAlign = HorizontalAlign.Right; //} }