示例#1
0
        private void ComboBoxRawProduct_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            int comboBoxNumber = ComboBoxRawProduct.SelectedIndex - 1;

            if (comboBoxNumber != -1)
            {
                TextBoxName.Width      = 181;
                Loss.Visibility        = Visibility.Visible;
                TextBoxLoss.Visibility = Visibility.Visible;
                TextBoxLoss.Text       = "20";

                rawProduct         = rawProducts[comboBoxNumber];
                TextBoxName.Text   = rawProduct.RawProductName;
                TextBoxWeight.Text = rawProduct.RawProductWeight.ToString();
            }
            else
            {
                TextBoxName.Width      = 273;
                Loss.Visibility        = Visibility.Hidden;
                TextBoxLoss.Visibility = Visibility.Hidden;

                TextBoxName.Text   = "";
                TextBoxWeight.Text = "0";
            }
        }
示例#2
0
        public static async Task AddProductFromRaw(RawProduct raw, int count)
        {
            List <string> ProductName  = new List <string>();
            List <int?>   ProductPrice = new List <int?>();
            List <int?>   ProductStock = new List <int?>();

            foreach (string value in RawProduct.ProductNames.Values)
            {
                ProductName.Add(value);
            }
            foreach (int?value in RawProduct.ProductPrices.Values)
            {
                ProductPrice.Add(value);
            }
            foreach (int?value in RawProduct.ProductStockQuantity.Values)
            {
                ProductStock.Add(value);
            }

            for (int i = 0; i < count; i++)
            {
                Product product = new Product();
                product.name           = ProductName[i];
                product.regular_price  = ProductPrice[i];
                product.manage_stock   = true;
                product.stock_quantity = ProductStock[i];
                await Rest.wc.Product.Add(product).ConfigureAwait(true);
            }
        }
示例#3
0
        private void AddButton_Click(object sender, RoutedEventArgs e)
        {
            RawProduct       rawProduct = new RawProduct();
            WindowShowDialog wsd        = new WindowShowDialog();

            rawProduct.RawProductName = TextBoxName.Text.ToString();

            if (double.TryParse(TextBoxWeight.Text, out double resultWeight) && TextBoxDateOfPurchase.SelectedDate != null)
            {
                rawProduct.RawProductWeight = double.Parse(TextBoxWeight.Text);
                rawProduct.DateOfPurchase   = DateTime.Parse(TextBoxDateOfPurchase.Text);

                rawProductRepository.AddRawProduct(rawProduct);

                wsd.LabelShowDialog.Content = "Råvaren blev tilføjet";
                wsd.ShowDialog();

                this.Close();
            }
            else
            {
                wsd.LabelShowDialog.Content = "Der var en fejl i 'Vægt' eller 'Indkøbsdato'";
                wsd.ShowDialog();
            }
        }
示例#4
0
 public WindowEditRawProduct(int rawProductID)
 {
     rawProduct = rawProductRepository.DisplayRawProduct(rawProductID);
     InitializeComponent();
     TextBoxName.Text           = rawProduct.RawProductName;
     TextBoxWeight.Text         = rawProduct.RawProductWeight.ToString();
     TextBoxDateOfPurchase.Text = rawProduct.DateOfPurchase.ToString();
 }
        private void ButtonSearch_Click(object sender, RoutedEventArgs e)
        {
            RawProduct       rawProduct = new RawProduct();
            WindowShowDialog wsd        = new WindowShowDialog();

            rawProduct.RawProductName = TextBoxName.Text.ToString();

            if (double.TryParse(TextBoxWeight.Text, out double resultWeight) || TextBoxDateOfPurchase.SelectedDate != null)
            {
                if (double.TryParse(TextBoxWeight.Text, out resultWeight) == false)
                {
                    rawProduct.RawProductWeight = 0;
                }
                else
                {
                    rawProduct.RawProductWeight = double.Parse(TextBoxWeight.Text);
                }
                if (TextBoxDateOfPurchase.SelectedDate == null)
                {
                    rawProduct.DateOfPurchase = new DateTime(1973, 1, 1, 12, 0, 0);
                }
                else
                {
                    rawProduct.DateOfPurchase = DateTime.Parse(TextBoxDateOfPurchase.Text);
                }

                eventSendList(rawProductRepository.DisplaySpecificRawProducts(rawProduct));

                this.Close();
            }
            else if (TextBoxWeight.Text == string.Empty || TextBoxDateOfPurchase.SelectedDate == null)
            {
                rawProduct.DateOfPurchase = new DateTime(1973, 1, 1, 12, 0, 0);

                eventSendList(rawProductRepository.DisplaySpecificRawProducts(rawProduct));

                this.Close();
            }
            else
            {
                wsd.LabelShowDialog.Content = "Der var en fejl i 'Vægt' eller 'Indkøbsdato'";
                wsd.ShowDialog();
            }
        }
