/// <summary>Gets how many Teachers exist.<summary>
public int GetTeachersCount()
{
using (DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return(dataContext.Teachers.Count());
}
}
/// <summary>Gets how many Enrollments exist.<summary>
public int GetEnrollmentsCount()
{
using (DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return(dataContext.Enrollments.Count());
}
}
/// <summary>Gets how many Students exist.<summary>
public int GetStudentsCount()
{
using (DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return(dataContext.Students.Count());
}
}
/// <summary>Gets how many Courses exist.<summary>
public int GetCoursesCount()
{
using (DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return(dataContext.Courses.Count());
}
}
/// <summary>Gets how many Semesters exist.<summary>
public int GetSemestersCount()
{
using (DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return(dataContext.Semesters.Count());
}
}
public static void DeleteEnrollment(int id)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DeleteEnrollment(context, id);
context.SubmitChanges();
DA.Enrollment.OnCacheNeedsRefresh();
}
public static void DeleteTeacher(int id)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DeleteTeacher(context, id);
context.SubmitChanges();
DA.Teacher.OnCacheNeedsRefresh();
}
public static void DeleteCourse(int id)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DeleteCourse(context, id);
context.SubmitChanges();
DA.Course.OnCacheNeedsRefresh();
}
public static List<Course> FindCourseAPI(SampleDataContext context, string keyword)
{
return (from c in context.Courses
where
c.Name.Contains(keyword)
|| c.Teacher.FirstName.Contains(keyword)
|| c.Teacher.LastName.Contains(keyword)
select c).ToList();
}
public static DA.Course CreateCourse(DA.Semester Semester_Parameter, DA.Teacher Teacher_Parameter, string Number_Parameter, string Name_Parameter, DO.CourseStatus Status_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Course obj = CreateCourse(context, Semester_Parameter, Teacher_Parameter, Number_Parameter, Name_Parameter, Status_Parameter);
context.SubmitChanges();
DA.Course.OnCacheNeedsRefresh();
return obj;
}
public static void DeleteStudent(DA.SampleDataContext context, int id)
{
DA.Student obj = GetByID(context, id);
PerformPreDeleteLogic(context, obj);
context.Students.DeleteOnSubmit(obj);
PerformPostDeleteLogic(context, obj);
}
public static void DeleteCourse(DA.SampleDataContext context, int id)
{
DA.Course obj = GetByID(context, id);
PerformPreDeleteLogic(context, obj);
context.Courses.DeleteOnSubmit(obj);
PerformPostDeleteLogic(context, obj);
}
public static DA.Enrollment CreateEnrollment(DA.Student Student_Parameter, DA.Course Course_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Enrollment obj = CreateEnrollment(context, Student_Parameter, Course_Parameter);
context.SubmitChanges();
DA.Enrollment.OnCacheNeedsRefresh();
return(obj);
}
public static DA.Course CreateCourse(DA.Semester Semester_Parameter, DA.Teacher Teacher_Parameter, string Number_Parameter, string Name_Parameter, DO.CourseStatus Status_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Course obj = CreateCourse(context, Semester_Parameter, Teacher_Parameter, Number_Parameter, Name_Parameter, Status_Parameter);
context.SubmitChanges();
DA.Course.OnCacheNeedsRefresh();
return(obj);
}
public static DA.Student CreateStudent(DA.Major Major_Parameter, string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Student obj = CreateStudent(context, Major_Parameter, SSN_Parameter, FirstName_Parameter, LastName_Parameter, Active_Parameter);
context.SubmitChanges();
DA.Student.OnCacheNeedsRefresh();
return(obj);
}
public static DA.Semester CreateSemester(DateTime Begin_Parameter, DateTime End_Parameter, string Name_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Semester obj = CreateSemester(context, Begin_Parameter, End_Parameter, Name_Parameter);
context.SubmitChanges();
DA.Semester.OnCacheNeedsRefresh();
return(obj);
}
public static void DeleteTeacher(DA.SampleDataContext context, int id)
{
DA.Teacher obj = GetByID(context, id);
PerformPreDeleteLogic(context, obj);
context.Teachers.DeleteOnSubmit(obj);
PerformPostDeleteLogic(context, obj);
}
public static DA.Major CreateMajor(string Name_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Major obj = CreateMajor(context, Name_Parameter);
context.SubmitChanges();
DA.Major.OnCacheNeedsRefresh();
return(obj);
}
public static DA.Teacher CreateTeacher(string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Teacher obj = CreateTeacher(context, SSN_Parameter, FirstName_Parameter, LastName_Parameter, Active_Parameter);
context.SubmitChanges();
DA.Teacher.OnCacheNeedsRefresh();
return(obj);
}
public static DA.Major CreateMajor(DA.SampleDataContext context, string Name_Parameter)
{
DA.Major obj = new DA.Major();
obj.Name = Name_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Majors.InsertOnSubmit(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static DA.Enrollment CreateEnrollment(DA.SampleDataContext context, DA.Student Student_Parameter, DA.Course Course_Parameter)
{
DA.Enrollment obj = new DA.Enrollment();
obj.Student = Student_Parameter;
obj.Course = Course_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Enrollments.InsertOnSubmit(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static DA.Semester CreateSemester(DA.SampleDataContext context, DateTime Begin_Parameter, DateTime End_Parameter, string Name_Parameter)
{
DA.Semester obj = new DA.Semester();
obj.Begin = Begin_Parameter;
obj.End = End_Parameter;
obj.Name = Name_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Semesters.InsertOnSubmit(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static DA.Teacher CreateTeacher(DA.SampleDataContext context, string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
DA.Teacher obj = new DA.Teacher();
obj.SSN = SSN_Parameter;
obj.FirstName = FirstName_Parameter;
obj.LastName = LastName_Parameter;
obj.Active = Active_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Teachers.InsertOnSubmit(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static DA.Course CreateCourse(DA.SampleDataContext context, DA.Semester Semester_Parameter, DA.Teacher Teacher_Parameter, string Number_Parameter, string Name_Parameter, DO.CourseStatus Status_Parameter)
{
DA.Course obj = new DA.Course();
obj.Semester = Semester_Parameter;
obj.Teacher = Teacher_Parameter;
obj.Number = Number_Parameter;
obj.Name = Name_Parameter;
obj.Status = Status_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Courses.InsertOnSubmit(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static DA.Student CreateStudent(DA.SampleDataContext context, DA.Major Major_Parameter, string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
DA.Student obj = new DA.Student();
obj.Major = Major_Parameter;
obj.SSN = SSN_Parameter;
obj.FirstName = FirstName_Parameter;
obj.LastName = LastName_Parameter;
obj.Active = Active_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Students.InsertOnSubmit(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
/// <summary>Gets how many Enrollments exist.<summary>
public int GetEnrollmentsCount()
{
using(DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return dataContext.Enrollments.Count();
}
}
/// <summary>When implemented, validates that the object conforms to standard business rules using the supplied data context.</summary> static partial void Validate(DA.SampleDataContext context, DA.Teacher obj);
/// <summary>Gets how many Teachers exist.<summary>
public int GetTeachersCount()
{
using(DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return dataContext.Teachers.Count();
}
}
public static DA.Semester CreateSemester(DateTime Begin_Parameter, DateTime End_Parameter, string Name_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Semester obj = CreateSemester(context, Begin_Parameter, End_Parameter, Name_Parameter);
context.SubmitChanges();
DA.Semester.OnCacheNeedsRefresh();
return obj;
}
public static Semester GetByBeginAndEnd(SampleDataContext context, DateTime begin, DateTime end)
{
return context.Semesters.FirstOrDefault(o => o.Begin == begin && o.End == end);
}
public static Student GetBySSN(SampleDataContext context, string sSN)
{
return context.Students.FirstOrDefault(o => o.SSN == sSN);
}
/// <summary>Returns the Enrollment with the provided primary key value.</summary>
/// <param name="id">The primary key of the Enrollment to fetch.</param>
/// <param name="context">The data context to use.</param>
/// <returns>A single Enrollment, or null if it does not exist.</returns>
public static DA.Enrollment GetByID(SampleDataContext context, int ID)
{
return context.Enrollments.SingleOrDefault(o => o.ID == ID);
}
public static DA.Course GetBySemesterIDAndName(DA.SampleDataContext context, int semesterID, string name)
{
return(DA.Course.GetBySemesterIDAndName(context, semesterID, name));
}
public static Course GetBySemesterIDAndName(SampleDataContext context, int semesterID, string name)
{
return context.Courses.FirstOrDefault(o => o.SemesterID == semesterID && o.Name == name);
}
/// <summary>Gets a list of all of the Courses in the database which are associated with the Teacher table via the ID column.</summary>
/// <param name="teacherID">The ID of the Teacher for which to retrieve the child Courses.</param>
/// <returns>An IEnumerable of Courses.</returns>
public static IEnumerable<Course> GetByTeacherID(SampleDataContext context, int iD)
{
var source = context.Courses;
return (from o in source where o.TeacherID == iD select o);
}
public static Teacher GetBySSN(SampleDataContext context, string sSN)
{
return context.Teachers.FirstOrDefault(o => o.SSN == sSN);
}
/// <summary>Gets how many Semesters exist.<summary>
public int GetSemestersCount()
{
using(DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return dataContext.Semesters.Count();
}
}
/// <summary>Gets how many Students exist.<summary>
public int GetStudentsCount()
{
using(DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return dataContext.Students.Count();
}
}
/// <summary>When implemented, allows logic to be performed before the object is created using the supplied data context.</summary> static partial void PerformPreCreateLogic(DA.SampleDataContext context, DA.Teacher obj);
public static Enrollment GetByStudentIDAndCourseID(SampleDataContext context, int studentID, int courseID)
{
return context.Enrollments.FirstOrDefault(o => o.StudentID == studentID && o.CourseID == courseID);
}
/// <summary>When implemented, allows logic to be performed after the object is deleted using the supplied data context.</summary> static partial void PerformPostDeleteLogic(DA.SampleDataContext context, DA.Teacher obj);
/// <summary>Returns the Major with the provided primary key value.</summary>
/// <param name="id">The primary key of the Major to fetch.</param>
/// <param name="context">The data context to use.</param>
/// <returns>A single Major, or null if it does not exist.</returns>
public static DA.Major GetByID(SampleDataContext context, int ID)
{
return context.Majors.SingleOrDefault(o => o.ID == ID);
}
/// <summary>Gets a list of all of the Semesters in the database.</summary>
/// <returns>An IEnumerable of Semesters.</returns>
public static IEnumerable<Semester> GetAll(SampleDataContext context)
{
return context.Semesters;
}
/// <summary>Gets how many Courses exist.<summary>
public int GetCoursesCount()
{
using(DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return dataContext.Courses.Count();
}
}
/// <summary>Gets a list of all of the Students in the database.</summary>
/// <returns>An IEnumerable of Students.</returns>
public static IEnumerable<Student> GetAll(SampleDataContext context)
{
return context.Students;
}
/// <summary>Gets how many Majors exist.<summary>
public int GetMajorsCount()
{
using(DA.SampleDataContext dataContext = new DA.SampleDataContext())
{
return dataContext.Majors.Count();
}
}
/// <summary>Gets a list of all of the Teachers in the database.</summary>
/// <returns>An IEnumerable of Teachers.</returns>
public static IEnumerable<Teacher> GetAll(SampleDataContext context)
{
return context.Teachers;
}
public static DA.Student CreateStudent(DA.Major Major_Parameter, string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Student obj = CreateStudent(context, Major_Parameter, SSN_Parameter, FirstName_Parameter, LastName_Parameter, Active_Parameter);
context.SubmitChanges();
DA.Student.OnCacheNeedsRefresh();
return obj;
}
/// <summary>Gets a list of all of the Courses in the database.</summary>
/// <returns>An IEnumerable of Courses.</returns>
public static IEnumerable<Course> GetAll(SampleDataContext context)
{
return context.Courses;
}
public static void DeleteSemester(int id)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DeleteSemester(context, id);
context.SubmitChanges();
DA.Semester.OnCacheNeedsRefresh();
}
public static Course GetBySemesterIDAndNumber(SampleDataContext context, int semesterID, string number)
{
return context.Courses.FirstOrDefault(o => o.SemesterID == semesterID && o.Number == number);
}
public static DA.Course GetBySemesterIDAndNumber(DA.SampleDataContext context, int semesterID, string number)
{
return(DA.Course.GetBySemesterIDAndNumber(context, semesterID, number));
}
/// <summary>Gets a list of all of the Enrollments in the database.</summary>
/// <returns>An IEnumerable of Enrollments.</returns>
public static IEnumerable<Enrollment> GetAll(SampleDataContext context)
{
return context.Enrollments;
}
/// <summary>Gets a list of all of the Teachers in the database.</summary>
/// <returns>An IEnumerable of Teachers.</returns>
public static IEnumerable <DA.Teacher> GetAll(DA.SampleDataContext context)
{
return(DA.Teacher.GetAll(context));
}
/// <summary>Gets a list of all of the Enrollments in the database which are associated with the Student table via the ID column.</summary>
/// <param name="studentID">The ID of the Student for which to retrieve the child Enrollments.</param>
/// <returns>An IEnumerable of Enrollments.</returns>
public static IEnumerable<Enrollment> GetByStudentID(SampleDataContext context, int iD)
{
var source = context.Enrollments;
return (from o in source where o.StudentID == iD select o);
}
public static DA.Teacher GetBySSN(DA.SampleDataContext context, string sSN)
{
return(DA.Teacher.GetBySSN(context, sSN));
}
/// <summary>Gets a list of all of the Majors in the database.</summary>
/// <returns>An IEnumerable of Majors.</returns>
public static IEnumerable<Major> GetAll(SampleDataContext context)
{
return context.Majors;
}
public static DA.Teacher LoadTeacherFromDataContext(this DA.Teacher obj, DA.SampleDataContext dataContext)
{
return(DA.Teacher.GetByID(dataContext, obj.ID));
}
public static Major GetByName(SampleDataContext context, string name)
{
return context.Majors.FirstOrDefault(o => o.Name == name);
}
public static DA.Teacher CreateTeacher(string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
DA.SampleDataContext context = new DA.SampleDataContext();
DA.Teacher obj = CreateTeacher(context, SSN_Parameter, FirstName_Parameter, LastName_Parameter, Active_Parameter);
context.SubmitChanges();
DA.Teacher.OnCacheNeedsRefresh();
return obj;
}
