public async Task <IActionResult> DeleteAll() { await Db.Connection.OpenAsync(); var query = new football_matchQuery(Db); await query.DeleteAllAsync(); return(new OkResult()); }
public async Task <IActionResult> GetLatest() { await Db.Connection.OpenAsync(); var query = new football_matchQuery(Db); var result = await query.LatestPostsAsync(); return(new OkObjectResult(result)); }
public async Task <IActionResult> GetOne(int id) { await Db.Connection.OpenAsync(); var query = new football_matchQuery(Db); var result = await query.FindOneAsync(id); if (result is null) { return(new NotFoundResult()); } return(new OkObjectResult(result)); }
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)); }