public async Task <IActionResult> csv(IFormFile csv) { var consulates = new List <Consulate>(); using (var stream = csv.OpenReadStream()) using (var reader = new StreamReader(stream)) using (var csvReader = new CsvReader(reader, new CsvConfiguration(CultureInfo.InvariantCulture) { MissingFieldFound = null })) { csvReader.Read(); csvReader.ReadHeader(); while (csvReader.Read()) { var consulate = new Consulate { ConsulateType = csvReader.GetField("ConsulateType"), Country = csvReader.GetField("Country"), KoreanName = csvReader.GetField("KoreanName"), LocalName = csvReader.GetField("LocalName"), PhoneNumber = csvReader.GetField("PhoneNumber"), EmergencyPhoneNumber = csvReader.GetField("EmergencyPhoneNumber"), Email = csvReader.GetField("Email"), Address = csvReader.GetField("Address"), Homepage = csvReader.GetField("Homepage"), Latitude = csvReader.GetField <double>("Latitude"), Longitude = csvReader.GetField <double>("Longitude"), GoogleMap = csvReader.GetField("GoogleMap"), CountryCode = csvReader.GetField("CountryCode"), CountryCodeAndroid = csvReader.GetField("CountryCodeAndroid"), CountryCodeiOS = csvReader.GetField("CountryCodeiOS"), City = csvReader.GetField("City"), WorkingTime = csvReader.GetField("WorkingTime"), Description = csvReader.GetField("Description"), }; consulates.Add(consulate); } } await _dbContext.Consulates.AddRangeAsync(consulates); await _dbContext.SaveChangesAsync(); var savedConsulates = await _dbContext.Consulates.ToListAsync(); return(Ok(savedConsulates)); }
public List <Consulate> ReadConsulate() { List <Consulate> lstConsulate = new List <Consulate>(); DbCommand dbcommand = myDataBase.GetSqlStringCommand("Select consulate_id,consulate_name from Consulate"); using (IDataReader reader = myDataBase.ExecuteReader(dbcommand)) { while (reader.Read()) { Consulate consulate = new Consulate(); consulate.consulateName = GetStringFromDataReader(reader, "consulate_name"); consulate.consulateId = GetIntegerFromDataReader(reader, "consulate_id"); lstConsulate.Add(consulate); } return(lstConsulate); } }
static void Main(string[] args) { int testSamples = Convert.ToInt32(Console.ReadLine()); for (int i = 0; i < testSamples; i++) { int[] data = Array.ConvertAll(Console.ReadLine().Split(' '), int.Parse); Consulate[] consulate = new Consulate[data[0]]; Guest[] guest = new Guest[data[1]]; for (int g = 0; g < data[1]; g++) { string[] guestsData = Console.ReadLine().Split(' '); guest[g].currentPosition = Convert.ToInt32(guestsData[0]); guest[g].clockWise = guestsData[1] == "C"; Console.WriteLine(guest[g].clockWise); } for (int m = 0; m < data[2]; m++) { for (int g = 0; g < guest.Length; g++) { guest[g].currentPosition = guest[g].clockWise ? guest[g].currentPosition + 1 : guest[g].currentPosition - 1; consulate[guest[g].currentPosition].lastSeen.Clear(); consulate[guest[g].currentPosition].lastSeen.Add(g); } } // Console.Write("Case #" + i + ": "); // for (int g = 0; g < guest.Length; g++) // { // for (int i = 0; i < length; i++) // { // } // if (consulate[guest[g].]) // } } }