public void GetData(string city, string country) { RepositoryHolder holder = new RepositoryHolder(); string type = "Банк"; 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 asyncHandle = client.ExecuteAsync<YandexModel.RootObject>(request, response => { for (int i = 0; i <= response.Data.features.Count - 1; i++) { string[] buf = response.Data.features[i].properties.CompanyMetaData.address.Split(','); //разбиваем строку на массив слов, разделитель пробел Char separator = System.Globalization.CultureInfo.CurrentCulture.NumberFormat.CurrencyDecimalSeparator[0]; String Source = response.Data.features[i].geometry.coordinates[0].Replace(',', separator); Double number = Convert.ToDouble(Source); String Source2 = response.Data.features[i].geometry.coordinates[1].Replace(',', separator); Double number2 = Convert.ToDouble(Source2); holder.AdressRepository.Insert(new Entity.tbAdress() { cLatitude = Source, cLongitude = Source2, cIdBank = 1, cAdressVal = response.Data.features[i].properties.CompanyMetaData.address, cCity = city, cCountry = country, cStreet = buf[1] + buf[2] }); holder.SaveChanges(); } }); }
public async Task<List<ClosestPointModel>> BindData(string adress) { var client = new RestClient("https://geocode-maps.yandex.ru/1.x/?format=json&lang=uk_Ua&geocode="+adress); var request = new RestRequest("resource/", Method.GET); var data = await client.GetTaskAsync<GeocodeModel.RootObject>(request); var latitude = data.response.GeoObjectCollection.featureMember[0].GeoObject.Point.pos[0]; var longitude = data.response.GeoObjectCollection.featureMember[0].GeoObject.Point.pos[1]; RepositoryHolder holder = new RepositoryHolder(); ClosestPointMapper mapper = new ClosestPointMapper(); var adressRepository = holder.AdressRepository; List<ClosestPointModel> resultData = adressRepository. Fetch(). Select(p => mapper.EntityToUI(p, latitude, longitude)) .OrderBy(z => z.FakeLatitude). ThenBy(z => z.FakeLongitude). Take(20).ToList(); return resultData; }
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 void BindFromUIModel(CurrencyRateModel model) { using (RepositoryHolder scope = new RepositoryHolder()) { CurrencyRateMapper mapper = new CurrencyRateMapper(); var dbModel = mapper.ModelToEntity(model); scope.CurrencyRateRepository.Insert(dbModel); scope.SaveChanges(); } }
public void BindFromUIModel(BankModel model) { using (RepositoryHolder scope = new RepositoryHolder()) { BankMapper mapper = new BankMapper(); var dbModel = mapper.ModelToEntity(model); scope.BankRepository.Insert(dbModel); scope.SaveChanges(); } }
public List<OnlyBankModel> BindData() { RepositoryHolder holder = new RepositoryHolder(); OnlyBankMapper mapper = new OnlyBankMapper(); var bankRepository = holder.BankRepository; List<OnlyBankModel> resultnewData = bankRepository. Fetch(). Select(p => mapper.EntityToUI(p)).ToList(); return resultnewData; }
public List<OnlyCityModel> BindData(string country) { RepositoryHolder holder = new RepositoryHolder(); OnlyCityMapper mapper = new OnlyCityMapper(); var adressRepository = holder.AdressRepository; List<OnlyCityModel> resultnewData = adressRepository. FetchBy(p=>p.cCountry==country). Select(p => mapper.EntityToUI(p)).Distinct().ToList(); return resultnewData.Distinct().ToList(); }
public List<OnlyRateModel> BindData() { RepositoryHolder holder = new RepositoryHolder(); OnlyRateMapper mapper = new OnlyRateMapper(); var rateRepository = holder.CurrencyRepository; List<OnlyRateModel> resultnewData = rateRepository. Fetch(). Select(p => mapper.EntityToUI(p)).ToList(); return resultnewData; }
public List<BankModel> BindFromEntities() { using (RepositoryHolder scope = new RepositoryHolder()) { BankMapper mapper = new BankMapper(); //CurrencyRateMapper mapper2 = new CurrencyRateMapper(); List<BankModel> result = mapper.EntityToModel( scope.BankRepository .Fetch() .ToList()); return result; } }
public List<CurrencyModel> BindFromEntities() { using (RepositoryHolder scope = new RepositoryHolder()) { CurrencyMapper mapper = new CurrencyMapper(); List<CurrencyModel> result = mapper.EntityToModel( scope.CurrencyRepository .Fetch() .ToList()); return result; } }
public List<RateModel> BindFromEntities() { using (RepositoryHolder scope = new RepositoryHolder()) { RateMapper mapper = new RateMapper(); List<RateModel> result = mapper.EntityToModel( scope.RateRepository .Fetch() .ToList()); return result; } }
public List<AdressModel> BindFromEntitiesBy(int id) { using (RepositoryHolder scope = new RepositoryHolder()) { AdressMapper mapper = new AdressMapper(); //CurrencyRateMapper mapper2 = new CurrencyRateMapper(); List<AdressModel> result = mapper.EntityToModel( scope.AdressRepository .FetchBy(p => p.cIdBank == id) .ToList()); return result; } }
public List<RateByValidModel> BindData(string currency) { RepositoryHolder holder = new RepositoryHolder(); RatesMapper mapper = new RatesMapper(); var rateRepository = holder.CurrencyRateRepository; List<RateByValidModel> resultnewData = rateRepository. FetchBy(p=>p.tbRate.cIsValid==1&&p.tbCurrency.cCurrencyLong==currency). Select(p => mapper.EntityToUI(p)). OrderByDescending(z => z.Rate) .Reverse() .ToList(); return resultnewData; }
public List<BankByCityCountryModel> BindData(string country, string city) { RepositoryHolder holder = new RepositoryHolder(); BankByCityCountryMapper mapper = new BankByCityCountryMapper(); var bankRepository = holder.AdressRepository; List<BankByCityCountryModel> resultnewData = bankRepository. FetchBy(p => p.cCountry == country && p.cCity == city) .Select(p => mapper.EntityToUI(p)) .Distinct() .OrderByDescending(z =>z.Rating ) .Reverse() .ToList() ; return resultnewData; }
public List<GraphModel> BindData(DateTime startdate, DateTime enddate, string bank, string currency, string sellbuy) { RepositoryHolder holder = new RepositoryHolder(); GraphMapper mapper = new GraphMapper(); var rateRepository = holder.CurrencyRateRepository; List<GraphModel> resultData = rateRepository. FetchBy(p => p.tbRate.cDate <= enddate && p.tbRate.cDate >= startdate && p.tbBank.cName == bank && p.tbCurrency.cCurrencyLong==currency&& p.tbRate.SellBuy==sellbuy). Select(p => mapper.EntityToUI(p)).ToList(); return resultData; }
public List<CalculateModel> BindData(string currency1, string currency2,string sellbuy, string bank) { RepositoryHolder holder = new RepositoryHolder(); CalculateMapper mapper = new CalculateMapper(); var rateRepository = holder.CurrencyRateRepository; List<CalculateModel> resultData = rateRepository. FetchBy(p => p.tbBank.cName==bank&& p.tbRate.cIsValid==1&& p.tbRate.SellBuy==sellbuy&&( p.tbCurrency.cCurrencyLong==currency1|| p.tbCurrency.cCurrencyLong == currency2)). Select(p => mapper.EntityToUI(p)).ToList(); return resultData; }
public List<AdressModel> BindFromEntities() { using (RepositoryHolder scope = new RepositoryHolder()) { AdressMapper mapper = new AdressMapper(); List<AdressModel> result = //mapper.EntityToModel( scope.AdressRepository .Fetch() .Select ( p => mapper.EntityToModel(p) ) .ToList(); return result; } }
public List<AdressModel> BindFromEntities(string city, string country) { using (RepositoryHolder scope = new RepositoryHolder()) { AdressMapper mapper = new AdressMapper(); List<AdressModel> result = mapper.EntityToModel( scope.AdressRepository .FetchBy(p =>p.cCity==city) .ToList()); /* if (result == null) { return GetData(city, country); } else { return result; }*/ return result; } }
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; }