public IEnumerable <Course> GetAllCourse()
{
using (var db = new ContosoDataDbContext())
{
return(db.Courses.ToList());
}
}
public IEnumerable <People> GetAllPeople()
{
using (var db = new ContosoDataDbContext())
{
return(db.People.ToList());
}
}
public Course GetCourseByTitle(string title)
{
using (var db = new ContosoDataDbContext())
{
return(db.Courses.Where(d => d.Title == title).Single());
}
}
public People GetPeopleByName(string FirstName)
{
using (var db = new ContosoDataDbContext())
{
return(db.People.Where(d => d.FirstName == FirstName).SingleOrDefault());
}
}
public Enrollments GetEnrollmentGrade(string Grade)
{
using (var db = new ContosoDataDbContext())
{
return(db.Enrollment.Where(d => d.Grade == Grade).SingleOrDefault());
}
}
public Courses GetCourseByName(string Title)
{
using (var db = new ContosoDataDbContext())
{
return(db.Course.Where(d => d.Title == Title).SingleOrDefault());
}
}
public Enrollment GetEnrollmentByGrade(string grade)
{
using (var db = new ContosoDataDbContext())
{
return(db.Enrollments.Where(d => d.Grade == grade).FirstOrDefault());
}
}
public IEnumerable <Enrollments> GetAllEnrollment()
{
using (var db = new ContosoDataDbContext())
{
return(db.Enrollment.ToList());
}
}
public Course GetHighestCredit()
{
using (var db = new ContosoDataDbContext())
{
return(db.Courses.OrderByDescending(d => d.Credits).FirstOrDefault());
}
}
public Enrollment GetEnrollmentById(int id)
{
using (var db = new ContosoDataDbContext())
{
return(db.Enrollments.Where(d => d.Id == id).FirstOrDefault());
}
}
public People GetPeopleByCity(string City)
{
using (var db = new ContosoDataDbContext())
{
return(db.People.Where(d => d.City == City).Single());
}
}
public People GetPeopleById(int id)
{
using (var db = new ContosoDataDbContext())
{
return(db.People.Where(d => d.Id == id).FirstOrDefault());
}
}
public Course GetCourseById(int id)
{
using (var db = new ContosoDataDbContext())
{
return(db.Courses.Where(d => d.Id == id).FirstOrDefault());
}
}
public void Create(People people)
{
using (var db = new ContosoDataDbContext())
{
db.People.Add(people);
db.SaveChanges();
}
}
public Enrollments GetEnrollmentById(int id)
{
using (var db = new ContosoDataDbContext())
{
var result = db.Enrollment.Where(d => d.Id == id).FirstOrDefault();
return(result);
}
}
public void Create(Enrollments enrollment)
{
using (var db = new ContosoDataDbContext())
{
db.Enrollment.Add(enrollment);
db.SaveChanges();
}
}
public void Create(Course course)
{
using (var db = new ContosoDataDbContext())
{
db.Courses.Add(course);
db.SaveChanges();
}
}
public Courses GetCourseById(int id)
{
using (var db = new ContosoDataDbContext())
{
var result = db.Course.Where(d => d.Id == id).FirstOrDefault();
return(result);
}
}
public DepartmentRepository(ContosoDataDbContext context) : base(context) //access base class constructor
{
}
public DepartmentRepository(ContosoDataDbContext context) : base(context)
{
}
protected Repository(ContosoDataDbContext context)
{
_dbContext = context;
}
