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