protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string strParams = Request.QueryString["params"];
string[] strVal = strParams.Split(',');
if (strVal[4].Trim() == "S")
{
lblMonth.Text = "Payslip for the Month of " + strVal[1] + ", " + strVal[2];
}
else
{
lblMonth.Text = "Festival Allowance - " + strVal[1] + " " + strVal[2];
}
// Get Employee Personal data
DataTable dtPersonal = objEmp.SelectEmpPayslipPersonalInfo(strVal[3].Trim());
if (dtPersonal.Rows.Count > 0)
{
lblID.Text = dtPersonal.Rows[0]["EmpId"].ToString().Trim();
lblName.Text = dtPersonal.Rows[0]["FULLNAME"].ToString().Trim();
lblGrade.Text = dtPersonal.Rows[0]["GradeName"].ToString().Trim();
lblJobTitle.Text = dtPersonal.Rows[0]["JobTitleName"].ToString().Trim();
lblBankAc.Text = dtPersonal.Rows[0]["BankAccNo"].ToString().Trim();
lblDesig.Text = dtPersonal.Rows[0]["DesigName"].ToString().Trim();
lblPostDiv.Text = dtPersonal.Rows[0]["PostingDivName"].ToString().Trim();
lblDept.Text = dtPersonal.Rows[0]["DeptName"].ToString().Trim();
lblPostDist.Text = dtPersonal.Rows[0]["PostingDistName"].ToString().Trim();
lblSalLoc.Text = dtPersonal.Rows[0]["SalLocName"].ToString().Trim();
lblPostPla.Text = dtPersonal.Rows[0]["PostingPlaceName"].ToString().Trim();
lblSalDiv.Text = dtPersonal.Rows[0]["SalSubLocName"].ToString().Trim();
}
DataTable dt = new DataTable();
dt = (DataTable)objPayRptMgr.GetPayslipMonthlyGrossAndBenefits(strVal[3].Trim(), strVal[0].Trim(), strVal[2].Trim(), strVal[4].Trim());
grGrossandBenefits.DataSource = dt;
grGrossandBenefits.DataBind();
clscashword cal = new clscashword();
int nouOfRow = dt.Rows.Count;
if (string.IsNullOrEmpty(dt.Rows[nouOfRow - 1]["PAYAMT"].ToString().Trim()) == false)
{
lblTakaInWord.Text = "<b>In Words : </b>" + cal.getCashWord(Common.ReturnZeroForNull(dt.Rows[nouOfRow - 1]["PAYAMT"].ToString().Trim())); //nouOfRow.ToString();
}
dt.Rows.Clear();
lblRemarks.Text = objPayRptMgr.GetPayrollRemarksForPayslip(strVal[3].Trim(), strVal[0].Trim(), strVal[2].Trim(), strVal[4].Trim());
if (string.IsNullOrEmpty(lblRemarks.Text) == false)
{
lblRemarks.Text = "* " + lblRemarks.Text;
}
this.FormatGrossAndBenefitsGrid();
this.FormatDeductionGrid();
}
}
protected void GenerateReport(string strMonth, string strYear, string strEmpID, string IsFromPayroll)
{
dsFinalPayment objFinalPay = new dsFinalPayment();
ReportDoc = new ReportDocument();
ReportPath = Server.MapPath("~/CrystalReports/Payroll/rptFinalPayment.rpt");
DataTable dtTmp = objGrMgr.GetFinalPaymentData(strMonth, strYear, strEmpID, IsFromPayroll);
foreach (DataRow dRow in dtTmp.Rows)
{
clscashword objWord = new clscashword();
DataRow nRow = objFinalPay.dtFinalPayment.NewRow();
nRow["EmpId"] = dRow["EmpId"];
nRow["FullName"] = dRow["FullName"];
nRow["JobTitle"] = dRow["JobTitleName"];
nRow["JoiningDate"] = dRow["JoiningDate"];
nRow["SEPERATEDATE"] = dRow["SeparateDate"];
nRow["SeparationType"] = dRow["SeparateTypeId"];
nRow["Salary"] = dRow["Salary"];
nRow["SalayUpto"] = dRow["SalayUpto"];
nRow["Bonus"] = dRow["Bonus"];
nRow["SalaryMinBonus"] = dRow["SalaryMinBonus"];
nRow["BonusDays"] = dRow["BonusDays"];
nRow["Gratuity"] = dRow["Gratuity"];
nRow["GrPayDate"] = dRow["GrPayDate"];
nRow["LeaveEncash"] = dRow["LeaveEncash"];
nRow["AnnualLeave"] = dRow["AnnualLeave"];
nRow["PFAmount"] = dRow["PFAmount"];
nRow["TotalAmt"] = dRow["TotalAmt"];
nRow["InWord"] = objWord.getCashWord(dRow["TotalAmt"].ToString());
nRow["BasicSalary"] = dRow["BasicSalary"];
nRow["BONUSALLOW"] = dRow["BONUSALLOW"];
objFinalPay.dtFinalPayment.Rows.Add(nRow);
}
objFinalPay.dtFinalPayment.AcceptChanges();
ReportDoc.Load(ReportPath);
ReportDoc.SetDataSource(objFinalPay.Tables["dtFinalPayment"]);
CRV.ReportSource = ReportDoc;
}