static void DoOneToMany(AvansContext db, string forPerson)
{
Random random = new Random();
Grade grade = new Grade
{
GradeName = $"Prog {random.Next(1, 4)}",
Result = random.Next(0, 10)
};
var person = db.People.First(x => x.Firstname.ToLower() == forPerson);
person.Grades.Add(grade);
db.SaveChanges();
}
static bool DoManyToMany(AvansContext db, string forPerson)
{
Random random = new Random();
int id = random.Next(1, 3);
var person = db.People.Include(x => x.Workshops).First(x => x.Firstname.ToLower() == forPerson);
var ws = db.Workshops.FirstOrDefault(x => x.Id == id);
if (ws != null)
{
if (!person.Workshops.Any(x => x.Id == ws.Id))
{
person.Workshops.Add(ws);
return(db.SaveChanges() > 1);
}
}
return(false);
}