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()); } } } } }