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].])
// }
}
}
