private void CalculateBasicSalary() { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("1", ddlEmpType.SelectedValue.ToString()); if (dtBfPlc.Rows.Count > 0) { decimal dclBasicAmt = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtGrossSalary.Text, 0), Common.RoundDecimal(dtBfPlc.Rows[0]["Value"].ToString(), 2)); txtBasicSalary.Text = dclBasicAmt.ToString(); } }
protected void btnGenerate_Click(object sender, EventArgs e) { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); DataTable dtBenefitsPolicy = objOptMgr.SelectPayrollBenefitsPolicyData("0", "0"); DataTable dtBasic = objSalaryManager.GetEmpBasic(ddlSalPackTitle.SelectedValue.Trim()); DataTable dtSalHead = objSalaryManager.GetSalaryHeadForPackageSetup(); this.AddToSalaryPakDetailsDataSet(dtSalHead, dtBenefitsPolicy, dtBasic); }
protected void OpenBenefitsPolicyRecord() { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); grBPList.DataSource = objOptMgr.SelectPayrollBenefitsPolicyData("0", "0"); grBPList.DataBind(); foreach (GridViewRow gRow in grBPList.Rows) { if (grBPList.DataKeys[gRow.RowIndex][5].ToString() == "99") { gRow.Cells[6].Text = "Gross Salary"; } } }
private void FormateGrid() { int i = 1; decimal dclNewBasic = 0; decimal dclHR = 0; decimal dclPF = 0; DataTable dtBfPlc = objPayOptMgr.SelectPayrollBenefitsPolicyData("0"); DataRow[] foundPlcRow; foundPlcRow = null; foreach (GridViewRow gRow in grEmpList.Rows) { gRow.Cells[0].Text = i.ToString(); dclNewBasic = Convert.ToDecimal(gRow.Cells[3].Text) + (Convert.ToDecimal(gRow.Cells[3].Text) * Convert.ToDecimal(txtCOLAPercent.Text.Trim())) / 100; gRow.Cells[4].Text = Convert.ToString(Common.RoundDecimal(dclNewBasic.ToString(), 0)); //House Rent foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { dclHR = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(gRow.Cells[5].Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); } dclHR = (dclNewBasic * Convert.ToDecimal(dtBfPlc.Rows[0]["VALUE"]) / 100); gRow.Cells[5].Text = Convert.ToString(Common.RoundDecimal(dclHR.ToString(), 0)); //PF Allowance if (string.IsNullOrEmpty(grEmpList.DataKeys[gRow.DataItemIndex].Values[1].ToString().Trim()) == false) { foundPlcRow = null; foundPlcRow = dtBfPlc.Select("SHEADID=13"); if (foundPlcRow.Length > 0) { dclPF = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(gRow.Cells[4].Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); } gRow.Cells[6].Text = Convert.ToString(Common.RoundDecimal(dclPF.ToString(), 0)); } else { gRow.Cells[6].Text = "0"; } gRow.Cells[7].Text = txtCOLAPercent.Text.Trim(); i++; } }
private void FormateGrid() { int i = 1; decimal dclNewBasic = 0; decimal dclAllowance = 0; decimal dclPF = 0; DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0", "0"); DataRow[] foundPlcRow; foundPlcRow = null; foreach (GridViewRow gRow in grPayroll.Rows) { dclNewBasic = Convert.ToDecimal(gRow.Cells[1].Text); gRow.Cells[1].Text = Convert.ToString(Common.RoundDecimal(dclNewBasic.ToString(), 0)); //Allowance foundPlcRow = dtBfPlc.Select("SHEADID=2"); if (foundPlcRow.Length > 0) { dclAllowance = objEmpMgr.GetHeadAmount(Common.RoundDecimal(gRow.Cells[1].Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); } dclAllowance = (dclNewBasic * Convert.ToDecimal(dtBfPlc.Rows[0]["VALUE"]) / 100); gRow.Cells[2].Text = Convert.ToString(Common.RoundDecimal(dclAllowance.ToString(), 0)); //PF Allowance foundPlcRow = null; foundPlcRow = dtBfPlc.Select("SHEADID=13"); if (foundPlcRow.Length > 0) { dclPF = objEmpMgr.GetHeadAmount(Common.RoundDecimal(gRow.Cells[1].Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); } gRow.Cells[3].Text = Convert.ToString(Common.RoundDecimal(dclPF.ToString(), 0)); i++; } }
private void NewBasic() { DataTable dtBenefitsPolicy = objOptMgr.SelectPayrollBenefitsPolicyData("0"); decimal dclBasicAmt = Convert.ToDecimal(txtPercntOfBasic.Text); decimal dclAllowanceAmt = 0; decimal dclPFAmt = 0; foreach (GridViewRow gRow in grAppraisalIncUpdate.Rows) { if (Common.CheckNullString(gRow.Cells[2].Text) != "") { dclBasicAmt = Convert.ToDecimal(gRow.Cells[2].Text) + (Convert.ToDecimal(gRow.Cells[2].Text) * Convert.ToDecimal(txtPercntOfBasic.Text) / 100); gRow.Cells[4].Text = dclBasicAmt.ToString(); } //New Allowance dclAllowanceAmt = this.CalculateHeadAmount(dclBasicAmt, dtBenefitsPolicy, "1", "2"); gRow.Cells[5].Text = dclAllowanceAmt.ToString(); //PF dclPFAmt = this.CalculateHeadAmount(dclBasicAmt, dtBenefitsPolicy, "1", "13"); gRow.Cells[6].Text = dclPFAmt.ToString(); } }
protected void btnGenerate_Click(object sender, EventArgs e) { try { Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); DataTable dtBenefitsPolicy = objOptMgr.SelectPayrollBenefitsPolicyData("0"); DataTable dtBasic = objSalaryManager.GetEmpBasic(ddlSalPackTitle.SelectedValue.Trim()); if (string.IsNullOrEmpty(dtBasic.Rows[0]["GradeID"].ToString()) == true || string.IsNullOrEmpty(dtBasic.Rows[0]["GradeLevelID"].ToString()) == true) { lblMsg.Text = "Please assign staffs grade & grade step from HR screen."; return; } DataTable dtSalHead = objSalaryManager.GetSalaryHeadForPackageSetup(); this.AddToSalaryPakDetailsDataSet(dtSalHead, dtBenefitsPolicy, dtBasic); } catch (Exception ex) { lblMsg.Text = ex.Message.ToString(); } }
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(); }
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); }
private void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string IsDelete = "N"; long lngID = 0; try { string strConfrimDate = ""; if (string.IsNullOrEmpty(txtEffDate.Text.Trim()) == false) { strConfrimDate = Common.ReturnDate(txtEffDate.Text.Trim()); } if (hfIsUpdate.Value == "N") { lngID = objDB.GerMaxIDNumber("EmpSalaryAmendment", "LogId"); } else { lngID = Convert.ToInt32(hfID.Value); } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0"); DataRow[] foundPlcRow; foundPlcRow = null; //Basic DataRow nRow1 = objDs.dtSalPackUpdate.NewRow(); nRow1["SHEADID"] = 1; nRow1["PAYAMT"] = Common.RoundDecimal(txtBasicSalary.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"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtBasicSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } // Medical foundPlcRow = dtBfPlc.Select("SHEADID=3"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 3; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtBasicSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } // Conveyance foundPlcRow = dtBfPlc.Select("SHEADID=4"); if (foundPlcRow.Length > 0) { DataRow nRow2 = objDs.dtSalPackUpdate.NewRow(); nRow2["SHEADID"] = 4; nRow2["PAYAMT"] = objEmpInfoMgr.GetHeadAmount(Common.RoundDecimal(txtBasicSalary.Text, 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 0)); objDs.dtSalPackUpdate.Rows.Add(nRow2); } // Calculate Gross, Incremented Amount, and Percent decimal decGross = Common.RoundDecimal(txtBasicSalary.Text.Trim(), 0) + Common.RoundDecimal(txtHouseRent.Text.Trim(), 0) + Common.RoundDecimal(txtMedical.Text.Trim(), 0) + Common.RoundDecimal(txtConveyance.Text.Trim(), 0); decimal decIncrAmt = decGross - Common.RoundDecimal(lblGross.Text.Trim(), 0); decimal decIncrPercnt = (decIncrAmt * 100) / Common.RoundDecimal(lblGross.Text.Trim(), 0); decIncrPercnt = Common.RoundDecimal(decIncrPercnt.ToString(), 2); objEmpInfoMgr.InsertEmpSalaryAmendment(lngID.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), ddlAction.SelectedItem.ToString(), strConfrimDate, txtBasicSalary.Text, txtHouseRent.Text.Trim(), txtMedical.Text.Trim(), txtConveyance.Text.Trim(), decGross.ToString(), txtRemarks.Text.Trim(), decIncrAmt.ToString(), decIncrPercnt.ToString(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpdate.Value, IsDelete, lblSalPac.ToolTip.ToString(), objDs.dtSalPackUpdate); if (hfIsUpdate.Value == "N") { lblMsg.Text = "Record Saved Successfully"; } else { lblMsg.Text = "Record Updated Successfully"; } this.EntryMode(false); this.ClearControls(); //this.OpenRecord(); } catch (Exception ex) { lblMsg.Text = ""; throw (ex); } }
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); }
private void SaveData() { dsPayroll_SalaryPackage objDs = new dsPayroll_SalaryPackage(); Payroll_PaySlipOptionMgr objOptMgr = new Payroll_PaySlipOptionMgr(); string IsDelete = "N"; long lngID = 0; try { string strConfrimDate = ""; decimal dclNewBasicSal = 0; if (string.IsNullOrEmpty(txtEffDate.Text.Trim()) == false) { strConfrimDate = Common.ReturnDate(txtEffDate.Text.Trim()); } if (hfIsUpdate.Value == "N") { lngID = objDB.GerMaxIDNumber("EmpSalaryIncrementLog", "LogId"); } else { lngID = Convert.ToInt32(hfID.Value); } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0", lblName.ToolTip.ToString()); 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); } //PF Allowance foundPlcRow = dtBfPlc.Select("SHEADID=8"); if (foundPlcRow.Length > 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(); objEmpInfoMgr.InsertEmpSalaryIncrement(lngID.ToString(), txtEmpID.Text.Trim(), ddlAction.SelectedValue.ToString(), ddlAction.SelectedItem.ToString(), strConfrimDate, Common.ReturnZeroForNull(txtCOLA.Text.Trim()), Common.ReturnZeroForNull(txtGpPer.Text.Trim()), Common.ReturnZeroForNull(txtInvPer.Text.Trim()), txtNewGrossSalary.Text.Trim(), dclNewBasicSal.ToString(), txtRemarks.Text.Trim(), txtIncrement.Text, txtNewGrossSalary.ToolTip.ToString(), Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), hfIsUpdate.Value, IsDelete, lblSalPac.ToolTip.ToString(), objDs.dtSalPackUpdate); if (hfIsUpdate.Value == "N") { lblMsg.Text = "Record Saved Successfully"; } else { lblMsg.Text = "Record Updated Successfully"; } this.EntryMode(false); this.ClearControls(); //this.OpenRecord(); } catch (Exception ex) { lblMsg.Text = ""; throw (ex); } }
private void GenerateIncrementList(DataTable dtEmpList) { DateTime dtCurrDate = DateTime.Now; decimal dclTotalScore = 0; decimal dclCOLA = 0, dclGpPer = 0, dclInvPer = 0; foreach (DataRow dRow in dtEmpList.Rows) { DataRow nRow = objDS.dtIncrement.NewRow(); //if (string.IsNullOrEmpty(dRow["EmpTypeId"].ToString())) //{ // dRow["EmpTypeId"] = "-1"; //} string strIncDate = ""; char[] splitter = { '/' }; if (string.IsNullOrEmpty(dRow["IncrementDate"].ToString().Trim()) == false) { strIncDate = dRow["IncrementDate"].ToString(); } else { strIncDate = dRow["JoiningDate"].ToString(); } string[] arinfo = Common.str_split(Common.DisplayDate(strIncDate), splitter); if (arinfo.Length == 3) { strIncDate = arinfo[2] + "/" + arinfo[1] + "/" + arinfo[0]; //arinfo = null; } //Those Inc has already done on this yr if (arinfo[2].ToString() == dtCurrDate.Year.ToString()) { arinfo = null; goto AddNextEmpId; } if (Convert.ToInt16(arinfo[2]) < Convert.ToInt16(dtCurrDate.Year)) { switch (arinfo[1]) { case "10": case "11": case "12": dclCOLA = 0; dclGpPer = 0; dclInvPer = 0; break; case "07": case "08": case "09": dclCOLA = (Convert.ToDecimal(txtCOLA.Text) * 50) / 100; dclGpPer = (Convert.ToDecimal(txtGrpPer.Text) * 50) / 100; dclInvPer = (Convert.ToDecimal(txtInvPer.Text) * 50) / 100; break; case "04": case "05": case "06": dclCOLA = (Convert.ToDecimal(txtCOLA.Text) * 75) / 100; dclGpPer = (Convert.ToDecimal(txtGrpPer.Text) * 75) / 100; dclInvPer = (Convert.ToDecimal(txtInvPer.Text) * 75) / 100; break; case "01": case "02": case "03": dclCOLA = Convert.ToDecimal(txtCOLA.Text); dclGpPer = Convert.ToDecimal(txtGrpPer.Text); dclInvPer = Convert.ToDecimal(txtInvPer.Text); break; } } if (string.IsNullOrEmpty(dRow["EmpTypeId"].ToString()) == false) { if (dRow["EmpTypeId"].ToString() == "1") { } else//For Contractual Staff { DateTime CurrYear = Convert.ToDateTime(txtActionDate.Text); DateTime JoinYear = Convert.ToDateTime(dRow["JoiningDate"].ToString().Trim()); if (JoinYear.AddYears(1) > CurrYear) { TimeSpan DateDiff = JoinYear - CurrYear; string strTotDay = Common.ReturnTotalDay(DateDiff.ToString()); if (Convert.ToInt16(strTotDay) < 365) { goto AddNextEmpId; } } } DataTable dtBfPlc = objOptMgr.SelectPayrollBenefitsPolicyData("0", dRow["EmpTypeId"].ToString().Trim()); DataRow[] foundPlcRow; foundPlcRow = null; nRow["EmpId"] = dRow["EmpId"].ToString().Trim(); nRow["FullName"] = dRow["FullName"].ToString().Trim(); nRow["TypeName"] = dRow["TypeName"].ToString().Trim(); nRow["JoiningDate"] = dRow["JoiningDate"].ToString().Trim(); nRow["DesigName"] = dRow["DesigName"].ToString().Trim(); nRow["ClinicName"] = dRow["ClinicName"].ToString().Trim(); if (string.IsNullOrEmpty(dRow["IncrementDate"].ToString().Trim()) == false) { nRow["IncrementDate"] = dRow["IncrementDate"].ToString().Trim(); } else { nRow["IncrementDate"] = ""; } nRow["BasicSalary"] = dRow["BasicSalary"].ToString().Trim(); nRow["GrossSalary"] = dRow["GrossSalary"].ToString().Trim(); nRow["COLA"] = dclCOLA; nRow["GrpPer"] = dclGpPer; nRow["InvPer"] = dclInvPer; dclTotalScore = Convert.ToDecimal(nRow["COLA"]) + Convert.ToDecimal(nRow["GrpPer"]) + Convert.ToDecimal(nRow["InvPer"]); nRow["NewBasicSalary"] = Math.Round(Convert.ToDecimal(nRow["BasicSalary"]) + ((Convert.ToDecimal(nRow["BasicSalary"]) * dclTotalScore) / 100), 0); nRow["NewGrossSalary"] = Math.Round(Convert.ToDecimal(nRow["GrossSalary"]) + ((Convert.ToDecimal(nRow["GrossSalary"]) * dclTotalScore) / 100), 0); if (dtBfPlc.Rows.Count > 0) { foundPlcRow = dtBfPlc.Select("SHEADID=2"); //House Rent nRow["Housing"] = objEmpMgr.GetHeadAmount(Common.RoundDecimal(nRow["NewGrossSalary"].ToString(), 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); //Convert.ToDecimal(foundRows[0]["Housing"].ToString()) + Convert.ToDecimal(foundRows[0]["Housing"].ToString()) * dclTotalScore; foundPlcRow = null; foundPlcRow = dtBfPlc.Select("SHEADID=3");//Medical nRow["Medical"] = objEmpMgr.GetHeadAmount(Common.RoundDecimal(nRow["NewGrossSalary"].ToString(), 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); foundPlcRow = null; foundPlcRow = dtBfPlc.Select("SHEADID=8");//PF if (foundPlcRow.Length > 0) { nRow["PF"] = objEmpMgr.GetHeadAmount(Common.RoundDecimal(nRow["NewGrossSalary"].ToString(), 0), Common.RoundDecimal(foundPlcRow[0]["Value"].ToString(), 2)); } } objDS.dtIncrement.Rows.Add(nRow); } AddNextEmpId: { } } objDS.dtIncrement.AcceptChanges(); grIncrementList.DataSource = objDS.Tables["dtIncrement"]; grIncrementList.DataBind(); lblExistRecordCount.Text = grIncrementList.Rows.Count.ToString(); if (grIncrementList.Rows.Count > 0) { foreach (GridViewRow gRow in grIncrementList.Rows) { gRow.Cells[4].Text = gRow.Cells[4].Text != "" ? Common.DisplayDate(gRow.Cells[4].Text) : gRow.Cells[4].Text; gRow.Cells[7].Text = gRow.Cells[7].Text != "" ? Common.DisplayDate(gRow.Cells[7].Text) : gRow.Cells[7].Text; } } else { lblMsg.Text = "Selected Cost centers Increment process for this year has already done or no staff is available."; } }
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(); }