public async Task <AdminDemographicQuery> UpdateDemographicQueryAsync(AdminDemographicQuery query)
{
using (var cn = new SqlConnection(opts.ConnectionString))
{
await cn.OpenAsync();
var updated = await cn.QueryFirstOrDefaultAsync <AdminDemographicQuery>(
Sql.Update,
new { sql = query.SqlStatement, user = user.UUID },
commandType : CommandType.StoredProcedure,
commandTimeout : opts.DefaultTimeout);
return(updated);
}
}
public async Task <ActionResult <AdminDemographicQuery> > Get()
{
try
{
var query = await manager.GetDemographicQueryAsync();
if (query == null)
{
query = new AdminDemographicQuery();
}
return(Ok(query));
}
catch (Exception ex)
{
log.LogError("Failed to get DemographicsQuery. Error:{Error}", ex.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
public async Task <ActionResult <AdminDemographicQuery> > Update([FromBody] AdminDemographicQuery model)
{
try
{
var updated = await manager.UpdateDemographicQueryAsync(model);
return(Ok(updated));
}
catch (ArgumentException ae)
{
log.LogError("Invalid update DemographicsQuery 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 DemographicsQuery. Model:{@Model} Error:{Error}", model, ex.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
