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 <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 <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 <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 <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 <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 <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 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 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 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 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 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 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 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 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);
}
}
}