public async Task<List<AddressModelForBanks>> BindDataByBank(string city, string country, string bank)
        {
            RepositoryHolder holder = new RepositoryHolder();

            AddressMaper mapper = new AddressMaper();
            var addressRepository = holder.AdressRepository;
            List<AddressModelForBanks> resultData =
                addressRepository.
                    FetchBy(p => p.cCity == city && p.cCountry == country && p.tbBank.cName==bank).
                    Select(p => mapper.EntityToUI(p)).ToList();



            /*
            if (resultData == null || resultData.Count == 0)
            {
                string type = bank;
                var client = new RestClient("https://search-maps.yandex.ru/v1/?text=" + type + ", " + city + ", " + country + "&type=biz&lang=uk_Ua&apikey=f7f27aa0-8bf2-4d7d-9e80-fdab701a58c8&results=500");

                var request = new RestRequest("resource/", Method.GET);


                var data = await client.GetTaskAsync<YandexModel.RootObject>(request);

                for (int i = 0; i <= data.features.Count - 1; i++)
                {
                    string[] buf = data.features[i].properties.CompanyMetaData.address.Split(','); //разбиваем строку на массив слов, разделитель пробел

                    Char separator = System.Globalization.CultureInfo.CurrentCulture.NumberFormat.CurrencyDecimalSeparator[0];
                    String Source = data.features[i].geometry.coordinates[0].Replace(',', separator);

                    String Source2 = data.features[i].geometry.coordinates[1].Replace(',', separator);

                    holder.AdressRepository.Insert(new Entity.tbAdress()
                    {
                        cLatitude = Source,
                        cLongitude = Source2,
                        cIdBank = 1,
                        cAdressVal = data.features[i].properties.CompanyMetaData.address,
                        cCity = city,
                        cCountry = country,
                        cStreet = buf[1] + buf[2]
                    });
                    holder.SaveChanges();
                }

                List<AddressModelForBanks> resultData2 =
               addressRepository.
                   FetchBy(p => p.cCity == city && p.cCountry == country).
                   Select(p => mapper.EntityToUI(p)).ToList();
                return resultData2;
            }else
            {*/
                return resultData;
           // }
        }
        public List<AddressModelForBanks> BindDataByBank(string bank, string country)
        {
            RepositoryHolder holder = new RepositoryHolder();

            AddressMaper mapper = new AddressMaper();
            var addressRepository = holder.AdressRepository;
            List<AddressModelForBanks> resultData =
                addressRepository.
                    FetchBy(p => p.tbBank.cName == bank && p.cCountry == country).
                    Select(p => mapper.EntityToUI(p)).ToList();
           
                return resultData;
       
        }
        public  List<AddressModelForBanks> BindDataAll()
        {
            RepositoryHolder holder = new RepositoryHolder();

            AddressMaper mapper = new AddressMaper();
            var addressRepository = holder.AdressRepository;
            List<AddressModelForBanks> resultData =
                addressRepository.
                    Fetch().
                    Select(p => mapper.EntityToUI(p)).ToList();
            
            return resultData;
            
        }