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