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();
 }