Course IRepository.GetCourse(int id) { using (var db = new MyDBContext()) { return db.Course.SingleOrDefault(c => c.Id == id); } }
ICollection<IndexVM> IRepository.GetIndexViewModel() { using (var db = new MyDBContext()) { var em = db.EducationPlans; var vm = Mapper.Map<ICollection<IndexVM>>(em); return vm; } }
Course IRepository.GetDocuments(int id) { using (var db = new MyDBContext()) { var dmodel = db.Course.Where(d => d.Id == id).First(); //var dmodel = db.Course.Where(d => d.Name == name).First(); return dmodel; } }
ICollection<IndexVM> IRepository.GetCoursesDetailsViewModel(int id) { using (var db = new MyDBContext()) { var vm = db.Course.Where(cp=>cp.EducationPlanId== id).Select(cp=>cp); var mm = Mapper.Map<ICollection<IndexVM>>(vm); return mm; } }
EduPlanDetailsVM IRepository.GetEduPlansDetailsViewModel(int id) { using (var db = new MyDBContext()) { var em = db.EducationPlans.SingleOrDefault(ep=>ep.EducationId==id); em.Courses = db.Course.Where(c => c.EducationPlanId == em.EducationId).ToArray(); var vm = Mapper.Map<EduPlanDetailsVM>(em); return vm; } }