//charge back public async Task <IActionResult> ChargeBack() { ADTeam5User user = await _userManager.GetUserAsync(HttpContext.User); List <string> identity = userCheck.checkUserIdentityAsync(user); int userID = user.WorkID; List <ChargeBackViewModel> chargeBackViewModels = b.GetChargeBack("Completed"); if (chargeBackViewModels.Count != 0) { //Viewbag for year and month dropdownlist, need to post back List <int> years = new List <int>(); List <int> months = new List <int>() { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 }; var q = chargeBackViewModels.GroupBy(x => new { x.Year }).Select(y => new { year = y.Key.Year }); foreach (var item in q.ToList()) { years.Add(item.year); } ViewBag.ListOfYear = years; ViewBag.ListOfMonth = months; //Viewbag for department dropdownlist, need to post back var departments = _context.Department.ToList(); if (departments.Count != 0) { ViewBag.ListOfDepartment = departments.Select(x => new Department { DepartmentName = x.DepartmentName, DepartmentCode = x.DepartmentCode }); } } return(View()); }