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)));
}
public TemplateCollection GetTemplates(TemplateSearchParameters searchParameters = null)
{
return(TemplateCollection.CreateFromDataObjectCollection(DataAccess.TemplateRepository.GetTemplates(searchParameters ?? new TemplateSearchParameters())));
}
