public List <Course> GetAll()
{
using (var db = new UniversityDBEntities())
{
return(db.Courses.ToList());
}
}
public Student GetSingleRow(int id)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
return(db.Students.Single(std => std.Id == id));
}
}
public List <Enrollment> GetAll()
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
return(db.Enrollments.Include(x => x.Course).Include(x => x.Student).ToList());
}
}
public List <Department> GetSingleRow(int id)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
return(new List <Department>(db.Departments.Where(dept => dept.Id == id)));
}
}
public Enrollment GetSingleRow(int id)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
return(db.Enrollments.Find(id));
}
}
public Devision GetSingleDivision(int?divisionId)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
return(db.Devisions.Find(divisionId));
}
}
public District GetSinlgleDistrict(int?districtId)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
return(db.Districts.Find(districtId));
}
}
public Thana GetSingleThana(int? thanaId)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
return db.Thanas.Single(thana => thana.Id == thanaId);
}
}
public List <Devision> GetAll()
{
using (var db = new UniversityDBEntities())
{
return(db.Devisions.ToList());
}
}
public List <Department> GetAll()
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
return(db.Departments.ToList());
}
}
public Course GetSingleRow(int id)
{
using (var db = new UniversityDBEntities())
{
Course course = db.Courses.Find(id);
return(course);
}
}
//public List<District> GetAll()
//{
// using (var db = new UniversityDBEntities())
// {
// return db.Districts.ToList();
// }
//}
public List <District> GetAllByDivision(int divisionId)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ProxyCreationEnabled = false;
return(db.Districts.Where(x => x.DivisionId == divisionId).ToList());
}
}
//public List<Thana> GetAll()
//{
// using (var db = new UniversityDBEntities())
// {
// return db.Thanas.ToList();
// }
//}
public List<Thana> GetAllByDistrict(int district)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Configuration.LazyLoadingEnabled = false;
db.Configuration.ProxyCreationEnabled = false;
return db.Thanas.Where(x => x.DistrictId == district).ToList();
}
}
public bool Delete(Enrollment enrollment)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Entry(enrollment).State = EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
public bool Save(Course course)
{
using (var db = new UniversityDBEntities())
{
db.Courses.AddOrUpdate(course);
db.SaveChanges();
return(true);
}
}
public bool Save(Enrollment enrollment)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Enrollments.AddOrUpdate(enrollment);
db.SaveChanges();
return(true);
}
}
public bool Save(Student student)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Students.AddOrUpdate(student);
db.SaveChanges();
return(true);
}
}
public bool Update(Department department)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
db.Departments.AddOrUpdate(department);
db.SaveChanges();
return(true);
}
}
public bool Delete(Course course)
{
using (var db = new UniversityDBEntities())
{
db.Entry(course).State = EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
public bool Delete(Department department)
{
using (UniversityDBEntities db = new UniversityDBEntities())
{
//db.Departments.Remove(department);
db.Entry(department).State = EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
public List <Student> GetAll()
{
using (var db = new UniversityDBEntities())
{
return(db.Students.
Include(dept => dept.Department).
Include(div => div.Devision).
Include(dist => dist.District).
Include(thana => thana.Thana).
ToList());
}
}
public UnitOfWork()
{
db = new UniversityDBEntities();
}
public Repository(UniversityDBEntities db)
{
_db = db;
}
