public IActionResult Index(MakeBooking makeBooking)
{
//change makeBooking to Booking and convert to DateTimeOffset
Booking booking = new Booking()
{
ProductId = makeBooking.ProductId,
Date_start = DateTimeOffset.ParseExact($"{makeBooking.Date} {makeBooking.TimeStart}", "yyyy-MM-dd HH:mm", CultureInfo.InvariantCulture),
Date_end = DateTimeOffset.ParseExact($"{makeBooking.Date} {makeBooking.TimeFinish}", "yyyy-MM-dd HH:mm", CultureInfo.InvariantCulture)
};
//retrieve all bookings of the same productclass from DB if any
var currentBookings = _CoWork454Context.Booking
.Where(b => b.Product.ProductClass == makeBooking.ProductClass);
//retrieve all products of the same productClass that isAvailable
var availableProducts = _CoWork454Context.Product
.Where(p => p.ProductClass == makeBooking.ProductClass &&
p.isAvailable == true).ToList();
//if not null, check the incoming booking request times for overlaps with currentbookings
if (currentBookings != null)
{
foreach (var b in currentBookings)
{ //this is an algorithm that checks for overlap
if (b.Date_start <= booking.Date_end && booking.Date_start <= b.Date_end)
{
//if overlap occurs, remove from available products list
availableProducts.Remove(availableProducts.SingleOrDefault(p => p.Id == b.ProductId));
}
}
;
}
;
var userIdCookie = GetEncryptedUserCookie("USER_ID");
if (userIdCookie != null)
{
var LogginUser = _CoWork454Context.User.SingleOrDefault(l => l.Id == Convert.ToInt32(userIdCookie));
ViewData["User"] = LogginUser;
}
ViewData["BookingRequest"] = makeBooking;
ViewData["Products"] = availableProducts;
return(View());
}
public IActionResult AddBooking(MakeBooking makeBooking)
{
//create a booking from makebooking. Parse the date/time strings to a datetimeoffset.
Booking booking = new Booking()
{
ProductId = makeBooking.ProductId,
Date_start = DateTimeOffset.ParseExact($"{makeBooking.Date} {makeBooking.TimeStart}", "yyyy-MM-dd HH:mm", CultureInfo.InvariantCulture),
Date_end = DateTimeOffset.ParseExact($"{makeBooking.Date} {makeBooking.TimeFinish}", "yyyy-MM-dd HH:mm", CultureInfo.InvariantCulture)
};
var orderIdCookie = GetEncryptedUserCookie("ORDER_ID");
if (orderIdCookie == null)
{
// create new order
var order = new Order();
// create bookings list and add to new booking
order.Bookings = new List <Booking>();
order.Bookings.Add(booking);
var userId = GetEncryptedUserCookie("USER_ID");
if (userId != null)
{
order.UserId = Convert.ToInt32(userId);
}
// add the order to the context, save changes to update database
_CoWork454Context.Add(order);
_CoWork454Context.SaveChanges();
// set the orderId in a cookie
SetEncryptedUserCookie("ORDER_ID", order.Id.ToString());
// we are going to show the user
var currentBookings = _CoWork454Context.Booking.Include(o => o.Order)
.Where(o => o.Order.UserId == order.UserId).ToList();
ViewData["Bookings"] = currentBookings;
ViewData["Products"] = _CoWork454Context.Product.ToList();
ViewData["BookingRequest"] = makeBooking;
ViewData["User"] = _CoWork454Context.User
.SingleOrDefault(u => u.Id == order.UserId);
}
else
{
// already has an order
var orderId = Convert.ToInt32(orderIdCookie);
// get the order from the database
var order = _CoWork454Context.Order.
Include(o => o.Bookings)
.SingleOrDefault(o => o.Id == orderId);
if (order.Bookings == null)
{
return(NotFound());
}
// get the existing order item/s with the same ProductID, if any
var existingBookings = _CoWork454Context.Booking
.SingleOrDefault(b => b.OrderId == orderId &&
b.ProductId == booking.ProductId);
if (existingBookings == null)
{
//no bookings of same product on the order so add booking
order.Bookings.Add(booking);
//update database
_CoWork454Context.SaveChanges();
}
else
{
//Already has booking of that product id so make new order
var newOrder = new Order();
// create bookings list and add booking
newOrder.Bookings = new List <Booking>();
newOrder.Bookings.Add(booking);
var userId = GetEncryptedUserCookie("USER_ID");
if (userId != null)
{
newOrder.UserId = Convert.ToInt32(userId);
}
// add the order to the context, save changes to update database
_CoWork454Context.Add(newOrder);
_CoWork454Context.SaveChanges();
// set the orderId in a cookie
SetEncryptedUserCookie("ORDER_ID", newOrder.Id.ToString());
}
//update viewdata
var currentBookings = _CoWork454Context.Booking.Include(o => o.Order)
.Where(o => o.Order.UserId == order.UserId).ToList();
ViewData["Bookings"] = currentBookings;
ViewData["Products"] = _CoWork454Context.Product.ToList();
ViewData["User"] = _CoWork454Context.User
.SingleOrDefault(u => u.Id == order.UserId);
}
return(View("Members"));
}