Esempio n. 1
0
        async Task <AdminDatasetQuery> UpdateDynamicDatasetQueryAsync(AdminDatasetQuery query)
        {
            using (var cn = new SqlConnection(opts.ConnectionString))
            {
                await cn.OpenAsync();

                var grid = await cn.QueryMultipleAsync(
                    Sql.UpdateDynamic,
                    new
                {
                    id           = query.Id,
                    name         = query.Name,
                    catid        = query.CategoryId,
                    desc         = query.Description,
                    sql          = query.SqlStatement,
                    isEnc        = query.IsEncounterBased,
                    schema       = DynamicDatasetSchemaFieldSerde.Serialize(query.Schema),
                    sqlDate      = query.SqlFieldDate,
                    sqlValString = query.SqlFieldValueString,
                    sqlValNum    = query.SqlFieldValueNumeric,
                    tags         = DatasetQueryTagTable.From(query.Tags),
                    constraints  = ResourceConstraintTable.From(query),
                    user         = user.UUID
                },
                    commandType : CommandType.StoredProcedure,
                    commandTimeout : opts.DefaultTimeout);

                var updated = DbReader.Read(grid);
                return(updated);
            }
        }
Esempio n. 2
0
        async Task <AdminDatasetQuery> UpdateShapedDatasetQueryAsync(AdminDatasetQuery query)
        {
            using (var cn = new SqlConnection(opts.ConnectionString))
            {
                await cn.OpenAsync();

                var grid = await cn.QueryMultipleAsync(
                    Sql.Update,
                    new
                {
                    id          = query.Id,
                    uid         = query.UniversalId?.ToString(),
                    shape       = query.Shape,
                    name        = query.Name,
                    catid       = query.CategoryId,
                    desc        = query.Description,
                    sql         = query.SqlStatement,
                    tags        = DatasetQueryTagTable.From(query.Tags),
                    constraints = ResourceConstraintTable.From(query),
                    user        = user.UUID
                },
                    commandType : CommandType.StoredProcedure,
                    commandTimeout : opts.DefaultTimeout);

                var updated = DbReader.Read(grid);
                return(updated);
            }
        }
Esempio n. 3
0
 public static AdminDatasetQueryDTO AdminDatasetQueryDTO(this AdminDatasetQuery q)
 {
     if (q == null)
     {
         return(null);
     }
     return(new AdminDatasetQueryDTO
     {
         Id = q.Id,
         UniversalId = q.UniversalId?.ToString(),
         Shape = q.Shape,
         Name = q.Name,
         CategoryId = q.CategoryId,
         Description = q.Description,
         SqlStatement = q.SqlStatement,
         IsEncounterBased = q.IsEncounterBased,
         SqlFieldDate = q.SqlFieldDate,
         SqlFieldValueString = q.SqlFieldValueString,
         SqlFieldValueNumeric = q.SqlFieldValueNumeric,
         Schema = q.Schema,
         Created = q.Created,
         CreatedBy = q.CreatedBy,
         Updated = q.Updated,
         UpdatedBy = q.UpdatedBy,
         Tags = q.Tags,
         Constraints = q.Constraints
     });
 }
Esempio n. 4
0
 public async Task <AdminDatasetQuery> UpdateDatasetQueryAsync(AdminDatasetQuery query)
 {
     if (query.Shape == Shape.Dynamic)
     {
         return(await UpdateDynamicDatasetQueryAsync(query));
     }
     return(await UpdateShapedDatasetQueryAsync(query));
 }
Esempio n. 5
0
 public static AdminDatasetQueryDTO AdminDatasetQueryDTO(this AdminDatasetQuery q)
 {
     if (q == null)
     {
         return(null);
     }
     return(new AdminDatasetQueryDTO
     {
         Id = q.Id,
         UniversalId = q.UniversalId?.ToString(),
         Shape = q.Shape,
         Name = q.Name,
         CategoryId = q.CategoryId,
         Description = q.Description,
         SqlStatement = q.SqlStatement,
         Created = q.Created,
         CreatedBy = q.CreatedBy,
         Updated = q.Updated,
         UpdatedBy = q.UpdatedBy,
         Tags = q.Tags,
         Constraints = q.Constraints
     });
 }