/// <summary>
/// Updates a record in the Golfer table.
/// </summary>
/// <param name=""></param>
public static void Update(GolferData data, SqlTransaction transaction)
{
// Create and execute the command
SqlCommand cmd = GetSqlCommand(CONNECTION_STRING_KEY, "spGolfer_Update", CommandType.StoredProcedure, COMMAND_TIMEOUT, transaction);
//Create the parameters and append them to the command object
cmd.Parameters.Add(new SqlParameter("@GolferId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "GolferId", DataRowVersion.Proposed, data.GolferId.DBValue));
cmd.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "FirstName", DataRowVersion.Proposed, data.FirstName.DBValue));
cmd.Parameters.Add(new SqlParameter("@MiddleInitial", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "MiddleInitial", DataRowVersion.Proposed, data.MiddleInitial.DBValue));
cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "LastName", DataRowVersion.Proposed, data.LastName.DBValue));
cmd.Parameters.Add(new SqlParameter("@Phone", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Phone", DataRowVersion.Proposed, data.Phone.DBValue));
cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Email", DataRowVersion.Proposed, data.Email.DBValue));
cmd.Parameters.Add(new SqlParameter("@Address1", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Address.Address1", DataRowVersion.Proposed, data.Address.Address1.DBValue));
cmd.Parameters.Add(new SqlParameter("@Address2", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Address.Address2", DataRowVersion.Proposed, data.Address.Address2.DBValue));
cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Address.City", DataRowVersion.Proposed, data.Address.City.DBValue));
cmd.Parameters.Add(new SqlParameter("@State", SqlDbType.Char, 2, ParameterDirection.Input, false, 0, 0, "Address.State", DataRowVersion.Proposed, data.Address.State.DBValue));
cmd.Parameters.Add(new SqlParameter("@Country", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Address.Country", DataRowVersion.Proposed, data.Address.Country.DBValue));
cmd.Parameters.Add(new SqlParameter("@PostalCode", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "Address.PostalCode", DataRowVersion.Proposed, data.Address.PostalCode.DBValue));
cmd.Parameters.Add(new SqlParameter("@DateOfBirth", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateOfBirth", DataRowVersion.Proposed, data.DateOfBirth.DBValue));
cmd.Parameters.Add(new SqlParameter("@Handicap", SqlDbType.Decimal, 0, ParameterDirection.Input, false, 3, 1, "Handicap", DataRowVersion.Proposed, data.Handicap.DBValue));
cmd.Parameters.Add(new SqlParameter("@CourseNumber", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "CourseNumber", DataRowVersion.Proposed, data.CourseNumber.DBValue));
cmd.Parameters.Add(new SqlParameter("@PlayerNumber", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "PlayerNumber", DataRowVersion.Proposed, data.PlayerNumber.DBValue));
cmd.Parameters.Add(new SqlParameter("@Gender", SqlDbType.VarChar, 1, ParameterDirection.Input, false, 0, 0, "Gender", DataRowVersion.Proposed, data.Gender.DBValue));
cmd.Parameters.Add(new SqlParameter("@GolferStatus", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "GolferStatus", DataRowVersion.Proposed, data.GolferStatus.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>
/// Inserts a record into the Golfer table.
/// </summary>
/// <param name=""></param>
public static IdType Insert(GolferData data)
{
// Create and execute the command
SqlCommand cmd = GetSqlCommand(CONNECTION_STRING_KEY, "spGolfer_Insert", CommandType.StoredProcedure, COMMAND_TIMEOUT);
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("@FirstName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "FirstName", DataRowVersion.Proposed, data.FirstName.DBValue));
cmd.Parameters.Add(new SqlParameter("@MiddleInitial", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "MiddleInitial", DataRowVersion.Proposed, data.MiddleInitial.DBValue));
cmd.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "LastName", DataRowVersion.Proposed, data.LastName.DBValue));
cmd.Parameters.Add(new SqlParameter("@Phone", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Phone", DataRowVersion.Proposed, data.Phone.DBValue));
cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Email", DataRowVersion.Proposed, data.Email.DBValue));
cmd.Parameters.Add(new SqlParameter("@Address1", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Address.Address1", DataRowVersion.Proposed, data.Address.Address1.DBValue));
cmd.Parameters.Add(new SqlParameter("@Address2", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Address.Address2", DataRowVersion.Proposed, data.Address.Address2.DBValue));
cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Address.City", DataRowVersion.Proposed, data.Address.City.DBValue));
cmd.Parameters.Add(new SqlParameter("@State", SqlDbType.Char, 2, ParameterDirection.Input, false, 0, 0, "Address.State", DataRowVersion.Proposed, data.Address.State.DBValue));
cmd.Parameters.Add(new SqlParameter("@Country", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Address.Country", DataRowVersion.Proposed, data.Address.Country.DBValue));
cmd.Parameters.Add(new SqlParameter("@PostalCode", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "Address.PostalCode", DataRowVersion.Proposed, data.Address.PostalCode.DBValue));
cmd.Parameters.Add(new SqlParameter("@DateOfBirth", SqlDbType.DateTime, 0, ParameterDirection.Input, false, 0, 0, "DateOfBirth", DataRowVersion.Proposed, data.DateOfBirth.DBValue));
cmd.Parameters.Add(new SqlParameter("@Handicap", SqlDbType.Decimal, 0, ParameterDirection.Input, false, 3, 1, "Handicap", DataRowVersion.Proposed, data.Handicap.DBValue));
cmd.Parameters.Add(new SqlParameter("@CourseNumber", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "CourseNumber", DataRowVersion.Proposed, data.CourseNumber.DBValue));
cmd.Parameters.Add(new SqlParameter("@PlayerNumber", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "PlayerNumber", DataRowVersion.Proposed, data.PlayerNumber.DBValue));
cmd.Parameters.Add(new SqlParameter("@Gender", SqlDbType.VarChar, 1, ParameterDirection.Input, false, 0, 0, "Gender", DataRowVersion.Proposed, data.Gender.DBValue));
cmd.Parameters.Add(new SqlParameter("@GolferStatus", SqlDbType.Char, 1, ParameterDirection.Input, false, 0, 0, "GolferStatus", DataRowVersion.Proposed, data.GolferStatus.DBValue));
// Execute the query
cmd.ExecuteNonQuery();
cmd.Connection.Close();
// Set the output paramter value(s)
return(new IdType((Int32)(cmd.Parameters["RETURN_VALUE"].Value)));
}
/// <summary>
/// Finds a Golfer entity using it's primary key.
/// </summary>
/// <param name="GolferId">A key field.</param>
/// <returns>A GolferData object.</returns>
/// <exception cref="Spring2.Core.DAO.FinderException">Thrown when no entity exists witht he specified primary key..</exception>
public static GolferData Load(IdType golferId)
{
WhereClause w = new WhereClause();
w.And("GolferId", golferId.DBValue);
SqlDataReader dataReader = GetListReader(CONNECTION_STRING_KEY, VIEW, w, null);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for Golfer.");
}
GolferData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
/// <summary>
/// Updates a record in the Golfer table.
/// </summary>
/// <param name=""></param>
public static void Update(GolferData data)
{
Update(data, null);
}
/// <summary>
/// Inserts a record into the Golfer table.
/// </summary>
/// <param name=""></param>
public static IdType Insert(GolferData data)
{
return(Insert(data, null));
}
/// <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 GolferData GetDataObjectFromReader(SqlDataReader dataReader)
{
GolferData data = new GolferData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("GolferId")))
{
data.GolferId = IdType.UNSET;
}
else
{
data.GolferId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("GolferId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("FirstName")))
{
data.FirstName = StringType.UNSET;
}
else
{
data.FirstName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("FirstName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("MiddleInitial")))
{
data.MiddleInitial = StringType.UNSET;
}
else
{
data.MiddleInitial = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("MiddleInitial")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("LastName")))
{
data.LastName = StringType.UNSET;
}
else
{
data.LastName = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("LastName")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Phone")))
{
data.Phone = StringType.UNSET;
}
else
{
data.Phone = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Phone")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Email")))
{
data.Email = StringType.UNSET;
}
else
{
data.Email = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Email")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Address1")))
{
data.Address.Address1 = StringType.UNSET;
}
else
{
data.Address.Address1 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Address1")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Address2")))
{
data.Address.Address2 = StringType.UNSET;
}
else
{
data.Address.Address2 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Address2")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("City")))
{
data.Address.City = StringType.UNSET;
}
else
{
data.Address.City = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("City")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("State")))
{
data.Address.State = USStateCodeEnum.UNSET;
}
else
{
data.Address.State = USStateCodeEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("State")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Country")))
{
data.Address.Country = StringType.UNSET;
}
else
{
data.Address.Country = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Country")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PostalCode")))
{
data.Address.PostalCode = StringType.UNSET;
}
else
{
data.Address.PostalCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PostalCode")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("DateOfBirth")))
{
data.DateOfBirth = DateType.UNSET;
}
else
{
data.DateOfBirth = new DateType(dataReader.GetDateTime(dataReader.GetOrdinal("DateOfBirth")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Handicap")))
{
data.Handicap = DecimalType.UNSET;
}
else
{
data.Handicap = new DecimalType(dataReader.GetDecimal(dataReader.GetOrdinal("Handicap")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("CourseNumber")))
{
data.CourseNumber = StringType.UNSET;
}
else
{
data.CourseNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("CourseNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PlayerNumber")))
{
data.PlayerNumber = StringType.UNSET;
}
else
{
data.PlayerNumber = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("PlayerNumber")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Gender")))
{
data.Gender = GenderType.UNSET;
}
else
{
data.Gender = GenderType.GetInstance(dataReader.GetString(dataReader.GetOrdinal("Gender")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GolferStatus")))
{
data.GolferStatus = GolferStatusEnum.UNSET;
}
else
{
data.GolferStatus = GolferStatusEnum.GetInstance(dataReader.GetString(dataReader.GetOrdinal("GolferStatus")));
}
return(data);
}
