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