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