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)); }