Exemplo n.º 1
0
 private void AddIfNotExists(MS_City city)
 {
     if (_context.MS_City.Any(l => l.cityCode == city.cityCode))
     {
         return;
     }
     _context.MS_City.Add(city);
     _context.SaveChanges();
 }
Exemplo n.º 2
0
        public void CreateMsCity(GetCreateMsCityInputDto input)
        {
            var cekCityName = (from A in _msCityRepo.GetAll()
                               where A.cityName == input.cityName && A.countyID == input.countyID
                               select A).FirstOrDefault();

            if (cekCityName == null)
            {
                var createMsCity = new MS_City
                {
                    cityName = input.cityName,
                    countyID = input.countyID
                };

                try
                {
                    _msCityRepo.Insert(createMsCity);
                    CurrentUnitOfWork.SaveChanges();
                }

                /*catch (DbEntityValidationException ex)
                 * {
                 *  var errorMessages = ex.EntityValidationErrors
                 *                          .SelectMany(x => x.ValidationErrors)
                 *                          .Select(x => x.ErrorMessage);
                 *  string fullErrorMessage = string.Join("; ", errorMessages);
                 *  string exceptionMessage = string.Concat("Validation Error: ", fullErrorMessage);
                 *  throw new UserFriendlyException(exceptionMessage);
                 * }*/
                // Handle data errors.
                catch (DataException exDb)
                {
                    throw new UserFriendlyException("Database Error : {0}", exDb.Message);
                }
                // Handle all other exceptions.
                catch (Exception ex)
                {
                    throw new UserFriendlyException("Error : {0}", ex.Message);
                }
            }
            else
            {
                throw new UserFriendlyException("City is exist!");
            }
        }
