public BinhLuan LayThongTinBinhLuan(int MaBL)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.Open();
string qry = "select TieuDe,NoiDung,NgayBL,HoTen,TenSP,TrangThai,s.MaSP as MaSP,k.MaKH as MaKH from BinhLuan b , KhachHang k , SanPham s where b.makh = k.makh and b.masp = s.masp and MaBinhLuan =" + MaBL;
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
BinhLuan bl = new BinhLuan();
bl.TIEUDE = reader.GetString(0);
bl.NOIDUNG = reader.GetString(1);
bl.NGAYBL = reader.GetDateTime(2);
bl.TENKH = reader.GetString(3);
bl.TENSP = reader.GetString(4);
bl.TRANGTHAI = reader.GetBoolean(5);
bl.MAKH = reader.GetInt32(6);
bl.MASP = reader.GetInt32(7);
cmd.Dispose();
reader.Dispose();
dao.Close();
return(bl);
}
public DataTable LoadBinhLuan(int MaSP, int admin)
{
DataTable dt = new DataTable();
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.Open();
String qry = "select TieuDe,NoiDung,NgayBL,HoTen,Email from BinhLuan b , KhachHang k where b.makh = k.makh and b.TrangThai = 'True' and b.masp = " + MaSP;
if (admin == 1)
{
qry = "select MaBinhLuan,TieuDe,NoiDung,NgayBL,HoTen,TenSP,TrangThai from BinhLuan b , KhachHang k , SanPham s where b.makh = k.makh and b.masp = s.masp and b.TrangThai = 'True'";
}
if (admin == 2)
{
qry = "select MaBinhLuan,TieuDe,NoiDung,NgayBL,HoTen,TenSP,TrangThai from BinhLuan b , KhachHang k , SanPham s where b.makh = k.makh and b.masp = s.masp and b.TrangThai = 'False'";
}
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
dt.Load(reader);
}
cmd.Dispose();
reader.Dispose();
dao.Close();
return(dt);
}
public void ThemBinhLuan(BinhLuan bl)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.Open();
string qry = "insert into BinhLuan(TieuDe,NoiDung,NgayBL,MaKH,MaSP) values(" + "'" + bl.TIEUDE + "','" + bl.NOIDUNG + "','" + bl.NGAYBL + "'," + bl.MAKH + "," + bl.MASP + ")";
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
cmd.ExecuteNonQuery();
cmd.Dispose();
dao.Close();
}
public void CapNhatBinhLuan(BinhLuan bl)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.Open();
string qry = "update BinhLuan set TieuDe = '" + bl.TIEUDE + "', NoiDung ='" + bl.NOIDUNG + "',TrangThai ='" + bl.TRANGTHAI + "' where MaBinhLuan =" + bl.MABINHLUAN;
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
cmd.ExecuteNonQuery();
cmd.Dispose();
dao.Close();
}
public void XoaBL(int MaBL)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.Open();
string qry = "delete from BinhLuan where MaBinhLuan =" + MaBL;
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
cmd.ExecuteNonQuery();
cmd.Dispose();
dao.Close();
}
public DataTable LoadBinhLuan(int MaSP)
{
DataTable dt = new DataTable();
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.Open();
String qry = "select TieuDe,NoiDung,NgayBL,HoTen,Email from BinhLuan b , KhachHang k where b.makh = k.makh and b.masp = " + MaSP;
SqlCommand cmd = new SqlCommand(qry, dao.cnn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
dt.Load(reader);
}
cmd.Dispose();
reader.Dispose();
dao.Close();
return(dt);
}
public void CapNhatBinhLuan(BinhLuan bl)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.CapNhatBinhLuan(bl);
}
public void XoaBL(int MaBL)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.XoaBL(MaBL);
}
public BinhLuan LayThongTinBinhLuan(int MaBL)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
return(dao.LayThongTinBinhLuan(MaBL));
}
public DataTable LoadBinhLuan(int MaSP, int Admin)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
return(dao.LoadBinhLuan(MaSP, Admin));
}
public void ThemBinhLuan(BinhLuan bl)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.ThemBinhLuan(bl);
}