public static void CapNhatKhuyenMai()
{
string query = string.Format("Select * from SanPham as sp,KhuyenMai as km where sp.MaKhuyenMai = km.MaKhuyenMai AND sp.MaKhuyenMai != 4 AND km.NgayKetThuc <= '{0}' ", DateTime.Now.ToString("yyyy-MM-dd"));
DataTable sanPhamHetHan = XuLyDuLieu.LayBang(query);
foreach (DataRow row in sanPhamHetHan.Rows)
{
string maSP = row["MaSP"].ToString();
query = string.Format("Update SanPham set MaKhuyenMai = {0} where MaSP = '{1}'", 4, maSP);
XuLyDuLieu.ThucThiCauLenh(query);
}
}
public static bool CapNhatSoLuong(string maCTSP, int soLuong)
{
clsChiTietSP_DTO chiTiet = LayChiTiet(maCTSP);
if (chiTiet != null)
{
int tongSLSP = chiTiet.SoLuong - soLuong;
string query = string.Format("UPDATE ChiTietSanPham SET SoLuong = {0} WHERE MaCTSP = '{1}'", tongSLSP, maCTSP);
return(XuLyDuLieu.ThucThiCauLenh(query) >= 1);
}
else
{
return(false);
}
}
public static int XoaNhaCungCap(string MaNhaCungCap)
{
string query = string.Format("UPDATE NhaCungCap Set TrangThai = 0 WHERE MaNhaCungCap = '{0}'", MaNhaCungCap);
return(XuLyDuLieu.ThucThiCauLenh(query));
}
public static int XoaSanPham(string idSanPham)
{
string query = string.Format("UPDATE ChiTietSanPham SET TrangThai = 0 WHERE MaCTSP ='{0}'", idSanPham);
return(XuLyDuLieu.ThucThiCauLenh(query));
}
public static bool CapNhatKhuyenMai(string maSP, int maKhuyenMai)
{
string query = string.Format("Update SanPham set MaKhuyenMai = {0} where MaSP = '{1}'", maKhuyenMai, maSP);
return(XuLyDuLieu.ThucThiCauLenh(query) >= 1);
}
public static bool CapNhatKhuyenMai(int maCu, int maMoi)
{
string query = string.Format("Update SanPham set MaKhuyenMai = {0} where MaKhuyenMai = {1}", maMoi, maCu);
return(XuLyDuLieu.ThucThiCauLenh(query) >= 1);
}
public static bool XoaTaiKhoan(string tenTaiKhoan)
{
string query = string.Format("UPDATE TaiKhoan SET TrangThai = 0 WHERE TenTaiKhoan ='{0}'", tenTaiKhoan);
return(XuLyDuLieu.ThucThiCauLenh(query) >= 1);
}
public static bool CapNhatDangNhap(string maNV)
{
string query = string.Format("Update TaiKhoan Set LastLogon = '{0}' where MaNV = '{1}'", DateTime.Now, maNV);
return(XuLyDuLieu.ThucThiCauLenh(query) >= 1);
}
public static bool Xoa(int _maKhuyenMai)
{
string query = string.Format("UPDATE KhuyenMai set TrangThai = 0 where MaKhuyenMai = '{0}'", _maKhuyenMai);
return(XuLyDuLieu.ThucThiCauLenh(query) >= 1);
}
