// 新建问题
public bool create(Problem obj)
{
DataClassesDataContext da = new DataClassesDataContext();
da.Problem.InsertOnSubmit(obj);
da.SubmitChanges();
return true;
}
//添加课程
public bool AddCourse(Course course)
{
DataClassesDataContext da = new DataClassesDataContext();
da.Course.InsertOnSubmit(course);
da.SubmitChanges();
return true;
}
//根据账号名获取学生全部信息
public Student GetStudent(String name)
{
DataClassesDataContext da = new DataClassesDataContext();
var stu = from s in da.Student
where s.username == name
select s;
return stu.FirstOrDefault();
}
//根据Problem的Id获得分值
public float GetProblemScore(int pro_id)
{
DataClassesDataContext da = new DataClassesDataContext();
var problem = from p in da.Problem
where p.id == pro_id
select p;
return (float)problem.First().score;
}
public Problem GetProblemById(int id)
{
DataClassesDataContext da = new DataClassesDataContext();
var p = from s in da.Problem
where s.id == id
select s;
return p.FirstOrDefault();
}
//根据teacher账号名获取teacher信息
public Teacher GetTeacher(String name)
{
DataClassesDataContext da = new DataClassesDataContext();
var t = from s in da.Teacher
where s.username == name
select s;
return t.FirstOrDefault();
}
public bool Create(Accessory accessory)
{
if (accessory.adress.Length == 0)
return false;
DataClassesDataContext da = new DataClassesDataContext();
da.Accessory.InsertOnSubmit(accessory);
da.SubmitChanges();
return true;
}
public Accessory GetAccessory(String stu, int assignment)
{
DataClassesDataContext da = new DataClassesDataContext();
var a = from s in da.Accessory
where s.student == stu && s.assignment == assignment
select s;
return a.FirstOrDefault();
}
// 添加学生
public bool AddStudent(Student stu)
{
DataClassesDataContext da = new DataClassesDataContext();
Student student = new Student();
student = stu;
da.Student.InsertOnSubmit(student);
da.SubmitChanges();
return true;
}
//插入teacher
public bool AddTeacher(Teacher teacher)
{
DataClassesDataContext da = new DataClassesDataContext();
Teacher t = new Teacher();
t = teacher;
da.Teacher.InsertOnSubmit(t);
da.SubmitChanges();
return true;
}
public bool Update(Admin newadmin)
{
DataClassesDataContext da = new DataClassesDataContext();
var a = from s in da.Admin
where s.username == newadmin.username
select s;
a.First().passwd = newadmin.passwd;
da.SubmitChanges();
return true;
}
//学生选课
public bool ChooseCourse(String stuname, String course_num)
{
DataClassesDataContext da = new DataClassesDataContext();
Student_Course sc = new Student_Course();
sc.course = course_num;
sc.student = stuname;
da.Student_Course.InsertOnSubmit(sc);
da.SubmitChanges();
return true;
}
//得到所有问题
public List<Problem> getAllProblem()
{
DataClassesDataContext da = new DataClassesDataContext();
var p = from s in da.Problem
select s;
pro = new List<Problem>();
foreach (var n in p)
pro.Add(n);
return pro;
}
//根据assignment的ID获取该作业的problem的List
public List<Problem> GetProblem(int assignment_id)
{
DataClassesDataContext da = new DataClassesDataContext();
var p = from s in da.Problem
where s.assignment == assignment_id
select s;
pro = new List<Problem>();
foreach (var n in p)
pro.Add(n);
return pro;
}
public Admin GetAdmin(String name)
{
DataClassesDataContext da = new DataClassesDataContext();
var admin = from s in da.Admin
where s.username == name
select s;
if (admin.Count() > 0)
return admin.First();
else
return null;
}
//获得所有老师
public List<Teacher> GetAllTeacher()
{
DataClassesDataContext da = new DataClassesDataContext();
var t = from s in da.Teacher
select s;
TeacherList = new List<Teacher>();
foreach (var n in t)
{
TeacherList.Add(n);
}
return TeacherList;
}
// 通过“专业”获取学生，返回该专业的全部学生信息的List
public List<Student> GetStudentByMajor(String major)
{
DataClassesDataContext da = new DataClassesDataContext();
var stu = from s in da.Student
where s.major == major
select s;
StuListForMajor = new List<Student>();
foreach (var n in stu)
{
StuListForMajor.Add(n);
}
return StuListForMajor;
}
//根据Problem的Id来删除作业
public bool DeleteProblem(int pro_id)
{
DataClassesDataContext da = new DataClassesDataContext();
var answer = from s in da.Answer
where s.problem == pro_id
select s;
da.Answer.DeleteAllOnSubmit(answer);
var p = from s in da.Problem
where s.id == pro_id
select s;
da.Problem.DeleteAllOnSubmit(p);
da.SubmitChanges();
return true;
}
//删除课程
public bool DeleteCourse(Course course)
{
DataClassesDataContext da = new DataClassesDataContext();
var c=from s in da.Course
where s.teacher==course.teacher && s.name==course.name
select s;
var cin = from s in da.Student_Course
where s.course == c.First().num
select s;
var ca = from s in da.Assignment
where s.course == c.First().num
select s;
if (ca.Count() > 0)
{
foreach (var n in ca)
{
var p = from s in da.Problem
where s.assignment == n.id
select s;
if (p.Count() > 0)
{
var answer = from s in da.Answer
where s.problem == p.First().id
select s;
if (answer.Count() > 0)
{
da.Answer.DeleteAllOnSubmit(answer); //删除answer
}
}
var accessory = from s in da.Accessory
where s.assignment == n.id
select s;
if (accessory.Count() > 0)
da.Accessory.DeleteAllOnSubmit(accessory);
da.Problem.DeleteAllOnSubmit(p); //删除Problem
}
da.Assignment.DeleteAllOnSubmit(ca); //删除assignment
}
if (cin.Count() > 0)
{
da.Student_Course.DeleteAllOnSubmit(cin); //删除student_course
}
da.Course.DeleteAllOnSubmit(c); //删除Course
da.SubmitChanges();
return true;
}
//根据课程获取Student的列表
public List<Student> GetStudentByCourse(String course)
{
DataClassesDataContext da = new DataClassesDataContext();
var student = from s in da.Student_Course
where s.course == course
select s.student;
StuListForCourse = new List<Student>();
foreach (var n in student)
{
var stu = from s in da.Student
where s.username == n
select s;
StuListForCourse.Add(stu.FirstOrDefault());
}
return StuListForCourse;
}
//通过老师账号名和课程名获得指定课程
public Course GetOneCourse(String teachername, String coursename)
{
DataClassesDataContext da = new DataClassesDataContext();
var c = from s in da.Course
where s.teacher == teachername && s.name == coursename
select s;
return c.FirstOrDefault();
}
//评分，pro_id代表问题ID，score代表分数
public bool Score(int pro_id,float score)
{
DataClassesDataContext da = new DataClassesDataContext();
var p = from s in da.Problem
where s.id == pro_id
select s;
p.First().score = score;
da.SubmitChanges();
return true;
}
//更新问题
public bool UpdateProblem(Problem pro)
{
DataClassesDataContext da = new DataClassesDataContext();
var p = from s in da.Problem
where s.id == pro.id
select s;
foreach (Problem problem in p)
{
problem.id = pro.id;
problem.assignment = pro.assignment;
problem.title = pro.title;
problem.descrip = pro.descrip;
problem.score = pro.score;
}
da.SubmitChanges();
return true;
}
public Course GetCourseByNum(string number)
{
DataClassesDataContext da = new DataClassesDataContext();
var cou = from s in da.Course
where s.num == number
select s;
if (cou.Count() > 0)
return cou.First();
else
return null;
}
//通过学生账号名，获取该学生课程的List
public List<Course> GetCourseForStudent(String stuname)
{
DataClassesDataContext da = new DataClassesDataContext();
var course_num = from s in da.Student_Course
where s.student == stuname
select s.course;
StudentCourse = new List<Course>();
foreach (var c in course_num)
{
var result = from s in da.Course
where s.num == c
select s;
StudentCourse.AddRange(result);
}
return StudentCourse;
}
//获取全部Course
public List<Course> GetCourse()
{
DataClassesDataContext da = new DataClassesDataContext();
var c = from s in da.Course
select s;
Course = new List<Course>();
foreach (var n in c)
{
Course.Add(n);
}
return Course;
}
//通过老师账号名，获取课程List
public List<Course> GetCourseForTeacher(String teachername)
{
DataClassesDataContext da = new DataClassesDataContext();
var c = from s in da.Course
where s.teacher == teachername
select s;
TeacherCourse = new List<Course>();
foreach (var n in c)
{
TeacherCourse.Add(n);
}
return TeacherCourse;
}
