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; } }