public Homework GetById(Guid id)
{
using (var context = new HomeworksContext())
{
return(context.Homeworks.Include("Exercises").FirstOrDefault(p => p.Id == id));
}
}
public IEnumerable <Homework> GetAll()
{
using (var context = new HomeworksContext())
{
return(context.Homeworks.Include("Exercises").ToList());
}
}
public Exercise GetById(Guid id)
{
using (var context = new HomeworksContext())
{
return(context.Exercises.FirstOrDefault(p => p.Id == id));
}
}
public Homework Add(Homework homework)
{
using (var context = new HomeworksContext())
{
homework = context.Homeworks.Add(homework);
context.SaveChanges();
}
return(homework);
}
public bool DeleteById(Guid id)
{
using (var context = new HomeworksContext())
{
Homework homework = context.Homeworks.Include("Exercises").FirstOrDefault(p => p.Id == id);
if (homework == null)
{
return(false);
}
context.Homeworks.Remove(homework);
context.SaveChanges();
return(true);
}
}
public bool Update(Guid id, Homework updatedHomework)
{
using (var context = new HomeworksContext())
{
Homework originalHomework = context.Homeworks.FirstOrDefault(p => p.Id == id);
if (originalHomework == null)
{
return(false);
}
originalHomework.Description = updatedHomework.Description;
originalHomework.DueDate = updatedHomework.DueDate;
context.SaveChanges();
return(true);
}
}
public Exercise Add(Guid homeworkId, Exercise exercise)
{
using (var context = new HomeworksContext())
{
Homework homework = context.Homeworks.Include("Exercises").FirstOrDefault(h => h.Id == homeworkId);
if (homework != null)
{
homework.Exercises.Add(exercise);
context.SaveChanges();
return(exercise);
}
else
{
return(null);
}
}
}