public void LoadSaleDetail() { ObservableCollection <SaleDetailAux> saleDetails = new ObservableCollection <SaleDetailAux>(); using (MFSContext context = new MFSContext()) { var data = from sd in context.SaleDetails where sd.Sale.SaleId == SelectedSaleDetail.SaleId select new { SaleDetailId = sd.SaleDetailId, Quantity = sd.Quantity, SellPrice = sd.SellPrice, ProductId = sd.Product.ProductId, ProductName = sd.Product.Name, SaleId = sd.Sale.SaleId }; foreach (var sa in data) { SaleDetailAux saleDetail = new SaleDetailAux() { SaleDetailId = sa.SaleDetailId, ProductId = sa.ProductId, ProductName = sa.ProductName, SaleId = sa.SaleId, Quantity = sa.Quantity, SellPrice = sa.SellPrice }; saleDetails.Add(saleDetail); } } SaleDetails = saleDetails; }
public SaleDetailViewModel(int saleId) { SelectedSaleDetail = new SaleDetailAux() { SaleId = saleId }; AddSaleDetailCommand = new MyICommand(OnAddCategory, CanAddCategory); UpdateSaleDetailCommand = new MyICommand(OnUpdateSaleDetail, CanUpdateSaleDetail); SaleId = saleId; LoadSaleDetail(); UpdateTotal(); //UpdateTotal(); }