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