protected void btnCapNhat_Click(object sender, EventArgs e)
        {
            try
            {
                //lay thong tin tu textbox
                CHUYENMUC lpDTO = new CHUYENMUC();
                lpDTO.MaChuyenMuc  = int.Parse(this.txtmachuyenmuc.Text);
                lpDTO.TenChuyenMuc  = this.txttenchuyenmuc.Text;

                //Goi ham cap nhat
                BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();
                if (BUSChuyenMuc.CapNhat(lpDTO) == 0)
                {
                    //Thong bao
                    lbThongBao.Text = "Cập Nhật Thành Công";
                    lbThongBao.Visible = true;
                    //Response.Redirect("LoaiMatHang.aspx");
                }
                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;
            }
        }
        //Load
        public int LoadChuyenMuc()
        {
            List<CHUYENMUC> lt = new List<CHUYENMUC>();

            BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();

            lt = BUSChuyenMuc.SelectCHUYENMUCsAll();
            if (lt != null || lt.Count > 0)
            {
                this.GridViewChuyenMuc.DataSource = lt;
                GridViewChuyenMuc.DataBind();
                UpdatePanel1.Visible = true;
                PanelMessage.Visible = false;
                return lt.Count;
            }
            else
            {
                UpdatePanel1.Visible = false;
                PanelMessage.Visible = true;
                return 0;
            }
            //return 0;
        }
        public string strMenuChuyenMuc()
        {
            string lblMenu = "";
            lblMenu += "<li>";
            lblMenu += "<a class='parent' href='#'><span>Chuyên Mục</span></a>";
            BUSChuyenMuc ChuyenMucBUS = new BUSChuyenMuc();
            List<CHUYENMUC> DSChuyenMuc = ChuyenMucBUS.SelectCHUYENMUCsAll_exception();
            BUSLoaiBaiViet LoaiBaiVietBUS = new BUSLoaiBaiViet();

            int i, j;
            lblMenu += "<div><ul>";
            for (i = 1; i < DSChuyenMuc.Count(); i++)
            {
                //MenuItem mnItem = new MenuItem(DSChuyenMuc[i].TenChuyenMuc, "", "");

                lblMenu += "<li><a href='ChuyenMuc.aspx?id="+ DSChuyenMuc[i].MaChuyenMuc.ToString()+"'><span>"+DSChuyenMuc[i].TenChuyenMuc+"</span></a>";
                List<LOAIBAIVIET> DSLoaiBaiViet = LoaiBaiVietBUS.TimKiemLoaiBaiVietTheoChuyenMuc(DSChuyenMuc[i].MaChuyenMuc);
                if (DSLoaiBaiViet.Count() != 0)
                {
                    lblMenu += "<div><ul>";

                    for (j = 0; j < DSLoaiBaiViet.Count(); j++)
                    {
                        lblMenu += "<li><a href='LoaiBaiViet.aspx?id=" + DSLoaiBaiViet[j].MaLoaiBaiViet.ToString()+ "'><span>" + DSLoaiBaiViet[j].TenLoaiBaiViet + "</span></a></li>";
                       // MenuItem mn = new MenuItem(DSLoaiBaiViet[j].TenLoaiBaiViet, "", "", "~/LoaiBaiViet.aspx?id=" + DSLoaiBaiViet[j].MaLoaiBaiViet);
                        // mnChuyenMuc.ChildItems[i + 3].ChildItems.Add(mn);
                       // mnItem.ChildItems.Add(mn);
                    }
                    lblMenu += "</ul></div>";
                }
               // mnChuyenMuc.ChildItems.Add(mnItem);

            }
            lblMenu += "</ul></div>";
            lblMenu += "</li>";
            return lblMenu;
        }
        //Load
        public int LoadChuyenMuc()
        {
            List<CHUYENMUC> lt = new List<CHUYENMUC>();

            BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();

            lt = BUSChuyenMuc.SelectCHUYENMUCsAll();
            Response.Write("<script>alert('hello');</script>");
            if (lt != null || lt.Count > 0)
            {
                this.GridViewChuyenMuc.DataSource = lt;
                GridViewChuyenMuc.DataBind();
                UpdatePanel1.Visible = true;
                PanelMessage.Visible = false;
                return lt.Count;
            }
            else
            {
                UpdatePanel1.Visible = false;
                PanelMessage.Visible = true;
                return 0;
            }
            return 0;
        }
        public string strMenuHoTroSinhVien()
        {
            BUSLoaiBaiViet LoaiBaiVietBUS = new BUSLoaiBaiViet();
            BUSChuyenMuc ChuyenMucBUS = new BUSChuyenMuc();
            List<CHUYENMUC> DSChuyenMuc = ChuyenMucBUS.SelectCHUYENMUCsAll();
            string strMenu = "";
            strMenu += "<li>";
            strMenu += "<a class='parent' href='ChuyenMuc.aspx?id=1'><span>Hỗ Trợ Sinh Viên</span></a>";

            int j;
               // MenuItem mnHoTroSinhVien = new MenuItem("Hỗ Trợ Sinh Viên", "", "", "~/default.aspx");
            List<LOAIBAIVIET> DSLoaiBaiVietHoTroSV = LoaiBaiVietBUS.TimKiemLoaiBaiVietTheoChuyenMuc(DSChuyenMuc[0].MaChuyenMuc);
            if (DSLoaiBaiVietHoTroSV.Count() != 0)
            {
                strMenu += "<div><ul>";
                for (j = 0; j < DSLoaiBaiVietHoTroSV.Count(); j++)
                {
                    //MenuItem mn = new MenuItem(DSLoaiBaiVietHoTroSV[j].TenLoaiBaiViet, "", "", "~/LoaiBaiViet.aspx?id=" + DSLoaiBaiVietHoTroSV[j].MaLoaiBaiViet);
                    //mnHoTroSinhVien.ChildItems.Add(mn);
                    strMenu += "<li><a href='LoaiBaiViet.aspx?id="+DSLoaiBaiVietHoTroSV[j].MaLoaiBaiViet.ToString()+"'><span>"+DSLoaiBaiVietHoTroSV[j].TenLoaiBaiViet+"</span></a></li>";
                }
                strMenu += "</ul></div>";
            }

            strMenu += "</li>";
            return strMenu;
        }
 protected void load_ddlChuyenMuc()
 {
     // load ddlChuyenMuc
     ddlChuyenMuc.Items.Clear();
     BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();
     List<CHUYENMUC> lstCM = BUSChuyenMuc.SelectCHUYENMUCsAll();
     for (int i = 0; i < lstCM.Count; i++)
     {
         ListItem li = new ListItem(lstCM[i].TenChuyenMuc.ToString(), lstCM[i].MaChuyenMuc.ToString());
         this.ddlChuyenMuc.Items.Add(li);
     }
 }
        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 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
            {
            }
        }
        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 Page_Load(object sender, EventArgs e)
        {
            Page.Title = "Danh Sách Bài Gửi";

            if (!IsPostBack)
            {
                int soDong = LoadChuyenMuc();
                FilterSTT(soDong, 0, 10);
            }
            this.GridViewChuyenMuc.HeaderStyle.CssClass = "headerstyle";
            //Thong tin nguoi dung

            if (Request.QueryString["id"] != null)
            {
                //lay ma
                int machuyenmuc = int.Parse(Request.QueryString["id"]);

                //lay thong tin va load len cac textbox
                BUSChuyenMuc BUSChuyenMuc = new BUSChuyenMuc();
                CHUYENMUC lpDTO = BUSChuyenMuc.TimKiem(machuyenmuc);
                this.txtmachuyenmuc.Text = Convert.ToString(lpDTO.MaChuyenMuc );
                this.txttenchuyenmuc.Text = lpDTO.TenChuyenMuc ;
            }
        }
        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;
            }
        }