public IQueryable<Product> GetProduct([QueryString("productID")] int? productId)
        {
            var _db = new CaliforniaPep.Models.ProductContext();
            if (productId.HasValue && productId > 0)
            {
                IQueryable<Product> query1 = _db.Products.Where(en => en.ProductId == productId);
                return query1;
            }
            else
            {
                IQueryable<Product> query2 = _db.Products;
                return query2;
            }

            //var _db = new CaliforniaPep.Models.ProductContext();
            //IQueryable<Product> query = _db.Products;
            //if (productId.HasValue && productId > 0)
            //{
            //    query = query.Where(p => p.ProductID == productId);
            //}
            //else
            //{
            //    query = null;
            //}
            //return query;
        }
 public IQueryable<Category> GetCategories2([QueryString("ProductID")] int? productId)
 {
     var _db = new CaliforniaPep.Models.ProductContext();            
     if (productId == null)
     {
         return null;
     }
     else
     {
         IQueryable<Category> query = _db.ProductCategories.Where(en => en.ProductId == productId).Select( s => s.Category);
         return query;
     }
     
     
 }
 public IQueryable<Product> GetProducts([QueryString("id")] int? categoryId)
 {
     var _db = new CaliforniaPep.Models.ProductContext();            
     if (categoryId.HasValue && categoryId > 0)
     {
         IQueryable<Product> query1 = _db.ProductCategories.Where(en => en.CategoryId == categoryId).Select(w => w.Product);
         return query1;
     }
     else
     {
         IQueryable<Product> query2 = _db.Products;
         return query2;
     }
     
 }
Beispiel #4
0
        ///////////////////////
        public string InsertFromUrl(string b)
        {
            //StringReader strReader = new StringReader(myString);
            WebClient client = new WebClient();
            string a = client.DownloadString(b);

            string ProductName = getBetween(a, "<div class=\"field field-title\"><h2>", "</h2></div></div><div class=\"nd-region-middle-wrapper").Trim(); //a.Substring(0, a.IndexOf(Environment.NewLine)).Trim();

            string Sequence = getBetween(a, "Sequence:&nbsp;</div>", "</div>").Trim();

            string strMolecularWeight = getBetween(a, "Molecular Weight:&nbsp;</div>", "</div>").Trim();
            double MolecularWeight = 0.00;
            if (strMolecularWeight != "")
            {
                MolecularWeight = Convert.ToDouble(strMolecularWeight);
            }

            string CatalogNumber = getBetween(a, "Catalog Number:&nbsp;</div>", "</div>").Trim();

            string Categories = "";//to return
            if (a.Contains("Categories"))
            {
                Categories = getBetween(a, "Categories</em>: </div><a href=\"", "Peptide Image").Trim();
            }

            string strAmount = (getBetween(a, "<span class=\"field-content\">", "mg for").Trim());
            double Amount = 0.00;
            if (strAmount != "")
            {
                Amount = Convert.ToDouble(strAmount);
            }

            string strUnitPrice = (getBetween(a, "mg for <span class=\"uc-price-product uc-price-sell_price uc-price\">", "</span></span>").Trim());
            decimal UnitPrice = 0.00m;
            if (strUnitPrice != "")
            {
                UnitPrice = Convert.ToDecimal(strUnitPrice.TrimStart('$'));
            }

            //string strDescription = getBetween(a, "Peptide Image", "PURCHASE THIS PRODUCT").Trim();

            using (ProductContext db = new ProductContext())
            {
                var newProduct = new Product();

                newProduct.ProductName = ProductName;
                newProduct.Sequence = Sequence;
                newProduct.MolecularWeight = MolecularWeight;
                newProduct.CatalogNumber = CatalogNumber;
                newProduct.Amount = Amount;
                newProduct.Unit = 0;
                newProduct.UnitPrice = UnitPrice;
                newProduct.ImagePath = "productimage.png";
                newProduct.Description = "";

                db.Products.Add(newProduct);

                if (Categories != "")
                {
                    if (Categories.Contains("Alzheimer&#039;s"))//1
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 1;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Cardiovascular"))//2
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 2;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Caspase"))//3
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 3;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Central Nervous System"))//4
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 4;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Enzyme Substrates"))//5
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 5;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Gastrointestinal"))//6
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 6;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Metabolic / Diabetes"))//7
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 7;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Neuropeptides &amp; Hormones"))//8
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 8;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Obesity"))//9
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 9;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Human"))//10
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 10;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                    if (Categories.Contains("Featured Products"))//11
                    {
                        var newProductcategory = new ProductCategory();
                        newProductcategory.ProductId = newProduct.ProductId;
                        newProductcategory.CategoryId = 11;
                        db.ProductCategories.Add(newProductcategory);
                        //db.SaveChanges();
                    }

                }
                try
                {
                    db.SaveChanges();
                    return " Ok! " + ProductName + " for " + UnitPrice;
                }
                catch
                {
                    return "Error!";
                }

            }
        }
Beispiel #5
0
 public IQueryable<Category> GetCategories()
 {
     var _db = new CaliforniaPep.Models.ProductContext();
     IQueryable<Category> query = _db.Categories;
     return query;
 }