// Method to import records from the CSV file
private static void ImportStudentsCSV()
{ //Recover CSV file path
string sruta = System.Configuration.ConfigurationManager.AppSettings["RutaFile"];
string[] lines = File.ReadAllLines(sruta);
string PreMessage = "ConsoleApp.exe input.csv ";
foreach (var line in lines)
{
//Separate comma values, for each line
var values = line.Split(',');
//Instance the object
clsStudent oStudent = new clsStudent();
bool sw;
// Use the object method to Insert
sw = oStudent.AddStudent(values[0].ToString(), values[1].ToString(), values[2].ToString(), FormatDate(values[3].ToString()));
if (sw)
{
Console.WriteLine(PreMessage + "name=" + values[1].ToString()); // name
Console.WriteLine(PreMessage + "type=" + values[0].ToString()); // type
string sGender = (values[2].ToString() == "F") ? "female" : "male";
Console.WriteLine(PreMessage + "gender=" + sGender); // gender
Console.WriteLine("Registered line... ");
}
else
{
Console.WriteLine("Error");
}
}
}
public void AddStudent_Test()
{
//Instance the object
clsStudent oStudent = new clsStudent();
var vResult = oStudent.AddStudent("university", "ivan", "M", DateTime.Now);
Assert.IsNotNull(vResult, "Test");
Console.WriteLine("-----Test Method AddStudent-----");
Console.WriteLine(vResult);
}
