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