private void btnGuncelle_Click(object sender, EventArgs e) { if (lstUrunler.SelectedItem == null) { return; } Urun seciliUrun = lstUrunler.SelectedItem as Urun; var guncellenecekUrun = new UrunRepo().UrunBul(seciliUrun.Id); // iki methoda da urunbul demişiki string arayana da id arayana da . Id arayanı kullandık. try { // update i de jenerikle yazalım. // update de ki biraz farklı. Öncelikle ürünü bulman lazım. Sonra aşağıya inip update yazıyorsun biriyorusun. // açıkçası update e jenerik yazmak çok da mantıklı değil çünkü biraz daha uzun oluyor kod. Ama diğer avantajları da çok olduğundan karışıklık olmasın hepsini jenerik yapalım diyoruz. seciliUrun = new ProductRepo().GetByID(seciliUrun.Id); // remdeki o anki instance da ki urunu buldu aktardı buraya. seciliUrun.UrunAdi = txtUrunAdi.Text; seciliUrun.Fiyat = nFiyat.Value; seciliUrun.SatistaMi = cbSatistaMi.Checked; //new UrunRepo().UrunGuncelle(seciliUrun); // bu eski yöntem di. // bu alttakini yazabilmek için getbyıd ile o ürünü bulmuş olmamız lazım. new ProductRepo().Update(); UrunleriYukle(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult OrderProduct(int id) { CartRepo cr1 = new CartRepo(); CartModel cart2 = cr1.GetCart(id); int pId = (int)cart2.ProductID; int q = (int)cart2.Quantity; int c = (int)cart2.CustomerID; int tp = (int)cart2.TotalPrice; String pname = cart2.Product.ProductName; //orderModel = new OrderModel(15001, c, pId, pname, q, tp, null); orderModel = new OrderModel() { OrderID = 15001, CustomerID = c, ProductID = pId, ProductName = pname, Quantity = q, TotalPrice = tp, OrderDate = null }; Boolean b = op.AddOrder(orderModel); if (b == true) { cr1.DeleteProduct(cart2.CartID); pr = new ProductRepo(); pr.EditProductQuantity(pId, q); } return(RedirectToAction("ShowOrders")); }
public async Task <IActionResult> CreateAdd([Bind("Id,ProductId,CustomerId,Quantity,Timestamp")] Order order) { var check = new OrderLogic(); var products = new ProductRepo(); if (ModelState.IsValid && check.IsWithinInventory(products.GetInventory(_context, order.ProductId), order.Quantity)) { try { products.UpdateInventory(_context, order.ProductId, order.Quantity); _context.Add(order); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } catch (Exception ex) { _logger.LogInformation(ex, "Something in the order wasn't able to be added"); } } var repo = new OrderRepo(); ViewData["ProductInfo"] = repo.ProductList(_context); return(View(order)); }
private void ProcessEans() { foreach (KeyValuePair <string, string> product in this.RecognizedEan) { Product entity = null; if (!string.IsNullOrEmpty(product.Value)) { entity = ProductRepo.GetByEan13(product.Value); } if (entity == null) { CWUnrecognizedProduct cw = new CWUnrecognizedProduct(this.Context, product.Key, product.Value); if (cw.ShowDialog().HasValue&& cw.DialogResult.Value) { entity = cw.GetProduct(); } } this.RecognizedProducts.Add(entity); } //this.SaveProducts(); this.LoadVisible = false; this.ValidateScan(); }
protected void AddCartBtn_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["ID"]); int userId = Convert.ToInt32(((User)Session["auth_user"]).Id.ToString()); int qty = Convert.ToInt32(TxtQty.Text); Product products = ProductRepo.GetProductByID(id); bool isExist = CartHandler.isExist(id, userId); if (isExist == true) { Cart carts = CartRepo.getCartbyProductIdAndUserId(id, userId); qty = qty + carts.Quantity; } if (qty > products.Stock) { LblError.Text = "Sorry, This Product Stock is just " + products.Stock; } else { if (isExist == false) { CartRepo.doInsertProductToCart(id, userId, qty); } else { CartRepo.addQtyProduct(id, userId, qty); } Response.Redirect("./ViewProduct.aspx"); } }
public ActionResult Edit(int id) { ViewBag.Product = new SelectList(ProductRepo.Get(), "Id", "Name"); ProductViewModel model = ProductRepo.GetById(id); return(View("_Edit", model)); }
public async Task <HttpResponseMessage> GetProductTypes() { var repo = new ProductRepo(_dbConnString); var res = await repo.GetProductTypesAsync(); return(Request.CreateResponse(HttpStatusCode.OK, res)); }
public IQueryable <Product> GetProducts() { var repo = new ProductRepo(); var productsFromRepo = repo.GetAllProducts().AsQueryable(); return(productsFromRepo); }
private void btnGetCategories_Click(object sender, EventArgs e) { var urun = new ProductRepo().GetAll(); var kategori = new CategoryRepo().GetAll(); var kategoriler = from p in urun join k in kategori on p.CategoryId equals k.CategoryId group new { p, k } by new { k.CategoryName } into gp orderby gp.Key.CategoryName ascending select new { CategoryName = gp.Key.CategoryName, Total = gp.Sum(x => x.p.ProductStock) }; lstReport.DataSource = kategoriler.ToList(); }
public static int addProduct(int catId, int vendorId, string name, int price , string desc, int subcatId) { int x = ProductRepo.insertProduct(catId, vendorId, name, price, desc, subcatId); return(x); }
public void GetProductById_Returns_Product() { var productRepo = new ProductRepo(); var product = productRepo.GetById(1); Assert.IsType <Product>(product); }
public frmStocks() { _errorLogs = new ErrorLogs(); _repoProduct = new ProductRepo(); _repoStock = new StockRepo(); InitializeComponent(); }
public List <ProductViewModel> GetAllProductsList() { var repo = new ProductRepo(); List <ProductViewModel> productsList = repo.GetAllProductsList().ToList(); return(productsList); }
public ActionResult ShowQuantity(String searchText) { ProductRepo productRepo = new ProductRepo(); var list = productRepo.SearchProducts(searchText); return(View(list)); }
public ActionResult ProductEdit(int id, ProductModel productModel) { ProductRepo productRepo = new ProductRepo(); Boolean b = productRepo.EditProduct(id, productModel); return(RedirectToAction("ProductDetails")); }
public ActionResult ShowDetails(int id) { ProductRepo productRepo = new ProductRepo(); var product = productRepo.GetProduct(id); return(View(product)); }
public ActionResult ShowQuantity() { ProductRepo productRepo = new ProductRepo(); var list = productRepo.GetAllProducts(); return(View(list)); }
protected List <SelectListItem> GetProductSelectList() { var products = new ProductRepo().GetAll(x => x.SupProductID == null).OrderBy(x => x.ProductName).ToList(); List <SelectListItem> prdList = new List <SelectListItem>() { new SelectListItem() { Text = "Üst ürünü yok", Value = "null" } }; foreach (var prd in products) { if (prd.Products.Any()) { prdList.Add(new SelectListItem() { Text = prd.ProductName, Value = prd.Id.ToString() }); prdList.AddRange(GetSubProducts(prd.Products.OrderBy(x => x.ProductName).ToList())); } else { prdList.Add(new SelectListItem() { Text = prd.ProductName, Value = prd.Id.ToString() }); } } return(prdList); }
public async Task Update_Product_When_Value_Valid() { var dbContext = _fixture.Context; dbContext.Products.Add(new Product { ProductName = "Book 2", Stock = 3, CategoryId = 3, ProviderId = 3, UnitPrice = 1000, Description = "new book", IsNew = true, Status = true, }); dbContext.SaveChanges(); var configuration = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var _repoUser = IUserServiesMock.UserServices(); var productRepo = new ProductRepo(dbContext, _repoUser, _hostingEnv, configuration); var productController = new ProductController(productRepo); var expected = true; var result = productController.Put(new ProductRequest { ProductId = 1, ProductName = "Book 1", Stock = 3, CategoryId = 3, ProviderId = 3, UnitPrice = 1000, Description = "new book", IsNew = true, Status = true, }); var resultValue = Assert.IsType <OkObjectResult>(result.Result); Assert.True(resultValue.Value.Equals(expected)); }
public void GetProducts_Returns_Product() { var productRepo = new ProductRepo(); var product = productRepo.GetAllProducts(); Assert.IsType <List <Product> >(product); }
internal ProductModule() { productRepo = new ProductRepo(); productsBrandRepo = new ProductsBrandRepo(); productsCategoryRepo = new ProductsCategoryRepo(); productsProviderRepo = new ProductsProviderRepo(); }
public IEnumerable <Product> GetProducts(string filter) { var repo = new ProductRepo(); var products = repo.GetAllProducts(); return(products.Where(p => p.Name.Contains(filter))); }
public ActionResult Add(int?productID) { // then didnt come from products page if (productID == null) { return(RedirectToAction("Index")); // send them there } // used to send current qunatity to the page string sessionID = System.Web.HttpContext.Current.Session.SessionID; ShoppingCartRepo cartRepo = new ShoppingCartRepo(); ProductVisit cartItem = cartRepo.GetCartItem(sessionID, (int)productID); ProductVM productVM; if (cartItem == null) { ProductRepo pRepo = new ProductRepo(); Product product = pRepo.GetProduct(productID); productVM = new ProductVM(product); productVM.SetTotalCost(); // quntity times price productVM.image = product.Image.imageTitle; productVM.quantity = 1; } else { productVM = new ProductVM(cartItem.Product); productVM.SetTotalCost(); // quntity times price productVM.image = cartItem.Product.Image.imageTitle; productVM.quantity = cartItem.qtyOrdered; } return(View(productVM)); }
public LossForProduct GetLossForProduct(Guid productId) { Product Product = ProductRepo.Get(x => x.Id == productId); LossForProduct LossRecords = new LossForProduct(); Batch[] ProductInStoreRecords = BatchRepo.GetAll(x => x.ProductId == productId).ToArray(); Guid[] ProductInStoreIds = ProductInStoreRecords.Select(x => x.Id).ToArray(); Loss[] LossesForProduct = LossRepo.GetAll(x => x.Batch.ProductId == productId).OrderBy(x => x.DateOfLoss).ToArray(); Dictionary <int, Dictionary <Month, double> > LossPerYear = new Dictionary <int, Dictionary <Month, double> >(); LossPerYear = GroupLossPerYear(LossesForProduct); foreach (var item in LossPerYear) { int Year = item.Key; Dictionary <Month, double> LossPerMonth = item.Value; LossRecords.LossForProductInYear.Add(new LossForProductInYear() { Year = Year, LossPerMonth = LossPerMonth, }); } LossRecords.Product = Product; return(LossRecords); }
public void NewProduct(Order order) { OrderManager manager = OrderManagerFactory.Create(); while (!isValid) { ProductRepo repo = new ProductRepo(); string productType = ConsoleIO.GetProduct(repo.LoadProducts()); Console.WriteLine($"Is this the correct new product: {productType}, Y/N?"); string correctProduct = Console.ReadLine().ToUpper(); if (correctProduct == "Y") { isValid = true; } ProductTypeResponse response = manager.FindProductByType(productType); if (response.Success) { manager.SaveCurrentOrder(order); ConsoleIO.DisplayEditedOrderDetail(order); Console.WriteLine("Press any key to continue..."); Console.ReadKey(); } else { response.Success = false; response.Message = "An error occurred"; Console.WriteLine("Press any key to continue..."); Console.ReadKey(); } } }
public async Task Seach_Product_by_Name_When_KeyWord_NotExits_in_ProductList(string keyword) { //Arrange var dbContext = _fixture.Context; dbContext.Products.Add(new Product { ProductName = "Book 2", Stock = 3, CategoryId = 3, ProviderId = 3, UnitPrice = 1000, Description = "new book 1", IsNew = true, Status = true, }); dbContext.Products.Add(new Product { ProductName = "Book 3", Stock = 13, CategoryId = 3, ProviderId = 3, UnitPrice = 500, Description = "new book 2", IsNew = true, Status = true, }); dbContext.SaveChanges(); var configuration = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); var _repoUser = IUserServiesMock.UserServices(); var productRepo = new ProductRepo(dbContext, _repoUser, _hostingEnv, configuration); var productController = new ProductController(productRepo); //Act var result = productController.search(keyword); //Assert var resultValue = Assert.IsType <OkObjectResult>(result.Result.Result); var product = resultValue.Value as List <Product>; Assert.Equal(product.Count(), 0); }
public ProductViewModel GetProduct(Guid id) { var repo = new ProductRepo(); ProductViewModel product = repo.GetProduct(id); return(product); }
public void GetProductInfoById_Returns_ProductInfo() { var productInfoRepo = new ProductRepo(); var productInfo = productInfoRepo.GetInfoById(1); Assert.IsType <ProductInformation>(productInfo); }
public static void DoReadOnly(Form form) { ProductRepo db = new ProductRepo(); foreach (Control control in form.Controls) { if (control is TextBox txt) { txt.ReadOnly = true; } else if (control is NumericUpDown nm) { nm.Enabled = false; } else if (control is ComboBox cmb) { foreach (var item in db.GetAll()) { if ((cmb.SelectedItem.GetType() == item.GetType())) { cmb.Enabled = false; break; } } } } }
[Route("Products")] //Add Route public IActionResult Index() { ViewBag.Action = "Edit"; var Products = ProductRepo.Get(orderBy: products => products.OrderBy(g => g.Name)).ToList(); return(View(Products)); }
public ProductBusiness() { this._repo = new ProductRepo(); }
public Products() { prod = new ProductRepo(); }