private void btnCheckOut_Click(object sender, EventArgs e)
{
if (lblNameOfCustomer.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Hãy nhập thông tin khách hàng", "Thông báo");
return;
}
try
{
tbl_Bill bill = new tbl_Bill();
bill.AdminID = SessionInfo.adminID;
bill.BilledDate = int.Parse(DateTime.Today.ToString("yyyyMMdd"));
bill.CustomerID = int.Parse(txtCustomerID.Text);
tbl_Bill.InsertOnSubmit(bill);
db.SubmitChanges();
tbl_Bill curBill = db.tbl_Bills.OrderByDescending(res => res.BillID).FirstOrDefault();
foreach (DataRow dr in dt.Rows)
{
tbl_DetailedBill detailedBill = new tbl_DetailedBill();
detailedBill.IDBill = curBill.BillID;
detailedBill.IDProduct = int.Parse(dr[0].ToString());
detailedBill.UnitPrice = int.Parse(dr[3].ToString());
detailedBill.Amount = int.Parse(dr[2].ToString());
db.tbl_DetailedBills.InsertOnSubmit(detailedBill);
}
db.SubmitChanges();
XtraMessageBox.Show("Thanh toán thành công", "Thông báo");
btnCheckOut.Enabled = false;
btnCreate.Enabled = false;
}
catch (Exception ex)
{
XtraMessageBox.Show("Thanh toán thất bại" + ex.Message, "Thông báo");
}
}
partial void Deletetbl_Bill(tbl_Bill instance);
partial void Updatetbl_Bill(tbl_Bill instance);
partial void Inserttbl_Bill(tbl_Bill instance);
