protected void uiRepeaterResults_ItemDataBound(object sender, RepeaterItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
            {
                DataRowView row = (DataRowView)e.Item.DataItem;
                Label cityname = (Label)e.Item.FindControl("uiLabelCityName");

                Cities city = new Cities();
                city.LoadByPrimaryKey(Convert.ToInt32(row["CityID"].ToString()));

                cityname.Text = city.ArName;

                HyperLink linkName = (HyperLink)e.Item.FindControl("CompanyLink");
                linkName.NavigateUrl = "CompanyProfile.aspx?cid=" + row["CompanyID"].ToString();
                System.Web.UI.HtmlControls.HtmlGenericControl Name = (System.Web.UI.HtmlControls.HtmlGenericControl)e.Item.FindControl("CompanyName");

                if (!string.IsNullOrEmpty(row["PackageTypeID"].ToString()) && row["PackageTypeID"].ToString() != "1")
                {
                    linkName.Visible = true;
                    Name.Visible = false;
                }
                else
                {
                    linkName.Visible = false;
                    Name.Visible = true;
                }
            }
        }
        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();
            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();
            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 = "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"));
        }