public async Task <IActionResult> Post([FromBody] football_match body) { await Db.Connection.OpenAsync(); body.Db = Db; await body.InsertAsync(); return(new OkObjectResult(body)); }
public async Task <IActionResult> PutOne(int id, [FromBody] football_match body) { await Db.Connection.OpenAsync(); var query = new football_matchQuery(Db); var result = await query.FindOneAsync(id); if (result is null) { return(new NotFoundResult()); } result.home_team = body.home_team; result.away_team = body.away_team; await result.UpdateAsync(); return(new OkObjectResult(result)); }
private async Task <List <football_match> > ReadAllAsync(DbDataReader reader) { var match = new List <football_match>(); using (reader) { while (await reader.ReadAsync()) { var post = new football_match(Db) { Id = reader.GetInt32(0), home_team = reader.GetString(1), away_team = reader.GetString(2), }; match.Add(post); } } return(match); }