/// <summary>
/// Phuong thuc lay thong tin tat ca anh quang cao
/// </summary>
public static DataTable Thongtin_AnhQuangCao()
{
SqlCommand cmd = new SqlCommand("Thongtin_AnhQuangCao");
cmd.CommandType = CommandType.StoredProcedure;
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc lay thong tin tat ca nhom san pham
/// </summary>
public static DataTable Thongtin_NhomSanPham()
{
SqlCommand cmd = new SqlCommand("Thongtin_NhomSanPham");
cmd.CommandType = CommandType.StoredProcedure;
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc lay thong tin tat ca danh muc san pham
/// </summary>
public static DataTable Thongtin_DanhMucSP()
{
SqlCommand cmd = new SqlCommand("Thongtin_DanhMucSP");
cmd.CommandType = CommandType.StoredProcedure;
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc lay thong tin tat ca ChiTietDonHang
/// </summary>
public static DataTable Thongtin_ChiTietDonHang()
{
SqlCommand cmd = new SqlCommand("Thongtin_ChiTietDonHang");
cmd.CommandType = CommandType.StoredProcedure;
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc xoa anh quang cao theo MaAnh
/// </summary>
/// <param name="MaAnh"></param>
public static void Delete_AnhQuangCao(string MaAnh)
{
SqlCommand cmd = new SqlCommand("Delete_AnhQuangCao");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaAnh", MaAnh);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc lay thong tin tat ca anh quang cao theo MaNhom
/// </summary>
/// <param name="MaNhom"></param>
/// <returns></returns>
public static DataTable Thongtin_AnhQuangCao_By_MaNhom(string MaNhom)
{
SqlCommand cmd = new SqlCommand("Thongtin_AnhQuangCao_By_MaNhom");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNhom", MaNhom);
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc lay thong tin tat ca danh muc san pham theo MaDanhMucCha
/// </summary>
/// <param name="MaDanhMucCha"></param>
/// <returns></returns>
public static DataTable Thongtin_DanhMucSP_By_MaDanhMucCha(string MaDanhMucCha)
{
SqlCommand cmd = new SqlCommand("Thongtin_DanhMucSP_By_MaDanhMucCha");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaDanhMucCha", MaDanhMucCha);
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc lay thong tin tat ca nhom quang cao theo vitri
/// </summary>
/// <param name="Vitri"></param>
/// <returns></returns>
public static DataTable Thongtin_NhomQuangCao_By_Vitri(string Vitri)
{
SqlCommand cmd = new SqlCommand("Thongtin_NhomQuangCao_By_Vitri");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Vitri", Vitri);
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc lay thong tin tat ca tai khoan theo TenDangNhap
/// </summary>
/// <param name="TenDangNhap"></param>
/// <returns></returns>
public static DataTable Thongtin_TaiKhoan_By_TenDangNhap(string TenDangNhap)
{
SqlCommand cmd = new SqlCommand("Thongtin_TaiKhoan_By_TenDangNhap");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenDangNhap", TenDangNhap);
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc xoa tai khoan theo ten dang nhap
/// </summary>
/// <param name="TenDangNhap">Ten dang nhap can xoa</param>
public static void Delete_TaiKhoan(string TenDangNhap)
{
SqlCommand cmd = new SqlCommand("Delete_TaiKhoan");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenDangNhap", TenDangNhap);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc xoa nhom san pham theo MaNhom
/// </summary>
/// <param name="MaNhom">Ma san pham can xoa</param>
public static void Delete_NhomSanPham(string MaNhom)
{
SqlCommand cmd = new SqlCommand("Delete_NhomSanPham");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNhom", MaNhom);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc xoa danh muc san pham theo MaDanhMucSP
/// </summary>
/// <param name="MaDanhMucSP">Ma san pham can xoa</param>
public static void Delete_DanhMucSP(string MaDanhMucSP)
{
SqlCommand cmd = new SqlCommand("Delete_DanhMucSP");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaDanhMucSP", MaDanhMucSP);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc lay thong tin tat ca san pham theo mã sản phẩm
/// </summary>
/// <param name="MaSP"></param>
/// <returns></returns>
public static DataTable Thongtin_SanPham_By_MaSP(string MaSP)
{
SqlCommand cmd = new SqlCommand("Thongtin_SanPham_By_MaSP");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaSP", MaSP);
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc lay thong tin tat ca khach hang bang Email
/// </summary>
/// <returns></returns>
public static DataTable Thongtin_KhachHang_By_Email(string Email)
{
SqlCommand cmd = new SqlCommand("Thongtin_KhachHang_By_Email");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Email", Email);
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Phuong thuc xoa danh muc san pham theo MaDanhMucSP
/// </summary>
/// <param name="MaCauHoiBaoMat"></param>
public static void Delete_CauHoiBaoMat(string MaCauHoiBaoMat)
{
SqlCommand cmd = new SqlCommand("Delete_CauHoiBaoMat");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaCauHoiBaoMat", MaCauHoiBaoMat);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc xoa danh muc san pham theo MaDanhMucSP
/// </summary>
/// <param name="MaQuyen"></param>
public static void Delete_QuyenDangNhap(string MaQuyen)
{
SqlCommand cmd = new SqlCommand("Delete_QuyenDangNhap");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaQuyen", MaQuyen);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc xoa khach hang theo id
/// </summary>
/// <param name="Id_Khach_Hang"></param>
public static void Delete_KhachHang(string Id_Khach_Hang)
{
SqlCommand cmd = new SqlCommand("Delete_KhachHang");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id_Khach_Hang", Id_Khach_Hang);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Them moi 1 cau hoi
/// </summary>
/// <param name="CauHoi"></param>
/// <param name="ret"></param>
public static void Insert_CauHoiBaoMat(string CauHoi, string ret)
{
SqlCommand cmd = new SqlCommand("Insert_CauHoiBaoMat");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CauHoi", CauHoi);
cmd.Parameters.AddWithValue("@ret", ret);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc lay thong tin tat ca san pham theo mã nhóm sản phẩm
/// </summary>
/// <param name="MaNhom"></param>
/// <returns></returns>
public static DataTable Thongtin_SanPham_By_MaNhom(string MaNhom, string SoSPHienThi)
{
SqlCommand cmd = new SqlCommand("Thongtin_SanPham_By_MaNhom");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNhom", MaNhom);
cmd.Parameters.AddWithValue("@SoSPHienThi", SoSPHienThi);
return(SQLDataBase.GetData(cmd));
}
/// <summary>
/// Them moi 1 quyen dang nhap
/// </summary>
/// <param name="TenQuyen"></param>
/// <param name="MaQuyenCha"></param>
/// <param name="ret"></param>
public static void Insert_QuyenDangNhap(string TenQuyen, string MaQuyenCha, string ret)
{
SqlCommand cmd = new SqlCommand("Insert_QuyenDangNhap");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenQuyen", TenQuyen);
cmd.Parameters.AddWithValue("@MaQuyenCha", MaQuyenCha);
cmd.Parameters.AddWithValue("@ret", ret);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin nhom quang cao
/// </summary>
/// <param name="MaNhom"></param>
/// <param name="TenNhom"></param>
/// <param name="Vitri"></param>
public static void Update_NhomQuangCao(string MaNhom, string TenNhom, string Vitri)
{
SqlCommand cmd = new SqlCommand("Update_NhomQuangCao");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNhom", MaNhom);
cmd.Parameters.AddWithValue("@TenNhom", TenNhom);
cmd.Parameters.AddWithValue("@Vitri", Vitri);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin danh muc san pham
/// </summary>
/// <param name="MaDanhMucSP"></param>
/// <param name="TenDanhMucSP"></param>
/// <param name="SoSPHienThi"></param>
public static void Update_DanhMucSP(string MaDanhMucSP, string TenDanhMucSP, string MaDanhMucCha, string SoSPHienThi)
{
SqlCommand cmd = new SqlCommand("Update_DanhMucSP");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaDanhMucSP", MaDanhMucSP);
cmd.Parameters.AddWithValue("@TenDanhMucSP", TenDanhMucSP);
cmd.Parameters.AddWithValue("@MaDanhMucCha", MaDanhMucCha);
cmd.Parameters.AddWithValue("@SoSPHienThi", SoSPHienThi);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin nhom san pham
/// </summary>
/// <param name="MaNhom"></param>
/// <param name="TenNhom"></param>
/// <param name="ThuTu"></param>
/// <param name="SoSPHienThi"></param>
public static void Update_NhomSanPham(string MaNhom, string TenNhom, string ThuTu, string SoSPHienThi)
{
SqlCommand cmd = new SqlCommand("Update_NhomSanPham");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaNhom", MaNhom);
cmd.Parameters.AddWithValue("@TenNhom", TenNhom);
cmd.Parameters.AddWithValue("@ThuTu", ThuTu);
cmd.Parameters.AddWithValue("@SoSPHienThi", SoSPHienThi);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat Menu
/// </summary>
/// <param name="Ma"></param>
/// <param name="TenMenu"></param>
/// <param name="ThuTu"></param>
/// <param name="MaMenuCha"></param>
/// <param name="LienKet"></param>
public static void Update_Menu(string Ma, string TenMenu, string ThuTu, string MaMenuCha, string LienKet)
{
SqlCommand cmd = new SqlCommand("Update_Menu");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ma", Ma);
cmd.Parameters.AddWithValue("@TenMenu", TenMenu);
cmd.Parameters.AddWithValue("@ThuTu", ThuTu);
cmd.Parameters.AddWithValue("@MaMenuCha", MaMenuCha);
cmd.Parameters.AddWithValue("@LienKet", LienKet);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin ChiTietDonHang
/// </summary>
/// <param name="MaChiTiet"></param>
/// <param name="MaSP"></param>
/// <param name="MaDonDatHang"></param>
/// <param name="SoLuongDat"></param>
/// <param name="DonGiaDat"></param>
public static void Update_ChiTietDonHang(string MaChiTiet, string MaSP, string MaDonDatHang, string SoLuongDat, string DonGiaDat)
{
SqlCommand cmd = new SqlCommand("Update_ChiTietDonHang");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaChiTiet", MaChiTiet);
cmd.Parameters.AddWithValue("@MaSP", MaSP);
cmd.Parameters.AddWithValue("@MaDonDatHang", MaDonDatHang);
cmd.Parameters.AddWithValue("@SoLuongDat", SoLuongDat);
cmd.Parameters.AddWithValue("@DonGiaDat", DonGiaDat);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin anh quang cao
/// </summary>
/// <param name="MaAnh"></param>
/// <param name="MaNhom"></param>
/// <param name="TenQuangCao"></param>
/// <param name="Anh"></param>
/// <param name="Thutu"></param>
/// <param name="LienKet"></param>
public static void Update_AnhQuangCao(string MaAnh, string MaNhom, string TenQuangCao, string Anh, string Thutu, string LienKet)
{
SqlCommand cmd = new SqlCommand("Update_AnhQuangCao");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaAnh", MaAnh);
cmd.Parameters.AddWithValue("@MaNhom", MaNhom);
cmd.Parameters.AddWithValue("@TenQuangCao", TenQuangCao);
cmd.Parameters.AddWithValue("@Anh", Anh);
cmd.Parameters.AddWithValue("@Thutu", Thutu);
cmd.Parameters.AddWithValue("@LienKet", LienKet);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin hang hoa
/// </summary>
/// <param name="MaSP"></param>
/// <param name="MaDanhMucSP"></param>
/// <param name="DacDiemSP"></param>
/// <param name="GiaSP"></param>
/// <param name="Anh"></param>
/// <param name="TenSanPham"></param>
/// <param name="MaNhom"></param>
public static void Update_SanPham(string MaSP, string MaDanhMucSP, string DacDiemSP, string GiaSP, string Anh, string TenSanPham, string MaNhom)
{
SqlCommand cmd = new SqlCommand("Update_SanPham");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaSP", MaSP);
cmd.Parameters.AddWithValue("@MaDanhMucSP", MaDanhMucSP);
cmd.Parameters.AddWithValue("@DacDiemSP", DacDiemSP);
cmd.Parameters.AddWithValue("@GiaSP", GiaSP);
cmd.Parameters.AddWithValue("@Anh", Anh);
cmd.Parameters.AddWithValue("@TenSanPham", TenSanPham);
cmd.Parameters.AddWithValue("@MaNhom", MaNhom);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin khach hang
/// </summary>
/// <param name="Id_Khach_Hang"></param>
/// <param name="TenKH"></param>
/// <param name="Facebook"></param>
/// <param name="Email"></param>
/// <param name="MatKhau"></param>
/// <param name="Sdt"></param>
/// <param name="DiaChi"></param>
public static void Update_KhachHang(string Id_Khach_Hang, string TenKH, string Facebook, string Email, string MatKhau, string Sdt, string DiaChi)
{
SqlCommand cmd = new SqlCommand("Update_KhachHang");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id_Khach_Hang", Id_Khach_Hang);
cmd.Parameters.AddWithValue("@TenKH", TenKH);
cmd.Parameters.AddWithValue("@Facebook", Facebook);
cmd.Parameters.AddWithValue("@Email", Email);
cmd.Parameters.AddWithValue("@MatKhau", MatKhau);
cmd.Parameters.AddWithValue("@Sdt", Sdt);
cmd.Parameters.AddWithValue("@DiaChi", DiaChi);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin don hang
/// </summary>
/// <param name="MaDonDatHang"></param>
/// <param name="GhiChu"></param>
/// <param name="NgayTao"></param>
/// <param name="ThanhTien"></param>
/// <param name="TinhTrangDonHang"></param>
/// <param name="Id_Khach_Hang"></param>
/// <param name="TenKH"></param>
/// <param name="SdtKH"></param>
/// <param name="EmailKH"></param>
/// <param name="DiaChi"></param>
public static void Update_DonHang(string MaDonDatHang, string GhiChu, string NgayTao, string ThanhTien, string TinhTrangDonHang, string Id_Khach_Hang, string TenKH, string SdtKH, string EmailKH, string DiaChi)
{
SqlCommand cmd = new SqlCommand("Update_DonHang");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaDonDatHang", MaDonDatHang);
cmd.Parameters.AddWithValue("@GhiChu", GhiChu);
cmd.Parameters.AddWithValue("@NgayTao", NgayTao);
cmd.Parameters.AddWithValue("@ThanhTien", ThanhTien);
cmd.Parameters.AddWithValue("@TinhTrangDonHang", TinhTrangDonHang);
cmd.Parameters.AddWithValue("@Id_Khach_Hang", Id_Khach_Hang);
cmd.Parameters.AddWithValue("@TenKH", TenKH);
cmd.Parameters.AddWithValue("@SdtKH", SdtKH);
cmd.Parameters.AddWithValue("@EmailKH", EmailKH);
cmd.Parameters.AddWithValue("@DiaChi", DiaChi);
SQLDataBase.ExecuteNoneQuery(cmd);
}
/// <summary>
/// Phuong thuc cap nhat thong tin tai khoan
/// </summary>
/// <param name="TenDangNhap"></param>
/// <param name="MatKhau"></param>
/// <param name="EmailDK"></param>
/// <param name="DiaChiDK"></param>
/// <param name="TenDayDu"></param>
/// <param name="MaCauHoiBaoMat"></param>
/// <param name="CauTraLoi"></param>
/// <param name="NgaySinh"></param>
/// <param name="GioiTinh"></param>
/// <param name="MaQuyen"></param>
public static void Update_TaiKhoan(string TenDangNhap, string MatKhau, string EmailDK, string DiaChiDK, string TenDayDu, string MaCauHoiBaoMat, string CauTraLoi, string NgaySinh, string GioiTinh, string MaQuyen)
{
SqlCommand cmd = new SqlCommand("Update_TaiKhoan");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TenDangNhap", TenDangNhap);
cmd.Parameters.AddWithValue("@MatKhau", MatKhau);
cmd.Parameters.AddWithValue("@EmailDK", EmailDK);
cmd.Parameters.AddWithValue("@DiaChiDK", DiaChiDK);
cmd.Parameters.AddWithValue("@TenDayDu", TenDayDu);
cmd.Parameters.AddWithValue("@MaCauHoiBaoMat", MaCauHoiBaoMat);
cmd.Parameters.AddWithValue("@CauTraLoi", CauTraLoi);
cmd.Parameters.AddWithValue("@NgaySinh", NgaySinh);
cmd.Parameters.AddWithValue("@GioiTinh", GioiTinh);
cmd.Parameters.AddWithValue("@MaQuyen", MaQuyen);
SQLDataBase.ExecuteNoneQuery(cmd);
}
