DataTable CDTU(Hotel_Booking hotel)
{
DataTable dt = new DataTable();
dt.Columns.Add("Room Type");
dt.Columns.Add("Room Rate Per Night ($)");
dt.Columns.Add("Rooms Required");
dt.Columns.Add("Sub-Total ($)");
DataRow dr = dt.NewRow();
dr["Room Type"] = "Single";
dr["Room Rate Per Night ($)"] = hotel.Hotel.singleRate;
dr["Rooms Required"] = hotel.numSingleRoomsRequired;
dr["Sub-Total ($)"] = hotel.numSingleRoomsRequired * hotel.Hotel.singleRate;
DataRow dr2 = dt.NewRow();
dr2["Room Type"] = "Double";
dr2["Room Rate Per Night ($)"] = hotel.Hotel.doubleRate;
dr2["Rooms Required"] = hotel.numDoubleRoomsRequired;
dr2["Sub-Total ($)"] = hotel.numDoubleRoomsRequired * hotel.Hotel.doubleRate;
var total = (hotel.numSingleRoomsRequired * hotel.Hotel.singleRate) + (hotel.numDoubleRoomsRequired * hotel.Hotel.doubleRate);
totalVal.Text = total.ToString();
dt.Rows.Add(dr);
dt.Rows.Add(dr2);
return(dt);
}
private async void done_button_Click(object sender, EventArgs e)
{
using (var db = new Session3Entities())
{
if (!(dgvlist[0].RoomsRequired > dgvlist[0].AvailableNoOfRooms))
{
if (!(dgvlist[1].RoomsRequired > dgvlist[1].AvailableNoOfRooms))
{
if (((dgvlist[1].RoomsRequired * 2) + dgvlist[0].RoomsRequired) >= Totalpeople)
{
try
{
Hotel_Booking hb = new Hotel_Booking()
{
bookingId = (from a in db.Hotel_Booking
orderby a.bookingId descending
select a.bookingId).First() + 1,
hotelIdFK = hotelID,
userIdFK = LoggedIn.userId,
numDoubleRoomsRequired = dgvlist[1].RoomsRequired,
numSingleRoomsRequired = dgvlist[0].RoomsRequired
};
db.Hotel_Booking.Add(hb);
await db.SaveChangesAsync();
}
catch
{
Hotel_Booking hb = new Hotel_Booking()
{
bookingId = 1,
hotelIdFK = hotelID,
userIdFK = LoggedIn.userId,
numDoubleRoomsRequired = dgvlist[1].RoomsRequired,
numSingleRoomsRequired = dgvlist[0].RoomsRequired
};
db.Hotel_Booking.Add(hb);
await db.SaveChangesAsync();
}
}
else
{
MessageBox.Show("Not Enough Rooms for arrivals");
}
}
else
{
MessageBox.Show("Error, more rooms requested than available");
}
}
else
{
MessageBox.Show("Error, more rooms requested than available");
}
}
}
private void book_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows[0].Cells["Rooms Required"].Value != null && dataGridView1.Rows[1].Cells["Rooms Required"].Value != null)
{
var singleR = dataGridView1.Rows[0].Cells["Rooms Required"].Value.ToString();
var doubleR = dataGridView1.Rows[1].Cells["Rooms Required"].Value.ToString();
using (var db = new Session3Entities())
{
var q2 = db.Hotel_Booking.Where(x => x.userIdFK == users.userId).FirstOrDefault();
oldD = q2.numDoubleRoomsRequired;
oldS = q2.numSingleRoomsRequired;
if (q2 == null)
{
var q = db.Hotels.Where(x => x.hotelId == hotels).FirstOrDefault();
Hotel_Booking hotel_Booking = new Hotel_Booking();
hotel_Booking.hotelIdFK = hotels;
hotel_Booking.userIdFK = users.userId;
if (int.Parse(singleR) <= q.numSingleRoomsTotal - q.numSingleRoomsBooked)
{
hotel_Booking.numSingleRoomsRequired = int.Parse(singleR);
q.numSingleRoomsBooked -= oldS;
q.numSingleRoomsBooked += int.Parse(singleR);
}
else
{
MessageBox.Show("Invalid Amount of Single Rooms!");
return;
}
if (int.Parse(doubleR) <= q.numDoubleRoomsTotal - q.numDoubleRoomsBooked)
{
hotel_Booking.numDoubleRoomsRequired = int.Parse(doubleR);
q.numDoubleRoomsBooked -= oldD;
q.numDoubleRoomsBooked += int.Parse(doubleR);
}
else
{
MessageBox.Show("Invalid Amount of Double Rooms!");
return;
}
db.Hotel_Booking.Add(hotel_Booking);
try
{
db.SaveChanges();
MessageBox.Show("Success!");
this.Hide();
}
catch (Exception es)
{
MessageBox.Show(es.ToString());
}
}
else
{
if (int.Parse(singleR) <= q2.Hotel.numSingleRoomsTotal - q2.Hotel.numSingleRoomsBooked)
{
q2.numSingleRoomsRequired = int.Parse(singleR);
q2.Hotel.numSingleRoomsBooked += int.Parse(singleR);
}
else
{
MessageBox.Show("Invalid Amount of Single Rooms!");
return;
}
if (int.Parse(doubleR) <= q2.Hotel.numDoubleRoomsTotal - q2.Hotel.numDoubleRoomsBooked)
{
q2.numDoubleRoomsRequired = int.Parse(doubleR);
q2.Hotel.numDoubleRoomsBooked += int.Parse(doubleR);
}
else
{
MessageBox.Show("Invalid Amount of Double Rooms!");
return;
}
try
{
db.SaveChanges();
MessageBox.Show("Success!");
this.Hide();
}
catch (Exception es)
{
MessageBox.Show(es.ToString());
}
}
}
}
}
