public async Task <IActionResult> Edit(string id, [Bind("order_id,customer_id,order_date,status")] order_list order_list) { if (id != order_list.order_id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(order_list); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!order_listExists(order_list.order_id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["customer_id"] = new SelectList(_context.customer, "customer_id", "customer_id", order_list.customer_id); return(View(order_list)); }
public async Task <IActionResult> Create([Bind("order_id,customer_id,order_date,status")] order_list order_list) { if (ModelState.IsValid) { _context.Add(order_list); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["customer_id"] = new SelectList(_context.customer, "customer_id", "customer_id", order_list.customer_id); return(View(order_list)); }
public async Task <IActionResult> NewOrder(order_detail od) { var customer = new SelectList(await _context.customer.ToListAsync(), "customer_id", "firstname", od.order_List.customer_id); var product = new SelectList(await _context.product.ToListAsync(), "product_id", "product_name", od.product_id); using (var tran = _context.Database.BeginTransaction()) { try { order_list ol = new order_list(); ol.order_id = od.order_id; ol.customer_id = od.order_List.customer_id; ol.status = od.order_List.status; ol.order_date = System.DateTime.Now; _context.Add(ol); await _context.SaveChangesAsync(); _context.Add(od); await _context.SaveChangesAsync(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); } tran.Dispose(); } ViewData["customer"] = customer; ViewData["product"] = product; return(View()); }