public MentalStatusQuery(MentalStatusDbContext db) { Field <MentalStatusType>( "mentalStatus", arguments: new QueryArguments( new QueryArgument <IdGraphType> { Name = "id", Description = "The ID of the Status." }), resolve: context => { var id = context.GetArgument <System.Guid>("id"); var status = db .MentalStatuses .FirstOrDefault(i => i.Id == id); return(status); }); Field <ListGraphType <MentalStatusType> >( "mentalStatuses", resolve: context => { var authors = db.MentalStatuses; return(authors); }); }
public MentalStatusMutation(MentalStatusDbContext db) { Field <MentalStatusType>( "createStatus", arguments: new QueryArguments( new QueryArgument <NonNullGraphType <MentalStatusInputType> > { Name = "mentalStatus" } ), resolve: context => { var mentalStatus = context.GetArgument <MentalStatus>("mentalStatus"); mentalStatus.Id = Guid.NewGuid(); db.MentalStatuses.Add(mentalStatus); db.SaveChanges(); return(mentalStatus); }); }
public static void Initialize(IServiceProvider serviceProvider) { using var context = new MentalStatusDbContext( serviceProvider.GetRequiredService <DbContextOptions <MentalStatusDbContext> >()); // Look for any items if (context.MentalStatuses.Any()) { return; // Data was already seeded } context.MentalStatuses.AddRange( new MentalStatus { Id = Guid.NewGuid(), Status = 3, StatusDate = DateTime.Now, AddInfo = "When does this all end?", Latitude = 60.388910M, Longitude = 25.665440M, PostCode = "06100", City = "Porvoo", Sex = 2, Age = 25 }, new MentalStatus { Id = Guid.NewGuid(), Status = 4, StatusDate = DateTime.Now, AddInfo = "I have renovated the whole house", Latitude = 63.841680M, Longitude = 23.144230M, PostCode = "06100", City = "Porvoo", Sex = 1, Age = 66 } ); context.SaveChanges(); }
public GraphqlController(MentalStatusDbContext db) { _db = db; }