public bool Load()
{
int errorNumber = 0;
string errorDescription = null;
Framework.DataServices.Model.EntityBaseData result = _daoBase.Load(
_currentLogin, this, out errorNumber, out errorDescription);
if (errorNumber != 0 || !string.IsNullOrEmpty(errorDescription))
{
return(false);
}
Model.DadosBasicos.Time model = (Model.DadosBasicos.Time)result;
this.Nome = model.Nome;
this.ActiveFlag = model.ActiveFlag;
this.Cidade = model.Cidade;
this.CreatedBy = model.CreatedBy;
this.CreatedDate = model.CreatedDate;
this.Descricao = model.Descricao;
this.Escudo = model.Escudo;
this.Estado = model.Estado;
this.Fundacao = model.Fundacao;
this.IsClube = model.IsClube;
this.Mascote = model.Mascote;
this.ModifiedBy = model.ModifiedBy;
this.ModifiedDate = model.ModifiedDate;
this.NomeMascote = model.NomeMascote;
this.Pais = model.Pais;
this.Site = model.Site;
return(errorNumber == 0 ? true : false);
}
public Framework.DataServices.Model.EntityBaseData Load(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.ApostaExtraUsuario entryData = (Model.Boloes.ApostaExtraUsuario)entry;
DataTable table = base.ExecuteFill(CommandType.StoredProcedure, base._commandSelect, true, currentUser,
base.Parameters.Create("@Posicao", DbType.Int32, entryData.Posicao),
base.Parameters.Create("@UserName", DbType.Int32, entryData.UserName),
base.Parameters.Create("@NomeBolao", DbType.Int32, entryData.Bolao.Nome),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
int rowsFound = Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value);
if (rowsFound == 0)
{
return(null);
}
//throw new Exception("There is no item found in database with this ID.");
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(Util.ApostaExtraUsuario.ConvertToObject(table.Rows[0]));
}
public bool AddMessage(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.Mensagem entryData = (Model.Boloes.Mensagem)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Mensagens_AddMessage", true, currentUser,
base.Parameters.Create("@NomeBolao", DbType.String, entryData.Bolao.Nome),
base.Parameters.Create("@FromUser", DbType.String, entryData.FromUser),
base.Parameters.Create("@Private", DbType.Boolean, entryData.Private),
base.Parameters.Create("@ToUser", DbType.String, entryData.ToUser),
base.Parameters.Create("@Title", DbType.String, entryData.Title),
base.Parameters.Create("@Message", DbType.String, entryData.Message),
base.Parameters.Create("@AnsweredMessageID", DbType.Int64, entryData.AnsweredMessageID),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) >= 1 ? true : false);
}
public bool Update(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Campeonatos.Jogo entryData = (Model.Campeonatos.Jogo)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, base._commandUpdate, true, currentUser,
base.Parameters.Create("IdJogo", DbType.Int64, entryData.IDJogo),
base.Parameters.Create("Titulo", DbType.String, entryData.Titulo),
base.Parameters.Create("NomeFase", DbType.String, entryData.Fase == null ? null : entryData.Fase.Nome),
base.Parameters.Create("NomeCampeonato", DbType.String, entryData.Campeonato.Nome),
base.Parameters.Create("NomeTime1", DbType.String, entryData.Time1 == null ? null : entryData.Time1.Nome),
base.Parameters.Create("NomeTime2", DbType.String, entryData.Time2 == null ? null : entryData.Time2.Nome),
base.Parameters.Create("Gols1", DbType.Int16, entryData.GolsTime1),
base.Parameters.Create("Gols2", DbType.Int16, entryData.GolsTime2),
base.Parameters.Create("Penaltis1", DbType.Int16, entryData.PenaltisTime1),
base.Parameters.Create("Penaltis2", DbType.Int16, entryData.PenaltisTime2),
base.Parameters.Create("DataJogo", DbType.DateTime, entryData.DataJogo),
base.Parameters.Create("Rodada", DbType.String, entryData.GolsTime1),
base.Parameters.Create("IsValido", DbType.Boolean, entryData.PartidaValida),
base.Parameters.Create("DataValidacao", DbType.DateTime, entryData.DataValidacao),
base.Parameters.Create("NomeGrupo", DbType.String, entryData.Grupo == null ? null : entryData.Grupo.Nome),
base.Parameters.Create("ValidadoBy", DbType.String, entryData.ValidadoBy),
base.Parameters.Create("NomeEstadio", DbType.String, entryData.Estadio == null ? null : entryData.Estadio.Nome),
base.Parameters.Create("DescricaoTime1", DbType.String, entryData.DescricaoTime1),
base.Parameters.Create("DescricaoTime2", DbType.String, entryData.DescricaoTime2),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) >= 1 ? true : false);
}
public bool Update(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.JogoUsuario entryData = (Model.Boloes.JogoUsuario)entry;
return(Insert(currentUser, entryData, out errorNumber, out errorDescription));
}
public bool Delete(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Campeonatos.Campeonato entryData = (Model.Campeonatos.Campeonato)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, base._commandDelete, true, currentUser,
base.Parameters.Create("@Nome", DbType.String, entryData.Nome),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) >= 1 ? true : false);
}
public bool InsertWithAllData(bool isClube, Framework.DataServices.Model.EntityBaseData entry)
{
int errorNumber = 0;
string errorDescription = null;
Model.Campeonatos.Jogo jogo = (Model.Campeonatos.Jogo)entry;
bool result = _daoBase.InsertWithAllData(_currentLogin, isClube, entry, out errorNumber, out errorDescription);
if (errorNumber > 0 || !string.IsNullOrEmpty(errorDescription))
{
return(false);
}
return(result);
}
public bool RemoveResult(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Campeonatos.Jogo entryData = (Model.Campeonatos.Jogo)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Jogos_ResultRemove", true, currentUser,
base.Parameters.Create("@NomeCampeonato", DbType.String, entryData.Campeonato.Nome),
base.Parameters.Create("@IDJogo", DbType.Int64, entryData.IDJogo),
base.Parameters.Create("@ValidoBy", DbType.String, entryData.ValidadoBy),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) == 1 ? true : false);
}
public bool Load()
{
int errorNumber = 0;
string errorDescription = null;
Framework.DataServices.Model.EntityBaseData result = _daoBase.Load(
_currentLogin, this, out errorNumber, out errorDescription);
if (errorNumber != 0 || !string.IsNullOrEmpty(errorDescription))
{
return(false);
}
this.Copy((Model.Boloes.ApostaExtra)result);
return(errorNumber == 0 ? true : false);
}
public bool InsertResult(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.ApostaExtra entryData = (Model.Boloes.ApostaExtra)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, "sp_ApostasExtras_InsertResult", true, currentUser,
base.Parameters.Create("@Posicao", DbType.Int64, entryData.Posicao),
base.Parameters.Create("@NomeBolao", DbType.String, entryData.Bolao.Nome),
base.Parameters.Create("@NomeTime", DbType.String, entryData.NomeTimeValidado),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) >= 1 ? true : false);
}
public void ShowStatus(Framework.DataServices.Model.EntityBaseData entry)
{
this.lblActiveFlag.Text = entry.ActiveFlag.ToString();
if (string.IsNullOrEmpty(entry.CreatedBy))
{
this.lblCreatedBy.Text = "-";
}
else
{
this.lblCreatedBy.Text = entry.CreatedBy;
}
if (entry.CreatedDate == DateTime.MinValue)
{
this.lblCreatedDate.Text = "-";
}
else
{
this.lblCreatedDate.Text = entry.CreatedDate.ToString("dd/MM/yyyy HH:mm:ss");
}
if (string.IsNullOrEmpty(entry.ModifiedBy))
{
this.lblModifiedBy.Text = "-";
}
else
{
this.lblModifiedBy.Text = entry.ModifiedBy;
}
if (entry.ModifiedDate == DateTime.MinValue)
{
this.lblModifiedDate.Text = "-";
}
else
{
this.lblModifiedDate.Text = entry.ModifiedDate.ToString("dd/MM/yyyy HH:mm:ss");
}
}
public bool Update(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.Regra entryData = (Model.Boloes.Regra)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, base._commandInsert, true, currentUser,
base.Parameters.Create("@RegraID", DbType.Int64, entryData.RegraID),
base.Parameters.Create("@NomeBolao", DbType.String, entryData.Bolao.Nome),
base.Parameters.Create("@Description", DbType.String, entryData.Description),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) >= 1 ? true : false);
}
public bool InsertWithAllData(string currentUser, bool isClube, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Campeonatos.Jogo entryData = (Model.Campeonatos.Jogo)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Jogos_InsertAllData", true, currentUser,
base.Parameters.Create("NomeFase", DbType.String, entryData.Fase == null ? null : entryData.Fase.Nome),
base.Parameters.Create("IsClube", DbType.Boolean, isClube),
base.Parameters.Create("Titulo", DbType.String, entryData.Titulo),
base.Parameters.Create("NomeCampeonato", DbType.String, entryData.Campeonato.Nome),
base.Parameters.Create("NomeTime1", DbType.String, entryData.Time1 == null ? null : entryData.Time1.Nome),
base.Parameters.Create("NomeTime2", DbType.String, entryData.Time2 == null ? null : entryData.Time2.Nome),
base.Parameters.Create("Gols1", DbType.Int16, entryData.GolsTime1),
base.Parameters.Create("Gols2", DbType.Int16, entryData.GolsTime2),
base.Parameters.Create("Penaltis1", DbType.Int16, entryData.PenaltisTime1),
base.Parameters.Create("Penaltis2", DbType.Int16, entryData.PenaltisTime2),
base.Parameters.Create("DataJogo", DbType.DateTime, entryData.DataJogo),
base.Parameters.Create("Rodada", DbType.String, entryData.Rodada),
base.Parameters.Create("IsValido", DbType.Boolean, entryData.PartidaValida),
base.Parameters.Create("NomeGrupo", DbType.String, entryData.Grupo == null ? null : entryData.Grupo.Nome),
base.Parameters.Create("NomeEstadio", DbType.String, entryData.Estadio == null ? null : entryData.Estadio.Nome),
base.Parameters.Create("DescricaoTime1", DbType.String, entryData.DescricaoTime1),
base.Parameters.Create("DescricaoTime2", DbType.String, entryData.DescricaoTime2),
base.Parameters.Create("JogoLabel", DbType.String, entryData.JogoLabel),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
((Model.Campeonatos.Jogo)entry).IDJogo = Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value);
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) > 0 ? true : false);
}
public bool Update(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.DadosBasicos.Estadio entryData = (Model.DadosBasicos.Estadio)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, base._commandUpdate, true, currentUser,
base.Parameters.Create("@Nome", DbType.String, entryData.Nome),
base.Parameters.Create("@NomeTime", DbType.String, entryData.Time == null ? null : entryData.Time.Nome),
base.Parameters.Create("@Pais", DbType.String, entryData.Pais),
base.Parameters.Create("@Estado", DbType.String, entryData.Estado),
base.Parameters.Create("@Cidade", DbType.String, entryData.Cidade),
base.Parameters.Create("@Foto", DbType.AnsiString, entryData.Foto),
base.Parameters.Create("@Capacidade", DbType.Int64, entryData.Capacidade),
base.Parameters.Create("@Descricao", DbType.String, entryData.Descricao),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) >= 1 ? true : false);
}
public bool Insert(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.JogoUsuario entryData = (Model.Boloes.JogoUsuario)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, base._commandInsert, true, currentUser,
base.Parameters.Create("@IDJogo", DbType.String, entryData.IDJogo),
base.Parameters.Create("@NomeCampeonato", DbType.String, entryData.Campeonato.Nome),
base.Parameters.Create("@UserName", DbType.String, entryData.UserName),
base.Parameters.Create("@NomeBolao", DbType.String, entryData.Bolao.Nome),
base.Parameters.Create("@Automatico", DbType.Boolean, entryData.Automatico),
base.Parameters.Create("@ApostaTime1", DbType.Int16, entryData.ApostaTime1),
base.Parameters.Create("@ApostaTime2", DbType.Int16, entryData.ApostaTime2),
base.Parameters.Create("@Ganhador", DbType.Int16, entryData.Ganhador),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) == 1 ? true : false);
}
public void Load(Framework.DataServices.Model.EntityBaseData entry)
{
int errorNumber = 0;
string errorDescription = null;
Framework.DataServices.Model.EntityBaseData result = _daoBase.Load(
_currentUser, entry, out errorNumber, out errorDescription);
if (result == null)
{
throw new AssertTestException("There is no result loaded");
}
if (errorNumber != 0)
{
throw new AssertTestException("There is an error number = " + errorNumber);
}
if (!string.IsNullOrEmpty(errorDescription))
{
throw new AssertTestException("There is an error description = " + errorDescription);
}
}
public bool Update(string currentUser, Framework.DataServices.Model.EntityBaseData entry, out int errorNumber, out string errorDescription)
{
errorNumber = 0;
errorDescription = null;
Model.Boloes.Pagamento entryData = (Model.Boloes.Pagamento)entry;
base.ExecuteNonQuery(CommandType.StoredProcedure, base._commandUpdate, true, currentUser,
base.Parameters.Create("@DataPagamento", DbType.DateTime, entryData.DataPagamento),
base.Parameters.Create("@UserName", DbType.String, entryData.UserName),
base.Parameters.Create("@NomeBolao", DbType.String, entryData.Bolao.Nome),
base.Parameters.Create("@TipoPagamento", DbType.Int32, (int)entryData.TipoPagamento),
base.Parameters.Create("@Valor", DbType.Decimal, entryData.Valor),
base.Parameters.Create("@Descricao", DbType.String, entryData.Descricao),
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null)
);
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
return(Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value) == 1 ? true : false);
}
public bool Load()
{
int errorNumber = 0;
string errorDescription = null;
Framework.DataServices.Model.EntityBaseData result = _daoBase.Load(
_currentLogin, this, out errorNumber, out errorDescription);
if (errorNumber != 0 || !string.IsNullOrEmpty(errorDescription))
{
return(false);
}
//Model.Campeonatos.Campeonato model = (Model.Campeonatos.Campeonato)result;
if (result == null)
{
return(false);
}
this.Copy(result);
//Model.DadosBasicos.Time model = (Model.DadosBasicos.Time)result;
//this.Nome = model.Nome;
//this.ActiveFlag = model.ActiveFlag;
//this.ModifiedBy = model.ModifiedBy;
//this.ModifiedDate = model.ModifiedDate;
//this.CreatedBy = model.CreatedBy;
//this.CreatedDate = model.CreatedDate;
//this.Descricao = model.Descricao;
//this.IsClube = model.IsClube;
return(errorNumber == 0 ? true : false);
}
public bool Contains(Framework.DataServices.Model.EntityBaseData value)
{
// If value is not of type Int16, this will return false.
return(List.Contains(value));
}
public void Remove(Framework.DataServices.Model.EntityBaseData value)
{
List.Remove(value);
}
public void Insert(int index, Framework.DataServices.Model.EntityBaseData value)
{
List.Insert(index, value);
}
public int IndexOf(Framework.DataServices.Model.EntityBaseData value)
{
return(List.IndexOf(value));
}
public int Add(Framework.DataServices.Model.EntityBaseData value)
{
return(List.Add(value));
}
