public Boolean DeleteDetailTeam(String TeamId, String TounId)
{
DetailTeamBE objDetailTeamBE = new DetailTeamBE();
connection.ConnectionString = MiConexion.GetCnx();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "EliminarDetalle_Equipo";
command.Parameters.AddWithValue("@IdEquipo", TeamId);
command.Parameters.AddWithValue("@IdTorneo", TounId);
try
{
connection.Open();
command.ExecuteNonQuery();
return(true);
}
catch (SqlException x)
{
throw new Exception(x.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
command.Parameters.Clear();
}
}
public Boolean UpdateDetailTeam(DetailTeamBE objDetailTeamBE)
{
connection.ConnectionString = MiConexion.GetCnx();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "ActualizarDetalle_Equipo";
command.Parameters.AddWithValue("@IdEquipo", objDetailTeamBE.IdEquipo);
command.Parameters.AddWithValue("@IdTorneo", objDetailTeamBE.IdTorneo);
command.Parameters.AddWithValue("@Victorias", objDetailTeamBE.Victorias);
command.Parameters.AddWithValue("@Derrotas", objDetailTeamBE.Derrotas);
command.Parameters.AddWithValue("@Puesto", objDetailTeamBE.Puesto);
try
{
connection.Open();
command.ExecuteNonQuery();
return(true);
}
catch (SqlException x)
{
throw new Exception(x.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
command.Parameters.Clear();
}
}
private void DetailTournament03_Load(object sender, EventArgs e)
{
try
{
cboTeam.DataSource = objTeamBL.ListTeams();
cboTeam.ValueMember = "IdNombre";
cboTeam.DisplayMember = "NomEquipo";
cboTournament.DataSource = objTournamentBL.ListTournaments();
cboTournament.ValueMember = "IdTorneo";
cboTournament.DisplayMember = "NomTorneo";
objDetailTeamBE = objDetailTeamBL.ConsultDetailTeam(Codigo1, Codigo2);
txtVictories.Text = objDetailTeamBE.Victorias.ToString();
txtDefeats.Text = objDetailTeamBE.Derrotas.ToString();
txtPlacement.Text = objDetailTeamBE.Puesto.ToString();
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex.Message);
}
}
public DetailTeamBE ConsultDetailTeam(String TeamId, String TounId)
{
DetailTeamBE objDetailTeamBE = new DetailTeamBE();
try
{
connection.ConnectionString = MiConexion.GetCnx();
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "ConsultarDetalle_Equipo";
command.Parameters.AddWithValue("@IdEquipo", TeamId);
command.Parameters.AddWithValue("@IdTorneo", TounId);
connection.Open();
dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
dataReader.Read();
objDetailTeamBE.IdEquipo = Convert.ToInt32(dataReader["IdEquipo"]);
objDetailTeamBE.IdTorneo = Convert.ToInt32(dataReader["IdTorneo"]);
objDetailTeamBE.Victorias = Convert.ToInt32(dataReader["Victorias"]);
objDetailTeamBE.Derrotas = Convert.ToInt32(dataReader["Derrotas"]);
objDetailTeamBE.Puesto = Convert.ToInt32(dataReader["Puesto"]);
}
dataReader.Close();
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
command.Parameters.Clear();
}
return(objDetailTeamBE);
}
public Boolean UpdateDetailTeam(DetailTeamBE objDetailBE)
{
return(objDetailADO.UpdateDetailTeam(objDetailBE));
}
public Boolean InsertDetailTeam(DetailTeamBE objDetailBE)
{
return(objDetailADO.InsertDetailTeam(objDetailBE));
}
