private void picBookingSave_Click(object sender, EventArgs e) { MyBooking myBook = new MyBooking(); MainWindow.maxCap = 0; bool ok = true; errP.Clear(); //Booking Number try { myBook.BookingNumber = lblBookingNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblBookingNo, MyEx.toString()); } //Check In Date try { myBook.CheckInDate = dtpBookingCheckIn.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpBookingCheckIn, MyEx.toString()); } //Check Out Date try { myBook.CheckOutDate = dtpBookingCheckOut.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpBookingCheckOut, MyEx.toString()); } //Check In Time try { myBook.BookingTime = "13:00"; } catch (MyException MyEx) { ok = false; errP.SetError(lblCheckInTime, MyEx.toString()); } //Customer Number try { myBook.CustomerNumber = cmbCustomerNo.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbCustomerNo, MyEx.toString()); } //Payment Type try { myBook.PaymentTypeID = cmbPayType.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbPayType, MyEx.toString()); } //Party Size try { for (int x = 0; x < 19; x++) { MainWindow.maxCap += Globals.capacity[x]; } if (int.Parse(txtPartySize.Text.Trim()) <= MainWindow.maxCap && int.Parse(txtPartySize.Text.Trim()) > 0) { myBook.PartySize = int.Parse(txtPartySize.Text.Trim()); } else { ok = false; errP.SetError(txtPartySize, "Party size must not exceed the capacity of the room, please enter a value of " + (MainWindow.maxCap) + " or less. Alternatively cancel and select a larger room."); } } catch (MyException MyEx) { ok = false; errP.SetError(txtPartySize, MyEx.toString()); } //Try Adding try { if (ok) { drBooking = dsBelfray.Tables["Booking"].NewRow(); drBooking["bookingNo"] = myBook.BookingNumber; drBooking["checkInDate"] = myBook.CheckInDate; drBooking["checkOutDate"] = myBook.CheckOutDate; drBooking["bookingTime"] = myBook.BookingTime; drBooking["paymentTypeID"] = myBook.PaymentTypeID; drBooking["partySize"] = myBook.PartySize; drBooking["customerNo"] = myBook.CustomerNumber; dsBelfray.Tables["Booking"].Rows.Add(drBooking); daBooking.Update(dsBelfray, "Booking"); int roomRows = dgvRooms.RowCount; for (int x = 0; x < roomRows; x++) { drBookingItem = dsBelfray.Tables["BookingItem"].NewRow(); drBookingItem["bookingNo"] = dgvRooms.Rows[x].Cells[0].Value.ToString(); drBookingItem["itemNo"] = "RM" + dgvRooms.Rows[x].Cells[1].Value.ToString(); drBookingItem["itemQty"] = DBNull.Value; dsBelfray.Tables["BookingItem"].Rows.Add(drBookingItem); } daBookingItem.Update(dsBelfray, "BookingItem"); MessageBox.Show("Booking Added"); cancelled = true; this.Close(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }
private void picBookingSave_Click(object sender, EventArgs e) { MyBooking myBook = new MyBooking(); bool ok = true; errP.Clear(); //Booking Number try { myBook.BookingNumber = lblBookingNo.Text.Trim(); } catch (MyException MyEx) { ok = false; errP.SetError(lblBookingNo, MyEx.toString()); } ////Booking Type //try //{ // myBook.TypeID = "TYP100001"; //} //catch (MyException MyEx) //{ // ok = false; // errP.SetError(lblBookingType, MyEx.toString()); //} //Check In Date try { myBook.CheckInDate = dtpBookingCheckIn.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpBookingCheckIn, MyEx.toString()); } //Check Out Date try { myBook.CheckOutDate = dtpBookingCheckOut.Value; } catch (MyException MyEx) { ok = false; errP.SetError(dtpBookingCheckOut, MyEx.toString()); } //Check In Time try { myBook.BookingTime = "13:00"; } catch (MyException MyEx) { ok = false; errP.SetError(lblCheckInTime, MyEx.toString()); } //Customer Number try { myBook.CustomerNumber = cmbCustomerNo.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbCustomerNo, MyEx.toString()); } //Payment Type try { myBook.PaymentTypeID = cmbPayType.SelectedValue.ToString(); } catch (MyException MyEx) { ok = false; errP.SetError(cmbPayType, MyEx.toString()); } //Party Size try { checkMaxCap(); if (int.Parse(txtPartySize.Text.Trim()) <= MainWindow.maxCap && int.Parse(txtPartySize.Text.Trim()) > 0) { myBook.PartySize = int.Parse(txtPartySize.Text.Trim()); } else { ok = false; errP.SetError(txtPartySize, "Party size must not exceed the capacity of the room, please enter a value of " + (MainWindow.maxCap) + " or less. Alternatively cancel and select a larger room."); } } catch (MyException MyEx) { ok = false; errP.SetError(txtPartySize, MyEx.toString()); } //Try Adding try { if (ok) { drBooking.BeginEdit(); drBooking["checkInDate"] = myBook.CheckInDate; drBooking["checkOutDate"] = myBook.CheckOutDate; drBooking["bookingTime"] = myBook.BookingTime; //drBooking["typeID"] = myBook.TypeID; drBooking["paymentTypeID"] = myBook.PaymentTypeID; //drBooking["roomNo"] = myBook.RoomNo; //drBooking["tableNo"] = myBook.TableNo; drBooking["partySize"] = myBook.PartySize; drBooking["customerNo"] = myBook.CustomerNumber; drBooking.EndEdit(); daBooking.Update(dsBelfray, "Booking"); MessageBox.Show("Booking Updated"); cancelled = true; this.Close(); } } catch (Exception ex) { MessageBox.Show("" + ex.TargetSite + "", ex.Message + "Error!", MessageBoxButtons.AbortRetryIgnore, MessageBoxIcon.Error); } }