public List <Creation> GetCreations(CurrentCreationsRequest request)
{
var conn = GetConnection(ConnectionNames.CSPSqlDatabase);
var commandWrapper = GetStoredProcCommand("dbo.Get_Creations", conn);
AddInParameter(commandWrapper, "@TeamId", DbType.Int16, request.TeamId);
AddInParameter(commandWrapper, "@Role", DbType.Int16, request.Role);
IDataReader reader = null;
List <Creation> tmp = new List <Creation>();
try
{
conn.Open();
reader = commandWrapper.ExecuteReader();
FillCreations(reader, tmp, 0, int.MaxValue);
MakeDboLog(request.ToString(), reader.ToString(), "dbo.Get_Creations");
return(tmp);
}
finally
{
if (reader != null)
{
reader.Close();
}
commandWrapper.Dispose();
conn.Close();
}
}
