public int LoadBaiViet()
        {
            List<BAIVIET_getall_newResult> lt = new List<BAIVIET_getall_newResult>();
            BUSBaiViet BUSBaiViet = new BUSBaiViet();
            lt = BUSBaiViet.SelectBAIVIETsAll_new();

            LOAIBAIVIET ltLoaiBaiViet = new LOAIBAIVIET();
            BUSLoaiBaiViet BUSLoaiBaiViet = new BUSLoaiBaiViet();
            if (lt.Count > 0)
            {
                lt.Sort(SortByDate);
                this.GridViewBaiViet.DataSource = lt;
                GridViewBaiViet.DataBind();
                PanelDanhSach.Visible = true;
                PanelMessage.Visible = false;

                //                 for (int i = 0; i < lt.Count; i++)
                //                 {
                //                     GridViewBaiViet.Rows[i].Cells[4].Text = BUSLoaiBaiViet.TimKiem((int)lt[i].MaLoaiBaiViet).TenLoaiBaiViet;
                //                 }
                return lt.Count;
            }
            else
            {
                PanelDanhSach.Visible = false;
                PanelMessage.Visible = true;
                return 0;
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.QueryString["id"] == null)
            {
                Response.Redirect("default.aspx");
            }
            int MaChuyenMuc = int.Parse(Request.QueryString["id"]);
            BUSBaiViet BaiVietBUS = new BUSBaiViet();
            List<BAIVIET> DSBaiViet = BaiVietBUS.LayDSBaiVietTheoChuyenMuc(MaChuyenMuc);

            if (DSBaiViet.Count() == 0)
            {
                Label1.Visible = false;
            }
            else
            {
                Label1.Visible = true;
            }
            string str = @"<table class='dsBaiViet'><thead><tr><th></th></tr></thead><tbody>";
            for (int j = 0; j < DSBaiViet.Count(); j++)
            {
                str += "<tr><td>";
                str += "<div class='tieude'>";
                str += "<img src='images/ico/favicon_002.png' height = '40px width = '40px'/>";
                str += DSBaiViet[j].TieuDe + "</div>";
                str += "<div>";
                if (DSBaiViet[j].HinhAnh!="")
                    str += @"<img style='margin:5px;width:300px;float:left' src='Uploads/" + DSBaiViet[j].HinhAnh + "'/>";
                str += "<a class='tomtat'>" + DSBaiViet[j].TomTat + "</a>";
                str += "<a class='XemTiep' href ='" + "BaiViet.aspx?id=" + DSBaiViet[j].MaBaiViet + "'><i>" + "(Xem tiếp >>)" + "</i></a>";
                str += "</div>";
                str += "<div style='clear:both'><hr width='50%'></div>";
                str += @"</div></td></tr>";
            }
            str += @"</tbody></table>";

            Label1.Text = str;
        }
 protected void Page_Load(object sender, EventArgs e)
 {
     BUSBaiViet BaiVietBUS = new BUSBaiViet();
     List<BAIVIET> DSBaiVietMoiNhat = BaiVietBUS.LayDSBaiVietNoiBatMoiNhat(5);
     string str = "";
     if (DSBaiVietMoiNhat == null)
     {
         return;
     }
     for (int i = 0; i < DSBaiVietMoiNhat.Count(); i++)
     {
         /*str += "<ul>";
         str += "<li><a href='#'>";
         str += DSBaiVietMoiNhat[i].TieuDe;
         str += "</a></li>";
         str += "</ul>";*/
         str += "<p>";
         str += "<img src = 'images/bullet.GIF' height='6px' width='6px'/>";
         str += "<a href ='" + "BaiViet.aspx?id=" + DSBaiVietMoiNhat[i].MaBaiViet + "'>  " + CultureInfo.CurrentUICulture.TextInfo.ToTitleCase/*.CurrentCulture..TextInfo.ToTitleCase*/(DSBaiVietMoiNhat[i].TieuDe.ToLower()) + "</a>";
         str += "</p>";
     }
     lblBaiVietMoiNhat.Text = str;
 }
        protected void LoadBaiViet()
        {
            if (Request.QueryString["id"] == null)
            {
                Response.Redirect("default.aspx");
            }
            else
            {
                BUSBaiViet BaiVietBUS = new BUSBaiViet();
                int MaBaiViet = int.Parse(Request.QueryString["id"]);
                BAIVIET BaiViet = BaiVietBUS.TimKiem(MaBaiViet);
                lblNoiDungBaiViet.Text = BaiViet.NoiDung;
                lblTieuDe.Text = BaiViet.TieuDe;
                lblTieuDe.Font.Bold = true;
                lblTieuDe.Font.Size = 18;

                if (BaiViet.NgayDang != null)
                {
                    lblNgayDang.Text = "Ngày đăng: " + BaiViet.NgayDang.Value.Day + "/" + BaiViet.NgayDang.Value.Month + "/" + BaiViet.NgayDang.Value.Year;
                    lblNgayDang.Font.Italic = true;
                }
                else
                    lblNgayDang.Visible = false;

                BUSTapTinBaiViet busTapTinBaiViet = new BUSTapTinBaiViet();
                List<TAPTINBAIVIET> DStapTinBaiViet = busTapTinBaiViet.TimKiemMaBaiViet(MaBaiViet);
                if (DStapTinBaiViet != null)
                {
                    foreach(TAPTINBAIVIET ttbv in DStapTinBaiViet)
                    {
                        System.Web.UI.WebControls.MenuItem item = new System.Web.UI.WebControls.MenuItem("-" + ttbv.TenTapTin);
                        item.NavigateUrl = ttbv.DuongDan;
                        hplDownloadLink.Items.Add(item);
                    }
                }
            }
        }
        protected void GridViewBaiViet_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "XoaBaiViet")
            {
                List<BAIVIET> lt = new List<BAIVIET>();

                BUSBaiViet busBaiViet = new BUSBaiViet();
                lt = busBaiViet.SelectBAIVIETsAll();

                //Anh Vu
                //kiem tra xem co phai admin hoac tac gia bai viet thi cho xoa
                //
                if (((NGUOIDUNG)Session["LOGIN"]) != null)
                {
                    if (((NGUOIDUNG)Session["LOGIN"]).MaVaiTro == 4)
                    {
                        int idBV = Convert.ToInt32(e.CommandArgument);
                        XoaBaiViet(idBV);
                    }
                    else
                    {
                        BAIVIET baiviet = new BAIVIET();
                        BUSBaiViet bviet = new BUSBaiViet();
                        int idBV = Convert.ToInt32(e.CommandArgument);
                        baiviet = bviet.TimKiemTheoMa(idBV);
                        if (((NGUOIDUNG)Session["LOGIN"]).MaNguoiDung == baiviet.MaNguoiDang)
                        {
                            XoaBaiViet(idBV);
                        }
                        else
                        {
                            ThongBao.Text = "<h1>Không xoá được vì bạn không phải admin hoặc tác giả bài viết !!!</h1>";
                        }
                    }
                }
            }
        }
        protected void btnCapNhat_Click(object sender, EventArgs e)
        {
            try
            {
                //lay thong tin tu textbox
                BAIVIET lpDTO = new BAIVIET();
                lpDTO.MaBaiViet = int.Parse(Request.QueryString["id"]);
                lpDTO.MaLoaiBaiViet = int.Parse(ddlLoaiBaiViet.SelectedValue);
                lpDTO.NgayDang = Convert.ToDateTime(lblNgayDang.Text);
                lpDTO.CapNhat = Convert.ToDateTime(System.DateTime.Now);
                lpDTO.NoiDung = this.txtnoidung.Value;
                lpDTO.TieuDe = this.txttieude.Text;
                lpDTO.TomTat = this.txtTomTat.Text;
                BaiVietTemp = (BAIVIET)Session["BaiVietTemp"];
                BUSBaiViet BUSBaiViet = new BUSBaiViet();
                if (this.fulImage.HasFile)
                {
                   // if (BaiVietTemp.HinhAnh != null && BaiVietTemp.HinhAnh != "")
                   //     System.IO.File.Delete(Server.MapPath("~/Uploads/") + BaiVietTemp.HinhAnh);
                    String currentPath = Server.MapPath("~/Uploads/");
                    String tempPath = Server.MapPath("~/Temp/");
                    String fileName = "anh_dai_dien" + lpDTO.NgayDang.Value.Day.ToString()
                        + lpDTO.NgayDang.Value.Month.ToString() + lpDTO.NgayDang.Value.Year.ToString()
                        + lpDTO.NgayDang.Value.Hour.ToString() + lpDTO.NgayDang.Value.Minute.ToString() + lpDTO.NgayDang.Value.Second.ToString() + ".jpg";
                    lpDTO.HinhAnh = fileName;
                   this.fulImage.SaveAs(tempPath + fileName);
                   SaveImageThumbnail(tempPath + fileName, currentPath + fileName, true);
                }
                else
                {
                    lpDTO.HinhAnh = BaiVietTemp.HinhAnh;
                }
                //Goi ham cap nhat

                if (BUSBaiViet.CapNhat(lpDTO) == 0)
                {
                    //Thong bao
                    lbThongBao.Text = "Cập Nhật Thành Công";
            //                     //Upload tập tin
            //                     List<TAPTINBAIVIET> lTapTinDTO = new List<TAPTINBAIVIET>();
            //                     string savePath = Server.MapPath("~/Uploads\\");
            //
            //                     //string fileName;
            //                     lTapTinDTO = (List<TAPTINBAIVIET>)Session["FileUploadTemp"];
            //                     List<HttpPostedFile> lFile = (List<HttpPostedFile>)Session["FileClientTemp"];
            //                     BUSTapTinBaiViet BUSTapTinBaiViet = new BUSTapTinBaiViet();
            //                     for (int i = 0; i < lTapTinDTO.Count && i < lFile.Count; i++)
            //                     {
            //                         lFile[i].SaveAs(savePath + lTapTinDTO[i].TenTapTin);
            //                         if (BUSTapTinBaiViet.Them(lTapTinDTO[i]) == 0)
            //                         {
            //                             MessageBox.Show("Upload tập tin " + lTapTinDTO[i].TenTapTin + " thất bại.");
            //
            //                         }
               //         }
                    lbThongBao.Visible = true;
                    Response.Redirect("~/administration/BaiViet.aspx?id=" + lpDTO.MaBaiViet.ToString());
                }
                else
                {
                    lbThongBao.Text = "Cập Nhật Không Thành Công";
                    lbThongBao.Visible = true;
                }
            }

            catch
            {
                lbThongBao.Text = "Cập nhật Không Thành Công";
                lbThongBao.Visible = true;
            }
        }
        protected void load()
        {
            //Thong tin nguoi dung

            if (!IsPostBack)
            {
                if (Request.QueryString["id"] != null)
                {
                    //lay ma
                    int mabaiviet = int.Parse(Request.QueryString["id"]);
                    BUSBaiViet BUSBaiViet = new BUSBaiViet();
                    BAIVIET lpDTO = BUSBaiViet.TimKiem(mabaiviet);
                    BaiVietTemp = lpDTO;
                    Session.Add("BaiVietTemp", BaiVietTemp);
                    BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();
                    CHUYENMUC cmDTO = BUSChuyenMuc.LayChuyenMucTheoBaiViet((int)lpDTO.MaLoaiBaiViet);
                    //this.txtngaydang.Text = dt.ToString("dd/MM/yyyy");
                    this.txtnoidung.Value = lpDTO.NoiDung;
                    this.txtTomTat.Text = lpDTO.TomTat;
                    this.txttieude.Text = lpDTO.TieuDe;
                    this.lblNgayDang.Text = lpDTO.NgayDang.ToString();
                    this.lblNgayCapNhat.Text = lpDTO.CapNhat.ToString();
                    if (lpDTO.HinhAnh != "")
                    {
                        this.imgAnhDaiDien.ImageUrl = @"~\Uploads/" + lpDTO.HinhAnh;
                    }
                    // load ddl
                    load_ddlChuyenMuc();
                    ddlChuyenMuc.SelectedValue = cmDTO.MaChuyenMuc.ToString();
                    load_ddlLBV(cmDTO.MaChuyenMuc);
                    ddlLoaiBaiViet.SelectedValue = lpDTO.MaLoaiBaiViet.ToString();
                    int soDong = LoadTapTin();
                    FilterSTT(soDong, 0, 30);
                    PanelBtnUpload.Visible = true;
                }
                else
                {
                    load_ddlChuyenMuc();
                    ddlChuyenMuc.SelectedValue = "1";
                    load_ddlLBV(1);
                    PanelBtnUpload.Visible = false;
                }
            }
        }
        protected void btnXoa_Click(object sender, EventArgs e)
        {
            try
            {
                //lay thong tin tu textbox
                int mabaiviet = int.Parse(Request.QueryString["id"]);

                //xac nhan truoc khi xoa

                    BUSBaiViet BUSBaiViet = new BUSBaiViet();
                    if (BUSBaiViet.Xoa(mabaiviet) == 0)
                    {
                        //Thong bao
                        lbThongBao.Text = "Xóa Thành Công";
                        lbThongBao.Visible = true;
                        Response.Redirect("BaiViet.aspx");
                    }
                    else
                    {
                        lbThongBao.Text = "Xóa Không Thành Công";
                        lbThongBao.Visible = true;
                    }

            }

            catch
            {
                lbThongBao.Text = "Xoa Không Thành Công";
                lbThongBao.Visible = true;
            }
        }
        protected void btnThem_Click(object sender, EventArgs e)
        {
            //txtngaydang.Text = DateTime.Now.ToShortDateString();
            try
            {
                //lay thong tin tu textbox
                BAIVIET lpDTO = new BAIVIET();

                lpDTO.MaLoaiBaiViet = int.Parse(ddlLoaiBaiViet.SelectedValue);
                lpDTO.NgayDang = Convert.ToDateTime(System.DateTime.Now);
                lpDTO.NoiDung = this.txtnoidung.Value;
                lpDTO.TieuDe = this.txttieude.Text;
                //Nhi sửa: thêm phần tóm tắt bài viết 11/8/2010
                lpDTO.TomTat = this.txtTomTat.Text;
                if (this.fulImage.HasFile)
                {
                    String currentPath = Server.MapPath("~/Uploads/");
                    String tempPath = Server.MapPath("~/Temp/");
                    String fileName = "anh_dai_dien" + lpDTO.NgayDang.Value.Day.ToString()
                        + lpDTO.NgayDang.Value.Month.ToString() + lpDTO.NgayDang.Value.Year.ToString()
                        + lpDTO.NgayDang.Value.Hour.ToString() + lpDTO.NgayDang.Value.Minute.ToString() + lpDTO.NgayDang.Value.Second.ToString() + ".jpg";
                    lpDTO.HinhAnh = fileName;
                    this.fulImage.SaveAs(tempPath + fileName);
                    SaveImageThumbnail(tempPath + fileName, currentPath + fileName, true);

                }

                //Goi ham cap nhat
                BUSBaiViet BUSBaiViet = new BUSBaiViet();
                if (BUSBaiViet.Them(lpDTO) == 1)
                {
                    //Thong bao
                    lbThongBao.Text = "Thêm Thành Công";
                    lbThongBao.Visible = true;
                    Response.Redirect("BaiViet.aspx");
                }
                else
                {
                    lbThongBao.Text = "Thêm Không Thành Công";
                    lbThongBao.Visible = true;
                }
            }

            catch
            {
                lbThongBao.Text = "Thêm Không Thành Công";
                lbThongBao.Visible = true;
            }
        }
        protected void XoaChuyenMuc(int maChuyenMuc)
        {
            try
            {

                //xac nhan truoc khi xoa

                BUSBaiViet busBaiViet = new BUSBaiViet();
                List<BAIVIET> lstBaiViet = busBaiViet.LayDSBaiVietTheoChuyenMuc(maChuyenMuc);
                if (lstBaiViet != null)
                {
                    foreach (BAIVIET bv in lstBaiViet)
                    {
                        BUSTapTinBaiViet busTapTin = new BUSTapTinBaiViet();
                        List<TAPTINBAIVIET> lstTapTin = busTapTin.TimKiemMaBaiViet(bv.MaBaiViet);
                        if (lstTapTin != null)
                        {
                            foreach (TAPTINBAIVIET taptin in lstTapTin)
                            {
                                busTapTin.Xoa(taptin.MaTapTin);
                            }
                        }

                        busBaiViet.Xoa(bv.MaBaiViet);
                    }
                }

                    BUSChuyenMuc busChuyenMuc = new BUSChuyenMuc();
                    if (busChuyenMuc.Xoa(maChuyenMuc) == 0)
                    {
                        //Thong bao

                        Response.Redirect("ChuyenMuc.aspx");
                    }

            }

            catch
            {
            }
        }
