public OrderDetailViewModel(int orderId)
{
SelectedOrderDetail = new OrderDetailAux()
{
OrderId = orderId
};
AddOrderDetailCommand = new MyICommand(OnAddCategory, CanAddCategory);
UpdateOrderDetailCommand = new MyICommand(OnUpdateOrderDetail, CanUpdateOrderDetail);
OrderId = orderId;
LoadOrderDetail();
UpdateTotal();
//UpdateTotal();
}
public void LoadOrderDetail()
{
ObservableCollection <OrderDetailAux> orderDetails = new ObservableCollection <OrderDetailAux>();
using (MFSContext context = new MFSContext())
{
var data = from od in context.OrderDetails
join p in context.Products on od.Product.ProductId equals p.ProductId
join o in context.Orders on od.Order.OrderId equals o.OrderId
where od.Order.OrderId == SelectedOrderDetail.OrderId
select new
{
OrderDetailId = od.OrderDetailId,
Quantity = od.Quantity,
Cost = od.Cost,
ProductId = p.ProductId,
ProductName = p.Name,
OrderId = o.OrderId
};
foreach (var or in data)
{
OrderDetailAux orderDetail = new OrderDetailAux()
{
OrderDetailId = or.OrderDetailId,
ProductId = or.ProductId,
ProductName = or.ProductName,
OrderId = or.OrderId,
Quantity = or.Quantity,
Cost = or.Cost
};
orderDetails.Add(orderDetail);
}
}
OrderDetails = orderDetails;
}
