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>(); } }