private void ChangeBooking_Load(object sender, EventArgs e) { var Data = new GetData(); var Customer = new SearchCustomer(); var Name = Customer.FindACustomer(Customer_ID); ExtraBedBox.Checked = false; NameLabel.Text = Name.FullName.ToString(); var BookingInfo = Data.GetBooking(_ID); var RoomInfo = Data.GetRoom(int.Parse(BookingInfo.RoomID.ToString())); RoomNumber.Text += int.Parse(RoomInfo.RoomID.ToString()); if (RoomInfo.RoomType == "1") { RoomType.Text += "Single"; } else if (RoomInfo.RoomType == "2") { RoomType.Text += "Double"; } List <BookRoom.Beds> BedList = new List <BookRoom.Beds>(); if (RoomInfo.RoomType == "2" && BookingInfo.Guests > 2) { BedList = Data.GetBeds(RoomInfo.Beds + 1); ExtraBedBox.Checked = true; } else { BedList = Data.GetBeds(RoomInfo.Beds); } RoomPrice.Text += RoomInfo.Price; RoomSize.Text += RoomInfo.Size; if (RoomInfo.Size < 35) { ExtraBedBox.Enabled = false; } else { ExtraBedBox.Enabled = true; } BedsCount = RoomInfo.Beds; GuestsBox.DisplayMember = "Number"; GuestsBox.ValueMember = "Number"; GuestsBox.DataSource = BedList; GuestsBox.SelectedValue = BookingInfo.Guests; dateTimePicker1.Value = BookingInfo.DateStart; dateTimePicker2.Value = BookingInfo.DateEnd; }
public void CreateInvoice(Booking B) { var Get = new GetData(); Room R = Get.GetRoom(int.Parse(B.RoomID.ToString())); decimal Price = decimal.Parse(((B.DateEnd - B.DateStart).TotalDays * R.Price).ToString()); var I = new Invoice(); I.BookingID = B.BookingID; I.Complete = 0; I.BookedDate = DateTime.Now; I.TotalPrice = Price; using (var db = new HotelCaliforniaEntities()) { db.Invoices.Add(I); db.SaveChanges(); } }
private void SaveChangesButton_Click(object sender, EventArgs e) { var Get = new GetData(); var Add = new AdjustData(); Booking B = Get.GetBooking(_ID); Room R = Get.GetRoom(int.Parse(B.RoomID.ToString())); if (Get.CheckRoomAvailable(Customer_ID, R, dateTimePicker1.Value, dateTimePicker2.Value)) { B.DateStart = dateTimePicker1.Value; B.DateEnd = dateTimePicker2.Value; B.Guests = int.Parse(GuestsBox.SelectedValue.ToString()); Add.UpdateBooking(B); this.Close(); } else { NoRoomLabel.Text = "Room not available."; } }
private void RoomBox_SelectedIndexChanged(object sender, EventArgs e) { var Data = new GetData(); ExtraBedBox.Checked = false; var RoomInfo = Data.GetRoom(int.Parse(RoomBox.SelectedValue.ToString())); if (RoomInfo.RoomType == "1") { RoomType.Text = RoomTypeOG + "Single"; } else if (RoomInfo.RoomType == "2") { RoomType.Text = RoomTypeOG + "Double"; } RoomPrice.Text = RoomPriceOG + RoomInfo.Price; RoomSize.Text = RoomSizeOG + RoomInfo.Size; if (RoomInfo.Size < 35) { ExtraBedBox.Enabled = false; } else { ExtraBedBox.Enabled = true; } BedsCount = RoomInfo.Beds; List <Beds> BedList = new List <Beds>(); BedList = Data.GetBeds(RoomInfo.Beds); GuestsBox.DisplayMember = "Number"; GuestsBox.ValueMember = "Number"; GuestsBox.DataSource = BedList; }