public static WhereToPlay GetItem(int whereToPlayId)
{
WhereToPlay tempItem = null;
using (SqlConnection myConnection = new SqlConnection(AppConfiguration.ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("usp_GetWhereToPlay", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.AddWithValue("@QueryId", SelectTypeEnum.GetItem);
myCommand.Parameters.AddWithValue("@WhereToPlayId", whereToPlayId);
myConnection.Open();
using (SqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.Read())
{
tempItem = FillDataRecord(myReader);
}
myReader.Close();
}
}
}
return(tempItem);
}
private void BindWhereToPlay()
{
int whereToPlayId = Request.QueryString["WhereToPlayId"].ToInt();
if (whereToPlayId > 0)
{
WhereToPlay whereToPlayLookup = WhereToPlayDAL.GetItem(whereToPlayId);
if (whereToPlayLookup != null)
{
lblWhereToPlayId.Text = whereToPlayLookup.WhereToPlayId.ToString();
lblGameId.Text = whereToPlayLookup.GameId.ToString();
lblStateId.Text = whereToPlayLookup.StateId.ToString();
lblCityId.Text = whereToPlayLookup.CityId.ToString();
lblAddressName.Text = whereToPlayLookup.AddressName;
lblAddressNumber.Text = whereToPlayLookup.AddressNumber.ToString();
lblStreet01.Text = whereToPlayLookup.Street01;
lblStreet02.Text = whereToPlayLookup.Street02;
lblZipCode.Text = whereToPlayLookup.ZipCode.ToString();
lblZipCodePlusFour.Text = whereToPlayLookup.ZipCodePlusFour.ToString();
}
else
{
lblMessage.Text = "Location could not be found.";
}
}
else
{
lblMessage.Text = "Invalid ID. Location record could not be found.";
}
}
private static WhereToPlay FillDataRecord(IDataRecord myDataRecord)
{
WhereToPlay myObject = new WhereToPlay();
myObject.WhereToPlayId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("WhereToPlayId"));
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("GameId")))
{
myObject.GameId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("GameId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("StateId")))
{
myObject.StateId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("StateId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("CityId")))
{
myObject.CityId = myDataRecord.GetInt32(myDataRecord.GetOrdinal("CityId"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("AddressName")))
{
myObject.AddressName = myDataRecord.GetString(myDataRecord.GetOrdinal("AddressName"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("AddressNumber")))
{
myObject.AddressNumber = myDataRecord.GetInt32(myDataRecord.GetOrdinal("AddressNumber"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Street01")))
{
myObject.Street01 = myDataRecord.GetString(myDataRecord.GetOrdinal("Street01"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("Street02")))
{
myObject.Street02 = myDataRecord.GetString(myDataRecord.GetOrdinal("Street02"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("ZipCode")))
{
myObject.ZipCode = myDataRecord.GetInt32(myDataRecord.GetOrdinal("ZipCode"));
}
if (!myDataRecord.IsDBNull(myDataRecord.GetOrdinal("ZipCodePlusFour")))
{
myObject.ZipCodePlusFour = myDataRecord.GetInt32(myDataRecord.GetOrdinal("ZipCodePlusFour"));
}
return(myObject);
}
