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