public IList <Framework.DataServices.Model.EntityBaseData> InsertApostasAuto(BolaoNet.Model.Boloes.Bolao bolao, string userName, BolaoNet.Model.Boloes.JogoUsuario.TypeAposta typeAposta, BolaoNet.Model.Boloes.JogoUsuario.TypeAutomatico typeAutomatico, DateTime dataInicial, DateTime dataFinal, int rodada, bool random, int time1, int time2, int randomInicial, int randomFinal, string nomeTime)
{
int errorNumber = 0;
string errorDescription = null;
IList <Framework.DataServices.Model.EntityBaseData> list = _daoBase.InsertApostasAuto(
_currentLogin, bolao, userName, typeAposta, typeAutomatico,
dataInicial, dataFinal, rodada, random, time1, time2, randomInicial, randomFinal, nomeTime,
out errorNumber, out errorDescription);
if (errorNumber != 0 || !string.IsNullOrEmpty(errorDescription))
{
return(null);
}
return(list);
}
public IList <Framework.DataServices.Model.EntityBaseData> InsertApostasAuto(string currentUser, BolaoNet.Model.Boloes.Bolao bolao, string userName, BolaoNet.Model.Boloes.JogoUsuario.TypeAposta typeAposta, BolaoNet.Model.Boloes.JogoUsuario.TypeAutomatico typeAutomatico, DateTime dataInicial, DateTime dataFinal, int rodada, bool random, int time1, int time2, int randomInicial, int randomFinal, string nomeTime, out int errorNumber, out string errorDescription)
{
DataTable table = base.ExecuteFill(CommandType.StoredProcedure, "sp_JogosUsuarios_ApostasAutomatica", true, currentUser,
base.Parameters.Create("@UserName", DbType.String, userName),
base.Parameters.Create("@NomeBolao", DbType.String, bolao.Nome),
base.Parameters.Create("@TipoAutomatico", DbType.Int32, (int)typeAutomatico),
base.Parameters.Create("@TipoAposta", DbType.Int32, (int)typeAposta),
base.Parameters.Create("@Rodada", DbType.Int32, rodada),
base.Parameters.Create("@DataInicial", DbType.DateTime, dataInicial),
base.Parameters.Create("@DataFinal", DbType.DateTime, dataFinal),
base.Parameters.Create("@NomeTime", DbType.String, nomeTime),
base.Parameters.Create("@GolsTime1", DbType.Int32, time1),
base.Parameters.Create("@GolsTime2", DbType.Int32, time2),
base.Parameters.Create("@RandomInicial", DbType.Int32, randomInicial),
base.Parameters.Create("@RandomFinal", DbType.Int32, randomFinal),
base.Parameters.Create("@Randomizado", DbType.Boolean, random),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
IList <Framework.DataServices.Model.EntityBaseData> list = ConvertToList(table);
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(list);
}
public long SelectCountByPeriodo(BolaoNet.Model.Boloes.Bolao bolao, string userName, int rodada, DateTime dataInicial, DateTime dataFinal, BolaoNet.Model.Boloes.JogoUsuario.TypeAposta typeAposta, BolaoNet.Model.Boloes.JogoUsuario.TypeAutomatico typeAutomatico, string condition)
{
int errorNumber = 0;
string errorDescription = null;
long result = _daoBase.LoadCount(
_currentLogin, rodada, bolao, dataInicial, dataFinal, userName, condition, typeAposta, typeAutomatico, out errorNumber, out errorDescription);
if (errorNumber != 0 || !string.IsNullOrEmpty(errorDescription))
{
return(-1);
}
return(result);
}
public long LoadCount(string currentUser, int rodada, BolaoNet.Model.Boloes.Bolao bolao, DateTime dataInicial, DateTime dataFinal, string userName, string condition, BolaoNet.Model.Boloes.JogoUsuario.TypeAposta typeAposta, BolaoNet.Model.Boloes.JogoUsuario.TypeAutomatico typeAutomatico, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
base.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Jogos_Count_By_Period", true, currentUser,
base.Parameters.Create("@UserName", DbType.String, userName),
base.Parameters.Create("@NomeBolao", DbType.String, bolao.Nome),
base.Parameters.Create("@TypeAposta", DbType.Int16, (int)typeAposta),
base.Parameters.Create("@TypeAutomatico", DbType.Int16, (int)typeAutomatico),
base.Parameters.Create("@DataInicial", DbType.DateTime, dataInicial),
base.Parameters.Create("@DataFinal", DbType.DateTime, dataFinal),
base.Parameters.Create("@Rodada", DbType.Int16, (int)rodada),
base.Parameters.Create("@Condition", DbType.String, condition),
base.Parameters.Create("@TotalRows", DbType.Int64, ParameterDirection.Output, null),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
return(Convert.ToInt64(base.ExecutionStatus.Command.Parameters["@TotalRows"].Value));
}
