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)); }