public UniversityStudentsList CreateUniversityStudentList(UniversityStudentsList uniStudent) { courseService = new CourseService(); UniversityStudentsList universityStudent = new UniversityStudentsList(); // check university student model bool modelIsOK = CheckUniversityStudentModel(uniStudent); if (!modelIsOK) { return(null); } //Check if student already exists bool studentAlreadyExists = CheckIfStudentAlreadyExists(uniStudent); if (studentAlreadyExists) { return(null); } // if model is ok, populate UNiversityStudent universityStudent = PopulateUniversityStudent(universityStudent, uniStudent); // add student to university student list and save to db AddStudentToUniversityStudentListAndSaveToDb(universityStudent); return(universityStudent); }
public void AddNewStudentToUniversityStudentsLists(UniversityStudentsList student) { db.UniversityStudentsList.Add(student); db.SaveChanges(); bool enrolled = student.isEnrolled; }
public Student RegisterStudent(UniversityStudentsList uniStudent) { studentRegisterService = new StudentRegisterService(); Student student = studentRegisterService.RegisterStudent(uniStudent); return(student); }
public void UpdateStudentByUniStudent(UniversityStudentsList previousUniStudent, Student student) { Student theStudent = db.Students.Find(student.ID); theStudent.Name = previousUniStudent.Name; //theStudent.CourseId = previousUniStudent.CourseId; db.SaveChanges(); }
public UniversityStudentsList CreateUniversityStudent(UniversityStudentsList uniStudent) { universityStudentsListService = new UniversityStudentsListService(); UniversityStudentsList universityStudent = universityStudentsListService .CreateUniversityStudentList(uniStudent); return(universityStudent); }
public Student CheckIfUniversityStudentExistsInStudentsDB(UniversityStudentsList uniStudent) { universityStudentsListService = new UniversityStudentsListService(); Student student = universityStudentsListService .CheckIfUniversityStudentExistsInStudentsDB(uniStudent); return(student); }
public UniversityStudentsList UpdateUniversityStudent(int id, UniversityStudentsList uniStudent) { universityStudentsListService = new UniversityStudentsListService(); UniversityStudentsList universityStudent = universityStudentsListService .UpdateUniversityStudent(id, uniStudent); return(universityStudent); }
public void UpdateUniversityStudentEnrollment(UniversityStudentsList student) { UniversityStudentsList newUniversityStudent; IEnumerable <UniversityStudentsList> universityStudents = db.UniversityStudentsList .Where(u => u.Email == student.Email).ToList(); newUniversityStudent = universityStudents.ToArray()[0]; newUniversityStudent.isEnrolled = true; db.SaveChanges(); }
public bool CheckIfStudentExistsInUniversityListDb(int id) { UniversityStudentsList uniStudent = db.UniversityStudentsList.Find(id); if (uniStudent == null) { return(false); } return(true); }
public Student CheckIfUniversityStudentExistsInStudentsDB(UniversityStudentsList uniStudent) { // compare emails IEnumerable <Student> students = db.Students.Where(s => s.Email == uniStudent.Email).ToList(); if (students.Count() == 0) { return(null); } return(students.ToArray()[0]); }
public bool CheckUniversityStudentModel(UniversityStudentsList uniStudent) { courseService = new CourseService(); if (uniStudent.Name == null || uniStudent.Email == null || uniStudent.IdentificationCard == 0 || uniStudent.Birthday == null || courseService.GetCourseByCourseId(uniStudent.CourseId) == null) { return(false); } return(true); }
public UniversityStudentsList GetUniversityStudentsList(int id) { UniversityStudentsList uniStudent = new UniversityStudentsList(); uniStudent = db.UniversityStudentsList.Find(id); if (uniStudent == null) { return(null); } return(uniStudent); }
public UniversityStudentsList PopulateUniversityStudent(UniversityStudentsList StudentToUpdate, UniversityStudentsList uniStudent) { UniversityStudentsList universityStudent = db.UniversityStudentsList.Find(StudentToUpdate.Id); universityStudent.Name = uniStudent.Name; universityStudent.Email = uniStudent.Email; universityStudent.IdentificationCard = uniStudent.IdentificationCard; universityStudent.CourseId = uniStudent.CourseId; universityStudent.Birthday = uniStudent.Birthday; db.SaveChanges(); return(universityStudent); }
public UniversityStudentsList UpdateUniversityStudent(int id, UniversityStudentsList uniStudent) { UniversityStudentsList studentToUpdate = db.UniversityStudentsList.Find(id); if (!CheckUniversityStudentModel(uniStudent)) { return(null); } // if model is ok, populate UNiversityStudent and save it to db UniversityStudentsList universityStudent = PopulateUniversityStudent(studentToUpdate, uniStudent); return(studentToUpdate); }
public void ChangeNameByStudentId(string email, string name) { studentService = new StudentService(); IEnumerable <UniversityStudentsList> uniStudents = db.UniversityStudentsList .Where(u => u.Email == email); if (uniStudents.ToList().Count > 0) { UniversityStudentsList uniStudent = uniStudents.ToArray()[0]; uniStudent.Name = name; db.SaveChanges(); } }
public ActionResult CreateUniversityStudent() { courseService = new CourseService(); UniversityStudentsList newStudent = new UniversityStudentsList(); IEnumerable <Course> courses = courseService.ListCourses(); UniversityStudentCreationViewModel viewModel = new UniversityStudentCreationViewModel() { Student = newStudent, Courses = courses }; return(View("CreateUniversityStudent", viewModel)); }
public void SetIsEnrolledToFalseByStudentId(int id) { List <Student> students = db.Students.Where(s => s.ID == id).ToList(); Student student = students.ToArray()[0]; List <UniversityStudentsList> universityStudents = db.UniversityStudentsList .Where(u => u.Email == student.Email).ToList(); UniversityStudentsList universityStudent = universityStudents.ToArray()[0]; universityStudent.isEnrolled = false; db.Entry(universityStudent).State = EntityState.Modified; db.SaveChanges(); }
public IHttpActionResult UpdateUniversityStudent(int id, UniversityStudentListDTO uniStudentDTO) { universityStudentsListsService = new UniversityStudentsListsService(); UniversityStudentsList updatedStudent = new UniversityStudentsList(); //check if uniStudent exists in University Students List db bool universityStudentExistsInDb = universityStudentsListsService .CheckIfStudentExistsInUniversityListDb(id); if (!universityStudentExistsInDb) { return(NotFound()); } // get previsous version of uniStudent UniversityStudentsList previousUniStudent = universityStudentsListsService .GetUniversityStudentsList(id); // check if uniStudent exists in db.Students Student student = universityStudentsListsService .CheckIfUniversityStudentExistsInStudentsDB(previousUniStudent); if (student == null) { UniversityStudentsList aStudent = Mapper.Map <UniversityStudentListDTO, UniversityStudentsList>(uniStudentDTO); updatedStudent = universityStudentsListsService.UpdateUniversityStudent(id, aStudent); UniversityStudentListDTO updatedUniversityStudentDTO = Mapper .Map <UniversityStudentsList, UniversityStudentListDTO>(updatedStudent); return(Ok(updatedUniversityStudentDTO)); } UniversityStudentsList anotherStudent = Mapper.Map <UniversityStudentListDTO, UniversityStudentsList>(uniStudentDTO); updatedStudent = universityStudentsListsService.UpdateUniversityStudent(id, anotherStudent); universityStudentsListsService.UpdateStudentByUniStudent(updatedStudent, student); UniversityStudentListDTO anotherUpdatedUniversityStudentDTO = Mapper .Map <UniversityStudentsList, UniversityStudentListDTO>(updatedStudent); return(Ok(anotherUpdatedUniversityStudentDTO)); }
public ActionResult CreateUniversityStudent(UniversityStudentsList student) { if (!ModelState.IsValid) { return(RedirectToAction("Index")); } if (student == null) { return(RedirectToAction("Index")); } uniService = new UniversityStudentsListService(); // put student on the university students list uniService.AddNewStudentToUniversityStudentsLists(student); return(RedirectToAction("Index")); }
public Student AddStudent(UniversityStudentsList student) { uniService = new UniversityStudentsListService(); Student studentToRegister = new Student() { Name = student.Name, Email = student.Email, CourseId = student.CourseId, isEnrolled = true }; db.Students.Add(studentToRegister); db.SaveChanges(); uniService.UpdateUniversityStudentEnrollment(student); return(studentToRegister); }
public bool CheckIfStudentAlreadyExists(UniversityStudentsList uniStudent) { IEnumerable <UniversityStudentsList> emails = db.UniversityStudentsList .Where(u => u.Email == uniStudent.Email).ToList(); if (emails.Count() > 0) { return(false); } IEnumerable <UniversityStudentsList> identificationCards = db.UniversityStudentsList .Where(u => u.IdentificationCard == uniStudent.IdentificationCard).ToList(); if (identificationCards.Count() > 0) { return(false); } return(true); }
public IHttpActionResult CreateUniversityStudent(UniversityStudentListDTO uniStudentDTO) { universityStudentsListsService = new UniversityStudentsListsService(); UniversityStudentsList theUniStudent = Mapper.Map <UniversityStudentListDTO, UniversityStudentsList>(uniStudentDTO); UniversityStudentsList universityStudent = universityStudentsListsService .CreateUniversityStudent(theUniStudent); if (universityStudent == null) { return(BadRequest()); } UniversityStudentListDTO theUniversityStudentDTO = Mapper.Map <UniversityStudentsList, UniversityStudentListDTO>(universityStudent); return(Created(new Uri(Request.RequestUri + "/" + theUniversityStudentDTO.Id), theUniversityStudentDTO)); }
// GET /api/universitystudenteslistss/id public IHttpActionResult GetUniversityStudentsList(int id) { if (id == 0) { BadRequest(); } universityStudentsListsService = new UniversityStudentsListsService(); UniversityStudentsList uniStudent = universityStudentsListsService .GetUniversityStudentsList(id); if (uniStudent == null) { NotFound(); } UniversityStudentListDTO uniStudentDTO = Mapper.Map <UniversityStudentsList, UniversityStudentListDTO>(uniStudent); return(Ok(uniStudentDTO)); }
public Student RegisterStudent(UniversityStudentsList student) { courseSubjectService = new CourseSubjectService(); studentService = new StudentService(); studentSubjectService = new StudentSubjectService(); universityStudentsListService = new UniversityStudentsListService(); Student studentToRegister = new Student(); // adding and saving student to db, changing university list isEnrolled to true studentToRegister = studentService.AddStudent(student); //populate student with student subjects ICollection <Subject> studentCourseSubjects = new List <Subject>(); studentCourseSubjects = courseSubjectService.GetSubjectsFromCourse(studentToRegister.CourseId); studentSubjectService.CreateStudentSubjectList(studentCourseSubjects.ToList(), studentToRegister); return(studentToRegister); }
public void UpdateStudentByUniStudent(UniversityStudentsList previousUniStudent, Student student) { studentService = new StudentService(); studentService.UpdateStudentByUniStudent(previousUniStudent, student); }
public void AddStudentToUniversityStudentListAndSaveToDb(UniversityStudentsList universityStudent) { db.UniversityStudentsList.Add(universityStudent); db.SaveChanges(); }