private void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string strTranType = ""; if (hfIsUpdate.Value == "Y") { hfId.Value = hfId.Value; } else { hfId.Value = Common.getMaxId("EmpTransitionLog", "TransId"); } string strEntryDate = ""; string strEffDate = ""; string strNextIncDate = ""; string strGradeChDate = ""; string strRetirementDate = ""; if (string.IsNullOrEmpty(txtEntryDate.Text.Trim()) == false) { strEntryDate = Common.ReturnDate(txtEntryDate.Text.Trim()); } if (string.IsNullOrEmpty(txtEffDate.Text.Trim()) == false) { strEffDate = Common.ReturnDate(txtEffDate.Text.Trim()); } if (string.IsNullOrEmpty(txtNextIncDate.Text.Trim()) == false) { strNextIncDate = Common.ReturnDate(txtNextIncDate.Text.Trim()); } if (string.IsNullOrEmpty(txtGradeChangeDate.Text.Trim()) == false) { strGradeChDate = Common.ReturnDate(txtGradeChangeDate.Text.Trim()); } char[] splitter = { '/' }; string[] arinfo = Common.str_split(lblName.ToolTip.ToString(), splitter); int iBirthYear = 0; if (arinfo.Length == 3) { iBirthYear = Convert.ToInt16(arinfo[2]); iBirthYear = iBirthYear + 60; strRetirementDate = iBirthYear + "/" + arinfo[1] + "/" + arinfo[0]; arinfo = null; } if (radPromotion.Checked == true) { strTranType = "P"; } else if (radTrans.Checked == true) { strTranType = "T"; } else if (radStatus.Checked == true) { strTranType = "C"; } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0", ddlEmpType.SelectedValue.ToString()); DataRow[] foundPlcRow; foundPlcRow = null; decimal dclNewBasicSal = 0; //Basic foundPlcRow = dtBfPlc.Select("SHEADID=1"); if (foundPlcRow.Length > 0) { DataRow nRow1 = objDs.dtSalPackUpdate.NewRow(); nRow1["SHEADID"] = 1; nRow1["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); dclNewBasicSal = Convert.ToDecimal(nRow1["PAYAMT"].ToString()); objDs.dtSalPackUpdate.Rows.Add(nRow1); } //House Rent foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 2; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } //Medical foundPlcRow = dtBfPlc.Select("SHEADID=3"); if (foundPlcRow.Length > 0) { DataRow nRow3 = objDs.dtSalPackUpdate.NewRow(); nRow3["SHEADID"] = 3; nRow3["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtNewGrossSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow3); } if (ddlEmpType.SelectedValue.ToString() == "1") { //PF Allowance foundPlcRow = dtBfPlc.Select("SHEADID=8"); if (dtBfPlc.Rows.Count > 0) { DataRow nRow4 = objDs.dtSalPackUpdate.NewRow(); nRow4["SHEADID"] = 8; nRow4["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(dclNewBasicSal.ToString(), 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); objDs.dtSalPackUpdate.Rows.Add(nRow4); } objDs.dtSalPackUpdate.AcceptChanges(); } clsEmpTransition objEmpTrans = new clsEmpTransition(hfId.Value.ToString(), txtEmpID.Text.Trim(), strEntryDate, strTranType, ddlAction.SelectedValue.ToString(), ddlCompany.SelectedValue.ToString(), ddlClinic.SelectedValue.ToString(), ddlProject.SelectedValue.ToString(), ddlDepartment.SelectedValue.ToString(), ddlSubDept.SelectedValue.ToString(), ddlDesignation.SelectedValue.ToString(), ddlGrade.SelectedValue.ToString(), ddlSalaryLoc.SelectedValue.ToString(), ddlEmpType.SelectedValue.ToString(), txtNewGrossSalary.Text.Trim(), strEffDate, strNextIncDate, strGradeChDate, txtRemarks.Text.Trim(), (chkIsTAApplicable.Checked == true ? "Y" : "N"), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString())); objEmpInfoMgr.InsertEmpTransitionLog(objEmpTrans, hfDivision.Value.ToString(), hfClinic.Value.ToString(), hfProject.Value.ToString(), hfDept.Value.ToString(), hfSubDept.Value.ToString(), hfDesig.Value.ToString(), hfGrade.Value.ToString(), hfSalLoc.Value.ToString(), hfEmpType.Value.ToString(), txtNewGrossSalary.Text.Trim(), strEffDate, strNextIncDate, strGradeChDate, strRetirementDate, txtRemarks.Text.Trim(), hfIsUpdate.Value, txtNewGrossSalary.ToolTip.ToString(), hfGrossSalary.Value.ToString(), objDs.dtSalPackUpdate); lblMsg.Text = "Record Saved Successfully"; this.EntryText(); this.EntryMode(false); this.ClearControls(); }
private void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); //string strSalPackId; string strTranType = ""; if (hfIsUpdate.Value == "Y") { hfId.Value = hfId.Value; } else { hfId.Value = Common.getMaxId("EmpTransitionLog", "TransId"); } string strEntryDate = ""; string strEffDate = ""; string strNextIncDate = ""; string strGradeChDate = ""; string strRetirementDate = ""; if (string.IsNullOrEmpty(txtEntryDate.Text.Trim()) == false) { strEntryDate = Common.ReturnDate(txtEntryDate.Text.Trim()); } if (string.IsNullOrEmpty(txtEffDate.Text.Trim()) == false) { strEffDate = Common.ReturnDate(txtEffDate.Text.Trim()); } if (string.IsNullOrEmpty(txtNextIncDate.Text.Trim()) == false) { strNextIncDate = Common.ReturnDate(txtNextIncDate.Text.Trim()); } if (string.IsNullOrEmpty(txtGradeChangeDate.Text.Trim()) == false) { strGradeChDate = Common.ReturnDate(txtGradeChangeDate.Text.Trim()); } if (radPromotion.Checked == true) { strTranType = "P"; } else if (radTrans.Checked == true) { strTranType = "T"; } else if (radStatus.Checked == true) { strTranType = "C"; } else if (radEquity.Checked == true) { strTranType = "E"; } else if (radReDesig.Checked == true) { strTranType = "R"; } else if (radDeputation.Checked == true) { strTranType = "D"; } else if (radIncrement.Checked == true) { strTranType = "I"; } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0"); DataRow[] foundPlcRow; foundPlcRow = null; //Basic DataRow nRow1 = objDs.dtSalPackUpdate.NewRow(); nRow1["SHEADID"] = 1; nRow1["PAYAMT"] = Common.RoundDecimal(txtBasicSal.Text, 0); objDs.dtSalPackUpdate.Rows.Add(nRow1); //House Rent foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 2; nRow2["PAYAMT"] = Common.RoundDecimal(hfHousing.Value, 0); objDs.dtSalPackUpdate.Rows.Add(nRow2); } //PF Allowance //dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("13"); foundPlcRow = null; foundPlcRow = dtBfPlc.Select("SHEADID=8"); if (foundPlcRow.Length > 0) { DataRow nRow3 = objDs.dtSalPackUpdate.NewRow(); nRow3["SHEADID"] = 8; nRow3["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtBasicSal.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow3); } objDs.dtSalPackUpdate.AcceptChanges(); clsEmpTransition objEmpTrans = new clsEmpTransition(hfId.Value.ToString(), txtEmpID.Text.Trim(), strEntryDate, strTranType, ddlAction.SelectedValue.ToString(), ddlDivision.SelectedValue.ToString(), ddlOffice.SelectedValue.ToString(), ddlDesignation.SelectedValue.ToString(), ddlJobTitle.SelectedValue.ToString(), ddlSector.SelectedValue.ToString(), ddlDepartment.SelectedValue.ToString(), ddlUnit.SelectedValue.ToString(), ddlGrade.SelectedValue.ToString(), ddlGradeLevel.SelectedValue.ToString(), ddlDivision.SelectedValue.ToString(), ddlDistrict.SelectedValue.ToString(), ddlSalaryLoc.SelectedValue.ToString(), "", ddlPostingPlace.SelectedValue.ToString(), txtBasicSal.Text.Trim(), txtGrossSalary.Text.Trim(), strEffDate, strNextIncDate, (chkIsNew.Checked == true ? "Y" : "N"), txtRemarks.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), ddlPosByFunction.SelectedValue.ToString(), strGradeChDate, ddlProject.SelectedValue.ToString(), ddlSupervisor.SelectedValue.ToString(), txtBankAccNo.Text.Trim()); // lblJoinDate.ToolTip contains salpakid objEmpInfoMgr.InsertEmpTransitionLog(objEmpTrans, "", hfDiv.Value.ToString(), hfOffice.Value.ToString(), hfDesig.Value.ToString(), hfJobTitle.Value.ToString(), hfSector.Value.ToString(), hfDept.Value.ToString(), hfUnit.Value.ToString(), hfGrade.Value.ToString(), hfGradeLevel.Value.ToString(), hfPostingDiv.Value.ToString(), hfPostingDist.Value.ToString(), hfSalLoc.Value.ToString(), "", hfPostingPlace.Value.ToString(), hfPosByFunction.Value.ToString(), txtBasicSal.ToolTip, txtGrossSalary.ToolTip, strEffDate, strNextIncDate, strGradeChDate, strRetirementDate, txtRemarks.Text.Trim(), hfIsUpdate.Value, lblJoinDate.ToolTip.ToString(), objDs.dtSalPackUpdate, hfProject.Value.ToString(), hfSuperId.Value.ToString(), hfBankAccNo.Value.ToString()); lblMsg.Text = "Record Saved Successfully"; this.EntryText(); this.EntryMode(false); this.ClearControls(); }