public void DeleteTakeClassList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
List <ClassWeb.Repository.Entity.TakeClass> takeClassList = DBEntity.TakeClass.Where(o => o.TakeClass_Student == StudentNo).ToList();
DBEntity.TakeClass.RemoveRange(takeClassList);
DBEntity.SaveChanges();
}
}
public void UpdateStudent()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Student student = DBEntity.Student.Where(o => o.Student_No == No).FirstOrDefault();
student.Student_Name = Name;
student.Student_Birthday = Convert.ToDateTime(Birthday);
student.Student_Email = Email;
DBEntity.SaveChanges();
}
}
//新增資料
public void InsertStudent()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Student student = new Repository.Entity.Student();
student.Student_No = GetNewStudentNo();
student.Student_Name = Name;
student.Student_Birthday = Convert.ToDateTime(Birthday);
student.Student_Email = Email;
DBEntity.Student.Add(student);
DBEntity.SaveChanges();
}
}
public void UpdateClass()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Class classData = DBEntity.Class.Where(o => o.Class_No == No).FirstOrDefault();
classData.Class_Name = Name;
classData.Class_Credit = Credit;
classData.Class_Place = Place;
classData.Class_Teacher = Teacher;
DBEntity.SaveChanges();
}
}
//新增資料
public void InsertClass()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Class classData = new Repository.Entity.Class();
classData.Class_No = GetNewClassNo();
classData.Class_Name = Name;
classData.Class_Credit = Credit;
classData.Class_Place = Place;
classData.Class_Teacher = Teacher;
DBEntity.Class.Add(classData);
DBEntity.SaveChanges();
}
}
public void DeleteClass()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Class classData = DBEntity.Class.Where(o => o.Class_No == No).FirstOrDefault();
DBEntity.Class.Remove(classData);
//一併刪除該學生修課紀錄避免資料關聯異常
List <ClassWeb.Repository.Entity.TakeClass> takeClass = DBEntity.TakeClass.Where(o => o.TakeClass_Class == No).ToList();
DBEntity.TakeClass.RemoveRange(takeClass);
DBEntity.SaveChanges();
}
}
public void DeleteStudent()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
ClassWeb.Repository.Entity.Student student = DBEntity.Student.Where(o => o.Student_No == No).FirstOrDefault();
DBEntity.Student.Remove(student);
//一併刪除該學生修課紀錄避免資料關聯異常
List <ClassWeb.Repository.Entity.TakeClass> takeClass = DBEntity.TakeClass.Where(o => o.TakeClass_Student == No).ToList();
DBEntity.TakeClass.RemoveRange(takeClass);
DBEntity.SaveChanges();
}
}
public void AddTakeClassList()
{
using (ClassWeb.Repository.Entity.SchoolEntities DBEntity = new Repository.Entity.SchoolEntities())
{
List <ClassWeb.Repository.Entity.TakeClass> takeClassList = DBEntity.TakeClass.Where(o => o.TakeClass_Student == StudentNo).ToList();
DBEntity.TakeClass.RemoveRange(takeClassList);
foreach (var ClassIsChk in ClassNoList.Where(o => o.IsCheck))
{
ClassWeb.Repository.Entity.TakeClass takeClass = new ClassWeb.Repository.Entity.TakeClass();
takeClass.TakeClass_Student = StudentNo;
takeClass.TakeClass_Class = ClassIsChk.ClassNo;
DBEntity.TakeClass.Add(takeClass);
}
DBEntity.SaveChanges();
StudentNo = string.Empty;
ClassNoList = new List <ClassItem>();
}
}
