public void importData(string path)
{
using (var db = new ProjectDbContext())
{
StreamReader streamCsv = new StreamReader(path);
string csvDataLine = "";
string[] data = null;
var lineHeader = streamCsv.ReadLine();
while ((csvDataLine = streamCsv.ReadLine()) != null)
{
data = csvDataLine.Split(',');
var newClass = new ClassDTO
{
ClassId = data[0],
TeachingHour = Convert.ToInt32(data[1]),
ModuleId = data[2],
StatusId = data[3],
TeacherId = data[4],
TypeId = data[5]
};
var dto = DTOEFMapper.GetEntityFromDTO(newClass);
db.Classes.Add(dto);
db.SaveChanges();
}
}
}
public void importData(string path)
{
using (var db = new ProjectDbContext())
{
StreamReader streamCsv = new StreamReader(path);
string csvDataLine = "";
string[] data = null;
var lineHeader = streamCsv.ReadLine();
while ((csvDataLine = streamCsv.ReadLine()) != null)
{
data = csvDataLine.Split(',');
var newEnreoll = new EnrollDTO
{
StudentId = data[0],
ClassId = data[1],
Passed = Convert.ToInt32(data[2]),
Hw1Grade = Convert.ToDouble(data[3]),
Hw2Grade = Convert.ToDouble(data[4]),
Hw3Grade = Convert.ToDouble(data[5]),
Hw4Grade = Convert.ToDouble(data[6]),
Hw5Grade = Convert.ToDouble(data[7]),
ExamGrade = data[8]
};
var dto = DTOEFMapper.GetEntityFromDTO(newEnreoll);
db.Enrolls.Add(dto);
db.SaveChanges();
}
}
}
public void createEvaluate(EvaluateDTO newEvalua)
{
using (var db = new ProjectDbContext())
{
var evalua = DTOEFMapper.GetEntityFromDTO(newEvalua);
db.Evaluates.Add(evalua);
db.SaveChanges();
}
}
public void createModule(ModuleDTO newModule)
{
using (var db = new ProjectDbContext())
{
var module = DTOEFMapper.GetEntityFromDTO(newModule);
db.Modules.Add(module);
db.SaveChanges();
}
}
public void createStatus(StatusDTO newStatus)
{
using (var db = new ProjectDbContext())
{
var status = DTOEFMapper.GetEntityFromDTO(newStatus);
db.Status.Add(status);
db.SaveChanges();
}
}
public void createClass(ClassTypesDTO newClass)
{
using (var db = new ProjectDbContext())
{
var classType = DTOEFMapper.GetEntityFromDTO(newClass);
db.ClassTypes.Add(classType);
db.SaveChanges();
}
}
public void createTeacher(TeacherDTO newTeacher)
{
using (var db = new ProjectDbContext())
{
var teacher = DTOEFMapper.GetEntityFromDTO(newTeacher);
db.Teachers.Add(teacher);
db.SaveChanges();
}
}
public void createStudent(StudentDTO newStudent)
{
using (var db = new ProjectDbContext())
{
var student = DTOEFMapper.GetEntityFromDTO(newStudent);
db.Students.Add(student);
db.SaveChanges();
}
}
public void createAccount(AccountDTO newAccount)
{
using (var db = new ProjectDbContext())
{
var account = DTOEFMapper.GetEntityFromDTO(newAccount);
db.Accounts.Add(account);
db.SaveChanges();
}
}
public void createEnroll(EnrollDTO newEnroll)
{
using (var db = new ProjectDbContext())
{
var enroll = DTOEFMapper.GetEntityFromDTO(newEnroll);
db.Enrolls.Add(enroll);
db.SaveChanges();
}
}
public void createCapable(CapableDTO newCapable)
{
using (var db = new ProjectDbContext())
{
var cappable = DTOEFMapper.GetEntityFromDTO(newCapable);
db.Capables.Add(cappable);
db.SaveChanges();
}
}