Esempio n. 1
0
        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();
        }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
 private static void DisplayResult(AvansContext db, bool m2m)
 {
     foreach (var p in db.People.Include(g => g.Grades).Include(w => w.Workshops))
     {
         Console.WriteLine($"{p.Firstname} {p.Lastname}");
         if (p.Grades.Any())
         {
             Console.WriteLine($"Grade average: {Math.Round(p.Grades.Average(c => c.Result), 2)}");
         }
         Console.WriteLine("Top 10 Grades:");
         foreach (var g in p.Grades.Take(10))
         {
             Console.WriteLine($"\t{g.GradeName} {g.Result}");
         }
         foreach (var ws in p.Workshops)
         {
             Console.WriteLine($"Workshop:\t{ws.WorkshopName}");
         }
         Console.WriteLine();
     }
 }
Esempio n. 4
0
        static void Main(string[] args)
        {
            bool   nogEenRondje = true;
            Random random       = new Random();

            string[] peopleToChoose = { "bob", "eric", "stijn", "ronald" };

            while (nogEenRondje)
            {
                using (var db = new AvansContext())
                {
                    Console.WriteLine();

                    DoOneToMany(db, peopleToChoose[random.Next(0, 3)]);
                    bool m2m = DoManyToMany(db, peopleToChoose[random.Next(0, 3)]);

                    DisplayResult(db, m2m);
                }
                Console.WriteLine();
                Console.WriteLine("Nog een rondje Y/N?");
                nogEenRondje = Console.ReadKey().KeyChar.ToString().ToLower() == "y";
            }
            Console.ReadLine();
        }