static void Main(string[] args) { var ProvinseList = new ProvinceList(); var jp = new JNEJakartaParser(); jp.Parse(@"Input\JKT.xls", ProvinseList.Provinces); JNESurabayaParser p1 = new JNERegulerSurabayaParser(); p1.Parse(@"Input\REGULAR.xls", ProvinseList.Provinces); JNESurabayaParser p2 = new JNEOKESurabayaParser(); p2.Parse(@"Input\OKE.xls", ProvinseList.Provinces); FileStream stream1 = new FileStream("final.json", FileMode.OpenOrCreate); DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(ProvinceList)); ser.WriteObject(stream1, ProvinseList); var StateData = new GenerateStateList(); StateData.Execute(ProvinseList); var CityData = new GenerateCityList(); CityData.Execute(ProvinseList); var RateData = new GenerateRateList(); RateData.Execute(ProvinseList); }
public void Execute(ProvinceList provinces) { var kabupatenKotaNames = provinces.Provinces.SelectMany(p => p.KotaList).Where(k => k.KotaType == KotaType.Kabupaten).SelectMany(k => k.KecamatanList).Select(k => CsvUtility.ToLine(k.Kota.Province.Name, k.Kota.Name, k.Name)); var kotaNames = provinces.Provinces.SelectMany(p => p.KotaList).Where(k => k.KotaType == KotaType.Kota).Select(k => CsvUtility.ToLine(k.Province.Name, k.Name, k.Name)); kotaNames = kotaNames.Union(kabupatenKotaNames).OrderBy(k => k); CsvUtility.WriteFile(FileName, "", kotaNames); }
public void Execute(ProvinceList provinces) { var kabupatenKotaNames = provinces.Provinces.SelectMany(p => p.KotaList).Where(k => k.KotaType == KotaType.Kabupaten).SelectMany(k => k.KecamatanList).Select(k => CsvUtility.ToLine(k.Kota.Province.Name, k.Kota.Name, k.Name, k.JneRate.OkeRate, k.JneRate.RegulerRate)); var kotaNames = provinces.Provinces.SelectMany(p => p.KotaList).Where(k => k.KotaType == KotaType.Kota).Select(k => CsvUtility.ToLine(k.Province.Name, k.Name, k.Name, k.JneRate.OkeRate, k.JneRate.RegulerRate)); kotaNames = kotaNames.Union(kabupatenKotaNames).OrderBy(k => k); CsvUtility.WriteFile(FileName, "provice, city-kabupaten, city, jneoke, jnereguler", kotaNames); // print out the one that has no rate var errorkotaNames = provinces.Provinces.SelectMany(p => p.KotaList).SelectMany(k => k.KecamatanList).Where(k => k.JneRate.OkeRate == 0 && k.JneRate.RegulerRate == 0).Select(k => CsvUtility.ToLine(k.Kota.Province.Name, k.Name, k.JneRate.OkeRate, k.JneRate.RegulerRate)); CsvUtility.WriteFile(ErrorFileName, "provice, city, jneoke, jnereguler", errorkotaNames); }
public void Execute(ProvinceList provinces) { var provinceNames = provinces.Provinces.Select(p => CsvUtility.ToLine(p.Name)); CsvUtility.WriteFile(fileName, "provice", provinceNames); }