public ApiController( ToDoItemsContext context, IConfiguration configuration, DbContextOptions<ToDoItemsContext> options) { _context = context; _configuration = configuration; _options = options; }
public async Task<string> GetAllAsync() { await using (ToDoItemsContext context = new ToDoItemsContext(_options, _configuration)) { await context.Database.EnsureCreatedAsync(); List<ToDoItem> getOpenItems = await context.ToDoItems .Where(w => !w.Completed) .ToListAsync(); return DefaultSerializer(getOpenItems) ?? NoContentResult; } }
public async Task<string> PostSeedAsync() { List<ToDoItem> sampleToDoList = new List<ToDoItem> { new ToDoItem { Id = Guid.NewGuid(), Name = "Virtual Golfing with Remote Team", Description = "Engage the remote team in a virtual golfing tournament at the local multi-player arena.", Completed = false, }, new ToDoItem { Id = Guid.NewGuid(), Name = "Book International Flight to Sea-Tac", Description = "Departure from Toronto (CYYZ) to destination Seattle (KSEA) sometime next month.", Completed = false, }, new ToDoItem { Id = Guid.NewGuid(), Name = "Tour Seattle Space Needle", Description = "The Seattle Space Needle is a landmark observation tower and a must visit location for any tourist.", Completed = false, }, }; try { foreach (ToDoItem item in sampleToDoList) { await using (ToDoItemsContext context = new ToDoItemsContext(_options, _configuration)) { await context.ToDoItems.AddAsync(item); await context.SaveChangesAsync(); } } return $"Iterated {nameof(ToDoItem)} in list {nameof(sampleToDoList)} for {nameof(EntityEntry)} type."; } catch (CosmosException ce) { Console.WriteLine(ce); } return null; }
public async Task<string> PostAsync([FromBody] ToDoItem toDoItem) { try { if (toDoItem == null) { return Error(); } await using (ToDoItemsContext context = new ToDoItemsContext(_options, _configuration)) { await context.ToDoItems.AddAsync(toDoItem); await context.SaveChangesAsync(); ToDoItem insertedItem = await context.ToDoItems.LastOrDefaultAsync(); return $"Created item in database with GUID: {insertedItem.Id} from serialized body input."; } } catch (CosmosException ce) { Console.WriteLine(ce); return $"Caught cosmos exception while performing operation: {ce}"; } }
public ToDoItemsRepository(ToDoItemsContext _context) { context = _context; }
public ToDoItemsController(ToDoItemsContext context, IMapper mapper) { _context = context; _mapper = mapper; }