public void LoadLoaiHoatDong()
 {
     BUSLoaiHoatDong BUSLoaiHoatDong = new BUSLoaiHoatDong();
     List<LOAIHOATDONG> LOAIHOATDONG = BUSLoaiHoatDong.SelectLOAIHOATDONGsAll();
     ddlLoaiHoatDong.DataSource = LOAIHOATDONG;
     ddlLoaiHoatDong.DataTextField = "TenLoaiHoatDong";
     ddlLoaiHoatDong.DataValueField = "MaLoaiHoatDong";
     ddlLoaiHoatDong.DataBind();
 }
 public void LoadImage()
 {
     BUSLoaiHoatDong busLoaiHD = new BUSLoaiHoatDong();
     LOAIHOATDONG aLoaiHD = busLoaiHD.TimKiem("Hoạt động nổi bật");
     if (aLoaiHD != null)
     {
         BUSHoatDong busHD = new BUSHoatDong();
         List<HOATDONG> dsHDNoiBat = busHD.LayHoatDongTheoLoai(aLoaiHD.MaLoaiHoatDong);
         if (dsHDNoiBat.Count > 0)
         {
             imgMain.ImageUrl = "~/Uploads/HinhAnhHoatDong/" + dsHDNoiBat[0].HinhAnh;
             imgMain.AlternateText = "Không tìm thấy hình ảnh";
             imgMain.PostBackUrl = "~/ChiTietHoatDong.aspx?id=" + dsHDNoiBat[0].MaHoatDong;
         }
     }
 }
        //Load
        public int LoadLoaiHoatDong()
        {
            List<LOAIHOATDONG> lt = new List<LOAIHOATDONG>();

            BUSLoaiHoatDong BUSLoaiHoatDong = new BUSLoaiHoatDong();

            lt = BUSLoaiHoatDong.SelectLOAIHOATDONGsAll ();
            if (lt.Count > 0)
            {
            this.GridViewLoaiHoatDong.DataSource = lt;
            GridViewLoaiHoatDong.DataBind();
            PanelDanhSach.Visible = true;
            PanelMessage.Visible = false;
            return lt.Count;
            }
            else
            {
            PanelDanhSach.Visible = false;
            PanelMessage.Visible = true;
            return 0;
            }
        }
 protected void ddlLoaiHoatDong_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (ddlLoaiHoatDong.SelectedIndex != -1)
     {
         int iMaLoai = int.Parse(ddlLoaiHoatDong.SelectedValue);
         BUSLoaiHoatDong busLoaiHD = new BUSLoaiHoatDong();
         LOAIHOATDONG LoaiTatCa = busLoaiHD.TimKiem("Tất Cả");
         if (LoaiTatCa != null && iMaLoai == LoaiTatCa.MaLoaiHoatDong)
         {
             int soDong = LoadHoatDong();
             FilterSTT(soDong, 0, int.Parse(DropDownListPaging.SelectedValue));
         }
         else
         {
             //Lấy hoạt động theo mã loại
             BUSHoatDong busHoatDong = new BUSHoatDong();
             List<HOATDONG> dsHoatDong = busHoatDong.LayHoatDongTheoLoai(iMaLoai);
             GridViewHoatDong.DataSource = dsHoatDong;
             GridViewHoatDong.AutoGenerateColumns = false;
             GridViewHoatDong.DataBind();
             this.FilterSTT(dsHoatDong.Count, GridViewHoatDong.PageIndex, int.Parse(DropDownListPaging.SelectedValue));
         }
     }
 }
        protected void Xoa(int id)
        {
            try
            {
            //xac nhan truoc khi xoa
            BUSLoaiHoatDong bus = new BUSLoaiHoatDong();
            if (bus.Xoa(id) == 0)
            {
                //Thong bao
                Response.Redirect("HoatDong.aspx");
            }

            }
            catch
            {
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //Do loai hoat dong
                BUSLoaiHoatDong BUSLoaiHoatDong = new BUSLoaiHoatDong();
                ddlLoaiHoatDong.DataSource = BUSLoaiHoatDong.SelectLOAIHOATDONGsAll();
                ddlLoaiHoatDong.DataTextField = "TenLoaiHoatDong";
                ddlLoaiHoatDong.DataValueField = "MaLoaiHoatDong";
                ddlLoaiHoatDong.DataBind();

                if (Request.QueryString["id"] != null)
                {
                    LoadHoatDong();
                }
            }
        }