private void FillEmpWithLeaveInfo(string EmpId, string Sex, string strLeaveStartPeriod, string strLeaveEndPeriod) { dtEmp.Rows.Clear(); dtEmp.Dispose(); dtEmp = objLeaveMgr.SelectEmpLeaveProfileEXCPL(EmpId, "0", Sex); DateTime dtStart = Convert.ToDateTime(strLeaveStartPeriod); DateTime dtEnd = Convert.ToDateTime(strLeaveEndPeriod); string strPreYrStartDate = Convert.ToString(dtStart.Year - 1) + "-" + dtStart.Month.ToString() + "-" + dtStart.Day.ToString(); string strPreYrEndDate = Convert.ToString(dtEnd.Year - 1) + "-" + dtEnd.Month.ToString() + "-" + dtEnd.Day.ToString(); dtPreYrLeave = objLvMgr.SelectEmpLeaveProfileHistory(EmpId, strPreYrStartDate, strPreYrEndDate); if (dtEmp.Rows.Count > 0) { lblName.Text = dtEmp.Rows[0]["FullName"].ToString(); lblDesig.Text = dtEmp.Rows[0]["DesigName"].ToString(); lblLvPackage.Text = dtEmp.Rows[0]["LPackName"].ToString(); grLeaveStatus.DataSource = null; grLeaveStatus.DataBind(); grLeaveStatus.DataSource = dtEmp; grLeaveStatus.DataBind(); grPreYrLeaveStatus.DataSource = null; grPreYrLeaveStatus.DataBind(); grPreYrLeaveStatus.DataSource = dtPreYrLeave; grPreYrLeaveStatus.DataBind(); this.FormatLeaveStatusGridNumber(); this.FormatHistoryLeaveStatusGridNumber(); this.FillEmpLeaveDet(txtEmpId.Text.Trim(), Common.SetDate(strLeaveStartPeriod), Common.SetDate(strLeaveEndPeriod)); this.FillEmpPreYrLeaveDet(txtEmpId.Text.Trim(), strPreYrStartDate, strPreYrEndDate); } else { lblName.Text = ""; lblDesig.Text = ""; lblLvPackage.Text = ""; grLeaveStatus.DataSource = null; grLeaveStatus.DataBind(); grLeaveDet.DataSource = null; grLeaveDet.DataBind(); grPreYrLeaveStatus.DataSource = null; grPreYrLeaveStatus.DataBind(); grPreYrLeaveDet.DataSource = null; grPreYrLeaveDet.DataBind(); lblMsg2.Text = "Selected employee's leave package does not exist."; } }
protected void GetLeaveBalance(string strEmpID, string strSex, string strStartPeriod, string strEndPeriod) { DataTable dtLeaveBalance = objLvMgr.SelectEmpLeaveProfileHistory(strEmpID, strStartPeriod, strEndPeriod); if (dtLeaveBalance.Rows.Count > 0) { grLeaveBalance.DataSource = dtLeaveBalance; grLeaveBalance.DataBind(); this.FormatLeaveStatusGridNumber(); this.GetLeaveHistory(strEmpID, strStartPeriod, strEndPeriod); } }
private void CalculateBalance(int iSalPakId) { //Total Salary decimal dclTotalSalary = 0; DataTable dtSalPakDtls = objPayMgr.SelectSalaryPakDetls(iSalPakId); DataRow[] foundRows = dtSalPakDtls.Select("HeadNature=1 AND ItemCategory='S'"); if (foundRows.Length > 0) { foreach (DataRow fRow in foundRows) { dclTotalSalary = dclTotalSalary + Convert.ToDecimal(fRow["PayAmt"]); } } //txtTotalPay.Text = Math.Round(dclTotalSalary).ToString(); dclTotalSalary = 0; dtSalPakDtls.Rows.Clear(); dtSalPakDtls.Dispose(); //EL Balance decimal dclELBalance = 0; DataTable dtLv = new DataTable(); dtLv = objLvMgr.SelectEmpLeaveProfileHistory(txtEmpID.Text.Trim(), "2019-01-01", "2019-12-31"); DataRow[] foundELRows; foundELRows = dtLv.Select("LTypeId=2"); if (foundELRows.Length > 0) { dclELBalance = (Convert.ToDecimal(foundELRows[0]["LCarryOverd"].ToString()) + Convert.ToDecimal(foundELRows[0]["LEntitled"].ToString())) - Convert.ToDecimal(foundELRows[0]["LeaveEnjoyed"].ToString()); txtELLeave.Text = dclELBalance.ToString(); this.LeaveEncashment(); } dtLv.Rows.Clear(); dtLv.Dispose(); //Salary of Last Month DateTime dtSeperateDate = Convert.ToDateTime(Common.ReturnDate(lblSeprateDate.Text.Trim())); string strMonth = dtSeperateDate.Month.ToString(); string strYear = dtSeperateDate.Year.ToString(); string strPrevMonth = Common.GetPreviousMonth(strMonth); if (strMonth == "1") { strYear = Convert.ToString(Convert.ToInt32(strYear) - 1); } DataTable dtEmpPayroll = objPayAppMgr.GetPayrollApprovedDataForDisbursement("E", txtEmpID.Text.Trim(), strPrevMonth, strYear, ""); if (dtEmpPayroll.Rows.Count > 0) { txtLastMonthSalary.Text = "0"; } else { txtLastMonthSalary.Text = txtBasicPay.ToolTip.ToString(); } //PF Balance DataTable dtPF = objPFMgr.SelectEmpWisePFBF(txtEmpID.Text.Trim()); if (dtPF.Rows.Count > 0) { txtPF.Text = Convert.ToString(Math.Round(Convert.ToDecimal(dtPF.Rows[0]["TotalPF"]), 0)); } dtPF.Rows.Clear(); dtPF.Dispose(); //Gratuity txtGratuity.Text = Convert.ToString(Math.Round(Convert.ToDecimal(txtBasicPay.Text) * Convert.ToDecimal(Common.ReturnZeroForNull(lblGratuityYr.Text)))); lblSalaryMonth.Text = Common.ReturnFullMonthName(strMonth); int iSalaryDays = Convert.ToInt32(Common.CalculateTotalDays("01/" + strMonth + "/" + strYear, lblSeprateDate.Text.Trim())); lblSalaryDays.Text = Convert.ToString(iSalaryDays - 1); txtSeperateMonthSal.Text = Convert.ToString(Math.Round(Convert.ToDecimal(txtTotalPay.Text) / Common.GetMonthDay(Convert.ToInt32(strMonth), strYear) * Convert.ToDecimal(lblSalaryDays.Text), 0)); dtEmpPayroll.Rows.Clear(); dtEmpPayroll.Dispose(); }