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));
        }