protected void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string strEntryDate = ""; string strConfirmDueDate = ""; string strExtensionDate = ""; string strConfirmDate = ""; decimal dclNewBasicSal = 0; if (string.IsNullOrEmpty(txtEntryDate.Text.Trim()) == false) { strEntryDate = Common.ReturnDate(txtEntryDate.Text.Trim()); } if (string.IsNullOrEmpty(txtConfirmDueDate.Text.Trim()) == false) { strConfirmDueDate = Common.ReturnDate(txtConfirmDueDate.Text.Trim()); } if (string.IsNullOrEmpty(txtExtensionDate.Text.Trim()) == false) { strExtensionDate = Common.ReturnDate(txtExtensionDate.Text.Trim()); } if (string.IsNullOrEmpty(txtConfirmDate.Text.Trim()) == false) { strConfirmDate = Common.ReturnDate(txtConfirmDate.Text.Trim()); } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0", "1"); DataRow[] foundPlcRow; foundPlcRow = null; //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(); } if (hfIsUpdate.Value == "Y") { hfId.Value = hfId.Value; } else { hfId.Value = Common.getMaxId("EmpConfirmationLog", "ConfirmId"); } objEmpInfoMgr.InsertConfirmation(hfId.Value.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), strEntryDate, txtProbationPeriod.Text.Trim(), strConfirmDueDate, strExtensionDate, strConfirmDate, txtExtensionMonth.Text.Trim(), txtRemarks.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpdate.Value.ToString(), lblBasicSalary.ToolTip.ToString(), objDs.dtSalPackUpdate, "Y", lblJoinDate.Text.Trim(), lblJoinDate.ToolTip.Trim(), ddlEmpType.SelectedValue.ToString(), txtNewGrossSalary.Text, dclNewBasicSal.ToString()); if (hfIsUpdate.Value == "N") { lblMsg.Text = "Record Saved Successfully"; } else { lblMsg.Text = "Record Updated Successfully"; } this.OpenRecord(); this.EntryMode(false); }
protected void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string strEntryDate = ""; string strConfirmDate = ""; string strNewConfirmDate = ""; string strExtensionDate = ""; if (string.IsNullOrEmpty(txtEntryDate.Text.Trim()) == false) { strEntryDate = Common.ReturnDate(txtEntryDate.Text.Trim()); } if (string.IsNullOrEmpty(txtConfirmDate.Text.Trim()) == false) { strConfirmDate = Common.ReturnDate(txtConfirmDate.Text.Trim()); } if (string.IsNullOrEmpty(txtNewConfirmDate.Text.Trim()) == false) { strNewConfirmDate = Common.ReturnDate(txtNewConfirmDate.Text.Trim()); } if (string.IsNullOrEmpty(txtExtensionDate.Text.Trim()) == false) { strExtensionDate = Common.ReturnDate(txtExtensionDate.Text.Trim()); } //PF Allowance DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0"); DataRow[] foundPlcRow; foundPlcRow = null; foundPlcRow = dtBfPlc.Select("SHEADID=13"); if (foundPlcRow.Length > 0) { DataRow nRow3 = objDs.dtSalPackUpdate.NewRow(); nRow3["SHEADID"] = 13; nRow3["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(lblBasicSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow3); } objDs.dtSalPackUpdate.AcceptChanges(); if (hfIsUpdate.Value == "Y") { hfId.Value = hfId.Value; } else { hfId.Value = Common.getMaxId("EmpConfirmationLog", "ConfirmId"); } objEmpInfoMgr.InsertConfirmation(hfId.Value.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), strEntryDate, strConfirmDate, txtExtensionMonth.Text.Trim(), strNewConfirmDate, strExtensionDate, txtRemarks.Text.Trim(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpdate.Value.ToString(), lblBasicSalary.ToolTip.ToString(), objDs.dtSalPackUpdate); if (hfIsUpdate.Value == "N") { lblMsg.Text = "Record Saved Successfully"; } else { lblMsg.Text = "Record Updated Successfully"; } this.OpenRecord(); this.EntryMode(false); }