public void addStudent(Student student) { using (ExamCourseEntityEntities db = new ExamCourseEntityEntities()) { db.Student.Add(student); db.SaveChanges(); } }
public void addTeacher(Teacher teacher) { using (ExamCourseEntityEntities db = new ExamCourseEntityEntities()) { db.Teacher.Add(teacher); db.SaveChanges(); } }
public void deleteStudent(int id) { using (ExamCourseEntityEntities db = new ExamCourseEntityEntities()) { Student Student = db.Student.Where(x => x.id == id).First(); db.Student.Remove(Student); db.SaveChanges(); } }
public List <Student> GetStudents() { List <Student> students = new List <Student>(); using (ExamCourseEntityEntities db = new ExamCourseEntityEntities()) { students = db.Student.ToList(); } return(students); }
public void deleteTeacher(int id) { using (ExamCourseEntityEntities db = new ExamCourseEntityEntities()) { Teacher teacher = db.Teacher.Where(x => x.id == id).First(); db.Teacher.Remove(teacher); db.SaveChanges(); } }
public List <Teacher> GetTeachers() { List <Teacher> teachers = new List <Teacher>(); using (ExamCourseEntityEntities db = new ExamCourseEntityEntities()) { teachers = db.Teacher.ToList(); } return(teachers); }
public void updateStudent(Student Student) { using (ExamCourseEntityEntities db = new ExamCourseEntityEntities()) { var updatedStudent = db.Student.Where(x => x.id == Student.id).First(); updatedStudent.password = Student.password; updatedStudent.full_name = Student.full_name; updatedStudent.username = Student.username; db.SaveChanges(); } }
public void updateTeacher(Teacher teacher) { using (ExamCourseEntityEntities db = new ExamCourseEntityEntities()) { var updatedTeacher = db.Teacher.Where(x => x.id == teacher.id).First(); updatedTeacher.password = teacher.password; updatedTeacher.full_name = teacher.full_name; updatedTeacher.username = teacher.username; db.SaveChanges(); } }