public async Task <ServiceResponse <TTAIlType> > InsertCitiesAsync() { try { // ILLER var head = new RequestHeaderType { BusinessID = "1", ConversationID = "1", MessageID = null, RequestID = "1" }; var req = new IlListesiGetirRequestBodyType { GirdiParametreleri = new EkParametreType[] { new EkParametreType { Deger = null, Ad = null } } }; TtAdresServiceSOAPClient asd = new TtAdresServiceSOAPClient(); var request = await asd.IlListesiGetirAsync(head, req); var response = request.IlListesiGetirResponseBody.Item as IlListesiGetirResponseBodySuccessType; var items = response.IlListesi.ToList(); List <AddressCity> ooo = new List <AddressCity>(); var noww = DateTime.Now; foreach (var item in items) { ooo.Add(new AddressCity { Code = (int)item.Kod, CreateDate = TimeStamp.ToUnixTimestamp(noww), CreateUser = 1, Name = item.Ad, ServiceUpdateDate = item.GuncellemeZamani, NationalityCode = (int)item.UlkeKodu, NationalityId = 25, StatusId = (int)item.Durum }); } _cityRepository.Insert(ooo); return(new ServiceResponse <TTAIlType>()); } catch (Exception ex) { return(new ServiceResponse <TTAIlType>(ex)); } }
public async Task <ServiceResponse <TTASiteType> > InsertSitesAsync() { try { var parent = _quarterRepository.TableNoTracking; var parents = parent.ToList(); var head = new RequestHeaderType { BusinessID = "1", ConversationID = "1", MessageID = null, RequestID = "1" }; List <AddressSite> ooo = new List <AddressSite>(); foreach (var item in parents) { if (item.Code > 0 && item.StatusId == 1) { var req = new MahalledekiSiteListesiRequestBodyType { GirdiParametreleri = new EkParametreType[] { new EkParametreType { Deger = null, Ad = null } }, MahalleKodu = (long)item.Code }; TtAdresServiceSOAPClient soap = new TtAdresServiceSOAPClient(); var request = await soap.MahalledekiSiteListesiAsync(head, req); var response = request.MahalledekiSiteListesiResponseBody.Item as MahalledekiSiteListesiResponseBodySuccessType; if (response.TTASiteListesi.Count() > 0) { var items = response.TTASiteListesi; var noww = DateTime.Now; foreach (var item2 in items) { Console.WriteLine("Mahalle ID: " + item.ID + " Site Kodu:" + item2.Kod); ooo.Add(new AddressSite { Code = (int)item2.Kod, CreateDate = TimeStamp.ToUnixTimestamp(noww), CreateUser = 1, Name = item2.Ad, ServiceUpdateDate = item2.GuncellemeZamani, QuarterCode = (int)item2.MahalleKodu, QuarterId = item.ID }); } } } } if (ooo.Count > 0) { _siteRepository.Insert(ooo); } return(new ServiceResponse <TTASiteType>()); } catch (Exception ex) { return(new ServiceResponse <TTASiteType>(ex)); } }
public async Task <ServiceResponse <TTACSBMType> > InsertCsbmAsync() { try { var parent = _quarterRepository.TableNoTracking; var parents = parent.ToList(); var head = new RequestHeaderType { BusinessID = "1", ConversationID = "1", MessageID = null, RequestID = "1" }; List <AddressCsbm> ooo = new List <AddressCsbm>(); foreach (var item in parents) { if (item.Code > 0 && item.StatusId == 1) { var req = new MahalleyeBagliCsbmListesiGetirRequestBodyType { GirdiParametreleri = new EkParametreType[] { new EkParametreType { Deger = null, Ad = null } }, MahalleKodu = (long)item.Code }; TtAdresServiceSOAPClient soap = new TtAdresServiceSOAPClient(); var request = await soap.MahalleyeBagliCsbmListesiGetirAsync(head, req); var response = request.MahalleyeBagliCsbmListesiGetirResponseBody.Item as MahalleyeBagliCsbmListesiGetirResponseBodySuccessType; var items = response.MahalleyeBagliCsbmListesi.ToList(); var noww = DateTime.Now; foreach (var item2 in items) { int typeId = 0; switch (item2.Tipi) { case 0: typeId = 1; break; case 1: typeId = 2; break; case 2: typeId = 3; break; case 3: typeId = 4; break; case 4: typeId = 5; break; case 5: typeId = 6; break; default: break; } Console.WriteLine(item2.Kod); ooo.Add(new AddressCsbm { Code = (int)item2.Kod, CreateDate = TimeStamp.ToUnixTimestamp(noww), CreateUser = 1, Name = item2.Ad, Name2 = item2.Ad2, OldName = item2.EskiAd, ServiceUpdateDate = item2.GuncellemeZamani, StatusId = (int)item2.Durum, CsbmTypeId = typeId, QuarterCode = (int)item2.MahalleKodu, QuarterId = item.ID }); } } } _csbmRepository.Insert(ooo); return(new ServiceResponse <TTACSBMType>()); } catch (Exception ex) { return(new ServiceResponse <TTACSBMType>(ex)); } }
public async Task <ServiceResponse <TTAMahalleType> > InsertQuarterAsync() { try { var parent = _villageRepository.TableNoTracking; var parents = parent.ToList(); var head = new RequestHeaderType { BusinessID = "1", ConversationID = "1", MessageID = null, RequestID = "1" }; List <AddressQuarter> ooo = new List <AddressQuarter>(); foreach (var item in parents) { if (item.Code > 0 && item.StatusId == 1) { var req = new KoyeBagliMahalleListesiGetirRequestBodyType { GirdiParametreleri = new EkParametreType[] { new EkParametreType { Deger = null, Ad = null } }, KoyKodu = (long)item.Code }; TtAdresServiceSOAPClient soap = new TtAdresServiceSOAPClient(); var request = await soap.KoyeBagliMahalleListesiGetirAsync(head, req); var response = request.KoyeBagliMahalleListesiGetirResponseBody.Item as KoyeBagliMahalleListesiGetirResponseBodySuccessType; var items = response.KoyeBagliMahalleListesi.ToList(); var noww = DateTime.Now; foreach (var item2 in items) { int typeId = 0; switch (item2.Tipi) { case 0: typeId = 1; break; case 1: typeId = 2; break; case 3: typeId = 3; break; case 4: typeId = 4; break; case 5: typeId = 5; break; case 6: typeId = 6; break; default: break; } ooo.Add(new AddressQuarter { Code = (int)item2.Kod, CreateDate = TimeStamp.ToUnixTimestamp(noww), CreateUser = 1, Name = item2.Ad, Name2 = item2.Ad2, OldName = item2.EskiAd, ServiceUpdateDate = item2.GuncellemeZamani, StatusId = (int)item2.Durum, VillageId = item.ID, VillageCode = item.Code, AuthorizedAdminCode = item2.YetkiliIdareKodu != null ? (int)item2.YetkiliIdareKodu : new Nullable <int>(), MunicipalityCode = item2.BelediyeKodu != null ? (int)item2.BelediyeKodu : new Nullable <int>(), QuarterTypeId = typeId }); } } } _quarterRepository.Insert(ooo); return(new ServiceResponse <TTAMahalleType>()); } catch (Exception ex) { return(new ServiceResponse <TTAMahalleType>(ex)); } }
public async Task <ServiceResponse <TTAKoyType> > InsertVillageAsync() { try { var parent = _townshipRepository.TableNoTracking; var parents = parent.ToList(); // ILLER var head = new RequestHeaderType { BusinessID = "1", ConversationID = "1", MessageID = null, RequestID = "1" }; List <AddressVillage> ooo = new List <AddressVillage>(); foreach (var item in parents) { if (item.Code > 0 && item.StatusId == 1) { var req = new BucagaBagliKoyListesiGetirRequestBodyType { GirdiParametreleri = new EkParametreType[] { new EkParametreType { Deger = null, Ad = null } }, BucakKodu = (long)item.Code }; TtAdresServiceSOAPClient soap = new TtAdresServiceSOAPClient(); var request = await soap.BucagaBagliKoyListesiGetirAsync(head, req); var response = request.BucagaBagliKoyListesiGetirResponseBody.Item as BucagaBagliKoyListesiGetirResponseBodySuccessType; var items = response.BucagaBagliKoyListesi.ToList(); var noww = DateTime.Now; foreach (var item2 in items) { ooo.Add(new AddressVillage { Code = (int)item2.Kod, CreateDate = TimeStamp.ToUnixTimestamp(noww), CreateUser = 1, Name = item2.Ad, ServiceUpdateDate = item2.GuncellemeZamani, StatusId = (int)item2.Durum, TownshipId = item.ID, TownshipCode = item.Code, QueueNo = (int)item2.SiraNo }); } } } _villageRepository.Insert(ooo); return(new ServiceResponse <TTAKoyType>()); } catch (Exception ex) { return(new ServiceResponse <TTAKoyType>(ex)); } }
public async Task <ServiceResponse <TTABelediyeTTType> > InsertMunicipalitiesAsync() { try { var city = _cityRepository.TableNoTracking; var cities = city.ToList(); // ILLER var head = new RequestHeaderType { BusinessID = "1", ConversationID = "1", MessageID = null, RequestID = "1" }; List <AddressMunicipality> ooo = new List <AddressMunicipality>(); foreach (var item in cities) { if (item.Code > 0) { var req = new IleBagliBelediyeListesiGetirRequestBodyType { GirdiParametreleri = new EkParametreType[] { new EkParametreType { Deger = null, Ad = null } }, IlKodu = (long)item.Code }; TtAdresServiceSOAPClient asd = new TtAdresServiceSOAPClient(); var request = await asd.IleBagliBelediyeListesiGetirAsync(head, req); var response = request.IleBagliBelediyeListesiGetirResponseBody.Item as IleBagliBelediyeListesiGetirResponseBodySuccessType; var items = response.BelediyeListesi.ToList(); var noww = DateTime.Now; foreach (var item2 in items) { ooo.Add(new AddressMunicipality { Code = (int)item2.Kod, CreateDate = TimeStamp.ToUnixTimestamp(noww), CreateUser = 1, Name = item2.Ad, ServiceUpdateDate = item2.GuncellemeZamani, CityCode = (int)item2.IlKodu, StatusId = (int)item2.Durum, CityId = item.ID }); } } } _municipalityRepository.Insert(ooo); return(new ServiceResponse <TTABelediyeTTType>()); } catch (Exception ex) { return(new ServiceResponse <TTABelediyeTTType>(ex)); } }