public async Task <IActionResult> GetLatest()
{
await Db.Connection.OpenAsync();
var query = new ftcandquery(Db);
var result = await query.LatestPostsAsync();
return(new OkObjectResult(result));
}
public async Task <IActionResult> DeleteAll()
{
await Db.Connection.OpenAsync();
var query = new ftcandquery(Db);
await query.DeleteAllAsync();
return(new OkResult());
}
public async Task <IActionResult> GetOne(int Id)
{
await Db.Connection.OpenAsync();
var query = new ftcandquery(Db);
var result = await query.FindListAsync(Id);
//if (result is null)
// return new NotFoundResult();
return(new OkObjectResult(result));
}
public async Task <IActionResult> DeleteOne(int Id)
{
await Db.Connection.OpenAsync();
var query = new ftcandquery(Db);
var result = await query.FindOneAsync(Id);
if (result is null)
{
return(new NotFoundResult());
}
await result.DeleteAsync();
return(new OkResult());
}
public async Task <IActionResult> PutOne(int Id, [FromBody] ftcand body)
{
await Db.Connection.OpenAsync();
var query = new ftcandquery(Db);
var result = await query.FindOneAsync(Id);
if (result is null)
{
return(new NotFoundResult());
}
result.dbcandno = body.dbcandno;
result.fullPath = body.fullPath;
result.reportStatus = body.reportStatus;
result.reportDesc = body.reportDesc;
result.status_email = body.status_email;
result.updated_at = body.updated_at;
result.filesize = body.filesize;
result.serverName = body.serverName;
result.lastmodified = body.lastmodified;
await result.UpdateAsync();
return(new OkObjectResult(result));
}
