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