public static Booking HandleRequest(ReservationRequest rr)
{
Booking returnBooking = null;
if (rr.isValid())
{
dat154_19_2Entities db = new dat154_19_2Entities();
// finner id på rom booket i perioden
var bookedRoomIds = db.Booking
.Where(bo => !(bo.CheckOutDate.CompareTo(rr.CheckInDate) < 0 || bo.CheckInDate.CompareTo(rr.CheckOutDate) > 0))
.Select(bo => bo.RoomId);
// finner rom med nok senger, som ikke er i forrige query, henter ut den med færrest rom av ledige
var bestRoom = db.Room
.Where(rm => rm.NumberOfBeds >= rr.NumberOfBeds)
.Where(rm => !bookedRoomIds.Contains(rm.RoomId))
.OrderBy(rm => rm.NumberOfBeds)
.FirstOrDefault();
if (bestRoom != null)
{
returnBooking = new Booking
{
CustomerUsername = rr.Username,
CheckInDate = rr.CheckInDate,
CheckOutDate = rr.CheckOutDate,
RoomId = bestRoom.RoomId
};
}
}
return(returnBooking);
}
public CheckOutWindow(dat154_19_2Entities dac)
{
booking = dac.Booking;
this.dac = dac;
InitializeComponent();
booking.Load();
ReservationListView.DataContext = booking.Local;
}
public CheckOutWindow(dat154_19_2Entities dac, Booking bookingElement)
{
booking = dac.Booking;
this.dac = dac;
InitializeComponent();
booking.Load();
ReservationListView.DataContext = booking.Local;
RoomNumberTextBox.Text = bookingElement.RoomId.ToString();
CustomerNameTextBox.Text = dac.Customer.FirstOrDefault(cu => cu.Username == bookingElement.CustomerUsername)?.Name;
}
// POST
public ActionResult LoginPost(Customer objUser)
{
if (ModelState.IsValid)
{
using (dat154_19_2Entities db = new dat154_19_2Entities())
{
var obj = db.Customer.FirstOrDefault(a => a.Username.Equals(objUser.Username) && a.Password.Equals(objUser.Password));
if (obj != null)
{
Session["Username"] = obj.Username.ToString();
return(RedirectToAction("LogInForwardActionResult"));
}
}
}
return(RedirectToAction("Login"));
}
public CheckInWindow(dat154_19_2Entities dac)
{
InitializeComponent();
this.dac = dac;
}
