public CCourse GetCourse(int courseId)
{
Assignment2Entities db = new Assignment2Entities();
Course course = db.Courses.Where(x => x.CourseId == courseId).FirstOrDefault();
List <Enroll> enrolls = course.Enrolls.ToList();
List <CStudent> classStudents = new List <CStudent>();
StudentWebService studentWebService = new StudentWebService();
foreach (Enroll e in enrolls)
{
classStudents.Add(studentWebService.ConvertToCStudent(e.Student));
}
CCourse cCourse = new CCourse();
db.Dispose();
cCourse = ConvertToCCourse(course);
cCourse.Students = classStudents;
return(cCourse);
}
public CStudent GetStudent(int studentId)
{
Assignment2Entities db = new Assignment2Entities();
Student student = db.Students.Where(x => x.StudentId == studentId).FirstOrDefault();
List <Enroll> enrollments = student.Enrolls.ToList();
List <CCourse> cCourses = new List <CCourse>();
CourseWebService courseWebService = new CourseWebService();
foreach (Enroll e in enrollments)
{
cCourses.Add(courseWebService.ConvertToCCourse(e.Course));
}
CStudent classStudent = new CStudent();
db.Dispose();
classStudent = ConvertToCStudent(student);
classStudent.Courses = cCourses;
return(classStudent);
}
public Boolean AddCourse(CCourse cCourse)
{
Assignment2Entities db = new Assignment2Entities();
Course course = new Course();
course = ConvertToCourse(cCourse);
db.Courses.Add(course);
db.SaveChanges();
db.Dispose();
return(true);
}
public Boolean AddStudent(CStudent classStudent)
{
Assignment2Entities db = new Assignment2Entities();
Student student = new Student();
student = ConvertToStudent(classStudent);
db.Students.Add(student);
db.SaveChanges();
db.Dispose();
return(true);
}
public Boolean SaveCourse(CCourse cCourse)
{
Assignment2Entities db = new Assignment2Entities();
Course course = db.Courses.Where(x => x.CourseId == cCourse.CourseId).FirstOrDefault();
Course studentTemp = ConvertToCourse(cCourse);
db.Entry(course).CurrentValues.SetValues(studentTemp);
db.SaveChanges();
db.Dispose();
return(true);
}
public Boolean SaveStudent(CStudent classStudent)
{
Assignment2Entities db = new Assignment2Entities();
Student student = db.Students.Where(x => x.StudentId == classStudent.StudentId).FirstOrDefault();
Student studentTemp = ConvertToStudent(classStudent);
db.Entry(student).CurrentValues.SetValues(studentTemp);
db.SaveChanges();
db.Dispose();
return(true);
}
public Boolean DeleteStudent(int studentId)
{
Assignment2Entities db = new Assignment2Entities();
Student student = db.Students.Where(x => x.StudentId == studentId).FirstOrDefault();
List <Enroll> enrollments = student.Enrolls.ToList();
db.Enrolls.RemoveRange(enrollments);
db.Students.Remove(student);
db.SaveChanges();
db.Dispose();
return(true);
}
public List <CCourse> GetAllCourses()
{
Assignment2Entities db = new Assignment2Entities();
List <Course> courses = db.Courses.ToList();
List <CCourse> cCourses = new List <CCourse>();
db.Dispose();
foreach (Course c in courses)
{
cCourses.Add(ConvertToCCourse(c));
}
return(cCourses);
}
public Boolean DeleteCourse(int studentId)
{
Assignment2Entities db = new Assignment2Entities();
Course course = db.Courses.Where(x => x.CourseId == studentId).FirstOrDefault();
List <Enroll> enrolls = course.Enrolls.ToList();
db.Enrolls.RemoveRange(enrolls);
db.Courses.Remove(course);
db.SaveChanges();
db.Dispose();
return(true);
}
public List <CStudent> GetAllStudents()
{
Assignment2Entities db = new Assignment2Entities();
List <Student> students = db.Students.ToList();
List <CStudent> classStudents = new List <CStudent>();
db.Dispose();
foreach (Student s in students)
{
classStudents.Add(ConvertToCStudent(s));
}
return(classStudents);
}
public List <CCourse> SearchCourses(String coursename)
{
Assignment2Entities db = new Assignment2Entities();
List <Course> courses = (from m in db.Courses
where m.CourseName.Contains(coursename)
select m).ToList();
List <CCourse> cCourses = new List <CCourse>();
db.Dispose();
foreach (Course c in courses)
{
cCourses.Add(ConvertToCCourse(c));
}
return(cCourses);
}
public List <CStudent> SearchStudents(String studentName)
{
Assignment2Entities db = new Assignment2Entities();
List <Student> students = (from m in db.Students
where m.StudentName.Contains(studentName)
select m).ToList();
List <CStudent> classStudents = new List <CStudent>();
db.Dispose();
foreach (Student s in students)
{
classStudents.Add(ConvertToCStudent(s));
}
return(classStudents);
}
public Boolean Enroll(int studentId, int courseId)
{
Assignment2Entities db = new Assignment2Entities();
Enroll enroll = db.Enrolls.Where(x => x.StudentId == studentId && x.CourseId == courseId).FirstOrDefault();
if (enroll != null)
{
return(false);
}
Enroll enrollment = new Enroll();
enrollment.StudentId = studentId;
enrollment.CourseId = courseId;
db.Enrolls.Add(enrollment);
db.SaveChanges();
db.Dispose();
return(true);
}