public static LeaveYearlyReportViewModel SpLeaveBalanceListToYearlyLeaveBalanceList(sp_LeaveApplicationEmployeeBalance_Result Record, int Empcode, int YearId) { LeaveYearlyReportViewModel single = new LeaveYearlyReportViewModel { LeaveTypeId = Convert.ToInt32(Record.LeaveTypeId), BalanceDays = Convert.ToDecimal(Record.BalanceDays), TotalTaken = Convert.ToDecimal(Record.TotalTaken), TotalLeaveDays = Convert.ToDecimal(Record.TotalLeaveDays), EmpCode = Empcode, LeaveYearId = YearId, PrevYearBalance = Convert.ToDecimal(Record.PrevYearBalance), ThisYearEarned = Convert.ToDecimal(Record.ThisYearEarned) }; return(single); }
public ActionResult Index(int OfficeId, int?DesgId, int LeaveYearId) { int EmpCode = Convert.ToInt32(Session["Empcode"]); ViewBag.dllOfficeTypeList = _officeService.GetClildOfficeListByEmpCode(Convert.ToInt32(ViewBag.EmpCode)); ViewBag.dllLeaveYearList = _LeaveApplicationService.GetLeaveYearSelectList(); ViewBag.dllDesginationList = _designationService.GetDesignationList().ToList(); ViewBag.OfficeId = OfficeId; ViewBag.DesgId = DesgId; ViewBag.LeaveYearId = LeaveYearId; var emplist = _employeeService.EmployeeSearch(OfficeId, DesgId); List <MultipleLeaveYearlyReportViewModel> masterRecord = new List <MultipleLeaveYearlyReportViewModel>(); foreach (var empdata in emplist) { var desgndata = _designationService.GetDesignationById(empdata.EmpDesgId); var empdbdata = _employeeService.GetEmployeeByID(empdata.EmpCode); LeaveYearlyReportViewModel homeleave = new LeaveYearlyReportViewModel(); homeleave = _LeaveAddAdmin.YearlyOfficewiseLeaveReport(empdata.EmpCode, 1, LeaveYearId); LeaveYearlyReportViewModel sickleave = new LeaveYearlyReportViewModel(); sickleave = _LeaveAddAdmin.YearlyOfficewiseLeaveReport(empdata.EmpCode, 2, LeaveYearId); LeaveYearlyReportViewModel casualleave = new LeaveYearlyReportViewModel(); casualleave = _LeaveAddAdmin.YearlyOfficewiseLeaveReport(empdata.EmpCode, 3, LeaveYearId); LeaveYearlyReportViewModel compensationLeave = new LeaveYearlyReportViewModel(); compensationLeave = _LeaveAddAdmin.YearlyOfficewiseLeaveReport(empdata.EmpCode, 9, LeaveYearId); MultipleLeaveYearlyReportViewModel single = new MultipleLeaveYearlyReportViewModel() { EmpName = empdbdata.Name, DesgName = desgndata.DsgName, OfficeName = _officeService.GetOfficeName(OfficeId), EmpCode = empdata.EmpCode, H_BalanceDays = homeleave.BalanceDays, H_TotalLeaveDays = homeleave.TotalLeaveDays, H_TotalTaken = homeleave.TotalTaken, H_PrevYearLeaveDays = homeleave.PrevYearBalance, H_ThisYearLeaveDays = homeleave.ThisYearEarned, S_BalanceDays = sickleave.BalanceDays, S_TotalLeaveDays = sickleave.TotalLeaveDays, S_TotalTaken = sickleave.TotalTaken, Ca_BalanceDays = casualleave.BalanceDays, Ca_TotalLeaveDays = casualleave.TotalLeaveDays, Ca_TotalTaken = casualleave.TotalTaken, Co_BalanceDays = compensationLeave.BalanceDays, Co_TotalLeaveDays = compensationLeave.TotalLeaveDays, Co_TotalTaken = compensationLeave.TotalTaken, }; masterRecord.Add(single); } return(View(masterRecord)); }