示例#6
0
        static void Main(string[] args)
        {
            // Initialize Milkshake helpers into memory
            Store.Initialize();

            // Reset the index
            Search.Reset();

            ConnectionMultiplexer redis = ConnectionMultiplexer.Connect("10.0.0.40:6379");

            redis.PreserveAsyncOrder = true;

            //ISubscriber sub = redis.GetSubscriber();
            IDatabase db = redis.GetDatabase();

            //sub.Subscribe("milkshake_newproduct", (channel, message) =>
            //{
            //var context = TaskScheduler.FromCurrentSynchronizationContext();

            while (true)
            {
                RedisValue item = db.ListLeftPop("milkshake_product_parse_queue");

                if (item.HasValue && !item.IsNullOrEmpty)
                {
                    try
                    {
                        //Console.Write("Deserializing product...");

                        Stopwatch sw = new Stopwatch();

                        //sw.Start();
                        RawProduct p = JsonConvert.DeserializeObject <RawProduct>(item);
                        //sw.Stop();

                        //Console.WriteLine("Deserialize: " + sw.ElapsedMilliseconds + "ms");
                        //sw.Reset();

                        ////
                        // Step 1: Check if store exists, if not, create it!
                        ////
                        sw.Start();
                        Store s = Store.Get(p.Store);
                        if (s == null)
                        {
                            s      = new Store();
                            s.Name = p.Store;

                            if (!String.IsNullOrEmpty(p.StoreWebsite))
                            {
                                s.Website = p.StoreWebsite;
                            }
                            else
                            {
                                s.Website = p.Store;
                            }

                            Store.Create(s);
                        }

                        p.StoreId = s.Id;
                        p.Store   = s.Name;
                        sw.Stop();

                        //Console.WriteLine("Store: " + sw.ElapsedMilliseconds + "ms");
                        //sw.Reset();

                        // Step 2: Check if brand exists, if not, create it
                        //sw.Start();
                        //Brand b = Brand.Get(p.Brand);

                        /*if (b == null)
                         * {
                         *  b = new Brand();
                         *  b.Name = p.Brand;
                         *
                         *  Brand.Create(b);
                         * }*/
                        //if (b!=null)
                        //    p.Brand = b.Name;

                        //sw.Stop();

                        //Console.WriteLine("Brand: " + sw.ElapsedMilliseconds + "ms");
                        //sw.Reset();

                        // Step 3: Check if manufacturer exists, if not, create it
                        //sw.Start();
                        //Manufacturer m = Manufacturer.Get(p.Manufacturer);

                        /*if (m == null)
                         * {
                         *  m = new Manufacturer();
                         *  m.Name = p.Manufacturer;
                         *
                         *  Manufacturer.Create(m);
                         * }*/
                        //if (m!=null)
                        //    p.Manufacturer = m.Name;
                        //sw.Stop();

                        //Console.WriteLine("Manufacturer: " + sw.ElapsedMilliseconds + "ms");
                        //sw.Reset();

                        try
                        {
                            sw.Start();
                            ProductManager.AddProduct(p).Wait();
                            sw.Stop();
                            Console.WriteLine("Indexed product in " + sw.ElapsedMilliseconds + "ms");
                            sw.Reset();
                        }
                        catch (Exception e)
                        {
                            Console.WriteLine("Unhandled exception occurred in Milkshake database pipeline: " + e.ToString());
                        }
                    }
                    catch (Exception e)
                    {
                        Console.WriteLine("Unhandled exception while deserializing RawProduct from JSON: " + e.ToString());
                    }
                }
            }

            //});

            //while (true)
            //{
            //    Thread.Sleep(1);
            //}
        }
示例#7
0
 public List <RawProduct> DisplaySpecificRawProducts(RawProduct rawProduct)
 {
     return(rawProducts = rawProduct.GetSpecificRawProducts(rawProduct.RawProductName, rawProduct.RawProductWeight, rawProduct.DateOfPurchase));
 }
