public async Task <ActionResult> Create([Bind(Include = "Id,VenueId,GuestId,Hours,CheckIn,Date")] VenueUsage venueUsage) { if (venueUsage != null) { venueUsage.Date = DateTime.Now; } if (ModelState.IsValid) { List <VenueUsage> usages = db.VenueUsages.ToList().Where(x => x.VenueId == venueUsage.VenueId).ToList(); foreach (var item in usages) { if ((item.CheckIn >= venueUsage.CheckIn && item.CheckIn <= venueUsage.CheckOut) || item.CheckIn.AddHours(venueUsage.Hours) >= venueUsage.CheckIn) { ModelState.AddModelError("", "Venue is not available!"); return(View(venueUsage)); } } db.VenueUsages.Add(venueUsage); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(venueUsage)); }
public async Task <ActionResult> DeleteConfirmed(int id) { VenueUsage venueUsage = await db.VenueUsages.FindAsync(id); db.VenueUsages.Remove(venueUsage); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "Id,VenueId,GuestId,Hours,CheckIn,Date")] VenueUsage venueUsage) { if (ModelState.IsValid) { db.Entry(venueUsage).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(venueUsage)); }
// GET: VenueUsages/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } VenueUsage venueUsage = await db.VenueUsages.FindAsync(id); if (venueUsage == null) { return(HttpNotFound()); } return(View(venueUsage)); }