Пример #1
0
        public override Collection MakeCollection(CollectionRequestContext context)
        {
            var collection = new Collection();

            using (SqlConnection connection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=SalesDB;Integrated Security=True;MultipleActiveResultSets=True"))
            {
                using (SqlCommand command = new SqlCommand("select p.Name Product, r.Name Region, f.Price Price, o.Date Date from Facts f join Orders o on f.OrderId=o.OrderId join Products p on f.ProductId=p.ProductId join Regions r on f.RegionId=r.RegionId", connection))
                {
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        string product = reader.GetString(0);
                        string region = reader.GetString(1);
                        Decimal price = reader.GetDecimal(2);
                        DateTime date = reader.GetDateTime(3);
                        string imagePath = String.Format("http://localhost:1297/ClientBin/Images/{0}.jpg", product);
                        ItemImage image = new ItemImage(new Uri(imagePath, UriKind.Absolute));
                        collection.AddItem("", null, "", image, new Facet[] { new Facet("Регион", region), new Facet("Продукт", product), new Facet("Цена", (double)price), new Facet("Дата", date) });
                    }
                }
            }

            collection.Name = "Sales Collection";
            return collection;
        }
Пример #2
0
		// Override this method to provide a Collection object for the request.
		public abstract Collection MakeCollection(CollectionRequestContext context);