public ActionResult Edit(MyBooking mybooking)
{
if (ModelState.IsValid)
{
var Check = (mybooking.BookingDate - DateTime.Now).TotalDays;
if (Check > 15)
{
db.Entry(mybooking).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("MyBookings"));
}
else
{
ViewBag.Sorry = "Sorry, You can't edit your booking in less than 15 days of booking date";
}
}
return(View());
}
public ActionResult Details(int id)
{
MyBooking booking = db.MyBookings.Single(a => a.Id == id);
return(View(booking));
}
public ActionResult Book(MyBooking booking)
{
int id = (int)Session["HallId"];
ViewBag.BookedDays = db.MyBookings.Where(a => a.HallId == id).Select(a => a.BookingDate).ToList();
ViewBag.Service1 = db.Halls.Where(a => a.Id == id).Select(a => a.AdditionalService).Single();
ViewBag.Service2 = db.Halls.Where(a => a.Id == id).Select(a => a.Service2).Single();
ViewBag.Service3 = db.Halls.Where(a => a.Id == id).Select(a => a.Service3).Single();
ViewBag.Service4 = db.Halls.Where(a => a.Id == id).Select(a => a.Service4).Single();
ViewBag.Service5 = db.Halls.Where(a => a.Id == id).Select(a => a.Service5).Single();
ViewBag.Service6 = db.Halls.Where(a => a.Id == id).Select(a => a.Service6).Single();
ViewBag.Service7 = db.Halls.Where(a => a.Id == id).Select(a => a.Service7).Single();
ViewBag.Service8 = db.Halls.Where(a => a.Id == id).Select(a => a.Service8).Single();
ViewBag.Service9 = db.Halls.Where(a => a.Id == id).Select(a => a.Service9).Single();
booking.HallId = id;
booking.UserId = User.Identity.GetUserId();
if (ModelState.IsValid)
{
char[] seperator = { ':' };
string s = db.MyBookings.Where(a => a.HallId == id && a.BookingDate == booking.BookingDate).Select(a => a.StartTime).Single();
string[] StartDbArray = s.Split(seperator);
int DbStart = Convert.ToInt32(StartDbArray[0]);
string e = db.MyBookings.Where(a => a.HallId == id && a.BookingDate == booking.BookingDate).Select(a => a.EndTime).Single();
string[] EndDbArray = e.Split(seperator);
int DbEnd = Convert.ToInt32(EndDbArray[0]);
string[] StartBookingArray = booking.StartTime.Split(seperator);
int bookingStart = int.Parse(StartBookingArray[0]);
string[] EndBookingArray = booking.EndTime.Split(seperator);
int bookingEnd = int.Parse(EndBookingArray[0]);
if (bookingStart > DbStart && bookingEnd < DbEnd)
{
ViewBag.Failure = "Sorry, the hall is booked during this interval";
}
else if (bookingStart < DbStart && bookingEnd > DbStart)
{
ViewBag.Failure = "Sorry, the hall is booked during this interval";
}
else
{
db.MyBookings.Add(booking);
db.SaveChanges();
ViewBag.Success = "The Hall Booked Successfully";
}
//int Checking = db.MyBookings.Where(a => a.BookingDate == booking.BookingDate && a.HallId == booking.HallId).Count();
//if (Checking < 1)
//{
// db.MyBookings.Add(booking);
// db.SaveChanges();
// ViewBag.Success = "The Hall Booked Successfully";
//}
//else
//{
// ViewBag.Failure = "Sorry, The Hall is booked during this day";
//}
}
return(View(booking));
}
