protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                Form.DefaultButton = btn_Search.UniqueID;

                facade = new BusinessFacade(myConn);

                dl_adminCate.DataSource = facade.GetChildCategory(1);
                dl_adminCate.DataBind();
                dl_Fromk12Cate.DataSource = facade.GetChildCategory(2);
                dl_Fromk12Cate.DataBind();
                dl_AcademicCate.DataSource = facade.GetChildCategory(3);
                dl_AcademicCate.DataBind();

                dl_Joblevel.DataSource = facade.GetAllJobRole();
                dl_Joblevel.DataBind();

                dl_WorkPlace.DataSource = facade.GetAllLocation();
                dl_WorkPlace.DataBind();

                Assembly ass = Assembly.Load("App_GlobalResources");
                ResourceManager rm = new ResourceManager("Resources.Resource", ass);

                ddl_citizenship.Items.Insert(0, new ListItem(rm.GetString("Pleaseselect"), string.Empty));
                List<Citizenship> ctList = facade.GetAllCitizenship();
                foreach (Citizenship ct in ctList)
                {
                    ListItem li = Utils.DecideLangDropdown(ct.CitizenshipName, ct.CitizenshipName_vn);
                    if (li.Value == "Afghanistan" || li.Value == "Afghanistan")
                    {
                        ListItem l = new ListItem("------------------------------", "");
                        ddl_citizenship.Items.Add(l);
                    }
                    ddl_citizenship.Items.Add(li);
                }

                dl_emplType.DataSource = facade.GetAllEmploymentType();
                dl_emplType.DataBind();

                ddl_OrgType.Items.Insert(0, new ListItem(rm.GetString("Pleaseselect"), string.Empty));
                List<OrganizationType> oType = facade.GetAllOrganizationType();
                foreach (OrganizationType ot in oType)
                {
                    ListItem li = Utils.DecideLangDropdown(ot.Name, ot.Name_vn);
                    ddl_OrgType.Items.Add(li);
                }

                ddl_SchoolType.Items.Insert(0, new ListItem(rm.GetString("Pleaseselect"), string.Empty));
                List<SchoolType> stList = facade.GetSchoolType();
                foreach (SchoolType st in stList)
                {
                    ListItem li = Utils.DecideLangDropdown(st.Name, st.Name_vn);
                    ddl_SchoolType.Items.Add(li);
                }

                //Load job title
                TitleList = new AdvanceSearchLogic(myConn).GetAllJobTitle();
                ArrTitle = "";
                foreach (String str in TitleList)
                {
                    ArrTitle += str + ",";
                }
            }
            catch (Exception ex)
            {
                Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "PopupScript", "<script>alert('"+ex.Message+"');</script>");
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            Form.DefaultButton = btn_Search.UniqueID;

            facade = new BusinessFacade(myConn);

            dl_adminCate.DataSource = facade.GetChildCategory(1);
            dl_adminCate.DataBind();
            dl_Fromk12Cate.DataSource = facade.GetChildCategory(2);
            dl_Fromk12Cate.DataBind();
            dl_AcademicCate.DataSource = facade.GetChildCategory(3);
            dl_AcademicCate.DataBind();

            dl_Joblevel.DataSource = facade.GetAllJobRole();
            dl_Joblevel.DataBind();

            dl_WorkPlace.DataSource = facade.GetAllLocation();
            dl_WorkPlace.DataBind();

            Assembly ass = Assembly.Load("App_GlobalResources");
            ResourceManager rm = new ResourceManager("Resources.Resource", ass);

            ddl_citizenship.Items.Insert(0, new ListItem(rm.GetString("Pleaseselect"), string.Empty));
            List<Citizenship> ctList = facade.GetAllCitizenship();
            foreach (Citizenship ct in ctList)
            {
                ListItem li = Utils.DecideLangDropdown(ct.CitizenshipName, ct.CitizenshipName_vn);
                if (li.Value == "Afghanistan" || li.Value == "Afghanistan")
                {
                    ListItem l = new ListItem("------------------------------", "");
                    ddl_citizenship.Items.Add(l);
                }
                ddl_citizenship.Items.Add(li);
            }

            ddl_YearOfExp.Items.Insert(0, new ListItem(rm.GetString("Pleaseselect"), string.Empty));
            List<YearOfExp> yeList = facade.GetYearsOfExp();
            foreach (YearOfExp ye in yeList)
            {
                ListItem li = Utils.DecideLangDropdown(ye.Name_en, ye.Name_vi);
                ddl_YearOfExp.Items.Add(li);
            }

            ddl_EduLevel.Items.Insert(0, new ListItem(rm.GetString("Pleaseselect"), string.Empty));
            List<EduLevelcs> elList = facade.GetEduLevel();
            foreach (EduLevelcs el in elList)
            {
                ListItem li = Utils.DecideLangDropdown(el.Name_en, el.Name_vi);
                ddl_EduLevel.Items.Add(li);
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Assembly ass = Assembly.Load("App_GlobalResources");
                ResourceManager rm = new ResourceManager("Resources.Resource", ass);

                facade = new BusinessFacade(myConn);
                courseFacade = new CourseBusinessFacade();

                //rm.GetString("Pleaseselect")
                ddl_city.Items.Insert(0, new ListItem("Any location", string.Empty));
                ddl_city.SelectedIndex = 0;
                List<Location> loList = facade.GetAllLocation();
                foreach (Location l in loList)
                {
                    ListItem li = Utils.DecideLangDropdownV2(l.LName, l.LName_vn,l.LId.ToString());
                    ddl_city.Items.Add(li);
                }

                List<Sector> seList = facade.GetChildCategory(3);
                ddl_category.Items.Insert(0, new ListItem("Any category", string.Empty));
                foreach (Sector s in seList)
                {
                    ListItem li = Utils.DecideLangDropdownV2(s.SeName_en, s.SeName_vi,s.SeId.ToString());
                    ddl_category.Items.Add(li);
                }

                List<TrainingLevel> tlList = courseFacade.GetTrainingLevel();
                ddl_level.Items.Insert(0, new ListItem("Any level", string.Empty));
                foreach (TrainingLevel tl in tlList)
                {
                    ListItem li = Utils.DecideLangDropdownV2(tl.TlName_en, tl.TlName_vi,tl.Id.ToString());
                    ddl_level.Items.Add(li);
                }

                lbl_AvaiCourse.Text = courseFacade.GetAvailableCourse() + " courses available";
            }
        }