public async Task <IActionResult> GetOne(int Id, string skilltype, string skillitem)
{
await Db.Connection.OpenAsync();
var query = new ticandskillsquery(Db);
var result = await query.FindOneAsync(Id, skilltype, skillitem);
//if (result is null)
// return new NotFoundResult();
return(new OkObjectResult(result));
}
public async Task <IActionResult> PutOne(int Id, string skilltype, string skillitem, [FromBody] ticandskills body)
{
await Db.Connection.OpenAsync();
var query = new ticandskillsquery(Db);
var result = await query.FindOneAsync(Id, skilltype, skillitem);
if (result is null)
{
body.Db = Db;
await body.InsertAsync();
return(new OkObjectResult(body));
}
result.dbcandno = body.dbcandno;
result.dbkeyskilltype = body.dbkeyskilltype;
result.dbskillitem = body.dbskillitem;
result.skillstatus = body.skillstatus;
result.staffid = body.staffid;
result.created_at = body.created_at;
await result.UpdateAsync();
return(new OkObjectResult(result));
}
