//עדכון כמות המלאי בעת שהלקוח מוסיפה אחת מהאופציות שבמלאי לכמויות שלו // GET: ConnectTables/Details/quantities public async Task <IActionResult> Details(Quantities quantities) { if (quantities.ProductesId == 0) { return(NotFound()); } var connectTable = await _context.ConnectTable .Include(c => c.Color) .Include(c => c.Productes) .Include(c => c.Size) .SingleOrDefaultAsync(m => m.ProductesId == quantities.ProductesId && m.ColorId == quantities.ColorId && m.SizeId == quantities.SizeId); if (connectTable.AmountInStock < quantities.AmountOfOrders) { quantities.AmountOfOrders = 0; _context.Update(quantities); await _context.SaveChangesAsync(); } else { connectTable.AmountInStock = connectTable.AmountInStock - quantities.AmountOfOrders; _context.Update(connectTable); await _context.SaveChangesAsync(); } if (connectTable == null) { return(NotFound()); } return(RedirectToAction("Index", "Quantities")); }
public async Task <IActionResult> Add([Bind("ProductesId,SizeId,ColorId,MartId,AmountOfOrders")] Quantities quantities) { if (quantities.MartId != 0) { _context.Add(quantities); await _context.SaveChangesAsync(); if (!ConnectTableExist(quantities.ProductesId, quantities.SizeId, quantities.ColorId)) { //כאשר אופציה זו לא נמצאת במלאי(בטבלה המקשרת quantities.AmountOfOrders = 0; _context.Update(quantities); await _context.SaveChangesAsync(); return(RedirectToAction("Index")); } if (ConnectTableExist(quantities.ProductesId, quantities.SizeId, quantities.ColorId)) { return(RedirectToAction("Details", "ConnectTables", quantities)); } } return(RedirectToAction("LogIn", "Customers")); }
public async Task <IActionResult> Edit(int id, [Bind("ProductId,ProductName,Color,Size,Price,AmountInStock,AmountOfOrders,DeliveryPrice,ImgId")] Productes productes) { if (id != productes.ProductId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(productes); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProductesExists(productes.ProductId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(productes)); }
public async Task <IActionResult> Edit(int id, [Bind("MartId,CustomerId")] Mart mart) { if (id != mart.MartId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(mart); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MartExists(mart.MartId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(mart)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Name")] Categories categories) { if (id != categories.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(categories); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CategoriesExists(categories.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction("List")); } return(View(categories)); }
public async Task <IActionResult> Edit(int id, [Bind("SubCategoryId,SubName")] SubCategory subCategory) { if (id != subCategory.SubCategoryId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(subCategory); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SubCategoryExists(subCategory.SubCategoryId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(subCategory)); }
public async Task <IActionResult> Edit(int id, [Bind("Id")] Mart mart) { if (id != mart.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(mart); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MartExists(mart.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } ViewData["Id"] = new SelectList(_context.Customer, "Id", "Id", mart.Id); return(View(mart)); }
public async Task <IActionResult> Edit(int id, [Bind("SubCategoryId,SubName,CategoryId")] SubCategory subCategory) { if (id != subCategory.SubCategoryId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(subCategory); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SubCategoryExists(subCategory.SubCategoryId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["CategoryId"] = new SelectList(_context.Category, "CategoryId", "CategoryId", subCategory.CategoryId); return(View(subCategory)); }
public async Task <IActionResult> Edit(int id, [Bind("DetailesId,ProductId,SizeId,ColorId,MartId")] ConectTable conectTable) { if (id != conectTable.DetailesId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(conectTable); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ConectTableExists(conectTable.DetailesId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["ColorId"] = new SelectList(_context.Color, "ColorId", "ColorId", conectTable.ColorId); ViewData["MartId"] = new SelectList(_context.Mart, "MartId", "MartId", conectTable.MartId); ViewData["ProductId"] = new SelectList(_context.Product, "ProductId", "ProductId", conectTable.ProductId); ViewData["SizeId"] = new SelectList(_context.Set <Size>(), "SizeId", "SizeId", conectTable.SizeId); return(View(conectTable)); }
public async Task <IActionResult> Edit(int id, [Bind("ProductId,ProductName,Price,AmountInStock,AmountOfOrders,DeliveryPrice,SubCategoryId,ImgId")] Product product) { if (id != product.ProductId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(product); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProductExists(product.ProductId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["SubCategoryId"] = new SelectList(_context.SubCategory, "SubCategoryId", "SubCategoryId", product.SubCategoryId); return(View(product)); }
public async Task <IActionResult> Edit(int id, [Bind("CustomerId,FirstName,LastName,PhoneNumber,Address,City,CreditCard,Mail,Password")] Customer customer) { if (id != customer.CustomerId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(customer); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CustomerExists(customer.CustomerId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Index")); } return(View(customer)); }
public async Task <IActionResult> Edit(int id, [Bind("SizeId,SizeName")] Size size) { if (id != size.SizeId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(size); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SizeExists(size.SizeId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(size)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,ProductName,Price,AmountInStock,AmountOfOrders,DeliveryPrice,ImgId,SubCategoryId")] Productes productes) { if (id != productes.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(productes); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ProductesExists(productes.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction("List")); } ViewData["SubIdE"] = new SelectList(await _context.SubCategory.ToListAsync(), "Id", "Name", productes.SubCategory.SubName); return(View(productes)); }
public async Task <IActionResult> Edit(int id, [Bind("ColorId,ColorName")] Color color) { if (id != color.ColorId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(color); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ColorExists(color.ColorId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(color)); }