private void ValorCombobox(ref ICollectionView cv) { string textFilter = TextBoxSearchBar.Text; if (!string.IsNullOrEmpty(textFilter)) { switch (((ComboBoxItem)ComboBoxSearch.SelectedItem).Content) { case "Nombre": cv.Filter = o => { ProductAux C = o as ProductAux; return(C.Name.ToUpper().StartsWith(textFilter.ToUpper())); }; break; case "Categoria": cv.Filter = o => { ProductAux C = o as ProductAux; return(C.Category.ToUpper().StartsWith(textFilter.ToUpper())); }; break; } } else { cv.Filter = o => { ProductAux C = o as ProductAux; return(C.Remove == 0); }; } }
private void OnUpdateProduct() { if (!ProductValidation()) { return; } using (MFSContext context = new MFSContext()) { Product product = new Product(); if (SelectedProduct.Id != 0) { product = context.Products.Include(p => p.Category).Single(p => p.ProductId == SelectedProduct.Id); } product.Name = SelectedProduct.Name; product.MinStock = SelectedProduct.MinStock; product.Category = context.Categories.Find(SelectedProduct.CategoryId); product.SellPrice = SelectedProduct.SellPrice; product.Mesurement = context.Measurements.Find(SelectedProduct.MeasurementId); context.Entry(product).State = SelectedProduct.Id == 0 ? EntityState.Added : EntityState.Modified; context.SaveChanges(); LoadProduct(); SelectedProduct = new ProductAux(); } }
public ProductViewModel() { UpdateProductCommand = new MyICommand(OnUpdateProduct, CanUpdateProduct); SelectedProduct = new ProductAux(); AddProductCommand = new MyICommand(OnAddCategory, CanAddCategory); LoadProduct(); //ChangeCategory = new MyICommand(OnChangeCategory, CanChangeCategory); }
public void LoadProduct() { ObservableCollection <ProductAux> products = new ObservableCollection <ProductAux>(); using (MFSContext context = new MFSContext()) { var data = from p in context.Products where p.Remove != 1 select new { Id = p.ProductId, Name = p.Name, CategoryId = p.Category.CategoryId, Category = p.Category.CategoryName, MinStock = p.MinStock, Remove = p.Remove, SellPrice = p.SellPrice, MeasurementId = p.Mesurement.MeasurementId, MeasurementName = p.Mesurement.Name, Cost = (context.OrderDetails.Where(o => o.Product.ProductId == p.ProductId && o.Remove != 1).Count() != 0) ? context.OrderDetails.Where(o => o.Product.ProductId == p.ProductId && o.Remove != 1).Average(o => o.Cost) : 0, Stock = (context.OrderDetails.Where(o => o.Product.ProductId == p.ProductId && o.Remove != 1).Count() != 0) ? (context.SaleDetails.Where(s => s.Product.ProductId == p.ProductId && s.Remove != 1).Count() != 0) ? context.OrderDetails.Where(o => o.Product.ProductId == p.ProductId && o.Remove != 1).Sum(o => o.Quantity) - context.SaleDetails.Where(s => s.Product.ProductId == p.ProductId && s.Remove != 1).Sum(s => s.Quantity) : context.OrderDetails.Where(o => o.Product.ProductId == p.ProductId && o.Remove != 1).Sum(o => o.Quantity) : 0 }; // MessageBox.Show(Convert.ToString(context.OrderDetails.First().Product.ProductId)); foreach (var pro in data) { ProductAux product = new ProductAux(); product.Id = pro.Id; product.Name = pro.Name; product.CategoryId = pro.CategoryId; product.Category = pro.Category; product.MinStock = pro.MinStock; product.SellPrice = pro.SellPrice; product.MeasurementId = pro.MeasurementId; product.Measurementname = pro.MeasurementName; product.Cost = pro.Cost; product.Stock = pro.Stock; product.Remove = pro.Remove; products.Add(product); } } Products = products; }
private void DataGridProducts_MouseDoubleClick(object sender, MouseButtonEventArgs e) { ProductAux product = DataGridProducts.SelectedItem as ProductAux; if (product == null) { return; } if (OrderDetailView != null) { OrderDetailView.TextBoxProductId.Text = Convert.ToString(product.Id); OrderDetailView.TextBoxProductName.Text = product.Name; this.Close(); } if (SaleDetailView != null) { SaleDetailView.TextBoxProductId.Text = Convert.ToString(product.Id); SaleDetailView.TextBoxProductName.Text = product.Name; SaleDetailView.TextBoxSellPrice.Text = string.Format("{0:0.00}", product.SellPrice).Replace(",", ".");//Convert.ToString(product.SellPrice); this.Close(); } }
private void OnAddCategory() { SelectedProduct = new ProductAux(); //OnPropertyChanged("SelectedProduct"); }