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