public void Run() { string log = String.Empty; ReplaceString replaceString = new ReplaceString(); DirectoryInfo dir = Directory.GetParent(Environment.CurrentDirectory).Parent.Parent; string dirPath = dir.FullName; string templateReport = System.IO.Path.Combine(dirPath, @"Json\Ward.json"); using (StreamReader r = new StreamReader(templateReport)) { string json = r.ReadToEnd(); List <Ward> items = JsonConvert.DeserializeObject <List <Ward> >(json); foreach (var item in items) { using (var context = new quickbeedev1Context()) { var ward = context.Translators.Where(x => x.DataKey == "VTP.WARD" && x.TranslatedValue == item.WARDS_ID.ToString()); if (ward.Count() == 0) { log += item.WARDS_NAME + "_" + item.DISTRICT_ID + "\n"; } } } } Console.WriteLine(log); }
public void Run() { string log = String.Empty; ReplaceString replaceString = new ReplaceString(); DirectoryInfo dir = Directory.GetParent(Environment.CurrentDirectory).Parent.Parent; string dirPath = dir.FullName; string templateReport = System.IO.Path.Combine(dirPath, @"Json\Province.json"); using (StreamReader r = new StreamReader(templateReport)) { string json = r.ReadToEnd(); List <Province> items = JsonConvert.DeserializeObject <List <Province> >(json); foreach (var item in items) { using (var context = new quickbeedev1Context()) { var provine = (from p in context.Provinces select new { Id = p.Id, Name = replaceString.Replace(p.Name, "PROVINCE") }).ToList(); var provinceObj = provine.Where(x => x.Name == replaceString.Replace(item.PROVINCE_NAME, "PROVINCE")).FirstOrDefault(); if (provinceObj != null) { var translators = new Translators() { DataKey = "VTP.PROVINCE", OriginalValue = Convert.ToString(provinceObj.Id), TranslatedValue = Convert.ToString(item.PROVINCE_ID) }; var provineExists = context.Translators.Where(x => x.DataKey == translators.DataKey && x.OriginalValue == translators.OriginalValue && x.TranslatedValue == translators.TranslatedValue); if (provineExists.Count() == 0) { context.Translators.Add(translators); context.SaveChanges(); log += provinceObj.Name + "-" + item.PROVINCE_NAME + "\n"; } } else { string a = replaceString.Replace(item.PROVINCE_NAME, "PROVINCE"); var province = new Provinces() { Name = item.PROVINCE_NAME, ProvinceType = "Tỉnh", CountryId = 256 }; context.Provinces.Add(province); context.SaveChanges(); var translators = new Translators() { DataKey = "VTP.PROVINCE", OriginalValue = Convert.ToString(province.Id), TranslatedValue = Convert.ToString(item.PROVINCE_ID) }; context.Translators.Add(translators); context.SaveChanges(); log += provinceObj.Name + "-" + item.PROVINCE_NAME + "\n"; } } } Console.WriteLine(log); } }
public void Run() { string log = String.Empty; ReplaceString replaceString = new ReplaceString(); DirectoryInfo dir = Directory.GetParent(Environment.CurrentDirectory).Parent.Parent; string dirPath = dir.FullName; string templateReport = System.IO.Path.Combine(dirPath, @"Json\District.json"); using (StreamReader r = new StreamReader(templateReport)) { string json = r.ReadToEnd(); List <District> items = JsonConvert.DeserializeObject <List <District> >(json); using (var context = new quickbeedev1Context()) { var translator = context.Translators.Where(x => x.DataKey == "VTP.PROVINCE").ToList(); foreach (var i in translator) { int? provinceOriginalId = Convert.ToInt32(i.OriginalValue); string provinceJsId = i.TranslatedValue; //List DistrictJS var districtJsList = items.Where(x => x.PROVINCE_ID == provinceJsId); var districtOriginalList = (from d in context.Districts.Where(x => x.ProvinceId == provinceOriginalId) select new { Id = d.Id, Name = replaceString.Replace(d.Name, "DISTRICT") }).ToList(); foreach (var itemD in districtJsList) { var districtOriginalObj = districtOriginalList.Where(x => x.Name == replaceString.Replace(itemD.DISTRICT_NAME, "DISTRICT")).FirstOrDefault(); if (districtOriginalObj != null) { var translators = new Translators() { DataKey = "VTP.DISTRICT", OriginalValue = Convert.ToString(districtOriginalObj.Id), TranslatedValue = Convert.ToString(itemD.DISTRICT_ID) }; var districtExists = context.Translators.Where(x => x.DataKey == translators.DataKey && x.TranslatedValue == translators.TranslatedValue); if (districtExists.Count() == 0) { context.Translators.Add(translators); context.SaveChanges(); log += districtOriginalObj.Name + "-" + itemD.DISTRICT_NAME + "\n"; } } else { var districtNew = new Districts() { Name = replaceString.ConverToUpper(itemD.DISTRICT_NAME), ProvinceId = provinceOriginalId ?? 0 }; context.Districts.Add(districtNew); context.SaveChanges(); var translators = new Translators() { DataKey = "VTP.DISTRICT", OriginalValue = Convert.ToString(districtNew.Id), TranslatedValue = provinceJsId }; context.Translators.Add(translators); context.SaveChanges(); log += itemD.DISTRICT_NAME + "\n"; } } } Console.WriteLine(log); } } }