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