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); }