/// <summary>
/// 新增訂單
/// </summary>
/// <param name="order"></param>
public void InsertOrder(Models.Order order)
{
using (Models.originalDB db = new Models.originalDB())
{
int max = db.Orders.Select(x => x.OrderID).Max();
order.OrderID = max + 1;
db.Orders.Add(order);
db.SaveChanges();
}
}
/// <summary>
/// 刪除訂單明細
/// </summary>
public void DeleteOrderDetailById(int orderId, int productId)
{
using (Models.originalDB db = new Models.originalDB())
{
//List<Models.OrderDetail> dbOrderDetails = db.OrderDetails.Select(x => new Models.Order { ProductID = x.ProductID, OrderID = x.OrderID }).Where(y => (y.OrderID == orderId) && (y.ProductID == productId)).ToList();
int[] par = new int[2];
par[0] = orderId;
par[1] = productId;
var deleteRow = db.OrderDetails.Find(orderId, productId);
db.OrderDetails.Remove(deleteRow);
db.SaveChanges();
}
}
/// <summary>
/// 刪除訂單
/// </summary>
public void DeleteOrderById(int orderId)
{
using (Models.originalDB db = new Models.originalDB())
{
var deleteRow = db.Orders.Find(orderId);
foreach (var orderDetail in deleteRow.OrderDetails)
{
// DeleteOrderDetailById(orderDetail.OrderID, orderDetail.ProductID);
}
// deleteRow.OrderDetails = new HashSet<Models.OrderDetail>();
db.Orders.Remove(deleteRow);
db.SaveChanges();
}
}
/// <summary>
/// 更新訂單
/// </summary>
/// <param name="訂單"></param>
public void UpdateOrder(Models.Order oneOrder)
{
using (Models.originalDB db = new Models.originalDB())
{
Models.Order dbOrders = db.Orders.Find(oneOrder.OrderID);
dbOrders.CustomerID = oneOrder.CustomerID;
dbOrders.EmployeeID = oneOrder.EmployeeID;
dbOrders.Freight = (decimal)oneOrder.Freight;
dbOrders.OrderDate = (DateTime)oneOrder.OrderDate;
dbOrders.RequiredDate = (DateTime)oneOrder.RequiredDate;
dbOrders.ShipAddress = oneOrder.ShipAddress;
dbOrders.ShipCity = oneOrder.ShipCity;
dbOrders.ShipCountry = oneOrder.ShipCountry;
dbOrders.ShipName = oneOrder.ShipName;
dbOrders.ShippedDate = oneOrder.ShippedDate;
dbOrders.ShipperID = oneOrder.ShipperID;
dbOrders.ShipPostalCode = oneOrder.ShipPostalCode;
dbOrders.ShipRegion = oneOrder.ShipRegion;
dbOrders.OrderDetails = oneOrder.OrderDetails;
var a = db.SaveChanges();
}
}