Пример #1
0
        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);
        }
Пример #2
0
        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);
        }
Пример #3
0
        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();
            }
        }
Пример #4
0
        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();
            }
        }