private void calculateCost(int range)
{
lblBookingId.Text = EditBooking2.TBookingID;
HotelReservationEntities3 h = new HotelReservationEntities3();
var book = from x in h.bookings
where x.bookingid == EditBooking2.TBookingID && x.email == EditBooking2.TEmail
select x;
booking b1 = book.FirstOrDefault();
string roomType = "";
switch (lblRoomType.Text)
{
case "Single": roomType = "s";
break;
case "Double": roomType = "d";
break;
case "Deluxe": roomType = "du";
break;
case "Superior": roomType = "su";
break;
}
b1.roomid = roomType;
lblNumberOfRoom.Text = "1";
var room = from x in h.roomfacilities
where x.roomid == b1.roomid
select x;
roomfacility rm = room.FirstOrDefault();
lblPrice.Text = "$" + rm.roomrent.ToString() + " per room";
lblTotal.Text = "$" + (rm.roomrent * range).ToString();
}
private Boolean showBookingInformation()
{
lblBookingId.Text = EditBooking2.TBookingID;
txtPhoneNo.Text = EditBooking2.TEmail;
HotelReservationEntities3 h = new HotelReservationEntities3();
var book = from x in h.bookings
where x.bookingid == EditBooking2.TBookingID && x.email == EditBooking2.TEmail
select x;
booking b1 = book.FirstOrDefault();
if (book.FirstOrDefault() != null)
{
RegularExpressionValidator2.Visible = false;
txtName.Text = b1.name;
txtPassportNo.Text = b1.passportno;
txtEmail.Text = b1.email;
txtPhoneNo.Text = b1.Phone;
txtCheckInDate.Text = b1.datecheckin.ToShortDateString();
txtCheckOutDate.Text = b1.datecheckout.ToShortDateString();
int range = b1.datecheckout.DayOfYear - b1.datecheckin.DayOfYear + 1;
if (range >= 0)
{
lblDurantionOut.Text = range.ToString();
}
else
{
lblDurantionOut.Text = "0";
}
string roomType = "";
switch (b1.roomid)
{
case "s": roomType = "Single";
break;
case "d": roomType = "Double";
break;
case "du": roomType = "Deluxe";
break;
case "su": roomType = "Superior";
break;
}
lblRoomType.Text = roomType;
lblNumberOfRoom.Text = b1.roomno.ToString();
var room = from x in h.roomfacilities
where x.roomid == b1.roomid
select x;
roomfacility rm = room.FirstOrDefault();
lblPrice.Text = "$" + rm.roomrent.ToString() + " per room";
lblTotal.Text = "$" + (rm.roomrent * range).ToString();
infoPanel.Visible = true;
return(true);
}
else
{
return(false);
}
}
private void changeBooking()
{
lblBookingId.Text = EditBooking2.TBookingID;
HotelReservationEntities3 h = new HotelReservationEntities3();
var book = from x in h.bookings
where x.bookingid == EditBooking2.TBookingID && x.email == EditBooking2.TEmail
select x;
booking b1 = book.FirstOrDefault();
string roomType = "";
switch (lblRoomType.Text)
{
case "Single": roomType = "s";
break;
case "Double": roomType = "d";
break;
case "Deluxe": roomType = "du";
break;
case "Superior": roomType = "su";
break;
}
// int beforeRoomAmounts = Convert.ToInt32(lblNumberOfRoom.Text);
var avail = from x in h.availablities
where x.dateofavailablity >= b1.datecheckin && x.dateofavailablity <= b1.datecheckout && //&& x.roomsavailable >= beforeRoomAmounts
x.roomid == roomType
select x;
foreach (availablity a in avail)
{
a.roomsavailable += 1;
}
b1.name = txtName.Text;
b1.passportno = txtPassportNo.Text;
b1.email = txtEmail.Text;
b1.Phone = txtPhoneNo.Text;
// lblAfterChange.Text = txtPhoneNo.Text;
b1.datecheckin = Convert.ToDateTime(txtCheckInDate.Text);
b1.datecheckout = Convert.ToDateTime(txtCheckOutDate.Text);
b1.roomid = roomType;
lblNumberOfRoom.Text = "1";
var room = from x in h.roomfacilities
where x.roomid == b1.roomid
select x;
roomfacility rm = room.FirstOrDefault();
lblPrice.Text = "$" + rm.roomrent.ToString() + " per room";
lblTotal.Text = "$" + (rm.roomrent).ToString();
//int afterRoomAmounts = Convert.ToInt32(lblNumberOfRoom.Text);
var avail2 = from x in h.availablities
where x.dateofavailablity >= b1.datecheckin && x.dateofavailablity <= b1.datecheckout && //&& x.roomsavailable >= afterRoomAmounts
x.roomid == roomType
select x;
foreach (availablity a in avail2)
{
a.roomsavailable -= 1;
}
h.SaveChanges();
}