public void Add(Instructor obj)
{
using (var context = new TobChatDbContext())
{
context.Instructors.Add(obj);
context.SaveChanges();
}
}
public void Add(Schedule obj)
{
using (var context = new TobChatDbContext())
{
context.Schedules.Add(obj);
context.SaveChanges();
}
}
public void Add(Course obj)
{
using (var context = new TobChatDbContext())
{
context.Courses.Add(obj);
context.SaveChanges();
}
}
public void Add(Student obj)
{
using (var context = new TobChatDbContext())
{
context.Students.Add(obj);
context.SaveChanges();
}
}
public void Add(Person obj)
{
using (var context = new TobChatDbContext())
{
context.People.Add(obj);
context.SaveChanges();
}
}
public void Update(Instructor obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Instructors.First(i => i.Id == obj.Id);
update.Speciality = obj.Speciality;
}
}
public void Delete(int id)
{
using (var context = new TobChatDbContext())
{
var delete = context.Instructors.First(i => i.Id == id);
context.Instructors.Remove(delete);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new TobChatDbContext())
{
var delete = context.Students.First(s => s.Id == id);
context.Students.Remove(delete);
context.SaveChanges();
}
}
public void Delete(int id)
{
using (var context = new TobChatDbContext())
{
var delete = context.Schedules.First(p => p.Id == id);
context.Schedules.Remove(delete);
context.SaveChanges();
}
}
public void Update(Schedule obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Schedules.First(p => p.Id == obj.Id);
update.Location = obj.Location;
update.ClassTime = obj.ClassTime;
context.SaveChanges();
}
}
public void Update(Student obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Students.First(s => s.Id == obj.Id);
update.Major = obj.Major;
update.YearLevel = obj.YearLevel;
context.SaveChanges();
}
}
public List <Instructor> GetAll()
{
List <Instructor> instructors;
using (var context = new TobChatDbContext())
{
instructors = context.Instructors.ToList();
}
return(instructors);
}
public List <Enrollment> GetAll()
{
List <Enrollment> enrollments;
using (var context = new TobChatDbContext())
{
enrollments = context.Enrollments.ToList();
}
return(enrollments);
}
public List <Department> GetAll()
{
List <Department> departments;
using (var context = new TobChatDbContext())
{
departments = context.Departments.ToList();
}
return(departments);
}
public List <Role> GetAll()
{
List <Role> roles;
using (var context = new TobChatDbContext())
{
roles = context.Roles.ToList();
}
return(roles);
}
public List <Course> GetAll()
{
List <Course> courses;
using (var context = new TobChatDbContext())
{
courses = context.Courses.ToList();
}
return(courses);
}
public List <Person> GetAll()
{
List <Person> people;
using (var context = new TobChatDbContext())
{
people = context.People.ToList();
}
return(people);
}
public List <Student> GetAll()
{
List <Student> students;
using (var context = new TobChatDbContext())
{
students = context.Students.ToList();
}
return(students);
}
public void Update(Department obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Departments.First(d => d.Id == obj.Id);
update.DeptName = obj.DeptName;
update.Adminstrator = obj.Adminstrator;
context.SaveChanges();
}
}
public List <Schedule> GetAll()
{
List <Schedule> schedules;
using (var context = new TobChatDbContext())
{
schedules = context.Schedules.ToList();
}
return(schedules);
}
public void Update(Enrollment obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Enrollments.First(s => s.Id == obj.Id);
update.CourseId = obj.CourseId;
update.StudentId = obj.StudentId;
update.Grade = obj.Grade;
context.SaveChanges();
}
}
public void Update(Role obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Roles.First(p => p.Id == obj.Id);
update.RoleName = obj.RoleName;
update.Department = obj.Department;
update.Description = obj.Description;
context.SaveChanges();
}
}
public void Update(Person obj)
{
using (var context = new TobChatDbContext())
{
var update = context.People.First(p => p.Id == obj.Id);
update.FirstName = obj.FirstName;
update.LastName = obj.LastName;
update.MiddleName = obj.MiddleName;
update.Password = obj.Password;
update.Email = obj.Email;
context.SaveChanges();
}
}
public void Update(Course obj)
{
using (var context = new TobChatDbContext())
{
var update = context.Courses.First(c => c.Id == obj.Id);
update.CourseTitle = obj.CourseTitle;
update.DepartmentId = obj.DepartmentId;
update.ScheduleId = obj.ScheduleId;
update.Assignment = obj.Assignment;
update.Credit = obj.Credit;
context.SaveChanges();
}
}
