public Category GetWithProducts(string categoryName) { using (var cn = WJStoreConnection) { var dr = cn.ExecuteReader( "SELECT * " + " FROM Category G" + " JOIN Product A ON A.CategoryId = G.CategoryId" + " WHERE G.Name = @Name", new {Name = categoryName}); Category category = null; while (dr.Read()) { if (category == null) { category = new Category { CategoryId = Convert.ToInt32(dr["CategoryId"]), Name = dr["Name"].ToString(), Description = dr["Description"].ToString() }; } category.Products.Add(new Product { ProductId = Convert.ToInt32(dr["ProductId"]), Title = dr["Title"].ToString(), Price = Convert.ToDecimal(dr["Price"]), ProductArtUrl = dr["ProductArtUrl"].ToString(), CategoryId = Convert.ToInt32(dr["CategoryId"]), Category = category }); } return category; } }
public static CategoryMenuViewModel ToViewModel(Category category) { return Mapper.Map<CategoryMenuViewModel>(category); }