public IActionResult Index(BookRoom confirmBooking, String btnbookroom)
{
var roomName = _motelContext.RoomTypes.Where(p => p.RoomName == btnbookroom).Select(p => p.RoomName).FirstOrDefault();
var roomTypeID = _motelContext.RoomTypes.Where(p => p.RoomName == roomName).Select(x => x.ID).FirstOrDefault();
var guestID = _motelContext.Guests.Where(p => p.FirstName == confirmBooking.firstName && p.LastName == confirmBooking.lastName).Select(x => x.ID).FirstOrDefault();
var locationID = 1;
Guest g = new Guest()
{
FirstName = confirmBooking.firstName,
LastName = confirmBooking.lastName,
Address = confirmBooking.address,
PhoneNumber = confirmBooking.phoneno,
ZipCode = confirmBooking.zipcode
};
RoomReservation confirmRoomReservation = new RoomReservation()
{
RoomTypeID = roomTypeID,
GuestID = g.ID,
checkIn = confirmBooking.checkinDate,
checkOut = confirmBooking.checkoutDate,
MotelPropertiesID = locationID
};
confirmRoomReservation.Guest = g;
_motelContext.RoomReservations.Add(confirmRoomReservation);
//_motelContext.Entry(confirmRoomReservation).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
_motelContext.SaveChanges();
ViewData["ReservationID"] = confirmRoomReservation.ID;
return(View(confirmRoomReservation));
}
public IActionResult Update(ExistingReservation updateReservation, String Modifybtn)
{
switch (Modifybtn)
{
case "Update Reservation":
var guestID = _motelContext.RoomReservations.Where(p => p.ID == updateReservation.ReservationID).Select(p => p.GuestID).First();
var existingGuest = _motelContext.Guests.Where(p => p.ID == guestID).Select(p => p).First();
if (existingGuest != null)
{
existingGuest.FirstName = updateReservation.FirstName;
existingGuest.LastName = updateReservation.LastName;
existingGuest.Address = updateReservation.Address;
existingGuest.PhoneNumber = updateReservation.PhoneNumber;
existingGuest.ZipCode = updateReservation.ZipCode;
}
_motelContext.SaveChanges();
ViewBag.Message = "Customer Details successfully!";
break;
case "Cancel Reservation":
var reservation = _motelContext.RoomReservations.Where(p => p.ID == updateReservation.ReservationID).Select(p => p).First();
var guest = _motelContext.Guests.Where(p => p.ID == reservation.GuestID).Select(p => p).First();
_motelContext.RoomReservations.Remove(reservation);
_motelContext.Guests.Remove(guest);
_motelContext.SaveChanges();
ViewBag.Message = "The operation is complete. Reservation is now Cancelled!";
break;
}
return(View("UpdateConfirm"));
}
public static void Initialize(NDMotelContext context)
{
context.Database.EnsureCreated();
if (context.Guests.Any())
{
return;
}
var guests = new Guest[]
{
new Guest {
FirstName = "Nirav", LastName = "Desai", Address = "123 Address Ln, FakeCity, IL", ZipCode = "12345", PhoneNumber = "123-456-7890"
},
new Guest {
FirstName = "Test", LastName = "Person", Address = "123 Address Road, FakeCity, IL", ZipCode = "12345", PhoneNumber = "321-456-7890"
}
};
foreach (Guest guest in guests)
{
context.Guests.Add(guest);
}
context.SaveChanges();
var roomType = new RoomType[]
{
new RoomType {
RoomDescription = "Spacious King Size Bed Room", RoomName = "King"
},
new RoomType {
RoomDescription = "Spacious Smoking King Size Bed Room", RoomName = "KingSM"
},
new RoomType {
RoomDescription = "Spacious Queen Size Bed Room", RoomName = "Queen"
},
new RoomType {
RoomDescription = "Spacious Smoking Queen Size Bed Room", RoomName = "QueenSM"
},
new RoomType {
RoomDescription = "Spacious Suite with King Size Bed and Jacuzzi", RoomName = "Suite"
},
new RoomType {
RoomDescription = "Spacious 2 Full Size Bed Room", RoomName = "Full"
}
};
foreach (RoomType RT in roomType)
{
context.RoomTypes.Add(RT);
}
context.SaveChanges();
var motelProperties = new MotelProperties[]
{
new MotelProperties {
Location = "Des Plaines", Address = "123 Des Plaines St., Des Plaines, IL 60016"
},
new MotelProperties {
Location = "Chicago", Address = "123 Chicago Ln., Chicago, IL 60003"
},
new MotelProperties {
Location = "Bartlett", Address = "123 Bartlett St., Bartlett, IL 60103"
}
};
foreach (MotelProperties MP in motelProperties)
{
context.MotelProperties.Add(MP);
}
context.SaveChanges();
var roomReservation = new RoomReservation[]
{
new RoomReservation {
RoomTypeID = 1, GuestID = 1, MotelPropertiesID = 1, checkIn = DateTime.Parse("02-02-2017"), checkOut = DateTime.Parse("02-03-2017")
},
new RoomReservation {
RoomTypeID = 3, GuestID = 2, MotelPropertiesID = 1, checkIn = DateTime.Parse("02-02-2017"), checkOut = DateTime.Parse("02-03-2017")
}
};
foreach (RoomReservation RR in roomReservation)
{
context.RoomReservations.Add(RR);
}
context.SaveChanges();
var roomInventory = new RoomInventory[]
{
new RoomInventory {
RoomTypeID = 1, MotelPropertiesID = 1, HighestPrice = 70, BestPrice = 50, NumberOfRooms = 5
},
new RoomInventory {
RoomTypeID = 2, MotelPropertiesID = 1, HighestPrice = 80, BestPrice = 60, NumberOfRooms = 5
},
new RoomInventory {
RoomTypeID = 3, MotelPropertiesID = 1, HighestPrice = 70, BestPrice = 50, NumberOfRooms = 5
},
new RoomInventory {
RoomTypeID = 4, MotelPropertiesID = 1, HighestPrice = 70, BestPrice = 50, NumberOfRooms = 5
},
new RoomInventory {
RoomTypeID = 5, MotelPropertiesID = 1, HighestPrice = 100, BestPrice = 80, NumberOfRooms = 5
},
new RoomInventory {
RoomTypeID = 6, MotelPropertiesID = 1, HighestPrice = 60, BestPrice = 30, NumberOfRooms = 5
}
};
foreach (RoomInventory RI in roomInventory)
{
context.RoomInventory.Add(RI);
}
context.SaveChanges();
}
