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); } ); }
public WorksetController(MemorizerContext db) { _db = db; }
public LanguageRepository(MemorizerContext db) { _db = db; }
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(); } }