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