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}");
}
}
}