private void LoadDDLs()
        {
            Cities objCities = new Cities();
            objCities.LoadAll();
            uiDropDownListCity.DataSource = objCities.DefaultView;
            uiDropDownListCity.DataTextField = "ArName";
            uiDropDownListCity.DataValueField = "CityID";
            uiDropDownListCity.DataBind();
            uiDropDownListCity.Items.Insert(0, new ListItem("إختر المدينة", "0"));

            Categories objCategories = new Categories();
            objCategories.LoadAll();
            uiDropDownListCategory.DataSource = objCategories.DefaultView;
            uiDropDownListCategory.DataTextField = "ArName";
            uiDropDownListCategory.DataValueField = "CategoryID";
            uiDropDownListCategory.DataBind();
            uiDropDownListCategory.Items.Insert(0, new ListItem("إختر قطاع العمل", "0"));

            Packages objpack = new Packages();
            objpack.LoadAll();
            uiDropDownListPackage.DataSource = objpack.DefaultView;
            uiDropDownListPackage.DataTextField = "EnName";
            uiDropDownListPackage.DataValueField = "PackageID";
            uiDropDownListPackage.DataBind();
        }
        private void LoadDDLs()
        {
            Cities objCities = new Cities();
            objCities.LoadAll();
            uiDropDownListCity.DataSource = objCities.DefaultView;
            uiDropDownListCity.DataTextField = "ArName";
            uiDropDownListCity.DataValueField = "CityID";
            uiDropDownListCity.DataBind();

            Categories objCats = new Categories();
            objCats.LoadAll();
            uiDropDownListCategory.DataSource = objCats.DefaultView;
            uiDropDownListCategory.DataTextField = "ArName";
            uiDropDownListCategory.DataValueField = "CategoryID";
            uiDropDownListCategory.DataBind();

            SubCategories objSubCat = new SubCategories();
            objSubCat.LoadAll();
            uiDropDownListSubCategory.DataSource = objSubCat.DefaultView;
            uiDropDownListSubCategory.DataTextField = "ArName";
            uiDropDownListSubCategory.DataValueField = "SubCategoryID";
            uiDropDownListSubCategory.DataBind();

            Packages objPackages = new Packages();
            objPackages.LoadAll();
            uiDropDownListPackages.DataSource = objPackages.DefaultView;
            uiDropDownListPackages.DataTextField = "EnName";
            uiDropDownListPackages.DataValueField = "PackageID";
            uiDropDownListPackages.DataBind();

            uiDropDownListCategoryFilter.DataSource = objCats.DefaultView;
            uiDropDownListCategoryFilter.DataTextField = "ArName";
            uiDropDownListCategoryFilter.DataValueField = "CategoryID";
            uiDropDownListCategoryFilter.DataBind();
            uiDropDownListCategoryFilter.Items.Insert(0, new ListItem("Select Category", "0"));
        }
        private void LoadDDLs()
        {
            Cities objCities = new Cities();
            objCities.LoadAll();
            uiDropDownListCity.DataSource = objCities.DefaultView;
            uiDropDownListCity.DataTextField = "ArName";
            uiDropDownListCity.DataValueField = "CityID";
            uiDropDownListCity.DataBind();

            Categories objCats = new Categories();
            objCats.LoadAll();
            uiDropDownListCategory.DataSource = objCats.DefaultView;
            uiDropDownListCategory.DataTextField = "ArName";
            uiDropDownListCategory.DataValueField = "CategoryID";
            uiDropDownListCategory.DataBind();
            uiDropDownListCategory.SelectedIndex = 0;

            SubCategories objSubCat = new SubCategories();
            objSubCat.GetAllSubCategoriesByCategory(Convert.ToInt32(uiDropDownListCategory.SelectedValue));
            uiDropDownListSubCategory.DataSource = objSubCat.DefaultView;
            uiDropDownListSubCategory.DataTextField = "ArName";
            uiDropDownListSubCategory.DataValueField = "SubCategoryID";
            uiDropDownListSubCategory.DataBind();
        }
        private void LoadDDLs()
        {
            Cities objCities = new Cities();
            objCities.LoadAll();
            uiDropDownListCities.DataSource = objCities.DefaultView;
            uiDropDownListCities.DataTextField = "ArName";
            uiDropDownListCities.DataValueField = "CityID";
            uiDropDownListCities.DataBind();
            uiDropDownListCities.Items.Insert(0, new ListItem("إختر المدينة", "0"));

            //AirPorts airport = new AirPorts();
            //airport.LoadAll();
            //uiDropDownListAitFrom.DataSource = airport.DefaultView;
            //uiDropDownListAitFrom.DataTextField = "EnName";
            //uiDropDownListAitFrom.DataValueField = "AirportID";
            //uiDropDownListAitFrom.DataBind();
            //uiDropDownListAitFrom.Items.Insert(0, new ListItem("إختر المطار", "0"));

            //uiDropDownListAirTo.DataSource = airport.DefaultView;
            //uiDropDownListAirTo.DataTextField = "EnName";
            //uiDropDownListAirTo.DataValueField = "AirportID";
            //uiDropDownListAirTo.DataBind();
            //uiDropDownListAirTo.Items.Insert(0, new ListItem("إختر المطار", "0"));

            //SeaPorts seaport = new SeaPorts();
            //seaport.LoadAll();
            //uiDropDownListFromShippinglines.DataSource = seaport.DefaultView;
            //uiDropDownListFromShippinglines.DataTextField = "EnName";
            //uiDropDownListFromShippinglines.DataValueField = "SeaPortID";
            //uiDropDownListFromShippinglines.DataBind();
            //uiDropDownListFromShippinglines.Items.Insert(0, new ListItem("إختر الميناء", "0"));

            //uiDropDownListToShippinglines.DataSource = seaport.DefaultView;
            //uiDropDownListToShippinglines.DataTextField = "EnName";
            //uiDropDownListToShippinglines.DataValueField = "SeaPortID";
            //uiDropDownListToShippinglines.DataBind();
            //uiDropDownListToShippinglines.Items.Insert(0, new ListItem("إختر الميناء", "0"));

            Categories objCategories = new Categories();
            objCategories.LoadAll();
            uiDropDownListCategories.DataSource = objCategories.DefaultView;
            uiDropDownListCategories.DataTextField = "ArName";
            uiDropDownListCategories.DataValueField = "CategoryID";
            uiDropDownListCategories.DataBind();
            uiDropDownListCategories.Items.Insert(0, new ListItem("قطاع الأعمال", "0"));
        }
        private void LoadDDLs()
        {
            Cities objCities = new Cities();
            objCities.LoadAll();
            uiDropDownListCities.DataSource = objCities.DefaultView;
            uiDropDownListCities.DataTextField = "EnName";
            uiDropDownListCities.DataValueField = "CityID";
            uiDropDownListCities.DataBind();
            uiDropDownListCities.Items.Insert(0, new ListItem("Select City", "0"));

            Categories objCategories = new Categories();
            objCategories.LoadAll();
            uiDropDownListCategories.DataSource = objCategories.DefaultView;
            uiDropDownListCategories.DataTextField = "EnName";
            uiDropDownListCategories.DataValueField = "CategoryID";
            uiDropDownListCategories.DataBind();
            uiDropDownListCategories.Items.Insert(0, new ListItem("Select Category", "0"));
        }