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