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);
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
if (Session["MaBL"] != null)
{
int id = int.Parse(Session["MaBL"].ToString());
BUS_BinhLuan bus = new BUS_BinhLuan();
BinhLuan bl = new BinhLuan();
bl.MABINHLUAN = id;
bl.TIEUDE = txtTieuDe.Text;
bl.NOIDUNG = txtNoiDung.Text;
bl.TRANGTHAI = bool.Parse(ddlTrangThai.SelectedValue);
bus.CapNhatBinhLuan(bl);
Session["MaBL"] = null;
DataTable dt = new DataTable();
int flag = int.Parse(ddlBinhLuan.SelectedValue);
dt = bus.LoadBinhLuan(0, flag);
gvBinhLuan.DataSource = dt.DefaultView;
gvBinhLuan.SelectedIndex = -1;
gvBinhLuan.PageIndex = int.Parse(Session["PageIndex"].ToString());
gvBinhLuan.DataBind();
lblThongBao.Text = "";
}
else
{
lblThongBao.Text = "Chưa chọn bình luận cần cập nhật !";
}
}
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();
}
protected void gvBinhLuan_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
int id = int.Parse(gvBinhLuan.DataKeys[e.NewSelectedIndex].Value.ToString());
Session["MaBL"] = id;
BinhLuan bl = new BinhLuan();
BUS_BinhLuan bus = new BUS_BinhLuan();
bl = bus.LayThongTinBinhLuan(id);
txtHoten.Text = bl.TENKH;
txtTieuDe.Text = bl.TIEUDE;
txtNoiDung.Text = bl.NOIDUNG;
txtTenSP.Text = bl.TENSP;
lblNgayGui.Text = bl.NGAYBL.ToShortDateString();
ddlTrangThai.SelectedValue = bl.TRANGTHAI.ToString();
lblThongBao.Text = "";
}
public void ThemComment()
{
// nhận các tham số truyền theo method post
string tieude = Request["td"];
string noidung = Request["nd"];
int masp = (int)Session["MaSP"];
DateTime date = DateTime.Now;
//lay ma khach hang thong qua username
string username = (string)Session["Username"];
int makh;
BUS_KhachHang bus = new BUS_KhachHang();
if (bus.LayMaKH(username) != -1)
{
makh = bus.LayMaKH(username);
}
else
{
return;
}
//neu nhap day du tieu de va noi dung
if (tieude != null && noidung != null)
{
BUS_BinhLuan bus_bl = new BUS_BinhLuan();
BinhLuan bl = new BinhLuan();
bl.TIEUDE = tieude;
bl.NOIDUNG = noidung;
bl.NGAYBL = date;
bl.MASP = masp;
bl.MAKH = makh;
bl.TRANGTHAI = false;
bus_bl.ThemBinhLuan(bl);
Response.Write("1");
}
//truong hop khong nhap tieu de hoac noi dung
else
{
Response.Write("0");
}
}
public void CapNhatBinhLuan(BinhLuan bl)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.CapNhatBinhLuan(bl);
}
public void ThemBinhLuan(BinhLuan bl)
{
DAO_BinhLuan dao = new DAO_BinhLuan();
dao.ThemBinhLuan(bl);
}
