public List<City_Suburb> GetSuburbList(int cityID)
        {
            List<City_Suburb> listSuburbs = null;

            SqlParameter[] parameters = new SqlParameter[]
            {
                new SqlParameter("@CityID", cityID)
            };

            using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("sp_GetSuburbs", CommandType.StoredProcedure, parameters))
            {
                if (table.Rows.Count > 0)
                {
                    listSuburbs = new List<City_Suburb>();
                    foreach (DataRow row in table.Rows)
                    {
                        City_Suburb city_Suburb = new City_Suburb();
                        city_Suburb.SuburbName = row["SuburbName"].ToString();
                        city_Suburb.PostalCode = row["PostalCode"].ToString();

                        listSuburbs.Add(city_Suburb);
                    }
                }
            }
            return listSuburbs;
        }
        public List<City_Suburb> GetCityList()
        {
            List<City_Suburb> listCities = null;

            using (DataTable table = DBHelper.ExecuteSelectCommand("sp_GetCities", CommandType.StoredProcedure))
            {
                if (table.Rows.Count > 0)
                {
                    listCities = new List<City_Suburb>();
                    foreach (DataRow row in table.Rows)
                    {
                        City_Suburb city_Suburb = new City_Suburb();
                        city_Suburb.CityID = Convert.ToInt32(row["CityID"]);
                        city_Suburb.CityName = row["CityName"].ToString();

                        listCities.Add(city_Suburb);
                    }
                }
            }
            return listCities;
        }