public static void DeleteTeacher(int id)
{
SampleObjectContext context = new SampleObjectContext();
DeleteTeacher(context, id);
context.AcceptAllChanges();
Teacher.OnCacheNeedsRefresh();
}
public static void DeleteEnrollment(int id)
{
SampleObjectContext context = new SampleObjectContext();
DeleteEnrollment(context, id);
context.AcceptAllChanges();
Enrollment.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 Major CreateMajor(string Name_Parameter)
{
SampleObjectContext context = new SampleObjectContext();
Major obj = CreateMajor(context, Name_Parameter);
context.AcceptAllChanges();
Major.OnCacheNeedsRefresh();
return(obj);
}
public static Enrollment CreateEnrollment(Student Student_Parameter, Course Course_Parameter)
{
SampleObjectContext context = new SampleObjectContext();
Enrollment obj = CreateEnrollment(context, Student_Parameter, Course_Parameter);
context.AcceptAllChanges();
Enrollment.OnCacheNeedsRefresh();
return(obj);
}
public static void DeleteCourse(SampleObjectContext context, int id)
{
Course obj = GetByID(context, id);
PerformPreDeleteLogic(context, obj);
context.Courses.DeleteObject(obj);
PerformPostDeleteLogic(context, obj);
}
public static Semester CreateSemester(DateTime Begin_Parameter, DateTime End_Parameter, string Name_Parameter)
{
SampleObjectContext context = new SampleObjectContext();
Semester obj = CreateSemester(context, Begin_Parameter, End_Parameter, Name_Parameter);
context.AcceptAllChanges();
Semester.OnCacheNeedsRefresh();
return(obj);
}
static partial void PerformPreDeleteLogic(SampleObjectContext context, Student obj)
{
if (obj.Enrollments != null)
{
foreach (DataAccess.Enrollment enrollment in obj.Enrollments)
{
EnrollmentLogic.DeleteEnrollment(context, enrollment.ID);
}
}
}
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 void DeleteTeacher(SampleObjectContext context, int id)
{
Teacher obj = GetByID(context, id);
PerformPreDeleteLogic(context, obj);
context.Teachers.DeleteObject(obj);
PerformPostDeleteLogic(context, obj);
}
public static void DeleteStudent(SampleObjectContext context, int id)
{
Student obj = GetByID(context, id);
PerformPreDeleteLogic(context, obj);
context.Students.DeleteObject(obj);
PerformPostDeleteLogic(context, obj);
}
public static Student CreateStudent(Major Major_Parameter, string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
SampleObjectContext context = new SampleObjectContext();
Student obj = CreateStudent(context, Major_Parameter, SSN_Parameter, FirstName_Parameter, LastName_Parameter, Active_Parameter);
context.AcceptAllChanges();
Student.OnCacheNeedsRefresh();
return(obj);
}
public static Teacher CreateTeacher(string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
SampleObjectContext context = new SampleObjectContext();
Teacher obj = CreateTeacher(context, SSN_Parameter, FirstName_Parameter, LastName_Parameter, Active_Parameter);
context.AcceptAllChanges();
Teacher.OnCacheNeedsRefresh();
return(obj);
}
public static Major CreateMajor(SampleObjectContext context, string Name_Parameter)
{
Major obj = new Major();
obj.Name = Name_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Majors.AddObject(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static Enrollment CreateEnrollment(SampleObjectContext context, Student Student_Parameter, Course Course_Parameter)
{
Enrollment obj = new Enrollment();
obj.Student = Student_Parameter;
obj.Course = Course_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Enrollments.AddObject(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static Semester CreateSemester(SampleObjectContext context, DateTime Begin_Parameter, DateTime End_Parameter, string Name_Parameter)
{
Semester obj = new Semester();
obj.Begin = Begin_Parameter;
obj.End = End_Parameter;
obj.Name = Name_Parameter;
Validate(context, obj);
PerformPreCreateLogic(context, obj);
context.Semesters.AddObject(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static Teacher CreateTeacher(SampleObjectContext context, string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
Teacher obj = new 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.AddObject(obj);
PerformPostCreateLogic(context, obj);
return(obj);
}
public static Student CreateStudent(SampleObjectContext context, Major Major_Parameter, string SSN_Parameter, string FirstName_Parameter, string LastName_Parameter, bool Active_Parameter)
{
Student obj = new 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.AddObject(obj);
PerformPostCreateLogic(context, obj);
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>Returns the Teacher with the provided primary key value.</summary>
/// <param name="id">The primary key of the Teacher to fetch.</param>
/// <param name="context">The data context to use.</param>
/// <returns>A single Teacher, or null if it does not exist.</returns>
public static Teacher GetByID(SampleObjectContext context, int id)
{
return(Teacher.GetByID(context, id));
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
this.DataContext = new SampleObjectContext();
}
/// <summary>When implemented, allows logic to be performed after the object is deleted using the supplied data context.</summary> static partial void PerformPostDeleteLogic(SampleObjectContext context, Teacher obj);
public static Course GetBySemesterIDAndName(SampleObjectContext context, int semesterID, string name)
{
return(Course.GetBySemesterIDAndName(context, semesterID, name));
}
/// <summary>When implemented, allows logic to be performed before the object is created using the supplied data context.</summary> static partial void PerformPreCreateLogic(SampleObjectContext context, Teacher obj);
/// <summary>When implemented, validates that the object conforms to standard business rules using the supplied data context.</summary> static partial void Validate(SampleObjectContext context, Teacher obj);
/// <summary>When implemented, allows logic to be performed after the object is deleted using the supplied data context.</summary> static partial void PerformPostDeleteLogic(SampleObjectContext context, Student obj);
public static Course GetBySemesterIDAndNumber(SampleObjectContext context, int semesterID, string number)
{
return(Course.GetBySemesterIDAndNumber(context, semesterID, number));
}
public static Teacher LoadTeacherFromDataContext(this Teacher obj, SampleObjectContext dataContext)
{
return(Teacher.GetByID(dataContext, obj.ID));
}
public static Teacher GetBySSN(SampleObjectContext context, string sSN)
{
return(Teacher.GetBySSN(context, sSN));
}
/// <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(Teacher.GetAll(context));
}
