public void DeleteOrder(int ID)
{
Models.DBObjects.Order orderToDelete = dbContext.Orders.FirstOrDefault(x => x.OrderID == ID);
if (orderToDelete != null)
{
dbContext.Orders.DeleteOnSubmit(orderToDelete);
dbContext.SubmitChanges();
}
}
public void UpdateOrder(OrderModel orderModel)
{
Models.DBObjects.Order existingOrder = dbContext.Orders.FirstOrDefault(x => x.OrderID == orderModel.OrderID);
if (existingOrder != null)
{
existingOrder.OrderID = orderModel.OrderID;
existingOrder.CustomerID = orderModel.CustomerID;
existingOrder.ShopID = orderModel.ShopID;
existingOrder.StartDate = orderModel.StartDate;
existingOrder.EndDate = orderModel.EndDate;
existingOrder.CreatedDateTime = orderModel.CreatedDateTime;
existingOrder.StatusID = orderModel.StatusID;
existingOrder.Total = orderModel.Total;
dbContext.SubmitChanges();
}
}
private Models.DBObjects.Order MapModelToDbObject(OrderModel orderModel)
{
Models.DBObjects.Order dbOrderModel = new Models.DBObjects.Order();
if (orderModel != null)
{
dbOrderModel.OrderID = orderModel.OrderID;
dbOrderModel.CustomerID = orderModel.CustomerID;
dbOrderModel.ShopID = orderModel.ShopID;
dbOrderModel.StartDate = orderModel.StartDate;
dbOrderModel.EndDate = orderModel.EndDate;
dbOrderModel.CreatedDateTime = orderModel.CreatedDateTime;
dbOrderModel.StatusID = orderModel.StatusID;
dbOrderModel.Total = orderModel.Total;
return(dbOrderModel);
}
return(null);
}
private OrderModel MapDbObjectToModel(Models.DBObjects.Order dbOrder)
{
OrderModel orderModel = new OrderModel();
if (dbOrder != null)
{
orderModel.OrderID = dbOrder.OrderID;
orderModel.CustomerID = dbOrder.CustomerID;
orderModel.ShopID = dbOrder.ShopID;
orderModel.StartDate = dbOrder.StartDate;
orderModel.EndDate = dbOrder.EndDate;
orderModel.CreatedDateTime = dbOrder.CreatedDateTime;
orderModel.StatusID = dbOrder.StatusID;
orderModel.Total = dbOrder.Total;
return(orderModel);
}
return(null);
}
