/// <summary>Gets how many Courses exist.<summary> public int GetCoursesCount() { using (DA.SampleObjectContext dataContext = new DA.SampleObjectContext()) { return(dataContext.Courses.Count()); } }
/// <summary>Gets how many Students exist.<summary> public int GetStudentsCount() { using (DA.SampleObjectContext dataContext = new DA.SampleObjectContext()) { return(dataContext.Students.Count()); } }
/// <summary>Gets how many Teachers exist.<summary> public int GetTeachersCount() { using (DA.SampleObjectContext dataContext = new DA.SampleObjectContext()) { return(dataContext.Teachers.Count()); } }
public static void DeleteCourse(int id) { SampleObjectContext context = new SampleObjectContext(); DeleteCourse(context, id); context.AcceptAllChanges(); Course.OnCacheNeedsRefresh(); }
public static List<Course> FindCourseAPI(SampleObjectContext 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 Course CreateCourse(Semester Semester_Parameter, Teacher Teacher_Parameter, string Number_Parameter, string Name_Parameter, CourseStatus Status_Parameter) { SampleObjectContext context = new SampleObjectContext(); Course obj = CreateCourse(context, Semester_Parameter, Teacher_Parameter, Number_Parameter, Name_Parameter, Status_Parameter); context.AcceptAllChanges(); Course.OnCacheNeedsRefresh(); return obj; }
public static Course CreateCourse(SampleObjectContext context, Semester Semester_Parameter, Teacher Teacher_Parameter, string Number_Parameter, string Name_Parameter, CourseStatus Status_Parameter) { Course obj = new 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.AddObject(obj); PerformPostCreateLogic(context, obj); return obj; }
/// <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(SampleObjectContext context, int iD) { var source = context.Courses; return (from o in source where o.TeacherID == iD select o); }
public static Course GetBySemesterIDAndNumber(SampleObjectContext context, int semesterID, string number) { return context.Courses.FirstOrDefault(o => o.SemesterID == semesterID && o.Number == number); }
public static Course GetBySemesterIDAndName(SampleObjectContext context, int semesterID, string name) { return context.Courses.FirstOrDefault(o => o.SemesterID == semesterID && o.Name == name); }
/// <summary>Returns the Course with the provided primary key value.</summary> /// <param name="id">The primary key of the Course to fetch.</param> /// <param name="context">The data context to use.</param> /// <returns>A single Course, or null if it does not exist.</returns> public static Course GetByID(SampleObjectContext context, int ID) { return context.Courses.SingleOrDefault(o => o.ID == ID); }
/// <summary>Gets how many Students exist.<summary> public int GetStudentsCount() { using(DA.SampleObjectContext dataContext = new DA.SampleObjectContext()) { return dataContext.Students.Count(); } }
public static Semester GetByName(SampleObjectContext context, string name) { return context.Semesters.FirstOrDefault(o => o.Name == name); }
public static Semester GetByBeginAndEnd(SampleObjectContext context, DateTime begin, DateTime end) { return context.Semesters.FirstOrDefault(o => o.Begin == begin && o.End == end); }
/// <summary>Gets a list of all of the Majors in the database.</summary> /// <returns>An IEnumerable of Majors.</returns> public static IEnumerable<Major> GetAll(SampleObjectContext context) { return context.Majors; }
/// <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(SampleObjectContext context, int iD) { var source = context.Enrollments; return (from o in source where o.StudentID == iD select o); }
/// <summary>Gets a list of all of the Enrollments in the database.</summary> /// <returns>An IEnumerable of Enrollments.</returns> public static IEnumerable<Enrollment> GetAll(SampleObjectContext context) { return context.Enrollments; }
/// <summary>When implemented, allows logic to be performed after the object is created using the supplied data context.</summary> partial static void PerformPostCreateLogic(SampleObjectContext context, Teacher obj);
partial static void PerformPreDeleteLogic(SampleObjectContext context, Student obj) { if (obj.Enrollments != null) foreach (DataAccess.Enrollment enrollment in obj.Enrollments) EnrollmentLogic.DeleteEnrollment(context, enrollment.ID); }
/// <summary>When implemented, validates that the object conforms to standard business rules using the supplied data context.</summary> partial static void Validate(SampleObjectContext context, Teacher obj);
/// <summary>When implemented, allows logic to be performed before the object is deleted using the supplied data context.</summary> partial static void PerformPreDeleteLogic(SampleObjectContext context, Teacher obj);
/// <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 Enrollment GetByID(SampleObjectContext context, int ID) { return context.Enrollments.SingleOrDefault(o => o.ID == ID); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); this.DataContext = new SampleObjectContext(); }
public static Enrollment GetByStudentIDAndCourseID(SampleObjectContext context, int studentID, int courseID) { return context.Enrollments.FirstOrDefault(o => o.StudentID == studentID && o.CourseID == courseID); }
/// <summary>Gets a list of all of the Students in the database.</summary> /// <returns>An IEnumerable of Students.</returns> public static IEnumerable<Student> GetAll(SampleObjectContext context) { return context.Students; }
/// <summary>Gets a list of all of the Semesters in the database.</summary> /// <returns>An IEnumerable of Semesters.</returns> public static IEnumerable<Semester> GetAll(SampleObjectContext context) { return context.Semesters; }
public static Student GetBySSN(SampleObjectContext context, string sSN) { return context.Students.FirstOrDefault(o => o.SSN == sSN); }
/// <summary>Returns the Semester with the provided primary key value.</summary> /// <param name="id">The primary key of the Semester to fetch.</param> /// <param name="context">The data context to use.</param> /// <returns>A single Semester, or null if it does not exist.</returns> public static Semester GetByID(SampleObjectContext context, int ID) { return context.Semesters.SingleOrDefault(o => o.ID == ID); }
/// <summary>Gets a list of all of the Teachers in the database.</summary> /// <returns>An IEnumerable of Teachers.</returns> public static IEnumerable<Teacher> GetAll(SampleObjectContext context) { return context.Teachers; }
/// <summary>Gets how many Courses exist.<summary> public int GetCoursesCount() { using(DA.SampleObjectContext dataContext = new DA.SampleObjectContext()) { return dataContext.Courses.Count(); } }
public static Teacher GetBySSN(SampleObjectContext context, string sSN) { return context.Teachers.FirstOrDefault(o => o.SSN == sSN); }
/// <summary>Gets how many Teachers exist.<summary> public int GetTeachersCount() { using(DA.SampleObjectContext dataContext = new DA.SampleObjectContext()) { return dataContext.Teachers.Count(); } }
/// <summary>Gets a list of all of the Courses in the database.</summary> /// <returns>An IEnumerable of Courses.</returns> public static IEnumerable<Course> GetAll(SampleObjectContext context) { return context.Courses; }