private void ProductEdit() { ProductToEdit.ProductGroup = SelectedMainGroup + "-" + SelectedSubGroup; ProductMethods.EditProduct(ProductToEdit); MessageBox.Show("Produkt Redigeret!"); Application.Current.Windows.OfType <Window>().SingleOrDefault(x => x.IsActive).Close(); }
public void PostOrder(Order order) { OrderedProduct orderedProduct = order.OrderedProducts.FirstOrDefault(); if (orderedProduct.Product.Count >= orderedProduct.CountProduct) { if (order.OrdererName.Length <= 100) { var orderFromList = OrderMethods.GetOrder(order, Connection); if (orderFromList == null) { OrderMethods.CreateOrder(order, Connection); } orderFromList = OrderMethods.GetOrder(order, Connection); if (orderFromList.EndDate == null) { if (OrderMethods.CheckProductInOrder(orderFromList.Id, orderedProduct.Product.Id, Connection)) { OrderMethods.UpdateOrder(orderFromList.Id, orderedProduct.Product.Id, orderedProduct.CountProduct, Connection); } else { OrderMethods.AddProductsInOrder(orderFromList.Id, orderedProduct, Connection); } ProductMethods.UpdateProduct(Connection, $"update PRODUCTS set ProductCount -= {orderedProduct.CountProduct} where Id = {orderedProduct.Product.Id};"); } } } }
/// <summary> /// Method listing products and getting the maingroup afterwards /// </summary> private void GetProductGroups() { List <Product> listProducts = ProductMethods.ListProducts(); MainGroup = listProducts.Select(x => x.ProductGroup.Substring(0, 2)).OrderBy(x => x).ToList(); MainGroup = MainGroup.Distinct().ToList(); }
public void TestGetProducts() { var auth = AccessToken.AccessToken.ProductMethods; var result = ProductMethods.GetProducts(token: auth, parameters: new RequestModel()); Assert.IsNotNull(result); Assert.IsTrue(result.Result == ResultType.Success); }
public void DeleteProduct() { Product selectedProd = MyFilteredItems.ElementAt(SelectedIndex); DataAccessLayer.ProductDelete(selectedProd); ProductList = ProductMethods.ListProducts(); NotifyPropertyChanged(""); }
// GET:Products/Delete/5 public ActionResult Delete(int id, bool?saveChangesError) { if (saveChangesError.GetValueOrDefault()) { ViewBag.ErrorMessage = "Unable to save changes. Try again, and if the problem persists see your system administrator."; } return(View(ProductMethods.GetItem(id))); }
/// <summary> /// выбирает непроданые товары /// </summary> /// <returns></returns> public static IEnumerable <Product> ProductsInStock() { var x = from m in ProductMethods.Outpoot() where m.Status = true select m; return(x); }
public ProductListVM() { ProductList = new List <Product>(); OpenProductEditWindow = new MethodCommand(EditProductWindow); ChangePriceWindow = new MethodCommand(ChangeProductPriceWindow); ProductDelete = new MethodCommand(DeleteProduct); ProductList = ProductMethods.ListProducts(); GetProducts(); }
public void TestReturnProducts_Expected_All_Products() { List <Product> products = CreateSut(); ProductMethods pm = new ProductMethods(products); var results = pm.GetProducts(); Assert.AreEqual(2, results.Count); }
public void TestReturnProducts_Greater_Than_Price() { List <Product> products = CreateSut(); ProductMethods pm = new ProductMethods(products); var results = pm.GetProductsGreateterThan(3.5); Assert.AreEqual("banana", results[0].Description); }
public ProductVM() { ListProducts = ProductMethods.ListProducts(); SelectedMainGroup = "00"; Product = new Product(); CreateProduct = new MethodCommand(CreateProd); GetProductGroups(); GetSubGroups(); }
public void TestMethodProducts_In_Range() { List <Product> products = CreateSut(); ProductMethods pm = new ProductMethods(products); var results = pm.GetProductsInRange(3.5, 10); Assert.AreEqual("banana", results[0].Description); }
public ProductEditVM(object selectedProduct) { EditProduct = new MethodCommand(ProductEdit); CastToType(selectedProduct); ListProducts = ProductMethods.ListProducts(); GetProductGroups(); SelectedMainGroup = ProductToEdit.ProductGroup.Substring(0, 2); SelectedSubGroup = ProductToEdit.ProductGroup.Substring(3, 3); }
public void GetKeysTest() { var auth = AccessToken.AccessToken.ProductMethods; var result = ProductMethods.GetKeys(token: auth, parameters: new GetKeysModel { ProductId = 3349 }); Assert.IsNotNull(result); Assert.IsTrue(result.Result == ResultType.Success); }
// GET: Products/Edit/5 public ActionResult Edit(int id) { Product item = ProductMethods.GetItem(id); if (item == null) { return(HttpNotFound()); } return(View(item)); }
public void AddItems() { List <Product> list = new List <Product>(); Product p = product; Product p1 = p; list.Add(product); list.Add(p); list.Add(p1); Assert.IsTrue(ProductMethods.AddItem(product)); }
/// <summary> /// Поиск по описанию /// </summary> /// <param name="name">Имя товара</param> /// <returns>Список товаров</returns> public static Dictionary <Product, int> SearchByDescription(string name) { var x = ProductsSortByNameAndPrice(ProductMethods.Outpoot()); Dictionary <Product, int> prod = new Dictionary <Product, int>(); var p = from m in x where m.Key.Description.Contains(name) select m; foreach (var item in p) { prod.Add(item.Key, item.Value); } return(prod); }
/// <summary> /// Поиск по названию компании /// </summary> /// <param name="companyName">Название компании</param> /// <returns>Список товаров</returns> public static Dictionary <Product, int> SearchByCompany(string companyName) { var x = ProductsSortByNameAndPrice(ProductMethods.Outpoot()); Dictionary <Product, int> prod = new Dictionary <Product, int>(); var p = from m in x where m.Key.InvoiceForPurchase.CompanyProvider.Name == companyName select m; foreach (var item in p) { prod.Add(item.Key, item.Value); } return(prod); }
/// <summary> /// Поиск по цене(товары с меньшей ценой) /// </summary> /// <param name="price">Цена меньше которой будет поиск</param> /// <returns>Список товаров</returns> public static Dictionary <Product, int> Search(decimal price) { var x = ProductsSortByNameAndPrice(ProductMethods.Outpoot()); Dictionary <Product, int> prod = new Dictionary <Product, int>(); var p = from m in x where m.Key.Price >= price select m; foreach (var item in p) { prod.Add(item.Key, item.Value); } return(prod); }
/// <summary> /// Поиск и продажа товара /// </summary> /// <param name="product">Товар</param> /// <returns>Логическое значение</returns> public static bool Sales(Product product) { var x = ProductMethods.GetItem(product.Id); if (x != null) { x.Status = false; x.DateOfSale = DateTime.Now; return(ProductMethods.SaveChanges()); } else { return(false); } }
public void CreateProd() { bool productNumberExist; if (productNumberExist = ProductMethods.CheckProductNumber(LocalProductNumber)) { MessageBox.Show("Dette produktnummer eksisterer allerede. Prøv et nyt"); } else { Product.ProductID = LocalProductNumber.ToString(); Product.ProductGroup = SelectedMainGroup + "-" + SelectedSubGroup; ProductMethods.CreateProduct(Product); MessageBox.Show("Produkt oprettet!"); } }
public void AddProduct(Product product) { Product prodFromList = ProductMethods.GetProductById(product, ConnectionString); if (prodFromList == null) { if (product.Name.Length <= 200) { ProductMethods.AddProduct(product, ConnectionString); } } else { ProductMethods.UpdateProduct(ConnectionString, $"update PRODUCTS set ProductCount += {product.Count} where Id = {prodFromList.Id};"); } }
public ActionResult DeleteConfirmed(int id) { try { ProductMethods.DeleteItem(id); } catch (DataException) { return(RedirectToAction("Delete", new System.Web.Routing.RouteValueDictionary { { "id", id }, { "saveChangesError", true } })); } return(RedirectToAction("Index")); }
public ActionResult Edit(Product item) { try { if (ModelState.IsValid) { ProductMethods.ChangeItem(item); return(RedirectToAction("Index")); } } catch (DataException) { //Log the error (add a variable name after DataException) ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator."); } return(View(item)); }
/// <summary> /// Поиск и продажа товара /// </summary> /// <param name="productName">Название товара</param> /// <param name="Price">Цена товара</param> /// <returns>Логическое значение</returns> public static bool Sales(string productName, decimal Price) { var x = from m in ProductMethods.Outpoot() where productName == m.Name where Price == m.Price orderby m.DateOfPurchase select m; if (x != null) { var f = x.First(); f.Status = false; f.DateOfSale = DateTime.Now; return(ProductMethods.SaveChanges()); } else { return(false); } }
/// <summary> /// Инвентаризация продуктов /// </summary> /// <returns>Логическое значение</returns> public static bool InventarizationProduct() { var x = ProductsInSales().ToArray(); if (StatisticsVoid.StatisticsProduct() == true) { if (Archiving.ArchivingProduct(x) == true) { foreach (var item in x) { ProductMethods.DeleteItem(item.Id); } } return(true); } else { return(false); } }
static void Main(string[] args) { List <CategoryEnt> categories = Unit.CategoryRepository.AllItems.ToList(); foreach (var item in categories) { Console.WriteLine(item.Id); Console.WriteLine(item.Name); } List <ProductEnt> u = Unit.ProductRepository.AllItems.ToList(); var x = ProductMethods.Outpoot(); foreach (var item in x) { Console.WriteLine(item.ToString()); Console.WriteLine(item.CategoryId); Console.WriteLine(item.Category.Name); Console.WriteLine($"ID накладной{item.InvoiceForPurchase.Id}\n"); } Console.ReadKey(); }
public void DropOneProduct(int id) { ProductMethods.AddOrDropeOneProduct($"update PRODUCTS set ProductCount -= 1 where Id = {id}", ConnectionString); }
string ProductCommand(string message, string[] json) { Product data = null;; if (json != null) { data = JsonConvert.DeserializeObject <Product>(json[0]); } string outMessage = null; switch (message) { case "AddItem": ProductMethods.AddItem(data); outMessage = "Добавленно"; break; case "AddItems": List <Product> list = new List <Product>(); int i = 0; foreach (var x in json) { Product u = JsonConvert.DeserializeObject <Product>(json[i]); list.Add(u); } ProductMethods.AddItems(list); outMessage = "Добавленно"; break; case "ChangeItem": if (ProductMethods.ChangeItem(data) == true) { outMessage = "Найден"; } else { outMessage = "Не найден"; } break; case "DeleteItem": ProductMethods.DeleteItem(Convert.ToInt32(json[0])); outMessage = "Удален"; break; case "GetItem": string s = JsonConvert.SerializeObject(ProductMethods.GetItem(Convert.ToInt32(json[0]))); outMessage = s; break; case "Outpoot": string outs = null; List <Product> unitWeights = ProductMethods.Outpoot().ToList(); foreach (var x in unitWeights) { outs = $"{outs}!{JsonConvert.SerializeObject(x)}"; } outMessage = outs; break; default: outMessage = "Product connect"; break; } return(outMessage); }
// GET: Products public ActionResult Index() { return(View(ProductMethods.Outpoot().ToList())); }