public void Them(DTO_HoaDon HoaDon)
{
string strSQL = "INSERT INTO HoaDon(MaHD,MaBan,MaKH,MaTK_NV,NgayHoaDon,MaDo_Uong,DonGia,SoLuong,ThanhTien,TrangThai) VALUES ";
strSQL = strSQL + "('" + HoaDon.MaHD + "', '" + HoaDon.MaBan + "','" + HoaDon.MaKH + "','" + HoaDon.MaTK_NV + "',GETDATE(),'" + HoaDon.MaDo_Uong + "'," + HoaDon.DonGia + "," + HoaDon.SoLuong + "," + HoaDon.ThanhTien + ",'0')";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Them(DTO_DoUong MaDo_Uong)
{
string strSQL = "INSERT INTO DoUong(MaDo_Uong,TenDo_Uong,DonGia,SoLuongTon,GhiChu) VALUES ( '" + MaDo_Uong.MaDo_Uong + "',N'" + MaDo_Uong.TenDo_Uong + "'," + MaDo_Uong.DonGia + "," + MaDo_Uong.SoLuongTon + ",N'" + MaDo_Uong.GhiChu + "')";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Sua(DTO_DoUong MaDo_Uong)
{
string strSQL = string.Format(@"UPDATE DoUong set MaDo_Uong = '" + MaDo_Uong.MaDo_Uong + "', TenDo_Uong = N'" + MaDo_Uong.TenDo_Uong + "',DonGia = " + MaDo_Uong.DonGia + ",SoLuongTon = " + MaDo_Uong.SoLuongTon + ",GhiChu = N'" + MaDo_Uong.GhiChu + "' where MaDo_Uong = '" + MaDo_Uong.MaDo_Uong_Sua + "'");
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Xoa(DTO_DoUong MaDo_Uong)
{
string strSQL = "DELETE DoUong where MaDo_Uong = '" + MaDo_Uong.MaDo_Uong + "'";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Xoa(DTO_HoaDon HoaDon)
{
string strSQL = "DELETE HoaDon WHERE MAHD = '" + HoaDon.MaHD + "' ";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Sua(DTO_HoaDon HoaDon)
{
string strSQL = string.Format(@"UPDATE HoaDon set MaDo_Uong = '" + HoaDon.MaDo_Uong + "',DonGia = " + HoaDon.DonGia + ",SoLuong = " + HoaDon.SoLuong + " where MaHD = '" + HoaDon.MaHD + "'");
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Sua(DTO_TaiKhoan_NhanVien TK_NV)
{
string strSQL = string.Format(@"UPDATE TaiKhoan_NhanVien set MaTK_NV = '" + TK_NV.MaTK_NV + "', TenTK_NV = N'" + TK_NV.TenTK_NV + "',MatKhau = '" + TK_NV.MatKhau + "',SoDienThoai = '" + TK_NV.SoDienThoai + "',DiaChi = N'" + TK_NV.DiaChi + "',Quyen = '" + TK_NV.Quyen + "' where MaTK_NV = '" + TK_NV.MaTK_NV_Sua + "'");
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Them(DTO_TaiKhoan_NhanVien TK_NV)
{
string strSQL = "INSERT INTO TaiKhoan_NhanVien(MaTK_NV,TenTK_NV,MatKhau,SoDienThoai,DiaChi,Quyen) VALUES ( '" + TK_NV.MaTK_NV + "',N'" + TK_NV.TenTK_NV + "','" + TK_NV.MatKhau + "',N'" + TK_NV.SoDienThoai + "',N'" + TK_NV.DiaChi + "','" + TK_NV.Quyen + "')";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Them(DTO_Ban MaBan)
{
string strSQL = "INSERT INTO Ban(MaBan,TenBan,SoLuongNguoi,GhiChu) VALUES ( '" + MaBan.MaBan + "',N'" + MaBan.TenBan + "'," + MaBan.SoLuongNguoi + ",N'" + MaBan.GhiChu + "')";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Xoa(DTO_TaiKhoan_NhanVien MaTK_NV)
{
string strSQL = "DELETE TaiKhoan_NhanVien where MaTK_NV = '" + MaTK_NV.MaTK_NV + "'";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Sua(DTO_Ban MaBan)
{
string strSQL = string.Format(@"UPDATE Ban set MaBan = '" + MaBan.MaBan + "', TenBan = N'" + MaBan.TenBan + "',SoLuongNguoi = " + MaBan.SoLuongNguoi + ",GhiChu = N'" + MaBan.GhiChu + "' where MaBan = '" + MaBan.MaBan_Sua + "'");
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Xoa(DTO_Ban MaBan)
{
string strSQL = "DELETE Ban where MaBan = '" + MaBan.MaBan + "'";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Them(DTO_KhachHang MaKH)
{
string strSQL = "INSERT INTO KhachHang(MaKH,TenKH,SoDienThoai,DiaChi) VALUES ( '" + MaKH.MaKH + "',N'" + MaKH.TenKH + "','" + MaKH.SoDienThoai + "',N'" + MaKH.DiaChi + "')";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Sua(DTO_KhachHang MaKH)
{
string strSQL = string.Format(@"UPDATE KhachHang set MaKH = '" + MaKH.MaKH + "', TenKH = N'" + MaKH.TenKH + "',SoDienThoai = '" + MaKH.SoDienThoai + "',DiaChi = N'" + MaKH.DiaChi + "' where MaKH = '" + MaKH.MaKH_Sua + "'");
KetNoiSQL.ExecuteNonQuery(strSQL);
}
public void Xoa(DTO_KhachHang MaKH)
{
string strSQL = "DELETE KhachHang where MaKH = '" + MaKH.MaKH + "'";
KetNoiSQL.ExecuteNonQuery(strSQL);
}
