public async Task <ActionResult <DatasetQueryCategory> > UpdateAsync(int id, [FromBody] DatasetQueryCategory model)
{
try
{
if (model != null)
{
model.Id = id;
}
var updated = await manager.UpdateCategoryAsync(model);
return(Ok(updated));
}
catch (ArgumentException ae)
{
log.LogError("Invalid update DatasetQueryCategory model. Model:{@Model} Error:{Error}", model, ae.Message);
return(BadRequest());
}
catch (LeafRPCException le)
{
return(StatusCode(le.StatusCode));
}
catch (Exception ex)
{
log.LogError("Failed to update DatasetQueryCategory. Model:{@Model} Error:{Error}", model, ex.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public async Task <DatasetQueryCategory> CreateCategoryAsync(DatasetQueryCategory cat)
{
using (var cn = new SqlConnection(opts.ConnectionString))
{
await cn.OpenAsync();
var created = await cn.QueryFirstOrDefaultAsync <DatasetQueryCategory>(
Sql.Create,
new
{
cat = cat.Category,
user = user.UUID
},
commandType : CommandType.StoredProcedure,
commandTimeout : opts.DefaultTimeout);
return(created);
}
}
