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