internal static TemplateCollection CreateDataObjectCollection(DataTable data)
{
var result = new TemplateCollection();
foreach (DataRow row in data.Rows)
{
result.Add(Template.CreateFromData(row));
}
return(result);
}
public TemplateCollection GetTemplates(TemplateSearchParameters searchParameters)
{
var command = SqlDbAccess.CreateTextCommand();
var sb = new StringBuilder(@"
SELECT
TemplateId,
Name,
CreatedByUserId,
CreatedDate,
LastModifiedDate,
VisualProperties
FROM
[Cerberus.TemplateEngine.Template] " );
if (searchParameters.CreatedByUserId > 0)
{
sb.AppendLine(" WHERE CreatedByUserId = @CreatedByUserId ");
SqlDbAccess.AddParameter(command, "@CreatedByUserId", SqlDbType.Int, searchParameters.CreatedByUserId);
}
command.CommandText = sb.ToString();
return(TemplateCollection.CreateDataObjectCollection(SqlDbAccess.ExecuteSelect(command)));
}