public async Task <IActionResult> Change_price(int id, [Bind("id,Category_id,Item_name,Item_price,Quantity,DateTime")] Add_item add_item) { if (id != add_item.id) { return(NotFound()); } if (ModelState.IsValid) { try { int newUserQnty = add_item.Quantity; var allFields = await _context.Add_item.FindAsync(id); float initialQnty = allFields.Item_price; //int newAvailable = newUserQnty + initialQnty; //add_item.Quantity = newAvailable; //var BookFromDb = await _context.Add_item.FindAsync(id); var query = _context.Add_item.Where(x => x.id == id).Single(); query.Item_price = add_item.Item_price; _context.Update(query); await _context.SaveChangesAsync(); ViewBag.InitialQuantity = initialQnty; ViewBag.NewQuantity = add_item.Item_price; } catch (DbUpdateConcurrencyException) { return(NotFound()); } } return(View(add_item)); }
public async Task <IActionResult> Edit(int id, [Bind("id,Category_id,Item_name,Item_price,Quantity,DateTime")] Add_item add_item) { if (id != add_item.id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(add_item); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Add_itemExists(add_item.Category_id.ToString())) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Create))); } return(View(add_item)); }
public async Task <IActionResult> Create([Bind("Category_id,Item_name,Item_price,Quantity,DateTime")] Add_item add_item) { if (ModelState.IsValid) { _context.Add(add_item); await _context.SaveChangesAsync(); //return RedirectToAction(nameof(Index)); } //var combineList = _context.Add_item.Include("category").ToList(); //ViewBag.itemlist = combineList; List <Add_item> ListOfItems = _context.Add_item.ToList(); List <Item_category> categorys = _context.Items_category.ToList(); List <JoinCategoryAndItem> joinList = new List <JoinCategoryAndItem>(); var results = (from pd in categorys join od in ListOfItems on pd.IDT equals od.Category_id select new { pd.Category_name, od.Item_price, pd.ImageURL, od.Item_name, od.Quantity, od.id, }).ToList(); foreach (var item in results) { JoinCategoryAndItem JoinObject = new JoinCategoryAndItem(); JoinObject.Category_name = item.Category_name; JoinObject.Item_price = item.Item_price; JoinObject.ImageURL = item.ImageURL; JoinObject.Quantity = item.Quantity; JoinObject.Item_name = item.Item_name; JoinObject.id = item.id; joinList.Add(JoinObject); var JoinListToViewbag = joinList.ToList(); ViewBag.JoinList = JoinListToViewbag; } BindCategoryName(); return(View()); }