public IEnumerable <Category> QueryCategories(TextContent content)
{
List <Category> list = new List <Category>();
SqlConnection connection;
using (var dataReader = SQLServerHelper.ExecuteReader(content.GetRepository(),
dbCommands.QueryCategories(content), out connection))
{
try
{
while (dataReader.Read())
{
Category category = new Category()
{
CategoryFolder = dataReader.GetString(dataReader.GetOrdinal("CategoryFolder")),
CategoryUUID = dataReader.GetString(dataReader.GetOrdinal("CategoryUUID")),
ContentUUID = dataReader.GetString(dataReader.GetOrdinal("UUID")),
};
list.Add(category);
}
}
finally
{
dataReader.Close();
connection.Close();
}
}
return(list);
}
public IEnumerable <Category> ExportCategoryData(Repository repository)
{
string sql = string.Format("SELECT UUID,CategoryFolder,CategoryUUID FROM [{0}] ", repository.GetCategoryTableName());
List <Category> list = new List <Category>();
SqlConnection connection;
using (var reader = SQLServerHelper.ExecuteReader(repository, new SqlCommand()
{
CommandText = sql
}, out connection))
{
try
{
while (reader.Read())
{
Category category = new Category();
category.ContentUUID = reader.GetString(0);
category.CategoryFolder = reader.GetString(1);
category.CategoryUUID = reader.GetString(2);
list.Add(category);
}
}
finally
{
reader.Close();
connection.Close();
}
}
return(list);
}
public IEnumerable <IDictionary <string, object> > ExecuteQuery(Repository repository, string queryText, System.Data.CommandType commandType = System.Data.CommandType.Text, params KeyValuePair <string, object>[] parameters)
{
var command = new System.Data.SqlClient.SqlCommand(queryText);
if (parameters != null && parameters.Length > 0)
{
command.Parameters.AddRange(parameters.Select(it => new SqlParameter()
{
ParameterName = it.Key, Value = it.Value
}).ToArray());
}
command.CommandType = commandType;
List <IDictionary <string, object> > list = new List <IDictionary <string, object> >();
SqlConnection connection;
using (var dataReader = SQLServerHelper.ExecuteReader(repository, command, out connection))
{
try
{
while (dataReader.Read())
{
TextContent content = new TextContent();
dataReader.ToContent(content);
list.Add(content);
}
}
finally
{
dataReader.Close();
connection.Close();
}
}
return(list);
}
public IEnumerable <IDictionary <string, object> > ExportSchemaData(Schema schema)
{
string sql = string.Format("SELECT * FROM [{0}] ", schema.GetTableName());
List <IDictionary <string, object> > list = new List <IDictionary <string, object> >();
SqlConnection connection;
using (var reader = SQLServerHelper.ExecuteReader(schema.Repository, new SqlCommand()
{
CommandText = sql
}, out connection))
{
try
{
while (reader.Read())
{
list.Add(reader.ToContent <TextContent>(new TextContent()));
}
}
finally
{
reader.Close();
connection.Close();
}
}
return(list);
}
