public static void Update(KhachHangDTO kh)
{
string sql = "Update KHACHHANG set HoTenKhachHang =('" + kh.HoTenKhachHang + "'),DienThoai=(" + kh.DienThoai + "), DiaChi=('" + kh.DiaChi + "'),Email=('" + kh.Email + "') where MaKhachHang=" + kh.MaKhachHang + "";
DataAccess.ExcuNonQuery(sql);
}
public static bool Delete(HoaDonDTO hd)
{
try
{
string sql = "delete from HOADON where MaHoaDon= " + hd.MaHoaDon + "";
DataAccess.ExcuNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
public static bool Delete(KhachHangDTO kh)
{
try
{
string sql = "delete from KHACHHANG where MaKhachHang= " + kh.MaKhachHang + "";
DataAccess.ExcuNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
public static bool Delete(SachDTO s)
{
try
{
string sql = "delete from SACH where MaSach= " + s.MaSach + "";
DataAccess.ExcuNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
public static bool Delete(PhieuThuDTO pt)
{
try
{
string sql = "delete from PHIEUTHU where MaPhieuThu= " + pt.MaPhieuThu + "";
DataAccess.ExcuNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
public static bool Delete(TheLoaiDTO tl)
{
try
{
string sql = "delete from THELOAI where TenTheLoai= '" + tl.TenTheLoai + "'";
DataAccess.ExcuNonQuery(sql);
return(true);
}
catch
{
return(false);
}
}
static public void Update(ThamSoDTO ts)
{
string sql = "update THAMSO set SoLuongNhapItNhat=(" + ts.SoLuongNhapMin + "),LuongTonItNhat=(" + ts.LuongTonMin + "),NoKhongQua=(" + ts.NoMin + "),LuongTonSauKhiBan=(" + ts.TonSauKhiBan + "),DieuKienThu=(" + ts.DieuKienThu + ") where MaThamSo = " + ts.MaThamSo + "";
DataAccess.ExcuNonQuery(sql);
}
static public void Insert(SachDTO s)
{
string sql = "insert into SACH(TenSach,TacGia,MaTheLoai,GiaBan,SoLuongTon) values('" + s.TenSach + "','" + s.TacGia + "'," + s.MaTheLoai + "," + s.GiaBan + "," + s.SoLuongTon + ")";
DataAccess.ExcuNonQuery(sql);
}
public static void Update(TheLoaiDTO tl)
{
string sql = "Update THELOAI set TenTheLoai ='" + tl.TenTheLoai + "'where MaTheLoai=" + tl.MaTheLoai + "";
DataAccess.ExcuNonQuery(sql);
}
public static void Insert(TheLoaiDTO tl)
{
string sql = "insert into THELOAI(TenTheLoai) values('" + tl.TenTheLoai + "')";
DataAccess.ExcuNonQuery(sql);
}
public static void InsertChitiet(HoaDonDTO hd)
{
string sql = "insert into CHITIETHOADON(MaHoaDon,MaSach,SoLuongMua) values(" + hd.MaHoaDon + "," + hd.MaSach + "," + hd.SoLuongMua + ")";
DataAccess.ExcuNonQuery(sql);
}
public static void Insert(PhieuThuDTO pt)
{
string sql = "insert into PHIEUTHU(NgayThu,SoTienThu,MaKhachHang) values('" + pt.NgayThu + "'," + pt.SoTienThu + "," + pt.MaKhachHang + ")";
DataAccess.ExcuNonQuery(sql);
}
static public void Update(SachDTO s)
{
string sql = "update SACH set TenSach=('" + s.TenSach + "'),TacGia=('" + s.TacGia + "'),MaTheLoai=(" + s.MaTheLoai + "),GiaBan=(" + s.GiaBan + "),SoLuongTon=(" + s.SoLuongTon + ") where MaSach = " + s.MaSach + "";
DataAccess.ExcuNonQuery(sql);
}
public static void UpdateTienNo(KhachHangDTO kh)
{
string sql = "Update KHACHHANG set TienNo=(" + kh.TienNo + ") where MaKhachHang=" + kh.MaKhachHang + "";
DataAccess.ExcuNonQuery(sql);
}
public static void Update(HoaDonDTO hd)
{
string sql = "Update HOADON set NgayLapHoaDon =('" + hd.NgayLapHoaDon + "'),MaSach=(" + hd.MaSach + "), MaKhachHang=(" + hd.MaKhachHang + ") where MaHoaDon=" + hd.MaHoaDon + "";
DataAccess.ExcuNonQuery(sql);
}
public static void Insert(KhachHangDTO kh)
{
string sql = "insert into KHACHHANG(HoTenKhachHang,DienThoai,DiaChi,Email) values('" + kh.HoTenKhachHang + "'," + kh.DienThoai + ",'" + kh.DiaChi + "','" + kh.Email + "')";
DataAccess.ExcuNonQuery(sql);
}
public static void Insert(BaoCaoCongNoDTO bc)
{
string sql = "insert into BAOCAOCONGNO(MaKhachHang,NgayPhatSinh,NoDau,PhatSinh,NoCuoi) values(" + bc.MaKhachHang + ",'" + bc.NgayPhatSinh + "'," + bc.NoDau + ",'" + bc.PhatSinh + "'," + bc.NoCuoi + ")";
DataAccess.ExcuNonQuery(sql);
}
static public void UpdateSoLuongTon(SachDTO s)
{
string sql = "update SACH set SoLuongTon=(" + s.SoLuongTon + ") where MaSach = " + s.MaSach + "";
DataAccess.ExcuNonQuery(sql);
}
static public void Insert(PhieuNhapDTO p)
{
string sql = "insert into CHITIETPHIEU(MaPhieuNhap,MaSach,SoLuongNhap) values(" + p.MaPhieuNhap + "," + p.MaSach + "," + p.SoLuong + ")";
DataAccess.ExcuNonQuery(sql);
}
public static void Update(PhieuThuDTO pt)
{
string sql = "Update PHIEUTHU set NgayThu =('" + pt.NgayThu + "'),SoTienThu=(" + pt.SoTienThu + ") where MaPhieuThu=" + pt.MaPhieuThu + "";
DataAccess.ExcuNonQuery(sql);
}
static public void Insertphieunhap(PhieuNhapDTO p)
{
string sql = "insert into PHIEUNHAP(NgayNhap) values('" + p.NgayNhap + "')";
DataAccess.ExcuNonQuery(sql);
}
public static void Insert(BaoCaoTonDTO bc)
{
string sql = "insert into BAOCAOTON(MaSach,NgayPhatSinh,TonDau,PhatSinh,TonCuoi) values(" + bc.MaSach + ",'" + bc.NgayPhatSinh + "'," + bc.TonDau + ",'" + bc.PhatSinh + "'," + bc.TonCuoi + ")";
DataAccess.ExcuNonQuery(sql);
}
public static void Insert(HoaDonDTO hd)
{
string sql = "insert into HOADON(NgayLapHoaDon,MaKhachHang) values('" + hd.NgayLapHoaDon + "'," + hd.MaKhachHang + ")";
DataAccess.ExcuNonQuery(sql);
}
