public override RunningTaskCollection GetRunningTasks(int userID)
{
RunningTaskCollection tasks;
using (SqlQuery query = new SqlQuery())
{
query.CommandType = CommandType.StoredProcedure;
query.CommandText = "bx_GetRunningStepByStepTasks";
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
using (XSqlDataReader reader = query.ExecuteReader())
{
tasks = new RunningTaskCollection(reader);
}
return(tasks);
}
}
public override RunningTaskCollection GetRunningTasks(int userID)
{
RunningTaskCollection tasks;
using (SqlQuery query = new SqlQuery())
{
query.CommandType = CommandType.StoredProcedure;
query.CommandText = "bx_GetRunningStepByStepTasks";
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
using (XSqlDataReader reader = query.ExecuteReader())
{
tasks = new RunningTaskCollection(reader);
}
return tasks;
}
}
public override RunningTaskCollection GetRunningTasks(int userID, Type taskType, string param)
{
RunningTaskCollection tasks;
using (SqlQuery query = new SqlQuery())
{
query.CommandType = CommandType.StoredProcedure;
query.CommandText = "bx_GetRunningStepByStepTasksByType";
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter <string>("@TaskType", taskType.FullName, SqlDbType.VarChar, 200);
query.CreateParameter <string>("@Param", param, SqlDbType.NVarChar, 3500);
using (XSqlDataReader reader = query.ExecuteReader())
{
tasks = new RunningTaskCollection(reader);
}
return(tasks);
}
}
public override RunningTaskCollection GetRunningTasks(int userID, Type taskType, string param)
{
RunningTaskCollection tasks;
using (SqlQuery query = new SqlQuery())
{
query.CommandType = CommandType.StoredProcedure;
query.CommandText = "bx_GetRunningStepByStepTasksByType";
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
query.CreateParameter<string>("@TaskType", taskType.FullName, SqlDbType.VarChar, 200);
query.CreateParameter<string>("@Param", param, SqlDbType.NVarChar, 3500);
using (XSqlDataReader reader = query.ExecuteReader())
{
tasks = new RunningTaskCollection(reader);
}
return tasks;
}
}
