public void CapNhatChiTiet(Chitiet_DatBan ct)
{
var queryChitiet_DatBans =
from Chitiet_DatBans in dbContext.Chitiet_DatBans
where
Chitiet_DatBans.id_datban == ct.id_datban &&
Chitiet_DatBans.id_mon == ct.id_mon
select Chitiet_DatBans;
foreach (var Chitiet_DatBans in queryChitiet_DatBans)
{
Chitiet_DatBans.soluong += ct.soluong;
Chitiet_DatBans.dongia = ct.dongia;
Chitiet_DatBans.thanhtien += ct.thanhtien;
}
dbContext.SubmitChanges();
}
private void btn_ThemMon_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
try
{
if (iddatbanSelected != 0)
{
Chitiet_DatBan ct_datban = new Chitiet_DatBan();
ct_datban.id_datban = iddatbanSelected;
if (gridView_DsMon.EditingValue == null)
{
ct_datban.soluong = 1;
}
else
{
ct_datban.soluong = int.Parse(gridView_DsMon.EditingValue.ToString());
}
ct_datban.dongia = decimal.Parse(gridView_DsMon.GetFocusedRowCellValue(gia).ToString());
ct_datban.thanhtien = ct_datban.soluong * ct_datban.dongia;
ct_datban.id_mon = int.Parse(gridView_DsMon.GetFocusedRowCellValue(id_mon).ToString());
if (datban_bll.KiemTraMonDaCoChua(ct_datban.id_datban, ct_datban.id_mon) > 0)
{
//update
datban_bll.CapNhatChiTiet(ct_datban);
MessageBox.Show("Thêm món thành công");
}
else
{
//add new
datban_bll.ThemChiTiet(ct_datban);
MessageBox.Show("Thêm món mới thành công");
}
LoadChiTietDatBan();
}
else
{
MessageBox.Show("Chọn phiếu đặt bàn");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void ThemChiTiet(Chitiet_DatBan ct)
{
dbContext.Chitiet_DatBans.InsertOnSubmit(ct);
dbContext.SubmitChanges();
}
