public IActionResult CheckOutGuest(int id)
{
var room = _context.Rooms
.Where(n => n.Is_ocuppied == true)
.Include(c => c.Guest)
.ToList();
var checkoutdata = new PensionViewModel()
{
RoomList = room
};
ViewBag.FirstNameGuest = room.FirstOrDefault().Guest.Name;
ViewBag.NameGuest = room.FirstOrDefault().Guest.Surname;
var roomtocheckout = _context.Rooms
.Where(n => n.RoomID == id)
.Include(c => c.Guest)
.ToList();
//logowanie błędów
try {
roomtocheckout.FirstOrDefault().Is_ocuppied = false;
roomtocheckout.FirstOrDefault().Guest = null;
_context.SaveChanges();
}
catch (Exception ex)
{
_logger.LogInformation("Hello, this is the bug!", ex);
throw;
}
//new segment - to tests - to refine
var reservationToCheckout = _context.Reserevations
.Where(n => n.Room == roomtocheckout.FirstOrDefault())
.FirstOrDefault();
var numberOfDaysInHotel = DateTime.Now.DayOfYear - reservationToCheckout.Check_in.DayOfYear;
var chargeForStayInHotel = numberOfDaysInHotel * roomtocheckout.FirstOrDefault().ReguralPrice;
if (reservationToCheckout.BreakfestIncluded == true)
{
chargeForStayInHotel = (numberOfDaysInHotel * roomtocheckout.FirstOrDefault().ReguralPrice) + (numberOfDaysInHotel * 80);
}
// end of ne segment
ViewBag.DaysInHotelTotal = $"Days in hotel: {numberOfDaysInHotel}.";
ViewBag.TotalAmount = $"Total amount for stay: {chargeForStayInHotel} PLN.";
//return RedirectToAction(nameof(Index));
return(View(checkoutdata));
}
public IActionResult Pension(EmployeePaymentViewModel employeePayment)
{
decimal? pension = _pensionCalculator.CalculatePension(employeePayment.Deceased, employeePayment.LastFiveYearAverage ?? 0, employeePayment.MonthsWorked ?? 0);
PensionViewModel pensionViewModel = new PensionViewModel(employeePayment);
if (pensionViewModel != null)
{
pensionViewModel.Pension = pension ?? 0;
}
return(View(pensionViewModel));
}
public IActionResult Index()
{
var roomsToDisplay = _context.Rooms
.Include(a => a.Guest)
.ToList();
var roomVM = new PensionViewModel()
{
RoomList = roomsToDisplay
};
return(View(roomVM));
}
public IActionResult CheckinAdd(int id)
{
var roomnumbertocheckin = from n in _context.Reserevations
where n.ReservationID == id
select n.Room.RoomID;
var roomtocheckin = _context.Rooms
.Where(m => m.RoomID == roomnumbertocheckin.First())
.Include(c => c.Guest)
.FirstOrDefault();
var usertocheckin = from n in _context.Reserevations
where n.ReservationID == id
select n.Guest;
//logowanie błędów
try
{
roomtocheckin.Is_ocuppied = true;
roomtocheckin.Guest = usertocheckin.First();
_context.SaveChanges();
}
catch (Exception ex)
{
_logger.LogInformation("Hello, this is the bug!", ex);
throw;
}
//return RedirectToAction(nameof(Index));
ViewBag.CheckinInformation = "Check-in complete.";
ViewBag.CheckinData = $"Room nr {roomtocheckin.Number} has been rented to {usertocheckin.First().Name} {usertocheckin.First().Surname}.";
var roomreservedfortoday = _context.Reserevations
.Where(n => n.Check_in.Date == DateTime.Today.Date)
.Include(c => c.Guest)
.Include(c => c.Room)
.ToList();
var roomnotoccupiedtoday = _context.Rooms
.Where(n => n.Is_ocuppied == false)
.Include(c => c.Guest)
.ToList();
var checkindata = new PensionViewModel
{
ReservedForToday = roomreservedfortoday,
RoomList = roomnotoccupiedtoday.ToList()
};
return(View(checkindata));
}
public IActionResult SelectReservation(int id)
{
var reservationselected = _context.Reserevations
.Where(n => n.ReservationID == id)
.Include(c => c.Guest)
.Include(c => c.Room)
.ToList();
var checkindata = new PensionViewModel
{
ReservationList = reservationselected
};
return(View(checkindata));
}
public IActionResult GetUserReservationHistory(int id)
{
var reservationHistoryOfGuest = _context.ReservationHistoryItems
.Include(c => c.Guest)
.Include(c => c.Room)
.Where(n => n.Guest.GuestID == id)
.ToList();
var ReservationtoDisplay = new PensionViewModel()
{
ReservationHistoryList = reservationHistoryOfGuest
};
return(View(ReservationtoDisplay));
}
public IActionResult Index()
{
var roomsToDisplay = _context.Rooms
.Where(n => n.Is_ocuppied == true)
.Include(c => c.Guest)
.ToList();
var checkoutdata = new PensionViewModel()
{
RoomList = roomsToDisplay
};
return(View(checkoutdata));
}
public IActionResult SelectRoom(int id)
{
var roomselected = _context.Rooms
.Where(n => n.RoomID == id)
.Include(c => c.Guest)
.ToList();
var checkindata = new PensionViewModel
{
RoomList = roomselected
};
ViewBag.RoomId = roomselected.First().RoomID;
ViewBag.RoomNr = roomselected.First().Number;
return(View(checkindata));
}
public IActionResult Index()
{
var ReservationsWithBreakfests = _context.Reserevations
.Where(n => n.Check_in <= DateTime.Now.Date)
.Where(n => n.Check_out >= DateTime.Now.Date)
.Where(n => n.BreakfestIncluded == true)
.Include(c => c.Room)
.Include(c => c.Guest)
.Where(n => n.Room.Is_ocuppied == true)
.ToList();
var ReservationsWithBreakfestsToDisplay = new PensionViewModel
{
ReservationList = ReservationsWithBreakfests
};
return(View(ReservationsWithBreakfestsToDisplay));
}
public IActionResult AddGuest(string nameuser, string surnameuser, string cityuser, string adressuser, string emailuser, string telephonenumberuser)
{
if (nameuser != null && surnameuser != null)
{
try
{
Guest nextguest = new Guest()
{
Name = nameuser,
Surname = surnameuser,
Member_since = DateTime.Now,
City = cityuser,
Adress = adressuser,
EmailAdress = emailuser,
TelephoneNumber = telephonenumberuser
};
_context.Guests.Add(nextguest);
_context.SaveChanges();
}
//logowanie błedów
catch (Exception ex)
{
_logger.LogInformation("Hello, this is the bug!", ex);
throw;
}
}
if (nameuser == null || surnameuser == null)
{
ViewBag.ValidationText = "Please enter correct name and surname!";
}
//return RedirectToAction(nameof(Index));
var guestToDislplay = from n in _context.Guests
select n;
var guestVM = new PensionViewModel()
{
GuestList = guestToDislplay.ToList()
};
//return View(guestVM);
return(RedirectToAction(nameof(Index)));
}
public IActionResult Index()
{
var roomreservedfortoday = _context.Reserevations
.Where(n => n.Check_in.Date == DateTime.Today.Date)
.Include(c => c.Room)
.Include(c => c.Guest)
.ToList();
var roomnotoccupiedtoday = _context.Rooms
.Where(m => m.Is_ocuppied == false)
.Include(c => c.Guest)
.ToList();
var checkindata = new PensionViewModel
{
ReservationList = roomreservedfortoday,
RoomList = roomnotoccupiedtoday
};
return(View(checkindata));
}
public IActionResult CheckinRoomAdd(int id, string name, string surname, DateTime departureDate, bool breakfestincluded)
{
var roomtocheckin = _context.Rooms
.Where(n => n.RoomID == id)
.Include(c => c.Guest)
.ToList();
roomtocheckin.First().Is_ocuppied = true;
var newguest = new Guest();
newguest.Name = name;
newguest.Surname = surname;
newguest.Member_since = DateTime.Today;
//if(!_context.Users.Contains(newguest))
var guestcontain = _context.Guests
.Where(n => n.Name == name)
.Where(m => m.Surname == surname)
.ToList();
ViewBag.CheckinInformation = "Check-in Complete.";
ViewBag.CheckinData = $"Room nr {roomtocheckin.First().Number} has been rented to {name} {surname}";
var roomreservedfortoday = _context.Reserevations
.Where(n => n.Check_in.Date == DateTime.Today.Date)
.Include(c => c.Guest)
.Include(c => c.Room)
.ToList();
var roomnotoccupiedtoday = _context.Rooms
.Where(n => n.Is_ocuppied == false)
.Include(c => c.Guest)
.ToList();
var simpleguest = from n in _context.Guests
select n;
var checkindata = new PensionViewModel
{
ReservedForToday = roomreservedfortoday,
RoomList = roomnotoccupiedtoday,
GuestList = simpleguest.ToList()
};
if (guestcontain.Count() == 0)
{
_context.Guests.Add(newguest);
_context.SaveChanges();
}
var guestToCheckin = _context.Guests
.Where(n => n.Name == newguest.Name)
.Where(n => n.Surname == newguest.Surname)
.First();
roomtocheckin.First().Guest = guestToCheckin;
_context.SaveChanges();
Reservation NewReservation = new Reservation();
NewReservation.Status = 0;
NewReservation.Guest = guestToCheckin;
NewReservation.Room = roomtocheckin.First();
NewReservation.Check_in = DateTime.Now.Date;
NewReservation.Check_out = departureDate;
NewReservation.TotalAmount = (departureDate.DayOfYear - DateTime.Now.DayOfYear) * roomtocheckin.First().ReguralPrice;
NewReservation.BreakfestIncluded = breakfestincluded;
_context.Reserevations.Add(NewReservation);
_context.SaveChanges();
return(View(checkindata));
}
