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 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 createEnroll(EnrollDTO newEnroll)
{
using (var db = new ProjectDbContext())
{
var enroll = DTOEFMapper.GetEntityFromDTO(newEnroll);
db.Enrolls.Add(enroll);
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 createCapable(CapableDTO newCapable)
{
using (var db = new ProjectDbContext())
{
var cappable = DTOEFMapper.GetEntityFromDTO(newCapable);
db.Capables.Add(cappable);
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 createStatus(StatusDTO newStatus)
{
using (var db = new ProjectDbContext())
{
var status = DTOEFMapper.GetEntityFromDTO(newStatus);
db.Status.Add(status);
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 createModule(ModuleDTO newModule)
{
using (var db = new ProjectDbContext())
{
var module = DTOEFMapper.GetEntityFromDTO(newModule);
db.Modules.Add(module);
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 createClass(ClassTypesDTO newClass)
{
using (var db = new ProjectDbContext())
{
var classType = DTOEFMapper.GetEntityFromDTO(newClass);
db.ClassTypes.Add(classType);
db.SaveChanges();
}
}
public List <EvaluateDTO> findAllEvaluate()
{
using (var db = new ProjectDbContext())
{
List <EvaluateDTO> teachers = new List <EvaluateDTO>();
foreach (var entity in db.Evaluates)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
teachers.Add(dto);
}
return(teachers);
}
}
public List <ModuleDTO> findAllModule()
{
using (var db = new ProjectDbContext())
{
List <ModuleDTO> modules = new List <ModuleDTO>();
foreach (var entity in db.Modules)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
modules.Add(dto);
}
return(modules);
}
}
public List <ClassTypesDTO> findAllClassType()
{
using (var db = new ProjectDbContext())
{
List <ClassTypesDTO> classType = new List <ClassTypesDTO>();
foreach (var entity in db.ClassTypes)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
classType.Add(dto);
}
return(classType);
}
}
public List <StatusDTO> fidAllStatus()
{
using (var db = new ProjectDbContext())
{
List <StatusDTO> status = new List <StatusDTO>();
foreach (var entity in db.Status)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
status.Add(dto);
}
return(status);
}
}
public List <CapableDTO> findAllCapable()
{
List <CapableDTO> capables = new List <CapableDTO>();
using (var db = new ProjectDbContext())
{
foreach (var capable in db.Capables)
{
var dto = DTOEFMapper.GetDtoFromEntity(capable);
capables.Add(dto);
}
return(capables);
}
}
public List <AccountDTO> findAllAccount()
{
List <AccountDTO> accounts = new List <AccountDTO>();
using (var db = new ProjectDbContext())
{
foreach (var account in db.Accounts)
{
var dto = DTOEFMapper.GetDtoFromEntity(account);
accounts.Add(dto);
}
return(accounts);
}
}
public List <StudentDTO> findAllStudent()
{
List <StudentDTO> students = new List <StudentDTO>();
using (var db = new ProjectDbContext())
{
foreach (var student in db.Students)
{
var dto = DTOEFMapper.GetDtoFromEntity(student);
students.Add(dto);
}
return(students);
}
}
public List <EnrollDTO> findAllEnroll()
{
List <EnrollDTO> enrolls = new List <EnrollDTO>();
using (var db = new ProjectDbContext())
{
foreach (var enroll in db.Enrolls)
{
var dto = DTOEFMapper.GetDtoFromEntity(enroll);
enrolls.Add(dto);
}
return(enrolls);
}
}
public AccountDTO findById(string username)
{
using (var db = new ProjectDbContext())
{
var entity = db.Accounts.Where(x => x.username == username).FirstOrDefault();
if (entity != null)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
return(dto);
}
else
{
return(null);
}
}
}
public ClassTypesDTO findById(string classID)
{
using (var db = new ProjectDbContext())
{
var entity = db.ClassTypes.Where(x => x.TypeId == classID).FirstOrDefault();
if (entity != null)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
return(dto);
}
else
{
return(null);
}
}
}
public StudentDTO findById(string studentID)
{
using (var db = new ProjectDbContext())
{
var student = db.Students.Where(x => x.StudentId == studentID).FirstOrDefault();
if (student != null)
{
var dto = DTOEFMapper.GetDtoFromEntity(student);
return(dto);
}
else
{
return(null);
}
}
}
public TeacherDTO findById(string teacherID)
{
using (var db = new ProjectDbContext())
{
var entity = db.Teachers.Where(x => x.TeacherId == teacherID).FirstOrDefault();
if (entity != null)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
return(dto);
}
else
{
return(null);
}
}
}
public ModuleDTO findById(string moduleID)
{
using (var db = new ProjectDbContext())
{
var entity = db.Modules.Where(x => x.ModuleId == moduleID).FirstOrDefault();
if (entity != null)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
return(dto);
}
else
{
return(null);
}
}
}
public EnrollDTO findById(string enrollID)
{
using (var db = new ProjectDbContext())
{
var enroll = db.Enrolls.Where(x => x.StudentId + x.ClassId == enrollID).FirstOrDefault();
if (enroll != null)
{
var dto = DTOEFMapper.GetDtoFromEntity(enroll);
return(dto);
}
else
{
return(null);
}
}
}
public EvaluateDTO findById(string evaluaId)
{
using (var db = new ProjectDbContext())
{
var entity = db.Evaluates.Where(x => x.StudentId + x.ClassId == evaluaId).FirstOrDefault();
if (entity != null)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
return(dto);
}
else
{
return(null);
}
}
}
public List <EvaluateDTO> search(string query)
{
List <EvaluateDTO> dtos = new List <EvaluateDTO>();
using (var db = new ProjectDbContext())
{
var entities = db.Evaluates
.Where(e => (e.Student.FirstName.Contains(query) || e.Student.LastName.Contains(query)) ||
string.IsNullOrEmpty(query));
foreach (var entity in entities)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
dtos.Add(dto);
}
return(dtos);
}
}
public List <ClassTypesDTO> search(string query)
{
List <ClassTypesDTO> dtos = new List <ClassTypesDTO>();
using (var db = new ProjectDbContext())
{
var entities = db.ClassTypes
.Where(e => e.TypeId.Contains(query) ||
string.IsNullOrEmpty(query));
foreach (var entity in entities)
{
var dto = DTOEFMapper.GetDtoFromEntity(entity);
dtos.Add(dto);
}
return(dtos);
}
}
public List <CapableDTO> findById(string teacherID)
{
List <CapableDTO> capables = new List <CapableDTO>();
using (var db = new ProjectDbContext())
{
var capable = db.Capables.Where(x => x.TeacherId == teacherID).FirstOrDefault();
if (capable != null)
{
foreach (var capabless in db.Capables.Where(x => x.TeacherId == teacherID))
{
var dto = DTOEFMapper.GetDtoFromEntity(capabless);
capables.Add(dto);
}
return(capables);
}
else
{
return(null);
}
}
}
