private void btnAddBill_Click(object sender, EventArgs e)
{
//check tao hoa don chua
HoaDon hd = db.HoaDons.Where(p => p.MaHoaDon == maHoaDon).SingleOrDefault();
if (hd == null)
{
//chua tao
hd = new HoaDon();
hd.GioVao = DateTime.Now;
hd.MaHoaDon = maHoaDon;
db.HoaDons.InsertOnSubmit(hd);
db.SubmitChanges();
}
ThongTinHoaDon tthd = new ThongTinHoaDon();
tthd.MaHoaDon = maHoaDon;
tthd.MaMon = cbbFood.SelectedValue.ToString();
tthd.SoLuong = (int)nudFood.Value;
tthd.ThanhTien = tthd.SoLuong * int.Parse(txtPrice.Text);
db.ThongTinHoaDons.InsertOnSubmit(tthd);
db.SubmitChanges();
loadFoodBill();
}
// Ấn vào hình đổ dữ liệu món qua dtgv
private void picCafe_Click(object sender, EventArgs e)
{
PictureBox pi = (PictureBox)sender;
string maMon = pi.Tag.ToString();
Mon m = db.Mons.Where(p => p.MaMon == maMon).SingleOrDefault();
HoaDon hd = db.HoaDons.Where(p => p.MaHoaDon == maHoaDon).SingleOrDefault();
if (hd == null)
{
//chua tao
hd = new HoaDon();
hd.GioVao = DateTime.Now;
hd.MaHoaDon = maHoaDon;
db.HoaDons.InsertOnSubmit(hd);
db.SubmitChanges();
}
ThongTinHoaDon tthd = new ThongTinHoaDon();
tthd.MaHoaDon = maHoaDon;
tthd.MaMon = maMon;
tthd.SoLuong = 1;
tthd.ThanhTien = tthd.SoLuong * int.Parse(txtPrice.Text);
db.ThongTinHoaDons.InsertOnSubmit(tthd);
db.SubmitChanges();
loadFoodBill();
}
//Cập nhật món
private void btnEditBill_Click(object sender, EventArgs e)
{
int dongdangchon = dtgvFoodBill.CurrentCell.RowIndex;
string maMon = dtgvFoodBill.Rows[dongdangchon].Cells[0].Value.ToString();
string maHoaDon = dtgvFoodBill.Rows[dongdangchon].Cells[4].Value.ToString();
{
ThongTinHoaDon tthd = db.ThongTinHoaDons.Where(p => p.MaMon == maMon && p.MaHoaDon == maHoaDon).FirstOrDefault();
if (tthd != null)
{
tthd.SoLuong = (int)nudFood.Value;
tthd.ThanhTien = (int)nudFood.Value * tthd.Mon.DonGia;
db.SubmitChanges();
loadFoodBill();
}
}
}
// Xóa 1 món trong bill
private void btnDeleteBill_Click(object sender, EventArgs e)
{
int dongdangchon = dtgvFoodBill.CurrentCell.RowIndex;
string maMon = dtgvFoodBill.Rows[dongdangchon].Cells[0].Value.ToString();
string maHoaDon = dtgvFoodBill.Rows[dongdangchon].Cells[4].Value.ToString();
if (DialogResult.Yes == MessageBox.Show("Bạn có muốn xóa món này không?", "Xác Nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
{
ThongTinHoaDon tthd = db.ThongTinHoaDons.Where(p => p.MaMon == maMon && p.MaHoaDon == maHoaDon).FirstOrDefault();
if (tthd != null)
{
db.ThongTinHoaDons.DeleteOnSubmit(tthd);
db.SubmitChanges();
loadFoodBill();
}
}
}
private void detach_ThongTinHoaDons(ThongTinHoaDon entity)
{
this.SendPropertyChanging();
entity.Mon = null;
}
partial void DeleteThongTinHoaDon(ThongTinHoaDon instance);
partial void UpdateThongTinHoaDon(ThongTinHoaDon instance);
partial void InsertThongTinHoaDon(ThongTinHoaDon instance);
private void attach_ThongTinHoaDons(ThongTinHoaDon entity)
{
this.SendPropertyChanging();
entity.HoaDon = this;
}
