public void Delete(Score score)
{
using (var context = new coursecontrolContext())
{
context.Score.Remove(score);
context.SaveChanges();
}
}
public void Add(Student student)
{
using (var context = new coursecontrolContext())
{
context.Student.Add(student);
context.SaveChanges();
}
}
public void Add(Teacher teacher)
{
using (var context = new coursecontrolContext())
{
context.Teacher.Add(teacher);
context.SaveChanges();
}
}
public void Update(Score score)
{
using (var context = new coursecontrolContext())
{
context.Score.Update(score);
context.SaveChanges();
}
}
public void Add(Selectcourse selectcourse)
{
using (var context = new coursecontrolContext())
{
context.Selectcourse.Add(selectcourse);
context.SaveChanges();
}
}
public void Add(Course course)
{
using (var context = new coursecontrolContext())
{
context.Course.Add(course);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new coursecontrolContext())
{
var student = context.Student.FirstOrDefault(x => x.StuId == id);
context.Student.Remove(student);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new coursecontrolContext())
{
var teacher = context.Teacher.FirstOrDefault(x => x.TeacherId == id);
context.Teacher.Remove(teacher);
context.SaveChanges();
}
}
public void Delete(int id, int coursecode)
{
using (var context = new coursecontrolContext())
{
var course = context.Course.FirstOrDefault(x => x.CourseCode == coursecode);
context.Course.Remove(course);
context.SaveChanges();
}
}
public void Delete(int coursecode, int stuid)
{
using (var context = new coursecontrolContext())
{
var selectcourse = context.Selectcourse.Where(d => d.StudentId == stuid).FirstOrDefault(x => x.CourseId == coursecode);
context.Selectcourse.Remove(selectcourse);
context.SaveChanges();
}
}
public void Add(int id, int code)
{
using (var context = new coursecontrolContext())
{
Score score = new Score();
score.CstuId = id;
score.CcourseCode = code;
context.Score.Add(score);
context.SaveChanges();
}
}
public Teacher Query(int teacherId)
{
Teacher teacher = null;
using (var context = new coursecontrolContext())
{
teacher = context.Teacher.FirstOrDefault(x => x.TeacherId == teacherId);
context.SaveChanges();
}
return(teacher);
}
public Score QueryByCode(int code, int id)
{
Score score = null;
using (var context = new coursecontrolContext())
{
score = context.Score.FirstOrDefault(x => x.CcourseCode == code && x.CstuId == id);
context.SaveChanges();
}
return(score);
}
public Student Query(int stuId)
{
Student student = null;
using (var context = new coursecontrolContext())
{
student = context.Student.FirstOrDefault(x => x.StuId == stuId);
context.SaveChanges();
}
return(student);
}
public Course Query(int CourseCode)
{
Course course = null;
using (var context = new coursecontrolContext())
{
course = context.Course.FirstOrDefault(x => x.CourseCode == CourseCode);
context.SaveChanges();
}
return(course);
}
public List <Score> Query(int id)
{
List <Score> listScore = new List <Score>();
using (var context = new coursecontrolContext())
{
listScore = (from u in context.Score
where u.CstuId == id
select u
).ToList();
context.SaveChanges();
}
return(listScore);
}
public List <Course> Query(string type)
{
List <Course> listCourse = new List <Course>();
using (var context = new coursecontrolContext())
{
listCourse = (from u in context.Course
where u.CourseType == type
select u
).ToList();
context.SaveChanges();
}
return(listCourse);
}
public Selectcourse Query(int stuid)//
{
Selectcourse selectcourse = null;
using (var context = new coursecontrolContext())
{
var test = context.Selectcourse.ToList();
foreach (var item in test)
{
}
//selectcourse = context.Selectcourse.FirstOrDefault(x => x.StudentId == stuid);
context.SaveChanges();
}
return(selectcourse);
}
