public Instructor GetByID(int id)
{
ContosoDBContext contosoDbContext = new ContosoDBContext();
Instructor instructor = contosoDbContext.Instructor.SingleOrDefault(d => d.ID == id);
return(instructor);
}
public Courses GetByID(int id)
{
ContosoDBContext contosoDbContext = new ContosoDBContext();
Courses course = contosoDbContext.Courses.SingleOrDefault(d => d.ID == id);
return(course);
}
public Departments GetByID(int id)
{
ContosoDBContext contosoDbContext = new ContosoDBContext();
Departments department = contosoDbContext.Departments.SingleOrDefault(d => d.ID == id);
return(department);
}
public People GetByID(int id)
{
ContosoDBContext contosoDbContext = new ContosoDBContext();
People person = contosoDbContext.People.SingleOrDefault(d => d.ID == id);
return(person);
}
public void Add(People entity)
{
using (var contosoDbContext = new ContosoDBContext())
{
contosoDbContext.People.Add(entity);
contosoDbContext.SaveChanges();
}
}
public void Add(Courses entity)
{
using (var contosoDbContext = new ContosoDBContext())
{
contosoDbContext.Courses.Add(entity);
contosoDbContext.SaveChanges();
}
}
public void Add(Departments entity)
{
using (var contosoDbContext = new ContosoDBContext())
{
contosoDbContext.Departments.Add(entity);
contosoDbContext.SaveChanges();
}
}
public void Update(Departments entity)
{
using (var contosoDbContext = new ContosoDBContext())
{
contosoDbContext.Departments.Attach(entity);
contosoDbContext.Entry(entity).State = EntityState.Modified;
contosoDbContext.SaveChanges();
}
}
public void Delete(Departments entity)
{
using (var contosoDbContext = new ContosoDBContext())
{
var departments = contosoDbContext.Departments.ToList();
var department = departments.SingleOrDefault(d => d.ID == entity.ID);
if (department != null)
{
contosoDbContext.Departments.Remove(department);
contosoDbContext.SaveChanges();
}
}
}
public void Delete(Courses entity)
{
using (var contosoDbContext = new ContosoDBContext())
{
var courses = contosoDbContext.Courses.ToList();
var course = courses.SingleOrDefault(d => d.ID == entity.ID);
if (course != null)
{
contosoDbContext.Courses.Remove(course);
contosoDbContext.SaveChanges();
}
}
}
public void Delete(People entity)
{
using (var contosoDbContext = new ContosoDBContext())
{
var people = contosoDbContext.People.ToList();
var person = people.SingleOrDefault(d => d.ID == entity.ID);
if (person != null)
{
contosoDbContext.People.Remove(person);
contosoDbContext.SaveChanges();
}
}
}
public List <Courses> GetAll()
{
ContosoDBContext contosoDbContext = new ContosoDBContext();
return(contosoDbContext.Courses.ToList());
}
public List <Departments> GetAll()
{
ContosoDBContext contosoDbContext = new ContosoDBContext();
return(contosoDbContext.Departments.ToList());
}
public CoursesRepository(ContosoDBContext context) : base(context)
{
}
public List <Instructor> GetAll()
{
ContosoDBContext contosoDbContext = new ContosoDBContext();
return(contosoDbContext.Instructor.ToList());
}
public departRepository(ContosoDBContext context) : base(context)
{
}
public List <People> GetAll()
{
ContosoDBContext contosoDbContext = new ContosoDBContext();
return(contosoDbContext.People.ToList());
}
protected Repository(ContosoDBContext context)
{
_dbContext = context;
}
public PeopleRepository(ContosoDBContext context) : base(context)
{
}
