public static IProbabilidadeMaoInicial GetItem(IMaoBasica mao, int qtdJogosSimulacao = 500000)
{
IProbabilidadeMaoInicial probMaoInicial = null;
StringBuilder strSelect = ProbabilidadeMaoInicialContext.GetSelectQuery();
strSelect.AppendFormat(" WHERE " + Environment.NewLine +
"(" + Environment.NewLine +
" (m.numero_carta_1 = {0} AND m.numero_carta_2 = {1}) OR" + Environment.NewLine +
" (m.numero_carta_2 = {2} AND m.numero_carta_1 = {3})" + Environment.NewLine +
") AND " + Environment.NewLine +
"m.offorsuited like \'{4}\' " + Environment.NewLine,
mao.NumCarta1,
mao.NumCarta2,
mao.NumCarta1,
mao.NumCarta2,
mao.OffOrSuited
);
DBConnect.AbreConexaoSeNaoEstiverAberta();
IDbCommand command = DBConnect.Connection.CreateCommand();
command.CommandText = strSelect.ToString();
using (IDataReader dataReader = command.ExecuteReader())
{
if (dataReader.Read())
{
probMaoInicial = ProbabilidadeMaoInicialContext.GetItem(dataReader);
}
}
return(probMaoInicial);
}
public static IList <IProbabilidadeMaoInicial> GetMaosProbabilidadesIniciais(int qtd_jogos_simulados = 500000)
{
DBConnect.AbreConexaoSeNaoEstiverAberta();
StringBuilder strBuilder
= ProbabilidadeMaoInicialContext.GetSelectQuery()
.AppendFormat(" WHERE m.qtd_jogos_simulados = {0}",
qtd_jogos_simulados
);
IDbCommand command = DBConnect.Connection.CreateCommand();
command.CommandText = strBuilder.ToString();
IList <IProbabilidadeMaoInicial> probabilidadeMaoIniciais = new List <IProbabilidadeMaoInicial>();
using (IDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
probabilidadeMaoIniciais.Add(ProbabilidadeMaoInicialContext.GetItem(dataReader));
}
}
return(probabilidadeMaoIniciais);
}
public static void Persiste(IProbabilidadeMaoInicial MaosParaPersistir)
{
DBConnect.AbreConexaoSeNaoEstiverAberta();
try
{
IDbCommand command = DBConnect.Connection.CreateCommand();
command.CommandText = ProbabilidadeMaoInicialContext.ToInsertQuery(MaosParaPersistir);
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw;
}
finally
{
DBConnect.FecharConexao();
}
}
public static void AtualizaPorNumerosOffOuSuitedQtdJogosSimulados(IList <IProbabilidadeMaoInicial> MaosParaPersistir)
{
DBConnect.AbreConexaoSeNaoEstiverAberta();
try
{
foreach (IProbabilidadeMaoInicial p in MaosParaPersistir)
{
IDbCommand command = DBConnect.Connection.CreateCommand();
command.CommandText = ProbabilidadeMaoInicialContext.ToUpdateProbabilidadeSairQuery(p);
command.ExecuteNonQuery();
}
}
catch (Exception e)
{
throw;
}
finally
{
DBConnect.FecharConexao();
}
}