/// <summary>
/// Inserts a record into the TournamentFee table.
/// </summary>
/// <param name=""></param>
public static IdType Insert(TournamentFeeData data, SqlTransaction transaction)
{
// Create and execute the command
SqlCommand cmd = GetSqlCommand(CONNECTION_STRING_KEY, "spTournamentFee_Insert", CommandType.StoredProcedure, COMMAND_TIMEOUT, transaction);
SqlParameter rv = cmd.Parameters.Add("RETURN_VALUE", SqlDbType.Int);
rv.Direction = ParameterDirection.ReturnValue;
//Create the parameters and append them to the command object
cmd.Parameters.Add(new SqlParameter("@TournamentId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "TournamentId", DataRowVersion.Proposed, data.TournamentId.DBValue));
cmd.Parameters.Add(new SqlParameter("@Key", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Key", DataRowVersion.Proposed, data.Key.DBValue));
cmd.Parameters.Add(new SqlParameter("@Fee", SqlDbType.Money, 0, ParameterDirection.Input, false, 0, 0, "Fee", DataRowVersion.Proposed, data.Fee.DBValue));
// Execute the query
cmd.ExecuteNonQuery();
// do not close the connection if it is part of a transaction
if (transaction == null)
{
cmd.Connection.Close();
}
// Set the output paramter value(s)
return(new IdType((Int32)(cmd.Parameters["RETURN_VALUE"].Value)));
}
/// <summary>
/// Finds a TournamentFee entity using it's primary key.
/// </summary>
/// <param name="TournamentFeeId">A key field.</param>
/// <returns>A TournamentFeeData object.</returns>
/// <exception cref="Spring2.Core.DAO.FinderException">Thrown when no entity exists witht he specified primary key..</exception>
public static TournamentFeeData Load(IdType tournamentFeeId)
{
WhereClause w = new WhereClause();
w.And("TournamentFeeId", tournamentFeeId.DBValue);
SqlDataReader dataReader = GetListReader(CONNECTION_STRING_KEY, VIEW, w, null);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for TournamentFee.");
}
TournamentFeeData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
/// <summary>
/// Updates a record in the TournamentFee table.
/// </summary>
/// <param name=""></param>
public static void Update(TournamentFeeData data, SqlTransaction transaction)
{
// Create and execute the command
SqlCommand cmd = GetSqlCommand(CONNECTION_STRING_KEY, "spTournamentFee_Update", CommandType.StoredProcedure, COMMAND_TIMEOUT, transaction);
//Create the parameters and append them to the command object
cmd.Parameters.Add(new SqlParameter("@TournamentFeeId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "TournamentFeeId", DataRowVersion.Proposed, data.TournamentFeeId.DBValue));
cmd.Parameters.Add(new SqlParameter("@TournamentId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "TournamentId", DataRowVersion.Proposed, data.TournamentId.DBValue));
cmd.Parameters.Add(new SqlParameter("@Key", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Key", DataRowVersion.Proposed, data.Key.DBValue));
cmd.Parameters.Add(new SqlParameter("@Fee", SqlDbType.Money, 0, ParameterDirection.Input, false, 0, 0, "Fee", DataRowVersion.Proposed, data.Fee.DBValue));
// Execute the query
cmd.ExecuteNonQuery();
// do not close the connection if it is part of a transaction
if (transaction == null)
{
cmd.Connection.Close();
}
}
/// <summary>
/// Builds a data object from the current row in a data reader..
/// </summary>
/// <param name="dataReader">Container for database row.</param>
/// <returns>Data object built from current row.</returns>
private static TournamentFeeData GetDataObjectFromReader(SqlDataReader dataReader)
{
TournamentFeeData data = new TournamentFeeData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("TournamentFeeId")))
{
data.TournamentFeeId = IdType.UNSET;
}
else
{
data.TournamentFeeId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("TournamentFeeId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("TournamentId")))
{
data.TournamentId = IdType.UNSET;
}
else
{
data.TournamentId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("TournamentId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Key")))
{
data.Key = StringType.UNSET;
}
else
{
data.Key = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Key")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Fee")))
{
data.Fee = CurrencyType.UNSET;
}
else
{
data.Fee = new CurrencyType(dataReader.GetDecimal(dataReader.GetOrdinal("Fee")));
}
return(data);
}
/// <summary>
/// Updates a record in the TournamentFee table.
/// </summary>
/// <param name=""></param>
public static void Update(TournamentFeeData data)
{
Update(data, null);
}
/// <summary>
/// Inserts a record into the TournamentFee table.
/// </summary>
/// <param name=""></param>
public static IdType Insert(TournamentFeeData data)
{
return(Insert(data, null));
}
