private void HotelService_Load(object sender, EventArgs e)
{
db = new DisneyDataDataContext();
cboSerivce.DataSource = db.RoomService;
cboSerivce.DisplayMember = "ServiceName";
orderDetail = Global.OrderDetailRecord;
lstService = db.RoomServiceRecord.ToList().Where(x => x.RoomOrderDetailNo == orderDetail.RoomOrderDetailNo).ToList();
dgv.DataSource = lstService.Select(x => new
{
x.RoomService.ServiceName,
x.Quantity
}).ToList();
}
private void lstRooms_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
detail = lstOrderDetail[lstRooms.SelectedIndex];
breakfast = lstBreakfast[lstRooms.SelectedIndex];
storage = lstStorage[lstRooms.SelectedIndex];
nudGuest.Value = detail.GuestNum;
nudChildren.Value = detail.ChildrenNum;
cbBreakfast.Checked = breakfast;
cbStorage.Checked = storage;
txtMain.Text = detail.MainGuest;
txtSpecial.Text = detail.Note;
}
catch (Exception)
{
return;
}
}
private void btnReserve_Click(object sender, EventArgs e)
{
try
{
//Add guest
lstGuests.ForEach(x =>
{
db.Guest.InsertOnSubmit(x);
});
db.SubmitChanges();
//Add order record
var order = new RoomOrder
{
OrderDateTime = DateTime.Now,
GuestNo = Global.OrderGuest.GuestNo,
CouponId = coupon == null ? null : coupon.CouponId,
TicketId = ticket == null ? null : ticket.TicketId,
PaymentMethodNo = null
};
db.RoomOrder.InsertOnSubmit(order);
db.SubmitChanges();
if (coupon != null)
{
db.Coupon.Single(x => x.CouponId == coupon.CouponId).isEnable = false;
db.SubmitChanges();
}
int i = 0;
lstOrderDetail.ForEach(x =>
{
//Add order detail
x.RoomOrderNo = order.RoomOrderNo;
var orderDetail = new RoomOrderDetail()
{
ChildrenNum = x.ChildrenNum,
EndDate = x.EndDate,
RoomOrderNo = x.RoomOrderNo,
StartDate = x.StartDate,
GuestNum = x.GuestNum,
MainGuest = x.MainGuest,
Note = x.Note,
RoomNo = x.RoomNo
};
db.RoomOrderDetail.InsertOnSubmit(orderDetail);
db.SubmitChanges();
//Add breakfast
if (lstBreakfast[i])
{
db.RoomServiceRecord.InsertOnSubmit(new RoomServiceRecord
{
RoomOrderDetailNo = orderDetail.RoomOrderDetailNo,
RoomServiceNo = 12,
Quantity = orderDetail.GuestNum + orderDetail.ChildrenNum
});
db.SubmitChanges();
}
//Add luggage storage service
if (lstStorage[i])
{
db.RoomServiceRecord.InsertOnSubmit(new RoomServiceRecord
{
RoomOrderDetailNo = orderDetail.RoomOrderDetailNo,
RoomServiceNo = 13,
Quantity = 1
});
db.SubmitChanges();
}
i += 1;
});
//Change rooms status
lstRooms.ForEach(x =>
{
var room = db.Room.ToList().Single(r => r.RoomNo == x.RoomNo);
room.RoomStatusNo = 1;
});
db.SubmitChanges();
MessageBox.Show("Reserve successfully", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
Global.BookRooms = new BindingList <Room>();
Global.CheckIn = new DateTime();
Global.CheckOut = new DateTime();
Global.OrderDetails = new List <RoomOrderDetail>();
Global.Breakfast = new List <bool>();
Global.Storage = new List <bool>();
Global.OrderGuest = new Guest();
btnReserve.Enabled = false;
btnBack.Enabled = false;
}
catch (Exception ex)
{
//MessageBox.Show("Reserve error", "Disneyland", MessageBoxButtons.OK, MessageBoxIcon.Information);
MessageBox.Show(ex.ToString());
}
}