示例#11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string []HinhDaiDien = new string[5];
             HinhDaiDien[0] = "1.jpg";
             HinhDaiDien[1] = "2.jpg";
             HinhDaiDien[2] = "3.jpg";
             HinhDaiDien[3] = "4.jpg";
             HinhDaiDien[4] = "5.jpg";
             BUSBaiViet BaiVietBUS = new BUSBaiViet();
             List<BAIVIET> DSBaiViet = BaiVietBUS.LayBaiVietMoiNhat(5);
             for (int i = 0; i < 5; i++)
             {
                 if (DSBaiViet[i].HinhAnh == null)
                 {
                     DSBaiViet[i].HinhAnh = HinhDaiDien[i];
                 }
             }
             imgBVNoiBatNhat.ImageUrl = "Uploads/" + DSBaiViet[0].HinhAnh;
             hlBVNoiBatNhat1.NavigateUrl = "BaiViet.aspx?id=" + DSBaiViet[0].MaBaiViet;
             hlTieuDeNoiBatNhat.NavigateUrl = "BaiViet.aspx?id=" + DSBaiViet[0].MaBaiViet;
             hlTieuDeNoiBatNhat.Text = DSBaiViet[0].TieuDe;
             lbTomTat.Text = DSBaiViet[0].TomTat;
             hlXemTiep.NavigateUrl = "BaiViet.aspx?id=" + DSBaiViet[0].MaBaiViet;
             string TinNoiBat = "";
             TinNoiBat += "<div id='imgBVNoiBat'>" + "<img align='left' class='hinhdaidienTinNoiBat' src ='Uploads/" + DSBaiViet[0].HinhAnh + "'  ><a href='" + "BaiViet.aspx?id=" + DSBaiViet[0].MaBaiViet + "'></a></img></div>";
             TinNoiBat += "<div id='BVNoiBatNhatDiv'>";
             TinNoiBat += "<div id='BVNoiBatNhatTitle'><a href='BaiViet.aspx?id=" + DSBaiViet[0].MaBaiViet + "'>" + DSBaiViet[0].TieuDe + "</a>" + "</div>";
             TinNoiBat += "<div id='BVNoiBatNhatContent'>";
             TinNoiBat += DSBaiViet[0].TomTat;
             TinNoiBat += "   <a class='XemTiep' href='" + "BaiViet.aspx?id=" + DSBaiViet[0].MaBaiViet + "'>" +"<i>"+ "(Xem tiếp >>)" +"</i></a>";
             TinNoiBat += "</div>";
             TinNoiBat += "</div>";
             /*TinNoiBat += "</div>";
             TinNoiBat += "<center><hr style='margin: 5px 0px 5px 0px;' width='95%' /></center>";
             TinNoiBat += "</div>";*/

            /*
             lblHinhAnh.Text = "<a href='" + "BaiViet.aspx?id=" + DSBaiViet[0].MaBaiViet + "'>" + "<img src ='Uploads/" + DSBaiViet[0].HinhAnh + "' style ='width:200px; height:200px' />" + "</a>";
             lblTieuDe.Text = "<a href='" + "BaiViet.aspx?id="+ DSBaiViet[0].MaBaiViet + "'>" +DSBaiViet[0].TieuDe + "</a>";
             lblTomTat.Text = DSBaiViet[0].TomTat;*/

             lblHinh1.Text = "<img src ='Uploads/" + DSBaiViet[1].HinhAnh + "' style ='width:125px; max-height:150px' />";
             lblHinh2.Text = "<img src ='Uploads/" + DSBaiViet[2].HinhAnh + "' style ='width:125px; max-height:150px' />";
             lblHinh3.Text = "<img src ='Uploads/" + DSBaiViet[3].HinhAnh + "' style ='width:125px; max-height:150px' />";
             lblHinh4.Text = "<img src ='Uploads/" + DSBaiViet[4].HinhAnh + "' style ='width:125px; max-height:150px' />";

             lblTieuDe1.Text = "<a style='text-align:center' href ='" + "BaiViet.aspx?id=" + DSBaiViet[1].MaBaiViet + "'><span>" + CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(DSBaiViet[1].TieuDe.ToLower()) + "</span></a>";
             lblTieuDe2.Text = "<a style='text-align:center' href ='" + "BaiViet.aspx?id=" + DSBaiViet[2].MaBaiViet + "'><span>" + CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(DSBaiViet[2].TieuDe.ToLower()) + "</span></a>";
             lblTieuDe3.Text = "<a style='text-align:center' href ='" + "BaiViet.aspx?id=" + DSBaiViet[3].MaBaiViet + "'><span>" + CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(DSBaiViet[3].TieuDe.ToLower()) + "</span></a>";
             lblTieuDe4.Text = "<a style='text-align:center' href ='" + "BaiViet.aspx?id=" + DSBaiViet[4].MaBaiViet + "'><span>" + CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(DSBaiViet[4].TieuDe.ToLower()) + "</span></a>";

            string str = "";
               // str += "<link href='css/style-3-col.css' rel='stylesheet' type='text/css' />";

            BUSChuyenMuc ChuyenMucBUS = new BUSChuyenMuc();
            List<CHUYENMUC> DSChuyenMuc = ChuyenMucBUS.SelectCHUYENMUCsAll();
            for (int i = 0; i < DSChuyenMuc.Count(); i++)
            {
                if (DSChuyenMuc[i].TenChuyenMuc == "Thông tin hoạt động")
                {
                    CHUYENMUC temp = DSChuyenMuc[i];
                    DSChuyenMuc.Remove(temp);
                    DSChuyenMuc.Insert(0, temp);
                }
            }
            str += "<div class='column'>";
            for (int i = 0; i < DSChuyenMuc.Count(); i++)
            {

                BUSBaiViet BvBUS = new BUSBaiViet();
                List<BAIVIET> BaiViet = BvBUS.LayBaiVietMoiNhatTheoChuyenMuc(DSChuyenMuc[i].MaChuyenMuc);
                if (BaiViet!= null)
                {
                    str += "<div class='portlet'>";
                    str += "<div class='portlet-header'>";
                    str += DSChuyenMuc[i].TenChuyenMuc;
                    str += "</div>";
                    str += "<div class='portlet-content'>";
                    /*str += "<table cellpadding='10px'><tr><td style='width: 30%' align='center' valign='middle'>";
                    str += "<img src = 'Uploads/" + BaiViet[0].HinhAnh + "' style ='width:170px; height:170px';float:left />";
                    str += "</td><td style='vertical-align:top'>";
                    str += "<a href ='" + "BaiViet.aspx?id=" + BaiViet[0].MaBaiViet + "'><b>" + BaiViet[0].TieuDe + "</b></a><br /><br />";
                    str += BaiViet[0].TomTat;
                    str += "<a href ='" + "BaiViet.aspx?id=" + BaiViet[0].MaBaiViet + "'><i>" + " Xem tiếp ..." + "</i></a><br />";
                    str += "</p></td></tr></table>";*/

                    str += "<div class='imgBaiViet'>";
                    if (BaiViet[0].HinhAnh == null || BaiViet[0].HinhAnh == "")
                    {
                        BaiViet[0].HinhAnh = HinhDaiDien[1];
                    }
                    str += "<a href='" + "BaiViet.aspx?id=" + BaiViet[0].MaBaiViet + "'>" + "<img align='left' class='hinhdaidienTinNoiBat' src ='Uploads/" + BaiViet[0].HinhAnh + "' 	max-height='250px' width = '150px'/></a></div>";
                    str += "<div class='BaiViet'><a class='BaiVietTitle' href='" + "BaiViet.aspx?id=" + BaiViet[0].MaBaiViet + "'><span>" + BaiViet[0].TieuDe + "</span></a><br/><p class='BaiVietContent'>";
                    str += BaiViet[0].TomTat;
                    str += "     </p><a class='XemTiep' href ='" + "BaiViet.aspx?id=" + BaiViet[0].MaBaiViet + "'><i>" + "(Xem tiếp >>)" + "</i></a><br />";
                    str += "</div>";
                    if (BaiViet.Count <= 5)
                    {
                        str += "<div class='RelatedBaiViet'><lu>";
                        for (int j = 1; j < BaiViet.Count; j++)
                        {
                            str += "<li type='circle'><a href ='" + "BaiViet.aspx?id=" + BaiViet[j].MaBaiViet + "'>" + CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(BaiViet[j].TieuDe.ToLower()) + "</a></li>";
                        }
                        str += "</lu></div>";
                    }
                    else
                    {
                        str += "<div class='RelatedBaiViet'><lu>";
                        for (int j = 1; j <= 5; j++)
                        {
                            str += "<li type='circle'><a href ='" + "BaiViet.aspx?id=" + BaiViet[j].MaBaiViet + "'>" + CultureInfo.CurrentUICulture.TextInfo.ToTitleCase(BaiViet[j].TieuDe.ToLower()) + "</a></li>";
                        }
                        str += "</lu></div>";
                    }

                    str += "</div></div>";
                }
            }
            str += "</div>";
            lblChuyenMuc.Text = str;
        }
        protected void btnXoa_Click(object sender, EventArgs e)
        {
            try
            {
                //lay thong tin tu textbox
                int machuyenmuc = int.Parse(Request.QueryString["id"]);
                BUSBaiViet busBaiViet = new BUSBaiViet();
                List<BAIVIET> lstBaiViet = busBaiViet.LayDSBaiVietTheoChuyenMuc(machuyenmuc);
                if (lstBaiViet != null)
                {
                    foreach (BAIVIET bv in lstBaiViet)
                    {
                        BUSTapTinBaiViet busTapTin = new BUSTapTinBaiViet();
                        List<TAPTINBAIVIET> lstTapTin = busTapTin.TimKiemMaBaiViet(bv.MaBaiViet);
                        if (lstTapTin != null)
                        {
                            foreach (TAPTINBAIVIET taptin in lstTapTin)
                            {
                                busTapTin.Xoa(taptin.MaTapTin);
                            }
                        }

                        busBaiViet.Xoa(bv.MaBaiViet);
                    }
                }

                //xac nhan truoc khi xoa

                    //Goi ham xoa
                    BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();
                    if (BUSChuyenMuc.Xoa(machuyenmuc) == 0)
                    {
                        //Thong bao
                        lbThongBao.Text = "Xóa Thành Công";
                        lbThongBao.Visible = true;
                        Response.Redirect("HoatDong.aspx");
                    }

            }

            catch
            {
                lbThongBao.Text = "Xoa Không Thành Công";
                lbThongBao.Visible = true;
            }
        }
        protected void XoaBai(int maloai)
        {
            try
            {

                //xac nhan truoc khi xoa
                BUSBaiViet busBaiViet = new BUSBaiViet();
                List<BAIVIET> lstBaiViet = busBaiViet.TimKiemTheoLoaiBaiViet(maloai);
                if (lstBaiViet != null)
                {
                    foreach (BAIVIET bv in lstBaiViet)
                    {
                        BUSTapTinBaiViet busTapTin = new BUSTapTinBaiViet();
                        List<TAPTINBAIVIET> lstTapTin = busTapTin.TimKiemMaBaiViet(bv.MaBaiViet);
                        if (lstTapTin != null)
                        {
                            foreach (TAPTINBAIVIET taptin in lstTapTin)
                            {
                                busTapTin.Xoa(taptin.MaTapTin);
                            }
                        }

                        busBaiViet.Xoa(bv.MaBaiViet);
                    }
                }

                    BUSLoaiBaiViet bus = new BUSLoaiBaiViet();
                    if (bus.Xoa(maloai) == 0)
                    {
                        //Thong bao

                        Response.Redirect("LoaiBaiViet.aspx");
                    }

            }

            catch
            {
            }
        }
        protected void XoaBaiViet(int mabaiviet)
        {
            try
            {

                //xac nhan truoc khi xoa

                //Goi ham xoa
                BUSBaiViet BUSBaiViet = new BUSBaiViet();
                if (BUSBaiViet.Xoa(mabaiviet) == 0)
                {
                    //Thong bao

                    Response.Redirect("BaiViet.aspx");
                }

            }

            catch
            {
            }
        }
 protected void onchecked_changed(object sender, EventArgs e)
 {
     System.Web.UI.WebControls.CheckBox chkStatus = (System.Web.UI.WebControls.CheckBox)sender;
     GridViewRow row = (GridViewRow)chkStatus.NamingContainer;
     int id = Int32.Parse(row.Cells[1].Text) ;
     bool status = chkStatus.Checked;
     BUSBaiViet bus = new BUSBaiViet();
     BAIVIET bv = bus.TimKiem(id);
     bv.TinNoiBat = status;
     bus.CapNhat(bv);
 }