//Helper functions
        private static IntegratedCourseSystemContext CreateDatabaseContext(string DbName)
        {
            //Arrange
            var options = new DbContextOptionsBuilder <IntegratedCourseSystemContext>()
                          .UseInMemoryDatabase(databaseName: DbName)
                          .Options;

            // Insert test users into the in-memory database
            using (var context = new IntegratedCourseSystemContext(options))
            {
                context.Users.Add(new User {
                    Id = 1, Email = "*****@*****.**", Password = "******", Role = UserRole.Student
                });
                context.Users.Add(new User {
                    Id = 2, Email = "*****@*****.**", Password = "******", Role = UserRole.Admin
                });
                context.Users.Add(new User {
                    Id = 3, Email = "*****@*****.**", Password = "******", Role = UserRole.Teacher
                });
                context.SaveChanges();
            }
            return(new IntegratedCourseSystemContext(options));
        }
        public static void SeedDatabase(IntegratedCourseSystemContext dbContext)
        {
            // Students
            var sa = new DataBase.Models.Student {
                Id = 1, Name = "Andrii", Surname = "Kliachkin"
            };

            dbContext.Students.Add(sa);
            var sb = new DataBase.Models.Student {
                Id = 2, Name = "NotAndrii", Surname = "NotKliachkin"
            };

            dbContext.Students.Add(sb);
            var sc = new DataBase.Models.Student {
                Id = 3, Name = "Kliandrii", Surname = "Achkin"
            };

            dbContext.Students.Add(sc);
            // Teachers
            var ta = new DataBase.Models.Teacher {
                Id = 1, Name = "Alex", Surname = "Fedorus"
            };

            dbContext.Teachers.Add(ta);
            var tb = new DataBase.Models.Teacher {
                Id = 2, Name = "Olena", Surname = "Shyshatska"
            };

            dbContext.Teachers.Add(tb);
            dbContext.SaveChanges();
            // Users
            dbContext.Users.Add(new DataBase.Models.User
            {
                Email    = "*****@*****.**",
                Password = "******",
                Role     = DataBase.Models.UserRole.Student,
                //Student = dbContext.Students.Single(x => x.Id == 1),
            });
            dbContext.Users.Add(new DataBase.Models.User
            {
                Email    = "*****@*****.**",
                Password = "******",
                Role     = DataBase.Models.UserRole.Teacher,
                //Teacher = dbContext.Teachers.Single(x=>x.Name == "Alex"),
            });
            dbContext.Users.Add(new DataBase.Models.User
            {
                Email    = "*****@*****.**",
                Password = "******",
                Role     = DataBase.Models.UserRole.Teacher,
                //Teacher = dbContext.Teachers.Single(x=>x.Id == 2),
            });
            // Groups
            dbContext.Groups.Add(new DataBase.Models.Group {
                Name = "Le Fishe au Chocolat", Classid = 0
            });
            dbContext.Groups.Add(new DataBase.Models.Group {
                Name = "Karppi", Classid = 0
            });
            dbContext.Groups.Add(new DataBase.Models.Group {
                Name = "Tuna", Classid = 1
            });

            dbContext.SaveChanges();
        }