public TourDay GetLatestTourDay(int TourId) { DateTime today = _dateTime.getToday(); TourDay tourDay = _context.TourDay.Where(r => r.TourId == TourId && r.TourDate <= today).OrderByDescending(r => r.TourDate).FirstOrDefault(); if (tourDay == null) { tourDay = _context.TourDay.Where(r => r.TourId == TourId && r.TourDate > today).OrderBy(r => r.TourDate).FirstOrDefault(); } return(tourDay); }
public async Task <IActionResult> Edit(int id, [Bind("TourDayId,TourId,TourDate")] TourDay tourDay) { if (id != tourDay.TourDayId) { return(NotFound()); } var Tour = _context.Tour .SingleOrDefault(m => m.TourId == tourDay.TourId); if (ModelState.IsValid) { try { _context.Update(tourDay); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TourDayExists(tourDay.TourDayId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index), "TourDay", new { id = Tour.TourId })); } var model = new TourDayEditViewModel(); model.Tour = Tour; model.TourDate = tourDay.TourDate; model.TourDayId = tourDay.TourDayId; model.TourId = tourDay.TourId; return(View(model)); }
public async Task <IActionResult> Create(int?Id, [Bind("TourDayId,TourId,TourDate")] TourDay tourDay) { if (Id == null) { return(NotFound()); } var Tour = _context.Tour.SingleOrDefault(m => m.TourId == Id); if (ModelState.IsValid) { _context.Add(tourDay); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index), "TourDay", new { id = Id })); } var model = new TourDayEditViewModel(); model.Tour = Tour; model.TourDate = tourDay.TourDate; model.TourId = tourDay.TourId; model.TourDayId = tourDay.TourDayId; return(View(model)); }