public void CreateNewGood(string name, int place, int amount, string provider) { Good good = new Good(); good.Name = name; good.StoragePlace = place; good.Amount = amount; if (provider.Length > 0) { good.ProviderID = _context.Providers.Single(x => x.Name == provider).ProviderID; } _context.Goods.Add(good); _context.SaveChanges(); }
private void updateProductList(int id, int sizeId, string func, int sizeAlter = 0, string sortOrder = "#") { IEnumerable <Product> products = this.db.Product; // products = products.Where(s => s.name.Contains(search) || s.supplier.Contains(search)); // IEnumerable <ProductSize> sizes = this.db.ProductSize; sizes = sizes.Where(s => s.product == this.aProducts.choosenProduct.id); for (int i = 0; i < pSortParams.Length; i++) { if (pSortParams[i].Contains(sortOrder)) { pSortParams[i] = sortOrder + (pSortParams[i].Contains("_asc") ? "_desc" : "_asc"); switch (pSortParams[i]) { case "cat_desc": products = products.OrderByDescending(p => p.category); break; case "cat_asc": products = products.OrderBy(p => p.category); break; case "sup_desc": products = products.OrderByDescending(p => p.supplier); break; case "sup_asc": products = products.OrderBy(p => p.supplier); break; case "price_desc": products = products.OrderByDescending(p => p.price); break; case "price_asc": products = products.OrderBy(p => p.price); break; case "name_desc": products = products.OrderByDescending(p => p.name); break; case "name_asc": products = products.OrderBy(p => p.name); break; case "size_desc": sizes = sizes.OrderByDescending(p => p.size); break; case "size_asc": sizes = sizes.OrderBy(p => p.size); break; case "quantity_desc": sizes = sizes.OrderByDescending(p => p.quantity); break; case "quantity_asc": sizes = sizes.OrderBy(p => p.quantity); break; } } } this.aProducts.products = products.Skip((pPageInfor.pageIndex - 1) * pPageInfor.pageSize).Take(pPageInfor.pageSize); this.aProducts.sizes = sizes; if (func == "details") { this.aProducts.choosenProduct = db.Product.Where(p => p.id == id).FirstOrDefault(); this.aProducts.sizes = db.ProductSize.Where(s => s.product == this.aProducts.choosenProduct.id); this.aProducts.editedSize = new ProductSize(); } if (sizeId != 0 && sizeAlter != 0) { ProductSize sz = db.ProductSize.FirstOrDefault(s => s.id == sizeId); db.Entry(sz).State = Microsoft.EntityFrameworkCore.EntityState.Detached; sz.quantity = Convert.ToString((int.Parse(sz.quantity) + sizeAlter)); db.Update(sz); db.SaveChanges(); } if (func == "edit") { this.isCreation = false; this.aProducts.editedProduct = db.Product.FirstOrDefault(p => p.id == id); } else if (func == "delete") { Product pd = db.Product.FirstOrDefault(p => p.id == id); db.Product.Remove(pd); db.SaveChanges(); } else { this.isCreation = true; this.aProducts.editedProduct = new Product() { id = 0 }; } }
public IActionResult Catalog(String dresses, String leggings, String bloudseAndshirts, String coatsAndjackets, String hoodiesAndsweats, String denim, String jeans, String jumpersAndcardigans, string size, int price, string deletion, string subcat, string subsize, int subprice, int cpId, int wpId, int cart_remove, int wish_remove, int dpId, string sort) { if (cart_remove != 0) { //Product cp = db.Product.Where(p => p.id == cart_remove).FirstOrDefault(); int ind = cart_products.IndexOf(cart_products.Where(p => p.id == cart_remove).FirstOrDefault()); cart_products.RemoveAt(ind); cart_images.RemoveAt(ind); cart_items.RemoveAt(ind); } if (wish_remove != 0) { //Product cp = db.Product.Where(p => p.id == wish_remove).FirstOrDefault(); int ind = wish_products.IndexOf(wish_products.Where(p => p.id == wish_remove).FirstOrDefault()); wish_products.RemoveAt(ind); wish_images.RemoveAt(ind); } if (cpId != 0) { //Product cp = db.Product.Where(p => p.id == cpId).FirstOrDefault(); if (!cart_products.Contains(cart_products.Where(p => p.id == cpId).FirstOrDefault())) { cart_products.Add(db.Product.Where(p => p.id == cpId).FirstOrDefault()); cart_images.Add(db.Image.Where(p => p.whose == (1000 + cpId)).FirstOrDefault()); ItemForm iform = new ItemForm() { product = cpId, price = Convert.ToInt32(db.Product.Where(p => p.id == cpId).FirstOrDefault().price), quantity = 1, sizes = db.ProductSize.Where(p => p.product == cpId).ToList(), }; cart_items.Add(iform); } } if (wpId != 0) { //Product wp = db.Product.Where(p => p.id == wpId).FirstOrDefault(); if (!wish_products.Contains(wish_products.Where(p => p.id == wpId).FirstOrDefault())) { wish_products.Add(db.Product.Where(p => p.id == wpId).FirstOrDefault()); wish_images.Add(db.Image.Where(p => p.whose == (1000 + wpId)).FirstOrDefault()); } } if (dpId != 0) { if (!detail_products.Contains(detail_products.Where(d => d.id == dpId).FirstOrDefault())) { detail_products.Add(db.Product.Where(d => d.id == dpId).FirstOrDefault()); detail_images.Add(db.Image.Where(d => d.whose == (1000 + dpId)).FirstOrDefault()); } } if (deletion != null && deletion != "") { if (deletion == "category") { //catalog.category = ""; //c_cat = true; category_filters.Remove(subcat.ToLower()); } if (deletion == "size") { //catalog.size = ""; //c_size = true; size_filters.Remove(subsize); } if (deletion == "price") { //catalog.price = 0; //c_price = true; price_filters.Remove(subprice); } } if (price != 0 && !price_filters.Contains(price)) { price_filters.Add(price); } if (size != null && size != "" && !size_filters.Contains(size)) { size_filters.Add(size); } if (dresses != null && dresses != "" && !category_filters.Contains(dresses)) { category_filters.Add(dresses); } List <Product> priced_products = new List <Product>(); products = new List <Product>(); productSizes = new List <ProductSize>(); if (price_filters == null || price_filters.Count() == 0) { priced_products = db.Product.ToList(); } else { foreach (var p in price_filters) { if (p == 1) { List <Product> pds = db.Product.Where(s => (Convert.ToInt32(s.price)) >= 10 && (Convert.ToInt32(s.price)) <= 49).ToList(); priced_products.AddRange(pds); } else if (p == 2) { List <Product> pds = db.Product.Where(s => (Convert.ToInt32(s.price)) >= 50 && (Convert.ToInt32(s.price)) <= 99).ToList(); priced_products.AddRange(pds); } else if (p == 3) { List <Product> pds = db.Product.Where(s => (Convert.ToInt32(s.price)) >= 100 && (Convert.ToInt32(s.price)) <= 199).ToList(); priced_products.AddRange(pds); } else if (p == 4) { List <Product> pds = db.Product.Where(s => (Convert.ToInt32(s.price)) >= 200).ToList(); priced_products.AddRange(pds); } //catalog.size = size; } } if (size_filters == null || size_filters.Count() == 0) { productSizes = db.ProductSize.ToList(); } else { foreach (string s in size_filters) { List <ProductSize> sz = db.ProductSize.Where(_s => _s.size == s).ToList(); productSizes.AddRange(sz); } } if (category_filters == null || category_filters.Count() == 0) { products = priced_products; } else { foreach (var c in category_filters) { List <Product> _category = priced_products.Where(p => p.category.Contains(c.ToLower())).ToList(); products.AddRange(_category); } } // /*string cat=catalog.category*/ ; //string sz = catalog.size; //int pr = catalog.price; //if (dresses != null && dresses != "") //{ // products = products.Where(p => p.category.Contains(dresses)).ToList(); // catalog.category = dresses.ToUpper(); // category_filters.Add(dresses); //} if (leggings != null && leggings != "") { products = products.Where(p => p.category.Contains(leggings)).ToList(); //catalog.category = dresses.ToUpper(); //c_cat = true; products = db.Product.ToList(); productSizes = db.ProductSize.ToList(); } if (bloudseAndshirts != null && bloudseAndshirts != "") { products = products.Where(p => p.category.Contains(bloudseAndshirts)).ToList(); //catalog.category = dresses.ToUpper(); //c_cat = true; } if (leggings != null && leggings != "") { products = products.Where(p => p.category.Contains(leggings)).ToList(); catalog.category = dresses.ToUpper(); c_cat = true; } if (coatsAndjackets != null && coatsAndjackets != "") { products = products.Where(p => p.category.Contains(coatsAndjackets)).ToList(); //catalog.category = dresses.ToUpper(); //c_cat = true; } if (bloudseAndshirts != null && bloudseAndshirts != "") { products = products.Where(p => p.category.Contains(bloudseAndshirts)).ToList(); catalog.category = dresses.ToUpper(); c_cat = true; } if (hoodiesAndsweats != null && hoodiesAndsweats != "") { products = products.Where(p => p.category.Contains(hoodiesAndsweats)).ToList(); //catalog.category = dresses.ToUpper(); //c_cat = true; } if (coatsAndjackets != null && coatsAndjackets != "") { products = products.Where(p => p.category.Contains(coatsAndjackets)).ToList(); catalog.category = dresses.ToUpper(); c_cat = true; } if (denim != null && denim != "") { products = products.Where(p => p.category.Contains(denim)).ToList(); //catalog.category = dresses.ToUpper(); //c_cat = true; } if (hoodiesAndsweats != null && hoodiesAndsweats != "") { products = products.Where(p => p.category.Contains(hoodiesAndsweats)).ToList(); catalog.category = dresses.ToUpper(); c_cat = true; } if (denim != null && denim != "") { products = products.Where(p => p.category.Contains(denim)).ToList(); catalog.category = dresses.ToUpper(); c_cat = true; } if (jumpersAndcardigans != null && jumpersAndcardigans != "") { products = products.Where(p => p.category.Contains(jumpersAndcardigans)).ToList(); catalog.category = dresses.ToUpper(); c_cat = true; } if (jeans != null && jeans != "") { products = products.Where(p => p.category.Contains(jeans)).ToList(); catalog.category = dresses.ToUpper(); c_cat = true; } if (price == 1) { products = products.Where(p => Convert.ToInt32(p.price) >= 10 && Convert.ToInt32(p.price) <= 49).ToList(); this.catalog.price = price; c_price = true; } else if (price == 2) { products = products.Where(p => Convert.ToInt32(p.price) >= 50 && Convert.ToInt32(p.price) <= 99).ToList(); this.catalog.price = price; c_price = true; } else if (price == 3) { products = products.Where(p => Convert.ToInt32(p.price) >= 100 && Convert.ToInt32(p.price) <= 199).ToList(); this.catalog.price = price; c_price = true; } else if (price == 4) { products = products.Where(p => Convert.ToInt32(p.price) >= 200).ToList(); this.catalog.price = price; c_price = true; } if (size == "S" || size == "M" || size == "L" || size == "XL" || size == "2XL" || size == "One Size") { productSizes = productSizes.Where(s => s.size == size).ToList(); this.catalog.size = size; c_size = true; } initCatalog(products, productSizes, images); if (c_price == false) { this.catalog.price = old_price; } if (c_size == false) { this.catalog.size = old_size; } if (c_cat == false) { this.catalog.category = old_category; } if (cart != null && cart != "") { Product pd = this.catalog.products.Where(p => p.product.id == Convert.ToInt32(cart)).FirstOrDefault().product; ////Item cd = new Item() ////{ //// product = pd.id, //// cart = ////}; //this.catalog.cartProducts.Add(pd); //this.catalog.cartTotal +=pd.price; Item cp = new Item() { products = products.Where(p => p.category.Contains(jumpersAndcardigans)).ToList(); //catalog.category = dresses.ToUpper(); //c_cat = true; this.catalog.items = db.Item.Where(i => i.cart == 1).ToList(); List <int> pIds = new List <int>(); foreach (var i in this.catalog.items) { if (!pIds.Contains(i.product)) { pIds.Add(i.product); } } this.catalog.cartTotal = 0; foreach (var p in this.catalog.products) { products = products.Where(p => p.category.Contains(jeans)).ToList(); //catalog.category = dresses.ToUpper(); //c_cat = true; } } } if (cartRemove != null && cartRemove != "") { Product pd = this.catalog.products.Where(p => p.product.id == Convert.ToInt32(cartRemove)).FirstOrDefault().product; ////Item cd = new Item() ////{ //// product = pd.id, //// cart = ////}; //this.catalog.cartProducts.Add(pd); //this.catalog.cartTotal +=pd.price; Item cp = db.Item.Where(i => i.product == pd.id).FirstOrDefault(); db.Item.Remove(cp); db.SaveChanges(); //if (price == 1) //{ // products = products.Where(p => Convert.ToInt32(p.price) >= 10 && Convert.ToInt32(p.price) <= 49).ToList(); // catalog.price = price; // c_price = true; //} //else if (price == 2) //{ // products = products.Where(p => Convert.ToInt32(p.price) >= 50 && Convert.ToInt32(p.price) <= 99).ToList(); // catalog.price = price; // c_price = true; //} //else if (price == 3) //{ // products = products.Where(p => Convert.ToInt32(p.price) >= 100 && Convert.ToInt32(p.price) <= 199).ToList(); // catalog.price = price; // c_price = true; //} //else if (price == 4) //{ // products = products.Where(p => Convert.ToInt32(p.price) >= 200).ToList(); // catalog.price = price; // c_price = true; //} //if (size == "S" || size == "M" || size == "L" || size == "XL" || size == "2XL" || size == "One Size") //{ // productSizes = productSizes.Where(s => s.size == size).ToList(); // catalog.size = size; // c_size = true; //} initCatalog(products, productSizes, images); catalog.price_filters = price_filters; catalog.size_filters = size_filters; catalog.category_filters = category_filters; catalog.cart_product = cart_products; catalog.wish_product = wish_products; catalog.wish_images = wish_images; catalog.cart_images = cart_images; catalog.detail_images = detail_images; catalog.detail_product = detail_products; catalog.items = cart_items; //if (c_price == false) //{ // catalog.price = old_price; //} //if (c_size == false) //{ // catalog.size = old_size; //} //if (c_cat == false) //{ // catalog.category = old_category; //} return(View(catalog)); }