//public async Task<AcademyDetail> GetAcademyByDetailAsync(int id) //{ // var entity = await _context.Academies.FindAsync(id); // if (entity == null) // return null; // var model = new AcademyDetail // { // AcademyId = entity.AcademyId, // Name = entity.Name, // City = entity.City, // State = entity.State, // Programs = entity.Programs.Select(program => new ProgramListItem // { // ProgramId = program.ProgramId, // Name = program.Name, // Type = program.Type, // AverageRating = program.AverageRating // }).ToList(), // Instructors = entity.Instructors.Select(i => new InstructorListItem // { // InstructorId = i.InstructorId, // FullName = i.FullName, // }).ToList(), // Ratings = new List<AcademyRatingListItem>() // }; // foreach (var rating in entity.Ratings) // { // model.Ratings.Add(new AcademyRatingListItem // { // RatingId = rating.RatingId, // AcademyId = entity.AcademyId, // AcademyName = entity.Name, // Description = rating.Description, // //IsUserOwned = rating.UserId == _userId, // Score = rating.Score // //VisitDate = rating.VisitDate // }); // } // return model; //} //public async Task<AcademyDetail> GetAcademyByIdAsync(int academyId) //{ // var entity = await _context.Academies.FindAsync(academyId); // if (entity == null) // return null; // var model = new AcademyDetail // { // AcademyId = entity.AcademyId, // Name = entity.Name, // City = entity.City, // State = entity.State, // Programs = entity.Programs.Select(program => new ProgramListItem // { // ProgramId = program.ProgramId, // Name = program.Name, // Type = program.Type, // AverageRating = program.AverageRating // }).ToList(), // Ratings = new List<AcademyRatingListItem>() // }; // foreach (var rating in entity.Ratings) // { // model.Ratings.Add(new AcademyRatingListItem // { // RatingId = rating.RatingId, // AcademyId = entity.AcademyId, // AcademyName = entity.Name, // Description = rating.Description, // IsUserOwned = rating.UserId == _userId, // Score = rating.Score // //VisitDate = rating.VisitDate // }); // } // return model; //} public AcademyDetail GetAcademyById(int id) { var model = new AcademyDetail(); using (var ctx = new ApplicationDbContext()) { var entity = ctx.Academies.FirstOrDefault(a => a.AcademyId == id); entity.Name = model.Name; entity.City = model.City; entity.State = model.State; } return(model); }
public AcademyDetail GetAcademyByDetail(int id) { var model = new AcademyDetail(); var ctx = new ApplicationDbContext(); using (ctx) { string createdBy = ctx.Users.FirstOrDefault(u => u.Id == _userId).UserName; var entity = ctx.Academies.FirstOrDefault(i => i.AcademyId == id); //var programs = ctx.Programs.Where(p => p.AcademyId == id); model.AcademyId = entity.AcademyId; model.Name = entity.Name; model.State = entity.State; model.City = entity.City; model.CreatedBy = entity.CreatedBy; model.Ratings = entity.Ratings; //model.Programs = entity.Programs; //model.Instructors = entity.Instructors; } return(model); }