public async Task <IActionResult> Post([FromBody] ftcand body)
        {
            await Db.Connection.OpenAsync();

            body.Db = Db;
            await body.InsertAsync();

            return(new OkObjectResult(body));
        }
        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));
        }