public Course SelectById(int id)
{
using (var context = new HaermsEntities())
{
return(context.Course.Find(id));
}
}
/// <summary>
/// 通过ｃｌａｓｓＩｄ查找班级
/// </summary>
/// <param name="id">classid</param>
/// <returns>The entity found, or null.</returns>
public Class SelectClassById(int id)
{
using (var context = new HaermsEntities())
{
return(context.Class.Find(id));
}
}
public IEnumerable <Teacher> SelectAllTeacher()
{
using (var context = new HaermsEntities())
{
return(context.Teacher.ToArray());
}
}
public IEnumerable <Class> SelectClassAll()
{
using (var context = new HaermsEntities())
{
return(context.Class.AsParallel().ToArray());
}
}
public Teacher SelectById(int id)
{
using (var context = new HaermsEntities())
{
return(context.Teacher.Find(id));
}
}
public CourseHomework SelectByCourseHomeworkId(int id)
{
using (var context = new HaermsEntities())
{
return(context.CourseHomework.Find(id));
}
}
public IEnumerable <CourseExperiment> SelectByCourse(Course course)
{
using (var context = new HaermsEntities())
{
var queryable = context.CourseExperiment.Where(ce => ce.CourseId == course.CourseId);
return(queryable.ToArray());
}
}
public int GetTeacherIdByCourseId(int courseId)
{
using (var context = new HaermsEntities())
{
var queryable = (Course)context.Course.Where(c => c.CourseId == courseId).First();
return(queryable.TeacherId);
}
}
public IEnumerable <Course> SelectAllByTeacher(Teacher teacher)
{
using (var context = new HaermsEntities())
{
var queryable = context.Course.Where(c => c.TeacherId == teacher.TeacherId);
return(queryable.ToArray());
}
}
public IEnumerable <Homework> SelectHomeworkByCourseHomeworkId(int id)
{
using (var context = new HaermsEntities())
{
var querySet = context.Homework.Where(h => h.CourseHomeworkId == id);
return(querySet.ToArray());
}
}
public Admin SelectByJobNumberAndPassword(Admin admin)
{
using (var context = new HaermsEntities())
{
var iqueryable = context.Admin.Where(t => t.JobNumber == admin.JobNumber && t.Password == admin.Password);
return(iqueryable.FirstOrDefault());
}
}
public Department SelectDepartmentById(int id)
{
using (var context = new HaermsEntities())
{
var department = context.Department.Find(id);
return(department);
}
}
public Teacher SelectByJobNumberAndPassword(Teacher teacher)
{
using (var context = new HaermsEntities())
{
var queryable = context.Teacher.Where(t => t.JobNumber == teacher.JobNumber && t.Password == teacher.Password);
return(queryable.FirstOrDefault());
}
}
public Teacher[] SelectTeachersByDepartment(int departmentId)
{
using (var context = new HaermsEntities())
{
var queryable = context.Teacher.Where(t => t.DepartmentId == departmentId);
return(queryable.ToArray());
}
}
public bool IsBanned(Teacher teacher)
{
using (var context = new HaermsEntities())
{
var t = context.Teacher.Find(teacher.TeacherId);
return(t?.Banned ?? true);
}
}
public IEnumerable <Department> SelectAllDepartments()
{
using (var context = new HaermsEntities())
{
var departments = context.Department.ToArray();
return(departments);
}
}
public IEnumerable <CourseHomework> SelectByCourse(Course course)
{
using (var context = new HaermsEntities())
{
var queryable = context.CourseHomework.Where(ch => ch.CourseId == course.CourseId);
return(queryable.ToArray());
}
}
public Department SelectDepartmentByName(string name)
{
using (var context = new HaermsEntities())
{
var _t = context.Department.FirstOrDefault(t => t.ChinesaeName == name);
return(_t);
}
}
/// <summary>
/// 通过老师布置的实验ID获取交的作业集合
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IEnumerable <Experiment> SelectExpermentByCourseExpermentId(int id)
{
using (var context = new HaermsEntities())
{
var querySet = context.Experiment.Where(e => e.CourseExperimentId == id);
return(querySet.ToArray());
}
}
public Student SelectStudentByStudentNumber(Student student)
{
using (var context = new HaermsEntities())
{
var queryable = context.Student.Where(s => s.StudentNumber == student.StudentNumber);
return(queryable.FirstOrDefault());
}
}
/**
* add a teacher
* <returns>return the affected rows</returns>
*/
public int InsertTeacher(Teacher teacher)
{
using (var context = new HaermsEntities())
{
context.Teacher.Add(teacher);
return(context.SaveChanges());
}
}
public IEnumerable <CourseAttachment> SelectByCourse(Course course)
{
using (var context = new HaermsEntities())
{
var courseAttachments = context.CourseAttachment.Where(ca => ca.CourseId == course.CourseId);
return(courseAttachments.ToArray());
}
}
public CourseAttachment SelectByAttachmentId(int attachmentId)
{
using (var context = new HaermsEntities())
{
var courseAttachments = context.CourseAttachment.Where(ca => ca.AttachmentId == attachmentId);
return(courseAttachments.ToArray().First());
}
}
public IEnumerable <CourseSelection> SelectByStudentIdAndCourseId(Student student, Course course)
{
using (var context = new HaermsEntities())
{
return(context.CourseSelection
.Where(cs => cs.StudentId == student.StudentId && cs.CourseId == course.CourseId).ToArray());
}
}
public IEnumerable <CourseSelection> SelectByStudentId(int studentStudentId)
{
using (var context = new HaermsEntities())
{
var courseSelections = context.CourseSelection.Where(cs => cs.StudentId == studentStudentId);
return(courseSelections.ToArray());
}
}
public IEnumerable <CourseSelection> SelectRecordStudentByCourseId(int id)
{
using (var context = new HaermsEntities())
{
var queryset = context.CourseSelection.Where(cs => cs.CourseId == id);
return(queryset.ToArray());
}
}
public int InsertCourseAttachment(CourseAttachment courseAttachment)
{
using (var context = new HaermsEntities())
{
var obj = context.CourseAttachment.Add(courseAttachment);
context.SaveChanges();
return(obj.AttachmentId);
}
}
public int InsertCourseExperiment(CourseExperiment courseExperiment)
{
using (var context = new HaermsEntities())
{
CourseExperiment c = context.CourseExperiment.Add(courseExperiment);
context.SaveChanges();
return(c.CourseExperimentId);
}
}
public int InsertCourseHomework(CourseHomework courseHomework)
{
using (var context = new HaermsEntities())
{
CourseHomework c = context.CourseHomework.Add(courseHomework);
context.SaveChanges();
return(c.CourseHomeworkId);
}
}
public int createCourseSelectRecording(CourseSelection courseSelection)
{
using (var context = new HaermsEntities())
{
CourseSelection cs = context.CourseSelection.Add((CourseSelection)courseSelection);
context.SaveChanges();
return(cs.CourseSelectionId);
}
}
