private void InitializeEmpSkillsReportPage(EmployeeSkillsReportViewModel viewModel) { viewModel.FilterTypeDropDownItems = new List <SelectListItem> { new SelectListItem { Text = "Project Account", Value = "acc" }, new SelectListItem { Text = "Project Name", Value = "prj" }, new SelectListItem { Text = "Allocation Type", Value = "allc" }, new SelectListItem { Text = "Employee Name", Value = "emp" }, new SelectListItem { Text = "Tech. SKills", Value = "techs" }, new SelectListItem { Text = "Employee ID", Value = "eid" }, new SelectListItem { Text = "Total Experience", Value = "tot", }, new SelectListItem { Text = "Project Manager", Value = "pm" }, new SelectListItem { Text = "Reporting Manager", Value = "RM" } }; if (string.IsNullOrEmpty(viewModel.FilterBy) == false && Session["FilterValueListItems"] != null) { viewModel.FilterValueDropDownItems = (List <SelectListItem>)Session["FilterValueListItems"]; } }
public ActionResult GetEmpSkillsReport(string filterBy, int?filterValue, string filterText = "", int page = 1) { EmployeeSkillsReportViewModel viewModel = new EmployeeSkillsReportViewModel() { FilterBy = filterBy, FilterValue = filterValue, FilterText = filterText, }; try { InitializeEmpSkillsReportPage(viewModel); viewModel.PagingInfo = new PagingInfo { TotalRecordsCount = 0, RecordsPerPage = RecordsPerPage, CurentPageNo = page }; viewModel.PagingInfo.TotalRecordsCount = techService.GetEmployeeSkillsReportCount(filterBy, filterValue.HasValue ? filterValue.Value.ToString() : "", filterText); if (viewModel.PagingInfo.TotalRecordsCount > 0) { List <EmployeeSkillsReportDto> empSkillsDto = techService.GetEmployeeSkillsReport(filterBy, filterValue.HasValue ? filterValue.Value.ToString() : "", filterText, RecordsPerPage, page); var empReport = Mapper.Map <List <EmployeeSkillsReportDto>, List <EmployeeSkillsReportModel> >(empSkillsDto); foreach (var model in empReport) { float overallExp = 0; if (model.PastExperience.HasValue) { overallExp = model.PastExperience.Value + ((float)DateTime.Today.Subtract(model.DateOfJoin).TotalDays / 365); } else { overallExp = (float)DateTime.Today.Subtract(model.DateOfJoin).TotalDays / 365; } model.OverallExperience = string.Format("{0:0.0}", overallExp); } viewModel.EmployeeSkillsReports = empReport; } else { DisplayWarningMessage("No records to display"); } } catch (Exception exp) { DisplayLoadErrorMessage(exp); } return(View(viewModel)); }