public ActionResult PickByDay() { List <string> WeekDays = new List <string> { "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" }; ViewBag.Name = new SelectList(WeekDays); var id = User.Identity.GetUserId(); var usernow = db.Employees.Include(e => e.ApplicationUser).FirstOrDefault(e => e.ApplicationId == id); int zipcode = usernow.ZipCode; PickByDayViewModels models = new PickByDayViewModels(); var customers = db.Customers.Include(c => c.ApplicationUser).Where(c => c.ZipCode == zipcode).ToList(); models.customers = customers; return(View(models)); }
public ActionResult PickByDay(PickByDayViewModels model) { PickByDayViewModels models = new PickByDayViewModels(); string datenow = System.DateTime.Now.ToString("MM/dd/yyyy"); var id = User.Identity.GetUserId(); var usernow = db.Employees.Include(e => e.ApplicationUser).FirstOrDefault(e => e.ApplicationId == id); int zipcode = usernow.ZipCode; var customers = db.Customers.Include(e => e.ApplicationUser).Where(e => e.PickUpDay == model.Day || e.ExtraPickUpDate == datenow && e.ZipCode == zipcode).ToList(); models.customers = customers; List <string> WeekDays = new List <string> { "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" }; ViewBag.Name = new SelectList(WeekDays); return(View(models)); }