public void insert(Class_NhanVien nv)
{
string sql = "INSERT INTO KhachHang(MaNhanVien,TenNhanVien,GioiTinh,NgaySinh,DiaChi,MaQue,DienThoai) VALUES(";
sql += nv.MaNhanVien1 + ",N'" + nv.TenNhanVien1 + "',N'" + nv.GioiTinh1 + "',N'" + nv.NgaySinh1 + "',N'" + nv.DiaChi1 + "',N'" + nv.MaQue1 + "',N'" + nv.DienThoai1 + "')";
query.insert(sql);
}
public void insert(Class_CongDung cd)
{
string sql = "INSERT INTO CongDung(MaCongDung,TenCongDung) VALUES(";
sql += cd.MaCongDung1 + ",N'" + cd.TenCongDung1 + "')";
query.insert(sql);
}
public void insert(Class_HoaDonNhap HDN)
{
string sql = "INSERT INTO KhachHang(MaHoaDonNhap,NgayNhap,MaNhanVien,MaNhaCungCap,TongTien) VALUES(";
sql += HDN.MaHoaDonNhap1 + ",N'" + HDN.NgayNhap1 + "',N'" + HDN.MaNhanVien1 + "',N'" + HDN.MaNhaCungCap1 + "',N'" + HDN.TongTien1 + "')";
query.insert(sql);
}
public void insert(Class_Khach khach)
{
string sql = "INSERT INTO KhachHang(MaKhachHang,TenKhachHang, DiaChi,DienThoai) VALUES(";
sql += khach.MaKhach1 + ",N'" + khach.TenKhach1 + "',N'" + khach.DiaChi1 + "',N'" + khach.DienThoai1 + "')";
query.insert(sql);
}
public void insert(Class_NhaCungCap ncc)
{
string sql = "INSERT INTO NhaCungCap(MaNhaCungCap,TenNhaCungCap,DiaChi,DienThoai) VALUES(";
sql += ncc.MaNhaCungCap1 + ",N'" + ncc.TenNhaCungCap1 + "',N'" + ncc.DiaChi1 + "',N'" + ncc.DienThoai1 + "')";
query.insert(sql);
}
public void insert(Class_NguyenLieu_MonAn NL_MA)
{
string sql = "INSERT INTO NguyenLieu_MonAn(MaMonAn,MaNguyenLieu,SoLuong) VALUES(";
sql += NL_MA.MaMonAn1 + ",N'" + NL_MA.MaNguyenLieu1 + "',N'" + NL_MA.SoLuong1 + "')";
query.insert(sql);
}
public void insert(Class_LoaiMon loai_mon)
{
string sql = "INSERT INTO LoaiMon(MaLoai,TenLoai) VALUES(";
sql += loai_mon.MaLoai1 + ",N'" + loai_mon.TenLoai1 + "')";
query.insert(sql);
}
public void insert(Class_Que que)
{
string sql = "INSERT INTO Que(MaQue,TenQue) VALUES(";
sql += que.MaQue1 + ",N'" + que.TenQue1 + "')";
query.insert(sql);
}
public void insert(Class_ChiTietHoaDonNhap CTHDN)
{
string sql = "INSERT INTO ChiTietHoaDonNhap(MaHoaDonNhap,MaNguyenLieu,SoLuong,DonGia,KhuyenMai,ThanhTien) VALUES(";
sql += CTHDN.MaHoaDonNhap1 + ",N'" + CTHDN.MaNguyenLieu1 + "',N'" + CTHDN.SoLuong1 + "',N'" + CTHDN.DonGia1
+ "',N'" + CTHDN.KhuyenMai1 + "',N'" + CTHDN.ThanhTien1 + "')";
query.insert(sql);
}
public void insert(Class_PhieuDatBan PDB)
{
string sql = "INSERT INTO PhieuDatBan(MaPhieu,MaKhach,MaNhanVien,NgayDat,NgayDung,TongTien) VALUES(";
sql += PDB.MaPhieu1 + ",N'" + PDB.MaKhach1 + "',N'" + PDB.MaNhanVien1 + "',N'" + PDB.NgayDat1 + "',N'"
+ PDB.NgayDung1 + "',N'" + PDB.TongTien1 + "')";
query.insert(sql);
}
public void insert(Class_MonAn mon_an)
{
string sql = "INSERT INTO MonAn(MaMonAn,TenMonAn,MaCongDung,MaLoai,CachLam,YeuCau,DonGia) VALUES(";
sql += mon_an.MaMonAn1 + ",N'" + mon_an.TenMonAn1 + "',N'" + mon_an.MaCongDung1 + "',N'" + mon_an.MaLoai1 + "',N'"
+ mon_an.CachLam1 + "',N'" + mon_an.YeuCau1 + "',N'" + mon_an.DonGia1 + "')";
query.insert(sql);
}
public void insert(Class_NguyenLieu NL)
{
string sql = "INSERT INTO NguyenLieu(MaNguyenLieu,TenNguyenLieu,DonViTinh,SoLuong,DonGiaNhap,DonGiaBan,CongDung,YeuCau,ChongChiDinh) VALUES(";
sql += NL.MaNguyenLieu1 + ",N'" + NL.TenNguyenLieu1 + "',N'" + NL.DonViTinh1 + "',N'" + NL.SoLuong1 + "',N'"
+ NL.DonGiaNhap1 + "',N'" + NL.DonGiaBan1 + "',N'" + NL.CongDung1 + NL.YeuCau1 + "',N'" + NL.ChongChiDinh1 + "')";
query.insert(sql);
}
public void insert(Class_ChiTietPhieuDB CTPDB)
{
string sql = "INSERT INTO ChiTietPhieuDB(MaPhieu,MaMonAn,MaLoai,SoLuong,GiamGia,ThanhTien) VALUES(";
sql += CTPDB.MaPhieu1 + ",N'" + CTPDB.MaMonAn1 + "',N'" + CTPDB.MaLoai1 + "',N'" + CTPDB.SoLuong1 + "',N'"
+ CTPDB.GiamGia1 + "',N'" + CTPDB.ThanhTien1 + "')";
query.insert(sql);
}