public static IEnumerable <Pool> GetPools(PoolStatus statusId) { using (var conn = new SqlConnection(connString)) { conn.Open(); var cmd = new SqlCommand("GetPools", conn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@PoolStatusId", (int)statusId); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { yield return(new Pool { PoolId = reader.GetInt32(reader.GetOrdinal("PoolId")), PoolName = reader.GetString(reader.GetOrdinal("PoolName")) }); } } // end innner using } // end outer using }
public static IEnumerable <Pool> GetLotteryPools(PoolStatus status) { using (var conn = new SqlConnection(connString)) { conn.Open(); var cmd = new SqlCommand("GetLotteryPools", conn) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@PoolStatusId", (int)status); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { yield return(new Pool { PoolId = reader.GetInt32(reader.GetOrdinal("PoolId")), PoolName = reader.GetString(reader.GetOrdinal("PoolName")), TicketType = reader.GetString(reader.GetOrdinal("TicketTypeName")), DrawDate = reader.GetDateTime(reader.GetOrdinal("DrawDate")), Jackpot = reader.GetDecimal(reader.GetOrdinal("Jackpot")), WinningNumbers = reader.GetString(reader.GetOrdinal("WinningNumbers")), UpdatedBy = reader.GetString(reader.GetOrdinal("UpdatedBy")), DisplayUpdateTime = reader.GetString(reader.GetOrdinal("UpdateTime")), PoolStatus = status }); } } // end innner using } // end outer using }
/// <summary> /// Создает новую запись /// </summary> /// <param name="poolId">Идентификатор пула</param> /// <param name="poolName">Имя пула</param> /// <param name="threadsCount">Количество потоков</param> /// <param name="inProcessCount">Количество объектов в обработке</param> /// <param name="inQueueCount">Количество объектов в очереди на обработку</param> /// <param name="status">Текущий статус пула</param> public StatRecord(string poolName, int threadsCount, int inProcessCount, int inQueueCount, PoolStatus status) { source = new SourceInfo(poolName); timestamp = DateTime.Now; ThreadsCount = threadsCount; InProcessCount = inProcessCount; InQueueCount = inQueueCount; Status = status; ProcessedCount = 0; ErrorsCount = 0; ProcessTime = 0; ForeignTime = 0; PickedCount = 0; PickErrors = 0; EnqueuedCount = 0; PickTime = 0; PicksCount = 0; }
private ConnectionPoolStatus(PoolStatus code) { _code = code; }
public static void NotifyPoolStatus(this IMessageBus messageBus, IMiningPool pool, PoolStatus status) { messageBus.SendMessage(new PoolStatusNotification { Pool = pool, Status = status }); }
public IEnumerable <Pool> GetLotteryPools(PoolStatus status) => DataAccess.GetLotteryPools(status);