//public static void AddStudent(object student) //{ // throw new NotImplementedException(); //} #endregion #region Class public static void AddClass(subject_t subject_T) { using (SchoolDataDataContext data = new SchoolDataDataContext()) { data.subject_ts.InsertOnSubmit(subject_T); data.SubmitChanges(); } }
public static void AddStudent(student_t student) { using (SchoolDataDataContext data = new SchoolDataDataContext()) { data.student_ts.InsertOnSubmit(student); data.SubmitChanges(); } }
public static void DeleteStudent(student_t student) { using (SchoolDataDataContext data = new SchoolDataDataContext()) { student_t st = (from s in data.student_ts where s.studentID == student.studentID select s).FirstOrDefault(); data.student_ts.DeleteOnSubmit(st); data.SubmitChanges(); } }
public static void UpdateStudent(student_t student) { using (SchoolDataDataContext data = new SchoolDataDataContext()) { student_t st = (from s in data.student_ts where s.studentID == student.studentID select s).FirstOrDefault(); st.first_name = student.first_name; st.last_name = student.last_name; st.gender = student.gender; st.gpa = student.gpa; data.SubmitChanges(); } }