public void LoadNextPrevious(int languageId)
{
using (IDataReader reader = DBProduct.GetNextPreviousProduct(this.productID, this.zoneID, languageId))
{
if (reader.Read())
{
if (reader["PreviousProductID"] != DBNull.Value)
{
this.previousProductId = Convert.ToInt32(reader["PreviousProductID"].ToString());
}
if (reader["NextProductID"] != DBNull.Value)
{
this.nextProductId = Convert.ToInt32(reader["NextProductID"].ToString());
}
if (reader["PreviousZoneID"] != DBNull.Value)
{
this.previousZoneId = Convert.ToInt32(reader["PreviousZoneID"].ToString());
}
if (reader["NextZoneID"] != DBNull.Value)
{
this.nextZoneId = Convert.ToInt32(reader["NextZoneID"].ToString());
}
if (reader["PreviousProductUrl"] != DBNull.Value)
{
this.previousProductUrl = reader["PreviousProductUrl"].ToString();
}
if (reader["PreviousProductTitle"] != DBNull.Value)
{
this.previousProductTitle = reader["PreviousProductTitle"].ToString();
}
if (reader["NextProductUrl"] != DBNull.Value)
{
this.nextProductUrl = reader["NextProductUrl"].ToString();
}
if (reader["NextProductTitle"] != DBNull.Value)
{
this.nextProductTitle = reader["NextProductTitle"].ToString();
}
if (reader["IsFirstProduct"] != DBNull.Value)
{
this.isFirstProduct = Convert.ToBoolean(reader["IsFirstProduct"]);
}
if (reader["IsLastProduct"] != DBNull.Value)
{
this.isLastProduct = Convert.ToBoolean(reader["IsLastProduct"]);
}
}
}
}