private void PostalCode() { var items = GetTemplate <List <PostalCodeTemplate> >(@"Template\zipcodes.json"); foreach (var item in items) { try { var info = new PostalCodeInfo(); info.Code = item.ZIPCODE; info.Id = item.ZIPCODE_ID; info.SubAreaId = Convert.ToInt32(item.SUB_DISTRICT_ID); using (var context = new ThailandAddressMsSqlEntities()) { context.PostalCodeInfoes.Add(info); context.SaveChanges(); } } catch (Exception ex) { _logger.Error($"PostalCode || {ex}"); } } }
private void Area() { var items = GetTemplate <List <AreaTemplate> >(@"Template\districts.json"); foreach (var item in items) { try { var info = new AreaInfo(); info.Code = item.DISTRICT_CODE; info.Id = item.DISTRICT_ID; info.Name = item.DISTRICT_NAME; info.ProvinceId = item.PROVINCE_ID; using (var context = new ThailandAddressMsSqlEntities()) { context.AreaInfoes.Add(info); context.SaveChanges(); } } catch (Exception ex) { _logger.Error($"Area || {ex}"); } } }
private void Province() { var items = GetTemplate <List <ProvinceTemplate> >(@"Template\provinces.json"); foreach (var item in items) { try { var info = new ProvinceInfo(); info.Code = item.PROVINCE_CODE; info.GeographyId = item.GEO_ID; info.Id = item.PROVINCE_ID; info.Name = item.PROVINCE_NAME; using (var context = new ThailandAddressMsSqlEntities()) { context.ProvinceInfoes.Add(info); context.SaveChanges(); } } catch (Exception ex) { _logger.Error($"Province || {ex}"); } } }
private void Geography() { var items = GetTemplate <List <GeographyTemplate> >(@"Template\geography.json"); foreach (var item in items) { try { var info = new GeographyInfo(); info.Id = item.GEO_ID; info.Name = item.GEO_NAME; using (var context = new ThailandAddressMsSqlEntities()) { context.GeographyInfoes.Add(info); context.SaveChanges(); } } catch (Exception ex) { _logger.Error($"Geography || {ex}"); } } }