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