示例#8
0
 public void EditRawProduct(RawProduct rawProduct)
 {
     rawProduct.EditRawProduct(rawProduct.RawProductID, rawProduct.RawProductName, rawProduct.RawProductWeight, rawProduct.DateOfPurchase);
 }
示例#9
0
 //Metods
 public void AddRawProduct(RawProduct rawProduct)
 {
     rawProduct.AddRawProduct(rawProduct.RawProductName, rawProduct.RawProductWeight, rawProduct.DateOfPurchase);
 }
示例#10
0
 public static void GetProductDictionary(RawProduct raw)
 {
     var s = raw.GetProductNames();
     var d = raw.GetProductPrice();
     var n = raw.GetStickQuantity();
 }
示例#11
0
        public override RawProduct Parse(XElement node)
        {
            RawProduct p = new RawProduct();

            p.Source = RawProduct.ProductDataSource.Linkshare;

            try { p.Store = _storeName; }
            catch { }
            try { p.StoreWebsite = ""; }
            catch { }
            try { p.LinkshareMID = _storeId; }
            catch { }

            try { p.LinkshareProductId = node.Attribute("product_id").Value; }
            catch { }
            try { p.Name = node.Attribute("name").Value; }
            catch { }
            try { p.SKU = node.Attribute("sku_number").Value; }
            catch { }
            try { p.Manufacturer = node.Attribute("manufacturer_name").Value; }
            catch { }
            try { p.MPN = node.Attribute("part_number").Value; }
            catch { }

            try { p.PrimaryCategory = node.Element("category").Element("primary").Value; }
            catch { }
            try { p.SecondaryCategory = node.Element("category").Element("secondary").Value; }
            catch { }

            try { p.Url = node.Element("URL").Element("product").Value; }
            catch { }
            try { p.Image = node.Element("URL").Element("productImage").Value; }
            catch { }
            try { p.BuyUrl = node.Element("URL").Element("buyLink").Value; }
            catch { }

            try { p.ShortDescription = node.Element("description").Element("short").Value; }
            catch { }
            try { p.LongDescription = node.Element("description").Element("long").Value; }
            catch { }

            try { p.Currency = node.Element("price").Attribute("currency").Value; }
            catch { }
            try { p.SalePrice = node.Element("price").Element("sale").Value; }
            catch { }
            try { p.SaleStartDate = node.Element("price").Element("sale").Attribute("begin_date").Value; }
            catch { }
            try { p.SaleEndDate = node.Element("price").Element("sale").Attribute("end_date").Value; }
            catch { }
            try { p.RetailPrice = node.Element("price").Element("retail").Value; }
            catch { }

            try { p.Brand = node.Element("brand").Value; }
            catch { }

            try { p.StandardShippingCost = node.Element("shipping").Element("cost").Element("amount").Value; }
            catch { }
            try { p.ShippingInformation = node.Element("shipping").Element("information").Value; }
            catch { }
            try { p.Availability = node.Element("shipping").Element("availability").Value; }
            catch { }

            try { p.Keywords = node.Element("keywords").Value; }
            catch { }

            try { p.UPC = node.Element("upc").Value; }
            catch { }

            try { p.LinkshareM1 = node.Element("m1").Value; }
            catch { }

            try { p.ImpressionUrl = node.Element("pixel").Value; }
            catch { }

            try { p.LinkshareClassId = (LinkshareAttributeClass)Enum.Parse(typeof(LinkshareAttributeClass), node.Element("attributes").Attribute("class_id").Value, true); }
            catch { }

            // NO attributes, simply return product
            if (!Enum.IsDefined(typeof(LinkshareAttributeClass), p.LinkshareClassId))
            {
                return(p);
            }

            // Linkshare Attribute Miscellaneous is there regardless of class
            try { p.Miscellaneous = node.Element("attributes").Element("Miscellaneous").Value; }
            catch { }

            // Linkshare Attributes
            switch (p.LinkshareClassId)
            {
            case LinkshareAttributeClass.Books:
                try { p.Title = node.Element("attributes").Element("Title").Value; }
                catch { }
                try { p.Author = node.Element("attributes").Element("Author").Value; }
                catch { }
                try { p.ISBN = node.Element("attributes").Element("ISBN").Value; }
                catch { }
                try { p.Publisher = node.Element("attributes").Element("Publisher").Value; }
                catch { }
                try { p.PublishDate = node.Element("attributes").Element("Publish_Date").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.Music:
                try { p.Genre = node.Element("attributes").Element("Genre").Value; }
                catch { }
                try { p.Artist = node.Element("attributes").Element("Artist").Value; }
                catch { }
                try { p.Format = node.Element("attributes").Element("Format").Value; }
                catch { }
                try { p.Album = node.Element("attributes").Element("Album").Value; }
                catch { }
                try { p.SongTitle = node.Element("attributes").Element("SongTitle").Value; }
                catch { }
                try { p.Label = node.Element("attributes").Element("Label").Value; }
                catch { }
                try { p.ReleaseDate = node.Element("attributes").Element("ReleaseDate").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.Movies:
                try { p.Genre = node.Element("attributes").Element("Genre").Value; }
                catch { }
                try { p.Title = node.Element("attributes").Element("Title").Value; }
                catch { }
                try { p.Format = node.Element("attributes").Element("Format").Value; }
                catch { }
                try { p.Director = node.Element("attributes").Element("Director").Value; }
                catch { }
                try { p.Actor = node.Element("attributes").Element("Actor").Value; }
                catch { }
                try { p.MovieRating = node.Element("attributes").Element("Rating").Value; }
                catch { }
                try { p.Studio = node.Element("attributes").Element("Studio").Value; }
                catch { }
                try { p.ReleaseDate = node.Element("attributes").Element("Release_Date").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.ComputerHardware:
                try { p.Platform = node.Element("attributes").Element("Platform").Value; }
                catch { }
                try { p.RAM = node.Element("attributes").Element("Ram").Value; }
                catch { }
                try { p.HardDrive = node.Element("attributes").Element("Hard_Drive").Value; }
                catch { }
                try { p.Processor = node.Element("attributes").Element("Processor").Value; }
                catch { }
                try { p.MonitorSize = node.Element("attributes").Element("Monitor_Size").Value; }
                catch { }
                try { p.Modem = node.Element("attributes").Element("Modem").Value; }
                catch { }
                try { p.Drive = node.Element("attributes").Element("Drive").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.ComputerSoftware:
                try { p.Platform = node.Element("attributes").Element("Platform").Value; }
                catch { }
                try { p.Category = node.Element("attributes").Element("Category").Value; }
                catch { }
                try { p.Age = node.Element("attributes").Element("Age").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.ClothingAndAccessories:
                try { p.ProductType = node.Element("attributes").Element("Product_Type").Value; }
                catch { }
                try { p.Size = node.Element("attributes").Element("Size").Value; }
                catch { }
                try { p.Material = node.Element("attributes").Element("Material").Value; }
                catch { }
                try { p.Color = node.Element("attributes").Element("Color").Value; }
                catch { }
                try { p.Gender = node.Element("attributes").Element("Gender").Value; }
                catch { }
                try { p.Style = node.Element("attributes").Element("Style").Value; }
                catch { }
                try { p.Age = node.Element("attributes").Element("Age").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.Art:
                try { p.ProductType = node.Element("attributes").Element("Product_Type").Value; }
                catch { }
                try { p.Artist = node.Element("attributes").Element("Artist").Value; }
                catch { }
                try { p.Title = node.Element("attributes").Element("Title").Value; }
                catch { }
                try { p.Dimensions = node.Element("attributes").Element("Dimensions").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.Toys:
                try { p.Age = node.Element("attributes").Element("Age").Value; }
                catch { }
                try { p.Gender = node.Element("attributes").Element("Gender").Value; }
                catch { }
                try { p.Theme = node.Element("attributes").Element("Theme").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.Pets:
                try { p.PetType = node.Element("attributes").Element("Pet_Type").Value; }
                catch { }
                try { p.ProductType = node.Element("attributes").Element("Product_type").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.Games:
                try { p.Format = node.Element("attributes").Element("Format").Value; }
                catch { }
                try { p.Title = node.Element("attributes").Element("Title").Value; }
                catch { }
                try { p.Publisher = node.Element("attributes").Element("Publisher").Value; }
                catch { }
                try { p.Age = node.Element("attributes").Element("Age").Value; }
                catch { }
                try { p.ReleaseDate = node.Element("attributes").Element("Release_date").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.FoodAndDrink:
                try { p.ProductType = node.Element("attributes").Element("Product_Type").Value; }
                catch { }
                try { p.Region = node.Element("attributes").Element("Region").Value; }
                catch { }
                try { p.Size = node.Element("attributes").Element("Size").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.GiftsAndFlowers:
                try { p.Occasion = node.Element("attributes").Element("Occasion").Value; }
                catch { }
                try { p.Recipient = node.Element("attributes").Element("Recipient").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.Auto:
                try { p.Make = node.Element("attributes").Element("Make").Value; }
                catch { }
                try { p.Model = node.Element("attributes").Element("Genre").Value; }
                catch { }
                try { p.MPN = node.Element("attributes").Element("Part_Number").Value; }
                catch { }
                try { p.SubCategory = node.Element("attributes").Element("Category").Value; }
                catch { }
                try { p.Color = node.Element("attributes").Element("Color").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.Electronics:
                try { p.Category = node.Element("attributes").Element("Category").Value; }
                catch { }
                try { p.Model = node.Element("attributes").Element("Model").Value; }
                catch { }
                try { p.FeaturesAndSpecifications = node.Element("attributes").Element("Genre").Value; }
                catch { }
                try { p.Color = node.Element("attributes").Element("Color").Value; }
                catch { }
                try { p.Dimensions = node.Element("attributes").Element("Dimensions").Value; }
                catch { }
                try { p.PowerType = node.Element("attributes").Element("Power_Type").Value; }
                catch { }
                try { p.Warranty = node.Element("attributes").Element("Warranty").Value; }
                catch { }
                break;

            case LinkshareAttributeClass.CreditCards:
                try { p.CardType = node.Element("attributes").Element("Card_Type").Value; }
                catch { }
                try { p.IntroAPR = node.Element("attributes").Element("Intro_APR").Value; }
                catch { }
                try { p.RegularAPR = node.Element("attributes").Element("Regular_APR").Value; }
                catch { }
                try { p.AnnualFee = node.Element("attributes").Element("Annual_Fee").Value; }
                catch { }
                try { p.Incentive = node.Element("attributes").Element("Incentive").Value; }
                catch { }
                try { p.BalanceTransfer = node.Element("attributes").Element("Balance_Transfer").Value; }
                catch { }
                try { p.Benefits = node.Element("attributes").Element("Benefits").Value; }
                catch { }
                try { p.TermsURL = node.Element("attributes").Element("TermsURL").Value; }
                catch { }
                break;
            }

            return(p);
        }
示例#12
0
        public override RawProduct Parse(XElement node)
        {
            RawProduct p = new RawProduct();

            p.Source = RawProduct.ProductDataSource.CommissionJunction;

            try { p.Store = node.Element("programname").Value; }
            catch { }
            try { p.StoreWebsite = node.Element("programurl").Value; }
            catch { }

            try { p.Name = node.Element("name").Value; }
            catch { }
            try { p.Keywords = node.Element("keywords").Value; }
            catch { }
            try { p.Description = node.Element("description").Value; }
            catch { }

            try { p.SKU = node.Element("sku").Value; }
            catch { }
            try { p.Manufacturer = node.Element("manufacturer").Value; }
            catch { }
            try { p.ManufacturerID = node.Element("manufacturerid").Value; }
            catch { }

            // Unique Identifiers
            try { p.UPC = node.Element("upc").Value; }
            catch { }
            try { p.ISBN = node.Element("isbn").Value; }
            catch { }

            try { p.Currency = node.Element("currency").Value; }
            catch { }
            try { p.Price = node.Element("price").Value; }
            catch { }
            try { p.SalePrice = node.Element("saleprice").Value; }
            catch { }
            try { p.RetailPrice = node.Element("retailprice").Value; }
            catch { }
            try { p.FromPrice = node.Element("fromprice").Value; }
            catch { }

            try { p.Url = node.Element("buyurl").Value; }
            catch { }
            try { p.BuyUrl = node.Element("buyurl").Value; }
            catch { }
            try { p.ImpressionUrl = node.Element("impressionurl").Value; }
            catch { }
            try { p.Image = node.Element("imageurl").Value; }
            catch { }

            try { p.AdvertiserCategory = node.Element("advertisercategory").Value; }
            catch { }
            try { p.ThirdPartyId = node.Element("thirdpartyid").Value; }
            catch { }
            try { p.ThirdPartyCategory = node.Element("thirdpartycategory").Value; }
            catch { }

            try { p.Author = node.Element("author").Value; }
            catch { }
            try { p.Artist = node.Element("artist").Value; }
            catch { }
            try { p.Title = node.Element("title").Value; }
            catch { }
            try { p.Publisher = node.Element("publisher").Value; }
            catch { }
            try { p.Label = node.Element("label").Value; }
            catch { }
            try { p.Format = node.Element("format").Value; }
            catch { }

            try { p.Special = node.Element("special").Value; }
            catch { }
            try { p.Gift = node.Element("gift").Value; }
            catch { }
            try { p.PromotionalText = node.Element("promotionaltext").Value; }
            catch { }

            try { p.StartDate = node.Element("startdate").Value; }
            catch { }
            try { p.EndDate = node.Element("enddate").Value; }
            catch { }

            try { p.Offline = node.Element("offline").Value; }
            catch { }
            try { p.Online = node.Element("online").Value; }
            catch { }

            try { p.InStock = node.Element("instock").Value; }
            catch { }

            try { p.Condition = node.Element("condition").Value; }
            catch { }

            try { p.Condition = node.Element("condition").Value; }
            catch { }

            try { p.Warranty = node.Element("warranty").Value; }
            catch { }

            try { p.StandardShippingCost = node.Element("standardshippingcost").Value; }
            catch { }

            return(p);
        }
示例#13
0
        public override RawProduct Parse(CsvReader reader)
        {
            RawProduct p = new RawProduct();

            p.Source = RawProduct.ProductDataSource.Pepperjam;

            try { p.ProgramId = reader["program_id"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Store = reader["program_name"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Currency = reader["currency"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.AgeRange = reader["age_range"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Artist = reader["artist"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.AspectRatio = reader["aspect_ratio"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Author = reader["author"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.BatteryLife = reader["battery_life"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Binding = reader["binding"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Url = reader["buy_url"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.BuyUrl = reader["buy_url"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Color = reader["color"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ColorOutput = reader["color_output"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Condition = reader["condition"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.LongDescription = reader["description_long"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Director = reader["director"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.DisplayType = reader["display_type"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Edition = reader["edition"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ExpirationDate = reader["expiration_date"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.FeaturesAndSpecifications = reader["features"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.FocusType = reader["focus_type"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Format = reader["format"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Functions = reader["functions"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Genre = reader["genre"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.HeelHeight = reader["heel_height"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Height = reader["height"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ImageThumbUrl = reader["image_thumb_url"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Image = reader["image_url"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Installation = reader["installation"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ISBN = reader["isbn"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Length = reader["length"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.LoadType = reader["load_type"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Location = reader["location"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.MadeIn = reader["made_in"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Manufacturer = reader["manufacturer"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Material = reader["material"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Megapixels = reader["megapixels"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.MemoryType = reader["memory_type"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.MemoryCapacity = reader["memory_capacity"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.MemoryCardSlot = reader["memory_card_slot"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ModelNumber = reader["model_number"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.MPN = reader["mpn"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Name = reader["name"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Occasion = reader["occasion"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.OperatingSystem = reader["operating_system"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.OpticalDrive = reader["optical_drive"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.RetailPrice = reader["price_retail"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Pages = reader["pages"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.PaymentAccepted = reader["payment_accepted"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.PaymentNotes = reader["payment_notes"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Platform = reader["platform"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.SalePrice = reader["price_sale"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Processor = reader["processor"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Publisher = reader["publisher"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.QuantityInStock = reader["quantity_in_stock"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Rating = reader["rating"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.RecommendedUsage = reader["recommended_usage"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Resolution = reader["resolution"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ShoeSize = reader["shoe_size"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ScreenSize = reader["screen_size"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ShippingMethod = reader["shipping_method"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ShippingPrice = reader["price_shipping"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ShoeWidth = reader["shoe_width"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Size = reader["size"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.SKU = reader["sku"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Staring = reader["staring"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Style = reader["style"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Tracks = reader["tracks"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.UPC = reader["upc"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Weight = reader["weight"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Width = reader["width"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.WirelessInterface = reader["wireless_interface"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Year = reader["year"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Zoom = reader["zoom"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.NetworkCategory = reader["category_network"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ProgramCategory = reader["category_program"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.ShortDescription = reader["description_short"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Discontinued = reader["discontinued"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.InStock = reader["in_stock"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.TechSpecsUrl = reader["tech_specs_url"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Keywords = reader["keywords"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }
            try { p.Price = reader["price"]; }
            catch (Exception e)
            {
                Console.WriteLine(Exception e);
            }

            return(p);
        }