/// <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 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 ChiTietDonHang
/// </summary>
public static DataTable Thongtin_ChiTietDonHang()
{
SqlCommand cmd = new SqlCommand("Thongtin_ChiTietDonHang");
cmd.CommandType = CommandType.StoredProcedure;
return(SQLDataBase.GetData(cmd));
}
/// <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 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 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 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 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 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 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 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));
}