Exemplo n.º 3
0
        private void CreateLanguages()
        {
            List <MS_City> InitialCity = new List <MS_City>();
            List <String>  listCity    = new List <string>()
            {
                "1,0001,Ambarawa,Indonesia,ABW ",
                "1,0002,Amboina,Indonesia,AMB",
                "1,0003,Amlapura,Indonesia,AMP",
                "1,0004,Amuntai,Indonesia,AMT",
                "1,0005,Argamakmur,Indonesia,AGM",
                "1,0006,Atambua,Indonesia,ATB",
                "1,0007,Bagansiapiapi,Indonesia,BGN",
                "1,0008,Bajawa,Indonesia,BJW",
                "1,0009,Balige,Indonesia,BLG",
                "1,0010,Balikpapan,Indonesia,BPP",
                "1,0011,Bandaaceh,Indonesia,BAC",
                "1,0012,Bandarlampung,Indonesia,BLG",
                "1,0013,Bandung,Indonesia,BDG      ",
                "1,0014,Bangkalan,Indonesia,BKL    ",
                "1,0015,Bangkinang,Indonesia,BKG   ",
                "1,0016,Bangko,Indonesia,BGK       ",
                "1,0017,Bangli,Indonesia,BGL       ",
                "1,0018,Banjar,Indonesia,BJR       ",
                "1,0019,Banjarbaru,Indonesia,BJB   ",
                "1,0020,Banjarmasin,Indonesia,BJM  ",
                "1,0021,Banjarnegara,Indonesia,BJN ",
                "1,0022,Bantaeng,Indonesia,BTG     ",
                "1,0023,Bantul,Indonesia,BTL       ",
                "1,0024,Banyuwangi,Indonesia,BYI   ",
                "1,0025,Barabai,Indonesia,BRB      ",
                "1,0026,Barru,Indonesia,BRU        ",
                "1,0027,Batam,Indonesia,BTM        ",
                "1,0028,Batang,Indonesia,BTA       ",
                "1,0029,Batu,Indonesia,BAT         ",
                "1,0030,Baturaja,Indonesia,BTR     ",
                "1,0031,Batusangkar,Indonesia,BTS  ",
                "1,0032,Baubau,Indonesia,BAU       ",
                "1,0033,Bekasi,Indonesia,BKS       ",
                "1,0034,Bengkalis,Indonesia,BLS    ",
                "1,0035,Bengkulu,Indonesia,BLU     ",
                "1,0036,Benteng,Indonesia,BEN      ",
                "1,0037,Biak,Indonesia,BIK         ",
                "1,0038,Bima,Indonesia,BIM         ",
                "1,0039,Binjai,Indonesia,BIN       ",
                "1,0040,Bireuen,Indonesia,BRN      ",
                "1,0041,Bitung,Indonesia,BIT       ",
                "1,0042,Blitar,Indonesia,BLI       ",
                "1,0043,Blora,Indonesia,BLO        ",
                "1,0044,Bogor,Indonesia,BGR        ",
                "1,0045,Bojonegoro,Indonesia,BJN   ",
                "1,0046,Bondowoso,Indonesia,BWS    ",
                "1,0047,Bontang,Indonesia,BON      ",
                "1,0048,Boyolali,Indonesia,BYO     ",
                "1,0049,Brebes,Indonesia,BRS       ",
                "1,0050,Bukittinggi,Indonesia,BKT  ",
                "1,0051,Bulukumba,Indonesia,BKB    ",
                "1,0052,Buntok,Indonesia,BUT       ",
                "1,0053,Cepu,Indonesia,CEP         ",
                "1,0054,Ciamis,Indonesia,CMS       ",
                "1,0055,Cianjur,Indonesia,CJR      ",
                "1,0056,Cibinong,Indonesia,CBN     ",
                "1,0057,Cilacap,Indonesia,CLP      ",
                "1,0058,Cilegon,Indonesia,CLG      ",
                "1,0059,Cimahi,Indonesia,CMH       ",
                "1,0060,Cirebon,Indonesia,CRB      ",
                "1,0061,Curup,Indonesia,CRP        ",
                "1,0062,Demak,Indonesia,DEM        ",
                "1,0063,Denpasar,Indonesia,DEN     ",
                "1,0064,Depok,Indonesia,DPK        ",
                "1,0065,Dili,Indonesia,DIL         ",
                "1,0066,Dompu,Indonesia,DMP        ",
                "1,0067,Dumai,Indonesia,DUM        ",
                "1,0068,Ende,Indonesia,END         ",
                "1,0069,Enrekang,Indonesia,ERK     ",
                "1,0070,Fakfak,Indonesia,FFK       ",
                "1,0071,Garut,Indonesia,GAR        ",
                "1,0072,Gianyar,Indonesia,GYR      ",
                "1,0073,Gombong,Indonesia,GBG      ",
                "1,0074,Gorontalo,Indonesia,GRT    ",
                "1,0075,Gresik,Indonesia,GRE       ",
                "1,0076,Gunungsitoli,Indonesia,GSL ",
                "1,0077,Indramayu,Indonesia,IDM    ",
                "1,0078,Jakarta,Indonesia,JKT      ",
                "1,0079,Jambi,Indonesia,JAM        ",
                "1,0080,Jayapura,Indonesia,JYP     ",
                "1,0081,Jember,Indonesia,JEM       ",
                "1,0082,Jeneponto,Indonesia,JNP    ",
                "1,0083,Jepara,Indonesia,JPR       ",
                "1,0084,Jombang,Indonesia,JOM      ",
                "1,0085,Kabanjahe,Indonesia,KBJ    ",
                "1,0086,Kalabahi,Indonesia,KLB     ",
                "1,0087,Kalianda,Indonesia,KLD     ",
                "1,0088,Kandangan,Indonesia,KDG    ",
                "1,0089,Karanganyar,Indonesia,KRY  ",
                "1,0090,Karawang,Indonesia,KRW     ",
                "1,0091,Kasungan,Indonesia,KSG     ",
                "1,0092,Kayuagung,Indonesia,KYA    ",
                "1,0093,Kebumen,Indonesia,KBM      ",
                "1,0094,Kediri,Indonesia,KDR       ",
                "1,0095,Kefamenanu,Indonesia,KFM   ",
                "1,0096,Kendal,Indonesia,KDL       ",
                "1,0097,Kendari,Indonesia,KDR      ",
                "1,0098,Kertosono,Indonesia,KRS    ",
                "1,0099,Ketapang,Indonesia,KTP     ",
                "1,0100,Kisaran,Indonesia,KSR      ",
                "1,0101,Klaten,Indonesia,KLA       ",
                "1,0102,Kolaka,Indonesia,KLK       ",
                "1,0103,Kotabarupulaulaut,Indonesia,KBP",
                "1,0104,Kotabumi,Indonesia,KBU         ",
                "1,0105,Kotajantho,Indonesia,KJT       ",
                "1,0106,Kotamobagu,Indonesia,KMB       ",
                "1,0107,Kualakapuas,Indonesia,KLP      ",
                "1,0108,Kualakurun,Indonesia,KLR       ",
                "1,0109,Kualapembuang,Indonesia,KPB    ",
                "1,0110,Kualatungkal,Indonesia,KLT     ",
                "1,0111,Kudus,Indonesia,KDS            ",
                "1,0112,Kuningan,Indonesia,KNG         ",
                "1,0113,Kupang,Indonesia,KPG           ",
                "1,0114,Kutacane,Indonesia,KTC         ",
                "1,0115,Kutoarjo,Indonesia,KTJ         ",
                "1,0116,Lahat,Indonesia,LHT            ",
                "1,0117,Lamongan,Indonesia,LMG         ",
                "1,0118,Langsa,Indonesia,LGS           ",
                "1,0119,Larantuka,Indonesia,LRT        ",
                "1,0120,Lawang,Indonesia,LAW           ",
                "1,0121,Lhoseumawe,Indonesia,LHO       ",
                "1,0122,Limboto,Indonesia,LBT          ",
                "1,0123,Lubukbasung,Indonesia,LKB      ",
                "1,0124,Lubuklinggau,Indonesia,LKK     ",
                "1,0125,Lubukpakam,Indonesia,LKP       ",
                "1,0126,Lubuksikaping,Indonesia,LKS    ",
                "1,0127,Lumajang,Indonesia,LMJ         ",
                "1,0128,Luwuk,Indonesia,LUW            ",
                "1,0129,Madiun,Indonesia,MDN           ",
                "1,0130,Magelang,Indonesia,MGL         ",
                "1,0131,Magetan,Indonesia,MGT          ",
                "1,0132,Majalengka,Indonesia,MJL       ",
                "1,0133,Majene,Indonesia,MJN           ",
                "1,0134,Makale,Indonesia,MKL           ",
                "1,0135,Makassar,Indonesia,MKS         ",
                "1,0136,Malang,Indonesia,MLG           ",
                "1,0137,Mamuju,Indonesia,MMJ           ",
                "1,0138,Manado,Indonesia,MNA           ",
                "1,0139,Manna,Indonesia,MAN            ",
                "1,0140,Manokwari,Indonesia,MKW        ",
                "1,0141,Marabahan,Indonesia,MRB        ",
                "1,0142,Maros,Indonesia,MRS            ",
                "1,0143,Martapura,Indonesia,MTP        ",
                "1,0144,Masohi,Indonesia,MSH           ",
                "1,0145,Mataram,Indonesia,MTM          ",
                "1,0146,Maumere,Indonesia,MMR          ",
                "1,0147,Medan,Indonesia,MDN            ",
                "1,0148,Mempawah,Indonesia,MPW         ",
                "1,0149,Mentok,Indonesia,MTK           ",
                "1,0150,Merauke,Indonesia,MRK          ",
                "1,0151,Metro,Indonesia,MTR            ",
                "1,0152,Meulaboh,Indonesia,MEU         ",
                "1,0153,Mojokerto,Indonesia,MJK        ",
                "1,0154,Muarabulian,Indonesia,MRB      ",
                "1,0155,Muarabungo,Indonesia,MRG       ",
                "1,0156,Muaraenim,Indonesia,MRN        ",
                "1,0157,Muarateweh,Indonesia,MTW       ",
                "1,0158,Muarosijunjung,Indonesia,MRJ   ",
                "1,0159,Muntilan,Indonesia,MTL         ",
                "1,0160,Nabire,Indonesia,NBR           ",
                "1,0161,Negara,Indonesia,NGR           ",
                "1,0162,Nganjuk,Indonesia,NGJ          ",
                "1,0163,Ngawi,Indonesia,NGA            ",
                "1,0164,Pacitan,Indonesia,PCT          ",
                "1,0165,Padang,Indonesia,PDG           ",
                "1,0166,Padangpanjang,Indonesia,PPG    ",
                "1,0167,Padangsidempuan,Indonesia,PDS  ",
                "1,0168,Pagaralam,Indonesia,PGR        ",
                "1,0169,Painan,Indonesia,PAN           ",
                "1,0170,Palangkaraya,Indonesia,PLG     ",
                "1,0171,Palembang,Indonesia,PLB        ",
                "1,0172,Palopo,Indonesia,PLP           ",
                "1,0173,Palu,Indonesia,PAL             ",
                "1,0174,Pamekasan,Indonesia,PMK        ",
                "1,0175,Pandan,Indonesia,PDA           ",
                "1,0176,Pandeglang,Indonesia,PDG       ",
                "1,0177,Pangkajene,Indonesia,PKJ       ",
                "1,0178,Pangkajenesidenreng,Indonesia,PKS",
                "1,0179,Pangkalanbun,Indonesia,PKL       ",
                "1,0180,Pangkalpinang,Indonesia,PKP      ",
                "1,0181,Panyabungan,Indonesia,PYB        ",
                "1,0182,Pare,Indonesia,PRE               ",
                "1,0183,Parepare,Indonesia,PAR           ",
                "1,0184,Pariaman,Indonesia,PRM           ",
                "1,0185,Pasuruan,Indonesia,PSR           ",
                "1,0186,Pati,Indonesia,PAT               ",
                "1,0187,Payakumbuh,Indonesia,PAY         ",
                "1,0188,Pekalongan,Indonesia,PGA         ",
                "1,0189,Pekanbaru,Indonesia,PBR          ",
                "1,0190,Pemalang,Indonesia,PML           ",
                "1,0191,Pematangsiantar,Indonesia,PST    ",
                "1,0192,Pendopo,Indonesia,PDP            ",
                "1,0193,Pinrang,Indonesia,PIN            ",
                "1,0194,Pleihari,Indonesia,PLE           ",
                "1,0195,Polewali,Indonesia,PLW           ",
                "1,0196,Pondokgede,Indonesia,PKG         ",
                "1,0197,Ponorogo,Indonesia,PNG           ",
                "1,0198,Pontianak,Indonesia,PTK          ",
                "1,0199,Poso,Indonesia,PSO               ",
                "1,0200,Prabumulih,Indonesia,PRB         ",
                "1,0201,Praya,Indonesia,PRY              ",
                "1,0202,Probolinggo,Indonesia,PRL        ",
                "1,0203,Purbalingga,Indonesia,PBL        ",
                "1,0204,Purukcahu,Indonesia,PRC          ",
                "1,0205,Purwakarta,Indonesia,PWK         ",
                "1,0206,Purwodadigrobogan,Indonesia,PWD  ",
                "1,0207,Purwokerto,Indonesia,PWA         ",
                "1,0208,Purworejo,Indonesia,PWO          ",
                "1,0209,Putussibau,Indonesia,PTS         ",
                "1,0210,Raha,Indonesia,RAH               ",
                "1,0211,Rangkasbitung,Indonesia,RGS      ",
                "1,0212,Rantau,Indonesia,RTU             ",
                "1,0213,Rantauprapat,Indonesia,RTP       ",
                "1,0214,Rantepao,Indonesia,RTA           ",
                "1,0215,Rembang,Indonesia,RMB            ",
                "1,0216,Rengat,Indonesia,RGT             ",
                "1,0217,Ruteng,Indonesia,RTG             ",
                "1,0218,Sabang,Indonesia,SBG             ",
                "1,0219,Salatiga,Indonesia,STG           ",
                "1,0220,Samarinda,Indonesia,SMD          ",
                "1,0221,Sampang,Indonesia,SPG            ",
                "1,0222,Sampit,Indonesia,SPT             ",
                "1,0223,Sanggau,Indonesia,SGU            ",
                "1,0224,Sawahlunto,Indonesia,SWH         ",
                "1,0225,Sekayu,Indonesia,SKY             ",
                "1,0226,Selong,Indonesia,SEL             ",
                "1,0227,Semarang,Indonesia,SMG           ",
                "1,0228,Sengkang,Indonesia,SGK           ",
                "1,0229,Serang,Indonesia,SRG             ",
                "1,0230,Serui,Indonesia,SER              ",
                "1,0231,Sibolga,Indonesia,SBL            ",
                "1,0232,Sidikalang,Indonesia,SDK         ",
                "1,0233,Sidoarjo,Indonesia,SDR           ",
                "1,0234,Sigli,Indonesia,SGL              ",
                "1,0235,Singaparna,Indonesia,SGP         ",
                "1,0236,Singaraja,Indonesia,SRJ          ",
                "1,0237,Singkawang,Indonesia,SGW         ",
                "1,0238,Sinjai,Indonesia,SJI             ",
                "1,0239,Sintang,Indonesia,SNT            ",
                "1,0240,Situbondo,Indonesia,SBD          ",
                "1,0241,Slawi,Indonesia,SLW              ",
                "1,0242,Sleman,Indonesia,SLM             ",
                "1,0243,Soasiu,Indonesia,SOS             ",
                "1,0244,Soe,Indonesia,SOE                ",
                "1,0245,Solo,Indonesia,SOL               ",
                "1,0246,Solok,Indonesia,SLK              ",
                "1,0247,Soreang,Indonesia,SRE            ",
                "1,0248,Sorong,Indonesia,SOR             ",
                "1,0249,Sragen,Indonesia,SRA             ",
                "1,0250,Stabat,Indonesia,STA             ",
                "1,0251,Subang,Indonesia,SUB             ",
                "1,0252,Sukabumi,Indonesia,SBM           ",
                "1,0253,Sukoharjo,Indonesia,SKH          ",
                "1,0254,Sumbawabesar,Indonesia,SBB       ",
                "1,0255,Sumber,Indonesia,SBR             ",
                "1,0256,Sumedang,Indonesia,SMD           ",
                "1,0257,Sumenep,Indonesia,SMP            ",
                "1,0258,Sungailiat,Indonesia,SGT         ",
                "1,0259,Sungaipenuh,Indonesia,SPH        ",
                "1,0260,Sungguminasa,Indonesia,SGM       ",
                "1,0261,Surabaya,Indonesia,SBY           ",
                "1,0262,Tabanan,Indonesia,TBN            ",
                "1,0263,Tahuna,Indonesia,THN             ",
                "1,0264,Takalar,Indonesia,TKL            ",
                "1,0265,Takengon,Indonesia,TKG           ",
                "1,0266,Tamianglayang,Indonesia,TML      ",
                "1,0267,Tanahgrogot,Indonesia,TNG        ",
                "1,0268,Tangerang,Indonesia,TGR          ",
                "1,0269,Tanjungbalai,Indonesia,TBL       ",
                "1,0270,Tanjungenim,Indonesia,TGM        ",
                "1,0271,Tanjungpandan,Indonesia,TPD      ",
                "1,0272,Tanjungpinang,Indonesia,TPN      ",
                "1,0273,Tanjungredep,Indonesia,TRD       ",
                "1,0274,Tanjungselor,Indonesia,TSL       ",
                "1,0275,Tanjungtabalong,Indonesia,TTL    ",
                "1,0276,Tapaktuan,Indonesia,TPT          ",
                "1,0277,Tarakan,Indonesia,TRK            ",
                "1,0278,Tarutung,Indonesia,TRT           ",
                "1,0279,Tasikmalaya,Indonesia,TML        ",
                "1,0280,Tebingtinggi,Indonesia,TTI       ",
                "1,0281,Tegal,Indonesia,TGL              ",
                "1,0282,Temanggung,Indonesia,TMG         ",
                "1,0283,Tembilahan,Indonesia,TBN         ",
                "1,0284,Tenggarong,Indonesia,TGG         ",
                "1,0285,Ternate,Indonesia,TNT            ",
                "1,0286,Tolitoli,Indonesia,TTL           ",
                "1,0287,Tondano,Indonesia,TDN            ",
                "1,0288,Trenggalek,Indonesia,TRG         ",
                "1,0289,Tual,Indonesia,TUA               ",
                "1,0290,Tuban,Indonesia,TUB              ",
                "1,0291,Tulungagung,Indonesia,TLG        ",
                "1,0292,Ujungberung,Indonesia,UBG        ",
                "1,0293,Ungaran,Indonesia,UGR            ",
                "1,0294,Waikabubak,Indonesia,WKB         ",
                "1,0295,Waingapu,Indonesia,WGP           ",
                "1,0296,Watampone,Indonesia,WTP          ",
                "1,0297,Watansoppeng,Indonesia,WSP       ",
                "1,0298,Wates,Indonesia,WAT              ",
                "1,0299,Wonogiri,Indonesia,WNG           ",
                "1,0300,Wonosari,Indonesia,WNS           ",
                "1,0301,Wonosobo,Indonesia,WNO           ",
                "1,0302,Yogyakarta,Indonesia,YGY         ",
                "1,0303,Jakarta Barat,Indonesia,JBR      ",
                "1,0304,Jakarta Pusat,Indonesia,JPT      ",
                "1,0305,Jakarta Utara,Indonesia,JUT      ",
                "1,0306,Jakarta Selatan,Indonesia,JSL    ",
                "1,0307,Jakarta Timur,Indonesia,JTM      ",
                "1,0308,Singapore,Singapore,SGP          ",
                "1,0309,New York,United States of America,NYK",
                "1,0310,Timika,Indonesia,TMK                 ",
                "1,0311,Bangka,Indonesia,BGA                 ",
                "1,0312,Ontario,Canada,NULL                  ",
                "1,0313,Sulawesi Utara,Indonesia,NULL        ",
                "1,0314,Seria,Brunei Darusalam,NULL          ",
                "1,0315,Bandar seri Begawan,Brunei Darusalam,NULL",
                "1,0316,Nusa Dua,Indonesia,NULL                  ",
                "1,0317,Surakarta,Indonesia,NULL                 ",
                "1,0318,Gowa,Indonesia,NULL                      ",
                "1,0319,Bandar Bukit Tinggi,Malaysia,NULL        ",
                "1,0320,Johor Bahru,Malaysia,NULL                ",
                "1,0321,Attadale Perth,Australia,NULL            ",
                "1,0322,Shiu Fai Terrace,Hongkong,NULL           ",
                "1,0323,Mumbai,India,NULL                        ",
                "1,0324,Ampang,Malaysia,NULL                     ",
                "1,0325,Mimika,Indonesia,MMK                     ",
                "1,0326,Bali,Indonesia,BAL                       ",
                "1,0327,Ambon,Indonesia,ABN                      ",
                "1,0328,Waringin Timur,Indonesia,NULL            ",
                "1,0329,Luwu Timur,Indonesia,NULL                ",
                "1,0330,Luwu Utara,Indonesia,NULL                ",
                "1,0331,Wajo,Indonesia,NULL                      ",
                "1,0332,Toba Samosir,Indonesia,NULL              ",
                "1,0333,Nunukan,Indonesia,NULL                   ",
                "1,0334,Kepulauan Selayar,Indonesia,NULL         ",
                "1,0335,Maluku Tenggara,Indonesia,NULL           ",
                "1,0336,Kuala Lumpur,Malaysia,NULL               ",
                "1,0337,Semenyih,Malaysia,SEM                    ",
                "1,0338,Cikarang,Indonesia,CIK                   ",
                "1,0339,Lombok Barat,Indonesia,NULL              ",
                "1,0340,Nusa Tenggara Timur,Indonesia,NULL       ",
                "1,0341,Asmat,Indonesia,NULL                     ",
                "1,0342,Labuhanbatu,Indonesia,NULL               ",
                "1,0343,Belitung,Indonesia,NULL                  ",
                "1,0344,Toraja Utara,Indonesia,NULL              ",
                "1,0345,Bone,Indonesia,NULL                      ",
                "1,0346,Lombok Timur,Indonesia,NULL              ",
                "1,0347,Sinzig,German,NULL                       ",
                "1,0348,Yahukimo,Indonesia,NULL                  ",
                "1,0349,Kepulauan Talaud,Indonesia,NULL          ",
                "1,0350,Minahasa,Indonesia,NULL                  ",
                "1,0351,Kepulauan Sangihe,Indonesia,NULL         ",
                "1,0352,Tidore Kepulauan,Indonesia,NULL          ",
                "1,0353,Tomohon,Indonesia,NULL                   ",
                "1,0354,Halmahera Utara,Indonesia,NULL           ",
                "1,0355,Ogan Ilir,Indonesia,NULL                 ",
                "1,0356,Halmahera Selatan,Indonesia,NULL         ",
                "1,0357,Minahasa Selatan,Indonesia,NULL          ",
                "1,0359,Minahasa Utara,Indonesia,NULL            ",
                "1,0360,Halmahera Timur ,Indonesia,NULL          ",
                "1,0361,Raja Ampat,Indonesia,NULL                ",
                "1,0362,Maluku Utara,Indonesia,NULL              ",
                "1,0363,Kalimantan Barat,Indonesia,NULL          ",
                "1,0364,Bolaang Mongondow Utara,Indonesia,NULL   ",
                "1,0365,Minahasa Tenggara,Indonesia,NULL         ",
                "1,0366,Bolaang Mongondow Timur,Indonesia,NULL   ",
                "1,0367,Tana Toraja,Indonesia,NULL               ",
                "1,0368,Tambrauw,Indonesia,NULL                  ",
                "1,0369,Bombana,Indonesia,NULL                   ",
                "1,0370,Miami,United States of America,MIA       ",
                "1,0371,Copenhagen,Denmark,CPH                   ",
                "1,0372,Chicago,United States of America,CHI     ",
                "1,0373,Bangkok,Thailand,BKK                     ",
                "1,0374,Badung,Indonesia,NULL                    ",
                "1,0375,London,United Kingdom,LDN                ",
                "1,0376,Buol,Indonesia,NULL                      ",
                "1,0377,Paris,France,NULL                        ",
                "1,0378,Banyumas,Indonesia,NULL                  ",
                "1,0379,Deli Serdang,Indonesia,NULL              ",
                "1,0380,Manggarai,Indonesia,NULL                 ",
                "1,0381,Tapanuli Tengah,Indonesia,NULL           ",
                "1,0382,Rome,Italy,NULL"
            };

            foreach (var item in listCity)
            {
                var citySeparete = item.Split(',');
                var cityPush     = new MS_City()
                {
                    entityCode       = citySeparete[0],
                    cityCode         = citySeparete[1],
                    cityName         = citySeparete[2],
                    country          = citySeparete[3],
                    cityAbbreviation = citySeparete[4]
                };

                InitialCity.Add(cityPush);
            }

            foreach (var city in InitialCity)
            {
                AddIfNotExists(city);
            }
        }