public async Task <IEnumerable <ClassDto> > Get(int SemesterId) { var results = new List <ClassDto>(); using (var db = new AbetContext()) { try { results = await db.Classes.Where(s => s.SemesterId == SemesterId) .Select(s => new ClassDto { Id = s.Id, SemesterId = s.SemesterId, CourseCode = s.CourseCode, CourseName = s.CourseName, Instructor = s.Instructor, }).ToListAsync(); } catch (Exception e) { } } return(results); }
public async Task <ClassDto> AddOrUpdate(ClassDto classDto) { using (var db = new AbetContext()) { var c = new Class { Id = classDto.Id, SemesterId = classDto.SemesterId, CourseCode = classDto.CourseCode, CourseName = classDto.CourseName, Instructor = classDto.Instructor, }; db.Classes.AddOrUpdate(c); await db.SaveChangesAsync(); return(new ClassDto { Id = c.Id, SemesterId = c.SemesterId, CourseCode = c.CourseCode, CourseName = c.CourseName, Instructor = c.Instructor }); } }
public async Task <IEnumerable <ReviewDto> > Get(int id) { var results = new List <ReviewDto>(); using (var db = new AbetContext()) { try { results = await db.Reviews.Where(c => c.Id == id) .Select(s => new ReviewDto { Id = s.Id, Rating = s.Rating, ClassId = s.ClassId, ReviewText = s.ReviewText }).ToListAsync(); } catch (Exception e) { } } return(results); }
public async Task <SemesterDto> GetById(int id) { using (var db = new AbetContext()) { return(await db.Semesters.Where(s => s.Id == id)?.Take(1).Select(s => new SemesterDto { Id = s.Id, Name = s.Name }).FirstOrDefaultAsync()); } }
public async Task <Review> RemoveById(int id) { using (var db = new AbetContext()) { var toRemove = db.Reviews.FirstOrDefault(s => s.Id == id); db.Reviews.Remove(toRemove); await db.SaveChangesAsync(); return(toRemove); } }
public async Task <IEnumerable <SemesterDto> > Search(string query) { using (var db = new AbetContext()) { return(await db.Semesters .Where(s => s.Name.ToUpper().Contains(query.ToUpper())) .Select(s => new SemesterDto { Id = s.Id, Name = s.Name }) .ToListAsync()); } }
public SemesterDto Remove(SemesterDto semesterDto) { using (var db = new AbetContext()) { var result = db.Semesters.Remove(new Semester { Id = semesterDto.Id, Name = semesterDto.Name }); db.SaveChanges(); return(new SemesterDto { Id = result.Id, Name = result.Name }); } }
public async Task <ClassDto> Remove(int id) { using (var db = new AbetContext()) { var c = db.Classes.FirstOrDefault(cl => cl.Id == id); db.Classes.Remove(c); await db.SaveChangesAsync(); return(new ClassDto { Id = c.Id, SemesterId = c.SemesterId, CourseCode = c.CourseCode, CourseName = c.CourseName, Instructor = c.Instructor });; } }
public async Task <ReviewDto> AddOrUpdate(ReviewDto reviewDto) { using (var db = new AbetContext()) { db.Reviews.AddOrUpdate( new Review { Id = reviewDto.Id, Rating = reviewDto.Rating, ClassId = reviewDto.ClassId, ReviewText = reviewDto.ReviewText }); await db.SaveChangesAsync(); } return(reviewDto); }
public async Task <IEnumerable <SemesterDto> > Get() { var results = new List <SemesterDto>(); using (var db = new AbetContext()) { try { results = await db.Semesters.Select(s => new SemesterDto { Id = s.Id, Name = s.Name }).ToListAsync(); } catch (Exception e) { } } return(results); }
public ReviewDto Remove(ReviewDto reviewDto) { using (var db = new AbetContext()) { var result = db.Reviews.Remove(new Review { Id = reviewDto.Id, Rating = reviewDto.Rating, ClassId = reviewDto.ClassId, ReviewText = reviewDto.ReviewText }); db.SaveChanges(); return(new ReviewDto { Id = result.Id, Rating = reviewDto.Rating, ClassId = reviewDto.ClassId, ReviewText = reviewDto.ReviewText }); } }
public async Task <ClassDto> Remove(ClassDto classDto) { using (var db = new AbetContext()) { var result = db.Classes.Remove(new Class { Id = classDto.Id, SemesterId = classDto.SemesterId, CourseCode = classDto.CourseCode, CourseName = classDto.CourseName, Instructor = classDto.Instructor }); db.SaveChanges(); return(new ClassDto { Id = result.Id, SemesterId = result.SemesterId, CourseCode = result.CourseCode, CourseName = result.CourseName, Instructor = result.Instructor }); } }
public async Task <SemesterDto> AddOrUpdate(SemesterDto semesterDto) { var newSemester = new Semester { Id = semesterDto.Id, Name = semesterDto.Name, LastModified = DateTime.Now }; using (var db = new AbetContext()) { try { db.Semesters.AddOrUpdate(newSemester); await db.SaveChangesAsync(); } catch (Exception e) { } } return(new SemesterDto { Id = newSemester.Id, Name = newSemester.Name }); }