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());
}
