private void btnPay_Click(object sender, EventArgs e) { bkm = new tbl_BookingMaster { date_booking = DateTime.Now, id_schedule = tbIdschedule.Text, total_price = price }; db.tbl_BookingMasters.InsertOnSubmit(bkm); db.SubmitChanges(); for (int i = 0; i < dgvBookingdetail.RowCount; i++) { bkd = new tbl_BookingDetail { id_booking = bkm.id_booking, id_customer = int.Parse(dgvBookingdetail[0, i].Value.ToString()), no_seat = dgvBookingdetail[6, i].Value.ToString(), id_consumption = int.Parse(dgvBookingdetail[2, i].Value.ToString()), quantity = int.Parse(dgvBookingdetail[4, i].Value.ToString()) }; db.tbl_BookingDetails.InsertOnSubmit(bkd); db.SubmitChanges(); } MessageBox.Show("Thanks for your booking!\n Happy Fligh", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void btnSubmit_Click(object sender, EventArgs e) { if (listView1.Items.Count < 1) { MessageBox.Show("Please registered a Customer", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { DialogResult fc = MessageBox.Show("Are you sure want to add this data?", Application.ProductName, MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (fc == DialogResult.No) { return; } if (total < listView1.Items.Count) { MessageBox.Show("Stock Full", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } else { bok = new tbl_BookingMaster { id_schedule = int.Parse(idSchedule), total_ticket = listView1.Items.Count, booking_date = DateTime.Now, status = "NOT PAID" }; db.tbl_BookingMasters.InsertOnSubmit(bok); db.SubmitChanges(); int id = bok.id_booking; for (int i = 0; i < listView1.Items.Count; i++) { bokd = new tbl_BookingDetail { id_booking = id, id_customer = int.Parse(idCustomer) }; db.tbl_BookingDetails.InsertOnSubmit(bokd); db.SubmitChanges(); } MessageBox.Show("Booking data success!", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information); } } }