// Add new item
public Program AddProgram(ProgramAdd Program)
{
// Map from DTO object to domain (POCO) object
var p = ds.Programs.Add(Mapper.Map <ICTGWS.Models.Program>(Program));
ds.SaveChanges();
// Map to DTO object
return(Mapper.Map <Program>(p));
}
protected override void Seed(ApplicationDbContext context)
{
if (context.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);
// Process the file contents in a loop
while (csv.Read())
{
ProgramAdd addProgram = csv.GetRecord <ProgramAdd>();
context.Programs.Add(Mapper.Map <Program>(addProgram));
}
// Clean up
sr.Close();
sr = null;
// Deliver or otherwise process the results
context.SaveChanges();
}
if (context.Courses.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-courses-bsd.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);
// Process the file contents in a loop
while (csv.Read())
{
CourseAdd addCourse = csv.GetRecord <CourseAdd>();
context.Courses.Add(Mapper.Map <Course>(addCourse));
}
// Clean up
sr.Close();
sr = null;
// Deliver or otherwise process the results
context.SaveChanges();
}
/*
* var bsd = new Program();
* bsd.Code = "BSD";
* bsd.Name = "Bachelor of Software Development";
* bsd.Description = "Welcome to Bachelor of Software Development...";
* bsd.Credential = "Bachelor degree";
* context.Programs.Add(bsd);
* context.SaveChanges();
*
* var cpa = new Program();
* cpa.Code = "CPA";
* cpa.Name = "Computer Programmer Analyst";
* cpa.Description = "Welcome to Computer Programmer Analyst...";
* cpa.Credential = "Advanced Diploma";
* context.Programs.Add(cpa);
* context.SaveChanges();
*
* var cpp = new Course();
* cpp.Code = "cpp";
* cpp.Name = "C++";
* cpp.Description = "Intro to C++";
* context.Courses.Add(cpp);
* context.SaveChanges();
*
* var oop = new Course();
* oop.Code = "oop";
* oop.Name = "Object Oriented Programming";
* oop.Description = "Programming with Objects";
* context.Courses.Add(oop);
* context.SaveChanges();
*
* var btc = new Course();
* btc.Code = "btc";
* btc.Name = "Communication";
* btc.Description = "Written and verbal communicaiton course";
* context.Courses.Add(btc);
* context.SaveChanges();
*/
}