ASP.NET

Public class Product
{
  private string _productId;
  ...
  private Category _category;

 public Product()
{
  this.ProductId = "";
  this.Category.CategoryId = 0;
}

public Product(....parameter for product, string categoryId)
{
...
 this.category.CategoryId = categoryId;
}
public Category category
        {
            get { return _category; }
            set { _category = value; }           
        }
public ProductId
        {
            get { return _productId; }
            set { _productId= value; }           
        }

public Product()
{
this.Category = null;
}
public Product(parameters..., Category c)
{
...
this.Category = c
}
...
...
 public Category cat
        {
            get { return _category; }
            set { _category = value; }           
        }

part of my BLL
   public static class myBLL
    {
        public static List<Product> GetProducts(string CountryName, string AdCity, string AdSubCatType)
        {
            return myDAL.Instance.GetProducts(CountryName,AdCity,AdSubCatType);
        }
part of my DAL

public List<Product> GetProductss(string CountryName, string AdCity, string AdSubCatType)
        {
            using (SqlConnection oConn = new SqlConnection(_connectionString)) {
                string strSql = "spGetProductListList";
                SqlCommand oCmd = new SqlCommand(strSql, oConn);
                oCmd.CommandType = CommandType.StoredProcedure;
                oCmd.Parameters.Add(new SqlParameter("@CountryName", SqlDbType.NVarChar, 50)).Value = CountryName;
                oCmd.Parameters.Add(new SqlParameter("@AdCity", SqlDbType.NVarChar, 200)).Value = AdCity;
                oCmd.Parameters.Add(new SqlParameter("@AdSubCatType", SqlDbType.NVarChar, 50)).Value = AdSubCatType;               
               
                oConn.Open();
                string m = oCmd.ToString();
                
                // execute query
                SqlDataReader oReader = oCmd.ExecuteReader();
                List<Product> products= null;
                products = GetProductCollectionFromReader(oReader);
                oReader.Close();
                return products;
            }
        }
protected List<Product> GetProductCollectionFromReader(IDataReader oReader)
        {
            List<Product> products = new List<Product>();
            while( oReader.Read() )
                // read line by line and map to an object
                products.Add(GetProductFromReader(oReader));

            return products;
        }
protected Product GetProductFromReader(IDataRecord oReader)
        {
            Product product = new Product();
            product.ProductId = (int)oReader["ProductId"];
            ....
            product.Category.CategoryName  = (string)oReader["CategoryName"];//I get exception here not sure how can i set value of category
            product.Category.CategoryCode = (string)oReader["CategoryCode"];

          
            return product;
        }

Maxdd 7 wrote:

One step at the time