public IList <HREmployeeLeaveStatus_DetailedEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression, String filterExpression) { IList <HREmployeeLeaveStatus_DetailedEntity> hREmployeeLeaveStatus_DetailedList = new List <HREmployeeLeaveStatus_DetailedEntity>(); try { if (String.IsNullOrEmpty(sortExpression)) { sortExpression = "HREmployee.EmployeeID"; } Int32 currentPage = Convert.ToInt32(startRowIndex / pageSize) + 1; //startRowIndex = Convert.ToInt32( startRowIndex / pageSize) + 1; if (pageSize == -1) { pageSize = 1000000000; } hREmployeeLeaveStatus_DetailedList = FCCHREmployeeLeaveStatus_Detailed.GetFacadeCreate().GetIL(pageSize, currentPage, sortExpression, filterExpression); if (hREmployeeLeaveStatus_DetailedList != null && hREmployeeLeaveStatus_DetailedList.Count > 0) { totalRowCount = hREmployeeLeaveStatus_DetailedList[0].TotalRowCount; } } catch (Exception ex) { } return(hREmployeeLeaveStatus_DetailedList ?? new List <HREmployeeLeaveStatus_DetailedEntity>()); }
private Decimal?GetToalLeaveEnjoyed() { Decimal?totalLeaveEnjoyed = 0; String filterEmployeeID = "" + OverviewEmployeeID + ""; IList <HREmployeeLeaveStatus_DetailedEntity> statusList = FCCHREmployeeLeaveStatus_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, filterEmployeeID); if (statusList != null && statusList.Count > 0) { if (statusList[0].EarnLeaveEnjoyed == null) { statusList[0].EarnLeaveEnjoyed = 0; } if (statusList[0].CasualLeaveEnjoyed == null) { statusList[0].CasualLeaveEnjoyed = 0; } if (statusList[0].MedicalLeaveEnjoyed == null) { statusList[0].MedicalLeaveEnjoyed = 0; } if (statusList[0].LWPLeaveEnjoyed == null) { statusList[0].LWPLeaveEnjoyed = 0; } totalLeaveEnjoyed = statusList[0].EarnLeaveEnjoyed + statusList[0].CasualLeaveEnjoyed + statusList[0].MedicalLeaveEnjoyed + statusList[0].LWPLeaveEnjoyed; } return(totalLeaveEnjoyed); }