public ActionResult SearchCompleteRequsition(FilteringSearchViewModel filteringSearchViewModels) { var userEmployeeId = GetEmployeeId(); ViewBag.UserEmployeeId = userEmployeeId; var startTime = filteringSearchViewModels.Startdate; var endTime = filteringSearchViewModels.EndDate; var searchingValue = _requisitionManager.Get(c => c.Status == "Complete" && c.IsDeleted == false).Where(r => r.RequestedBy == userEmployeeId || r.EmployeeId == userEmployeeId); var completeRequsitionList = searchingValue.Where(c => c.JourneyStart >= startTime && c.JouneyEnd <= endTime); List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>(); foreach (var item in completeRequsitionList) { var requisitionVM = new RequsitionViewModel(); requisitionVM.Id = item.Id; requisitionVM.Employee = item.Employee; requisitionVM.Form = item.Form; requisitionVM.To = item.To; requisitionVM.Description = item.Description; requisitionVM.JourneyStart = item.JourneyStart; requisitionVM.JouneyEnd = item.JouneyEnd; requsitionViewModels.Add(requisitionVM); } filteringSearchViewModels.RequsitionViewModels = requsitionViewModels; return(PartialView("_CompleteRequsitionPartial", requsitionViewModels)); }
public ActionResult CompleteRequsition() { var userEmployeeId = GetEmployeeId(); ViewBag.UserEmployeeId = userEmployeeId; var searchingValue = _requisitionManager.Get(c => c.Status == "Complete" && c.IsDeleted == false).Where(c => c.EmployeeId == userEmployeeId).OrderByDescending(c => c.JourneyStart);; string todays = DateTime.Today.ToShortDateString(); var todayRequsition = searchingValue.Where(c => c.JouneyEnd.ToShortDateString() == todays); FilteringSearchViewModel filteringSearchViewModel = new FilteringSearchViewModel(); List <RequsitionViewModel> requsitionViewModels = new List <RequsitionViewModel>(); foreach (var item in todayRequsition) { var requisitionVM = new RequsitionViewModel(); requisitionVM.Id = item.Id; requisitionVM.Employee = item.Employee; requisitionVM.Form = item.Form; requisitionVM.To = item.To; requisitionVM.Description = item.Description; requisitionVM.JourneyStart = item.JourneyStart; requisitionVM.JouneyEnd = item.JouneyEnd; requsitionViewModels.Add(requisitionVM); } filteringSearchViewModel.RequsitionViewModels = requsitionViewModels; //var designation = designationManager.GetAll(); //filteringSearchViewModel.Designations = designation; return(View(filteringSearchViewModel)); }