public void updateTTBan(int maBan)
{
tblBan b = db.tblBans.Where(t => t.MaBan == maBan).FirstOrDefault();
b.TrangThai = "False";
db.SubmitChanges();
}
public void gopBan(int maBanCu, int maBanMoi)
{
try
{
tblBan bCu = db.tblBans.Where(t => t.MaBan == maBanCu).FirstOrDefault();
tblBan bMoi = db.tblBans.Where(t => t.MaBan == maBanMoi).FirstOrDefault();
tblHoaDon hCu = hd.getMaHDTheoBan(maBanCu);
tblHoaDon hMoi = hd.getMaHDTheoBan(maBanMoi);
List <tblChiTietHD> lstCu = ct.getCTByMaHD(hCu.MaHD).ToList();
List <tblChiTietHD> lstMoi = ct.getCTByMaHD(hMoi.MaHD).ToList();
double sum1 = (double)hCu.TongTienTT;
double sum2 = (double)hCu.TongTienTT;
//cap nhat cac hoa don trung nhau
foreach (tblChiTietHD ctCu in lstCu)
{
foreach (tblChiTietHD ctMoi in lstMoi)
{
if (ctCu.MaMon == ctMoi.MaMon)
{
//cap nhat sl + tong tien
ctCu.SoLuong = ctCu.SoLuong + ctMoi.SoLuong;
ctCu.TongTien = ctCu.TongTien + ctMoi.TongTien;
//xoa chi tiet moi
ct.xoaCTHDByMa(hMoi.MaHD, ctMoi.MaMon);
}
}
}
//them cac hoa don moi
foreach (tblChiTietHD ctMoi in lstMoi)
{
//them
tblChiTietHD c = new tblChiTietHD();
c.MaHD = hCu.MaHD;
c.MaMon = ctMoi.MaMon;
c.SoLuong = ctMoi.SoLuong;
c.TongTien = ctMoi.TongTien;
c.GiamGia = ctMoi.GiamGia;
db.tblChiTietHDs.InsertOnSubmit(c);
//xoa
ct.xoaCTHDByMa(hMoi.MaHD, ctMoi.MaMon);
}
//update tong tien hd
hd.suaHoaDon(hCu.MaHD, (sum1 + sum2));
db.SubmitChanges();
}
catch (Exception ee)
{
}
}
public void loadItemFormOrder(tblHoaDon tblHD)
{
tblBan tblBan = new tblBan();
List <tblHoaDon> listHD = hd.getDSHoaDonChuaThanhToan();
//List<Grid_Item> lst = new List<Grid_Item>();
foreach (tblHoaDon item in listHD)
{
tblBan = ban.getBanByID(item.MaBan);
Grid_Item user;
user = new Grid_Item(tblBan.KhuVuc, tblBan.TenBan, Convert.ToDouble(item.TongTienTT.ToString()), item.TGVao.ToString(), item.MaHD, item.MaBan);
//lst.Add(user);
flowLayoutPanel_TrangOrder.Controls.Add(user);
}
}
public void loadDataToLabel()
{
ModuleConvert module = new ModuleConvert();
lbl_MaHD.Text = "Số HĐ: " + hoaDon.MaHD;
try
{
lbl_SoTien.Text = module.convertCurrency(Convert.ToDouble(hoaDon.TongTienTT)) + " VNĐ";
}
catch (Exception ex)
{
MessageBox.Show("Trường tiền không hợp lệ");
}
lbl_TGRa.Text = "Thời gian ra: " + hoaDon.TGRa;
lbl_TGVao.Text = "Thời gian vào: " + hoaDon.TGVao;
if (nv.getTenNhanVienByMaNV(hoaDon.MaNV) == null || nv.getTenNhanVienByMaNV(hoaDon.MaNV) == String.Empty)
{
MessageBox.Show("Tên nhân viên không hợp lệ");
lbl_ThuNgan.Text = "Thu ngân: " + " unknown";
}
else
{
lbl_ThuNgan.Text = "Thu ngân: " + nv.getTenNhanVienByMaNV(hoaDon.MaNV);
}
tblBan ban_cls = new tblBan();
if (ban.getBanByID(hoaDon.MaBan) == null)
{
MessageBox.Show("Mã bàn không hợp lệ");
lbl_ban.Text = "Bàn: " + "unknown";
lbl_KhuVuc.Text = "Khu vực: " + "unknown";
}
else
{
ban_cls = ban.getBanByID(hoaDon.MaBan);
lbl_ban.Text = ban_cls.TenBan;
lbl_KhuVuc.Text = "Khu vực: " + ban_cls.KhuVuc;
}
}
