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