public async Task <IActionResult> DeleteAll()
{
await Db.Connection.OpenAsync();
var query = new AquariumQuery(Db);
await query.DeleteAllAsync();
return(new OkResult());
}
public async Task <IActionResult> GetLatest()
{
await Db.Connection.OpenAsync();
var query = new AquariumQuery(Db);
var result = await query.LatestPostsAsync();
return(new OkObjectResult(result));
}
public async Task <IActionResult> GetOne(int id)
{
await Db.Connection.OpenAsync();
var query = new AquariumQuery(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] Aquarium body)
{
await Db.Connection.OpenAsync();
var query = new AquariumQuery(Db);
var result = await query.FindOneAsync(id);
if (result is null)
{
return(new NotFoundResult());
}
result.Name = body.Name;
result.Capacity = body.Capacity;
result.Occupation = body.Occupation;
result.CurrTemp = body.CurrTemp;
result.PerfectTemp = body.PerfectTemp;
await result.UpdateAsync();
return(new OkObjectResult(result));
}
