Пример #1
0
        public WorksetQuery(MemorizerContext db)
        {
            Field <WorksetType>(
                "workset",
                arguments:
                new QueryArguments(
                    new QueryArgument <IdGraphType> {
                Name = "id", Description = "The Id of the Workset"
            }
                    ),
                resolve:
                context =>
            {
                var id      = context.GetArgument <Guid?>("id");
                var workset = db.Worksets.Include(x => x.Questions).FirstOrDefault(i => i.Id == id);
                return(workset);
            }
                );

            Field <ListGraphType <WorksetType> >(
                "worksets",
                resolve:
                context =>
            {
                var worksets = db.Worksets
                               .Include(x => x.Questions)
                               .ThenInclude(q => q.AnswerLanguage)
                               .Include(x => x.Questions)
                               .ThenInclude(q => q.QuestionLanguage);
                return(worksets);
            }
                );
        }
Пример #2
0
 public WorksetController(MemorizerContext db)
 {
     _db = db;
 }
Пример #3
0
 public LanguageRepository(MemorizerContext db)
 {
     _db = db;
 }
Пример #4
0
        public static void Run(MemorizerContext db)
        {
            User user = new User();

            user.Name       = "Keremcan";
            user.Surname    = "Çakar";
            user.PictureUrl = "";

            if (!db.Languages.Any())
            {
                db.Languages.Add(new Language()
                {
                    Name = "German"
                });

                db.Languages.Add(new Language()
                {
                    Name = "Turkish"
                });

                db.Languages.Add(new Language()
                {
                    Name = "English"
                });
                db.SaveChanges();
            }

            if (!db.Worksets.Any())
            {
                db.Worksets.Add(
                    new Workset(user)
                {
                    Name        = "Kerem's German Workset",
                    Description = "Memorize Basic German words and structures",
                    Questions   = new List <Question>
                    {
                        new Question(user)
                        {
                            QuestionText     = "Mädchen",
                            Answer           = "Girl",
                            QuestionLanguage = db.Languages.FirstOrDefault(x => x.Name == "German"),
                            AnswerLanguage   = db.Languages.FirstOrDefault(x => x.Name == "English"),
                        },
                        new Question(user)
                        {
                            QuestionText     = "Wasser",
                            Answer           = "Water",
                            QuestionLanguage = db.Languages.FirstOrDefault(x => x.Name == "German"),
                            AnswerLanguage   = db.Languages.FirstOrDefault(x => x.Name == "English"),
                        },
                        new Question(user)
                        {
                            QuestionText     = "Brot",
                            Answer           = "Bread",
                            QuestionLanguage = db.Languages.FirstOrDefault(x => x.Name == "German"),
                            AnswerLanguage   = db.Languages.FirstOrDefault(x => x.Name == "English"),
                        }
                    }
                });
                db.SaveChanges();
            }
        }