public List <Instructor> GetAll() { using (var db = new ContosoDBContext()) { return(db.Instructors.ToList()); } }
public List <Department> GetAll() { using (var db = new ContosoDBContext()) { return(db.Departments.ToList()); } }
public List <Course> GetAll() { using (var db = new ContosoDBContext()) { return(db.Course.ToList()); } }
public Person GetById(int id) { using (var Db = new ContosoDBContext()) { var person = Db.Person.Where(p => p.Id == id).FirstOrDefault(); return(person); } }
public List <Person> GetAll() { using (var Db = new ContosoDBContext()) { var people = Db.Person.ToList(); return(people); } }
public void CreateNew(Person obj) { using (var Db = new ContosoDBContext()) { Db.Person.Add(obj); Db.SaveChanges(); } }
public Department GetById(int Id) { using (var db = new ContosoDBContext()) { var dep = db.Departments.Where(d => d.Id == Id).FirstOrDefault(); return(dep); } }
public List <Courses> GetAll() { using (var db = new ContosoDBContext()) { var courses = db.Courses.ToList(); return(courses); } }
public Course GetById(int Id) { using (var db = new ContosoDBContext()) { var cor = db.Course.Where(c => c.Id == c.Id).FirstOrDefault(); return(cor); } }
public void CreateNew(Course obj) { using (var Db = new ContosoDBContext()) { Db.Course.Add(obj); Db.SaveChanges(); } }
public Departments Details(int id) { using (var db = new ContosoDBContext()) { var department = db.Departments.Where(d => d.Id == id).FirstOrDefault(); return(department); } }
public Instructor GetById(int Id) { using (var db = new ContosoDBContext()) { var inst = db.Instructors.Where(ins => ins.Id == Id).FirstOrDefault(); return(inst); } }
public void Create(Instructor entity) { using (var db = new ContosoDBContext()) { db.Instructors.Add(entity); db.SaveChanges(); } }
public List <Instructor> GetAll() { using (var db = new ContosoDBContext()) { var instructors = db.Intructor.ToList(); return(instructors); } }
public Person Details(int id) { using (var db = new ContosoDBContext()) { var person = db.Person.Where(d => d.Id == id).FirstOrDefault(); return(person); } }
public Course GetById(int id) { using (var Db = new ContosoDBContext()) { var course = Db.Course.Where(c => c.Id == id).FirstOrDefault(); return(course); } }
public void Create(Department entity) { using (var db = new ContosoDBContext()) { db.Departments.Add(entity); db.SaveChanges(); } }
public void Create(Courses course) { using (var db = new ContosoDBContext()) { db.Courses.Add(course); db.SaveChanges(); } }
public void Create(Course entity) { using (var db = new ContosoDBContext()) { db.Course.Add(entity); db.SaveChanges(); } }
public void Create(Person person) { using (var db = new ContosoDBContext()) { db.Person.Add(person); db.SaveChanges(); } }
public List <Department> GetAll() { using (var Db = new ContosoDBContext()) { var departments = Db.Department.ToList(); return(departments); } }
public Department GetById(int id) { using (var Db = new ContosoDBContext()) { var department = Db.Department.Where(d => d.Id == id).FirstOrDefault(); return(department); } }
public Person GetById(int Id) { using (var db = new ContosoDBContext()) { var person = db.People.Where(p => p.Id == Id).FirstOrDefault(); return(person); } }
public void CreateNew(Department dept) { using (var Db = new ContosoDBContext()) { Db.Department.Add(dept); Db.SaveChanges(); } }
public List <Person> GetAll() { using (var db = new ContosoDBContext()) { var person = db.People.ToList(); return(person); } }
public void Create(Person entity) { using (var db = new ContosoDBContext()) { db.People.Add(entity); db.SaveChanges(); } }
public Courses Details(int id) { using (var db = new ContosoDBContext()) { var course = db.Courses.Where(d => d.Id == id).FirstOrDefault(); return(course); } }
public void Update(Department dept) { using (var Db = new ContosoDBContext()) { Db.Department.Attach(dept); Db.Entry(dept).State = EntityState.Modified; Db.SaveChanges(); } }
public void Update(Person entity) { using (var db = new ContosoDBContext()) { db.People.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); } }
public void Update(Courses course) { using (var db = new ContosoDBContext()) { db.Courses.Attach(course); db.Entry(course).State = EntityState.Modified; db.SaveChanges(); } }