public void LoadProgramFromCSV()
{
if (!(ds.Programs.Count() > 0))
{
// File system path to the data file (in this project's App_Data folder)
string path = HttpContext.Current.Server.MapPath("~/App_Data/ict-programs.csv");
// Create a stream reader object, to read from the file system
StreamReader sr = File.OpenText(path);
// Create the CsvHelper object
var csv = new CsvReader(sr);
// Configure the mapping classes (if it exists)
csv.Configuration.RegisterClassMap <ProgramMap>();
// Go through the data file
while (csv.Read())
{
// Read one line in the source file into a new object
ProgramAdd qb = csv.GetRecord <ProgramAdd>();
// Add the new object to the data store
ds.Programs.Add(Mapper.Map <Program>(qb));
}
ds.SaveChanges();
// Clean up
sr.Close();
sr = null;
}
}
//#####################################################################
//Dataimports
public IEnumerable <ProgramBase> ReadProgramsFromCSV()
{
// File system path to the data file (in this project's App_Data folder)
string path = HttpContext.Current.Server.MapPath("~/App_Data/ict-programs.csv");
// Create a stream reader object, to read from the file system
StreamReader sr = File.OpenText(path);
// Create the CsvHelper object
var csv = new CsvReader(sr);
// Configure the mapping classes (if it exists)
csv.Configuration.RegisterClassMap <ProgramMap>();
// Configure a collection to hold the results
List <ProgramAdd> results = new List <ProgramAdd>();
// Go through the data file
while (csv.Read())
{
// Read one line in the source file
ProgramAdd qb = csv.GetRecord <ProgramAdd>();
results.Add(qb);
}
// Clean up
sr.Close();
sr = null;
// Return the results
return(Mapper.Map <IEnumerable <ProgramBase> >(results));
}
