protected void lvHREmployeeDetailsForMonthlyTimeSheetSummary_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
HREmployee_DetailedEntity ent = new HREmployee_DetailedEntity();
TextBox txtEmployeeName = (TextBox)e.Item.FindControl("txtEmployeeName");
TextBox txtDesignation = (TextBox)e.Item.FindControl("txtDesignation");
TextBox txtEmployeeJobTypeID = (TextBox)e.Item.FindControl("txtEmployeeJobTypeID");
TextBox txtSalaryLevel = (TextBox)e.Item.FindControl("txtSalaryLevel");
TextBox txtOnJob = (TextBox)e.Item.FindControl("txtOnJob");
TextBox txtHoliday = (TextBox)e.Item.FindControl("txtHoliday");
TextBox txtLCASUAL = (TextBox)e.Item.FindControl("txtLCASUAL");
TextBox txtLMEDICAL = (TextBox)e.Item.FindControl("txtLMEDICAL");
TextBox txtEARNLEAVE = (TextBox)e.Item.FindControl("txtEARNLEAVE");
TextBox txtLWP = (TextBox)e.Item.FindControl("txtLWP");
TextBox txtACTUALWORKDAYS = (TextBox)e.Item.FindControl("txtACTUALWORKDAYS");
TextBox txtREMARKS = (TextBox)e.Item.FindControl("txtREMARKS");
TextBox txtNUMBEROFMEALS = (TextBox)e.Item.FindControl("txtNUMBEROFMEALS");
TextBox txtPROJECTACTUAL = (TextBox)e.Item.FindControl("txtPROJECTACTUAL");
TextBox txtOTHERLEAVE = (TextBox)e.Item.FindControl("txtOTHERLEAVE");
Label employeeIDlv = (Label)e.Item.FindControl("employeeIDlv");
String remarks = String.Empty;
txtLCASUAL.Text = "0";
txtLMEDICAL.Text = "0";
txtEARNLEAVE.Text = "0";
txtLWP.Text = "0";
txtREMARKS.Text = String.Empty;
txtNUMBEROFMEALS.Text = "0";
txtPROJECTACTUAL.Text = "0";
txtOTHERLEAVE.Text = "0";
IList <HREmployeeDetailsForMonthlyTimeSheetSummary_CustomEntity> entList = FCCHREmployeeDetailsForMonthlyTimeSheetSummary_Custom.GetFacadeCreate().GetIL(Int64.Parse(ddlSalarySessionID.SelectedValue));
txtOnJob.Text = entList[0].OnJob.ToString().Trim();
txtHoliday.Text = (entList[0].Holiday - entList[0].LeaveDay).ToString().Trim();
txtACTUALWORKDAYS.Text = ((Decimal.Parse(txtOnJob.Text) + Decimal.Parse(txtHoliday.Text)) - Decimal.Parse(txtLWP.Text)).ToString().Trim();
//Int64 leaveApplicationApplicationStatusID = 2;
Int64 employeeID = (Int64.Parse(employeeIDlv.Text));
Decimal totalLeaveDays = 0;
Decimal casual = 0;
Decimal medical = 0;
Decimal earn = 0;
Decimal lwp = 0;
String fe1 = SqlExpressionBuilder.PrepareFilterExpression("HREmployee." + HREmployee_DetailedEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(MDSalarySessionEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeLeaveApplication." + HREmployeeLeaveApplicationEntity.FLD_NAME_LeaveApplicationApplicationStatusID, MasterDataConstants.MDLeaveApplicatoinStatus.APPROVED.ToString(), SQLMatchType.Equal);
String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3);
IList <HREmployeeLeaveApplication_DetailedEntity> leaveList = FCCHREmployeeLeaveApplication_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, fe);
if (leaveList != null && leaveList.Count > 0)
{
foreach (HREmployeeLeaveApplication_DetailedEntity entity in leaveList)
{
if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.CASUAL)
{
casual += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.MEDICAL)
{
medical += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.EARN)
{
earn += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.LWP)
{
lwp += leaveList[0].TotalLeaveDays;
}
}
}
if (lwp > 0)
{
remarks += lwp + " LWP " + (lwp * 6) + " Late. ";
}
totalLeaveDays = casual + medical + earn;
if (totalLeaveDays > 0)
{
remarks += Decimal.Truncate(totalLeaveDays).ToString().Trim() + " Leave.";
}
else
{
remarks += String.Empty;
}
txtLCASUAL.Text = casual.ToString();
txtLMEDICAL.Text = medical.ToString();
txtEARNLEAVE.Text = earn.ToString();
txtLWP.Text = lwp.ToString();
txtACTUALWORKDAYS.Text = (entList[0].ActualWorkingDay - lwp).ToString().Trim();
txtREMARKS.Text = remarks;
btnSubmit.Text = "Save";
#region CurrentEmployeeMonthlyTimeSheetSummaryInfo
String fe4 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
String fe5 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
String fe6 = SqlExpressionBuilder.PrepareFilterExpression(fe4, SQLJoinType.AND, fe5);
IList <HREmployeeMonthlyTimeSheetSummaryEntity> hREmployeeMonthlyTimeSheetSummarylist = FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().GetIL(null, null, String.Empty, fe6, DatabaseOperationType.LoadWithFilterExpression);
if (hREmployeeMonthlyTimeSheetSummarylist != null && hREmployeeMonthlyTimeSheetSummarylist.Count > 0)
{
txtOnJob.Text = hREmployeeMonthlyTimeSheetSummarylist[0].OnJob.ToString().Trim();
txtHoliday.Text = hREmployeeMonthlyTimeSheetSummarylist[0].Holiday.ToString().Trim();
txtACTUALWORKDAYS.Text = hREmployeeMonthlyTimeSheetSummarylist[0].ACTUALWORKDAYS.ToString().Trim();
txtLCASUAL.Text = hREmployeeMonthlyTimeSheetSummarylist[0].LCASUAL.ToString().Trim();
txtLMEDICAL.Text = hREmployeeMonthlyTimeSheetSummarylist[0].LMEDICAL.ToString().Trim();
txtLWP.Text = hREmployeeMonthlyTimeSheetSummarylist[0].LWP.ToString().Trim();
txtEARNLEAVE.Text = hREmployeeMonthlyTimeSheetSummarylist[0].EARNLEAVE.ToString().Trim();
txtREMARKS.Text = hREmployeeMonthlyTimeSheetSummarylist[0].REMARKS.ToString().Trim();
txtNUMBEROFMEALS.Text = hREmployeeMonthlyTimeSheetSummarylist[0].NUMBEROFMEALS.ToString().Trim();
txtPROJECTACTUAL.Text = hREmployeeMonthlyTimeSheetSummarylist[0].PROJECTACTUAL.ToString().Trim();
txtOTHERLEAVE.Text = hREmployeeMonthlyTimeSheetSummarylist[0].OTHERLEAVE.ToString().Trim();
btnSubmit.Text = "Update";
}
#endregion
}
}
private void GenerateAll()
{
try
{
StringBuilder xmlStr = new StringBuilder();
Int64 employmentStatusID = 1;
String fe = SqlExpressionBuilder.PrepareFilterExpression("(HREmployeeSalaryInfo.SalaryAmount is not null and HREmployeeSalaryInfo.FiscalYearID = (Select FiscalYearID from ACFiscalYear where IsClosed = 0)) and HREmployee." + HREmployee_DetailedEntity.FLD_NAME_EmploymentStatusID, employmentStatusID.ToString(), SQLMatchType.Equal);
if (ddlDepartmentID.SelectedValue == "1")
{
String fe2 = "( HREmployee.DepartmentID is null or HREmployee.DepartmentID <> 20)";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe2);
}
else
{
String fe3 = "(HREmployee.DepartmentID = 20)";
fe = SqlExpressionBuilder.PrepareFilterExpression(fe, SQLJoinType.AND, fe3);
}
IList <HREmployee_DetailedEntity> list = FCCHREmployeeMonthlyTimeSheet_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, fe);
xmlStr.Append("<m>");
if (list != null && list.Count > 0)
{
foreach (HREmployee_DetailedEntity hREmployee_DetailedEntity in list)
{
HREmployeeMonthlyTimeSheetSummaryEntity hREmployeeMonthlyTimeSheetSummaryEntity = new HREmployeeMonthlyTimeSheetSummaryEntity();
hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.LWP = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS = String.Empty;
hREmployeeMonthlyTimeSheetSummaryEntity.NUMBEROFMEALS = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.PROJECTACTUAL = 0;
hREmployeeMonthlyTimeSheetSummaryEntity.OTHERLEAVE = 0;
String remarks = String.Empty;
IList <HREmployeeDetailsForMonthlyTimeSheetSummary_CustomEntity> entList = FCCHREmployeeDetailsForMonthlyTimeSheetSummary_Custom.GetFacadeCreate().GetIL(Int64.Parse(ddlSalarySessionID.SelectedValue));
hREmployeeMonthlyTimeSheetSummaryEntity.OnJob = entList[0].OnJob;
hREmployeeMonthlyTimeSheetSummaryEntity.Holiday = (entList[0].Holiday - entList[0].LeaveDay);
hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS = ((hREmployeeMonthlyTimeSheetSummaryEntity.OnJob + hREmployeeMonthlyTimeSheetSummaryEntity.Holiday) - hREmployeeMonthlyTimeSheetSummaryEntity.LWP);
Int64 employeeID = hREmployee_DetailedEntity.EmployeeID;
Decimal totalLeaveDays = 0;
Decimal casual = 0;
Decimal medical = 0;
Decimal earn = 0;
Decimal lwp = 0;
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(" HREmployee." + HREmployee_DetailedEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(MDSalarySessionEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
String fe3 = SqlExpressionBuilder.PrepareFilterExpression("HREmployeeLeaveApplication." + HREmployeeLeaveApplicationEntity.FLD_NAME_LeaveApplicationApplicationStatusID, MasterDataConstants.MDLeaveApplicatoinStatus.APPROVED.ToString(), SQLMatchType.Equal);
String f = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
f = SqlExpressionBuilder.PrepareFilterExpression(f, SQLJoinType.AND, fe3);
IList <HREmployeeLeaveApplication_DetailedEntity> leaveList = FCCHREmployeeLeaveApplication_Detailed.GetFacadeCreate().GetIL(1000, 1, String.Empty, f);
if (leaveList != null && leaveList.Count > 0)
{
foreach (HREmployeeLeaveApplication_DetailedEntity entity in leaveList)
{
if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.CASUAL)
{
casual += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.MEDICAL)
{
medical += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.EARN)
{
earn += leaveList[0].TotalLeaveDays;
}
else if (entity.LeaveCategoryID == MasterDataConstants.MDLeaveCategory.LWP)
{
lwp += leaveList[0].TotalLeaveDays;
}
}
}
if (lwp > 0)
{
remarks += lwp + " LWP " + (lwp * 6) + " Late. ";
}
totalLeaveDays = casual + medical + earn;
if (totalLeaveDays > 0)
{
remarks += totalLeaveDays.ToString().Trim() + " Leave.";
}
else
{
remarks += String.Empty;
}
hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL = casual;
hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL = medical;
hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE = earn;
hREmployeeMonthlyTimeSheetSummaryEntity.LWP = lwp;
hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS = (entList[0].ActualWorkingDay - lwp);
hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS = remarks;
hREmployeeMonthlyTimeSheetSummaryEntity.SalarySessionID = Int64.Parse(ddlSalarySessionID.SelectedValue);
#region Already Has this employee
Boolean isTrue = true;
String fe4 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_EmployeeID, employeeID.ToString(), SQLMatchType.Equal);
String fe5 = SqlExpressionBuilder.PrepareFilterExpression(HREmployeeMonthlyTimeSheetSummaryEntity.FLD_NAME_SalarySessionID, (Int64.Parse(ddlSalarySessionID.SelectedValue)).ToString(), SQLMatchType.Equal);
String fe6 = SqlExpressionBuilder.PrepareFilterExpression(fe4, SQLJoinType.AND, fe5);
IList <HREmployeeMonthlyTimeSheetSummaryEntity> hREmployeeMonthlyTimeSheetSummarylist = FCCHREmployeeMonthlyTimeSheetSummary.GetFacadeCreate().GetIL(null, null, String.Empty, fe6, DatabaseOperationType.LoadWithFilterExpression);
if (hREmployeeMonthlyTimeSheetSummarylist != null && hREmployeeMonthlyTimeSheetSummarylist.Count > 0)
{
isTrue = false;
}
#endregion
if (isTrue)
{
String subXmlStr = null;
subXmlStr = subXmlStr + "<i><a>" + hREmployee_DetailedEntity.EmployeeID + "</a><b>" + hREmployee_DetailedEntity.DesignationID + "</b><c>" + hREmployee_DetailedEntity.EmployeeJobTypeID + "</c><d>" + hREmployee_DetailedEntity.SalaryLevel + "</d><e>" + hREmployeeMonthlyTimeSheetSummaryEntity.SalarySessionID + "</e><f>" + hREmployeeMonthlyTimeSheetSummaryEntity.OnJob + "</f><g>" + hREmployeeMonthlyTimeSheetSummaryEntity.Holiday + "</g><h>" + hREmployeeMonthlyTimeSheetSummaryEntity.LCASUAL + "</h><i1>" + hREmployeeMonthlyTimeSheetSummaryEntity.LMEDICAL + "</i1><j>" + hREmployeeMonthlyTimeSheetSummaryEntity.EARNLEAVE + "</j><k>" + hREmployeeMonthlyTimeSheetSummaryEntity.LWP + "</k><l>" + hREmployeeMonthlyTimeSheetSummaryEntity.ACTUALWORKDAYS + "</l><m>" + hREmployeeMonthlyTimeSheetSummaryEntity.REMARKS + "</m><n>" + hREmployeeMonthlyTimeSheetSummaryEntity.NUMBEROFMEALS + "</n><o>" + hREmployeeMonthlyTimeSheetSummaryEntity.PROJECTACTUAL + "</o><p>" + hREmployeeMonthlyTimeSheetSummaryEntity.OTHERLEAVE + "</p><q>" + hREmployee_DetailedEntity.DepartmentID + "</q></i>";
xmlStr.Append(subXmlStr.ToString());
}
}
}
xmlStr.Append("</m>");
FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.HREmployeeMonthlyTimeSheetSummary);
MiscUtil.ShowMessage(lblMessage, "Time Sheet Has been Generated Successfully.", false);
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true);
}
}