public ActionResult Edit([Bind(Include = "OrderID,CustomerID,EmployeeID,ShipName,ShipAddress,ProductID,UnitPrice,Quantity")] OrderPocViewModel orderPocViewModel)
{
if (ModelState.IsValid)
{
try
{
var order = db.Orders.Find(orderPocViewModel.OrderID);
order.CustomerID = orderPocViewModel.CustomerID;
order.EmployeeID = orderPocViewModel.EmployeeID;
order.ShipName = orderPocViewModel.ShipName;
order.ShipAddress = orderPocViewModel.ShipAddress;
db.SaveChanges();
var orderDetails = db.Order_Details.Find(orderPocViewModel.OrderID, orderPocViewModel.ProductID);
orderDetails.ProductID = orderPocViewModel.ProductID;
orderDetails.UnitPrice = orderPocViewModel.UnitPrice;
orderDetails.Quantity = orderPocViewModel.Quantity;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
log.Error("{0} Exception:", ex);
ModelState.AddModelError("DBERROR", "編輯訂單存檔發生錯誤！");
}
}
return(View(orderPocViewModel));
}
public ActionResult DeleteConfirmed(int id)
{
OrderPocViewModel orderPocViewModel = db.OrderPocViewModels.Find(id);
db.OrderPocViewModels.Remove(orderPocViewModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Order/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrderPocViewModel orderPocViewModel = db.OrderPocViewModels.Find(id);
if (orderPocViewModel == null)
{
return(HttpNotFound());
}
return(View(orderPocViewModel));
}
public ActionResult Create([Bind(Include = "OrderID,CustomerID,EmployeeID,ShipName,ShipAddress,ProductID,UnitPrice,Quantity")] OrderPocViewModel orderPocViewModel)
{
if (ModelState.IsValid)
{
var order = new Orders()
{
OrderID = orderPocViewModel.OrderID,
CustomerID = orderPocViewModel.CustomerID,
EmployeeID = orderPocViewModel.EmployeeID,
ShipName = orderPocViewModel.ShipName,
ShipAddress = orderPocViewModel.ShipAddress,
};
var orderDetails = new Order_Details()
{
OrderID = orderPocViewModel.OrderID,
ProductID = orderPocViewModel.ProductID,
UnitPrice = orderPocViewModel.UnitPrice,
Quantity = orderPocViewModel.Quantity,
};
try
{
db.Orders.Add(order);
db.Order_Details.Add(orderDetails);
db.SaveChanges();
return(RedirectToAction("Create"));
}
catch (Exception ex)
{
log.Error("{0} Exception:", ex);
ModelState.AddModelError("DBERROR", "新增訂單發生錯誤！");
}
}
return(View(orderPocViewModel));
}
