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;
//}
}