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