public GlobalPanelFilterDTO(AdminGlobalPanelFilter filter)
{
Id = filter.Id;
SessionType = filter.SessionType;
IsInclusion = filter.IsInclusion;
SqlSetId = filter.SqlSetId;
SqlSetWhere = filter.SqlSetWhere;
}
public async Task <AdminGlobalPanelFilter> CreateAsync(AdminGlobalPanelFilter pf)
{
using (var cn = new SqlConnection(opts.ConnectionString))
{
await cn.OpenAsync();
var created = await cn.QueryFirstOrDefaultAsync <AdminGlobalPanelFilter>(
Sql.Create,
new
{
sqlSetId = pf.SqlSetId,
sqlSetWhere = pf.SqlSetWhere,
sessionType = pf.SessionType,
isInclusion = pf.IsInclusion,
user = user.UUID
},
commandType : CommandType.StoredProcedure,
commandTimeout : opts.DefaultTimeout);
return(created);
}
}
public async Task <ActionResult <AdminGlobalPanelFilter> > CreateAsync([FromBody] AdminGlobalPanelFilter pf)
{
try
{
var created = await manager.CreateAsync(pf);
return(created);
}
catch (ArgumentException ae)
{
log.LogError("Invalid create GlobalPanelFilter model. Model:{@Model} Error:{Error}", pf, ae.Message);
return(BadRequest());
}
catch (LeafRPCException le)
{
return(StatusCode(le.StatusCode));
}
catch (Exception ex)
{
log.LogError("Failed to create GlobalPanelFilter. Model:{@Model} Error:{Error}", pf, ex.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError));
}
}
