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);
}
