public List<CountryViewModel> GetALLCountryViewByName(string searchName)
        {
            int count = 0;
            string query = "Select * from GetCountryInfo where Name LIKE '%[" + searchName + "]%' ";
            SqlCommand command = new SqlCommand(query, connection);

            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            List<CountryViewModel> countryView = new List<CountryViewModel>();
            while (reader.Read())
            {
                count = count + 1;
                CountryViewModel countryViewModelObj = new CountryViewModel();
                countryViewModelObj.SL = count;
                countryViewModelObj.Name = reader["Name"].ToString();

                byte[] binaryString = (byte[])(reader["About"]);
                countryViewModelObj.About = Encoding.UTF8.GetString(binaryString);

                //countryViewModelObj.About = reader["About"].ToString();
                countryViewModelObj.NoOfCities = Convert.ToInt32(reader["No Of Cities"].ToString());
                countryViewModelObj.NoOfCityDwellers = Convert.ToInt32(reader["No Of City Dwellers"].ToString());

                countryView.Add(countryViewModelObj);
            }
            connection.Close();
            int datacount = countryView.Count;
            if (datacount == 0)
            {
                return null;
            }
            return countryView;
        }
        /////////////////////////////
        public List<CountryViewModel> GetALLCountryView() {
            int count = 0;
            string query = "Select * from GetCountryInfo ORDER BY Name";
            SqlCommand command = new SqlCommand(query, connection);

            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            List<CountryViewModel> countryView = new List<CountryViewModel>();
            while (reader.Read()) {
                count = count + 1;
                CountryViewModel countryViewModelObj = new CountryViewModel();
                countryViewModelObj.SL = count;
                countryViewModelObj.Name = reader["Name"].ToString();
                byte[] binaryString = (byte[])(reader["About"]);
                countryViewModelObj.About = Encoding.UTF8.GetString(binaryString);
                countryViewModelObj.NoOfCities = Convert.ToInt32(reader["No. of cities"].ToString());
                countryViewModelObj.NoOfCityDwellers = Convert.ToInt32(reader["No. of city dwellers"].ToString());

                countryView.Add(countryViewModelObj);
            }
            connection.Close();
            return countryView;
        }