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