private void LoadProduct(HomeWindow para) { this.HomeWindow = para; this.HomeWindow.stkProducts.Children.Clear(); List <Product> products = new List <Product>(); string query = "SELECT * FROM Product"; products = DataProvider.Instance.DB.Products.SqlQuery(query).ToList(); foreach (Product product in products) { if (product.IsDelete == false) { ProductControlUC control = new ProductControlUC(); control.txbID.Text = product.ID.ToString(); control.txbName.Text = product.Name; control.txbUnit.Text = product.Unit; control.txbImportPrice.Text = ConvertToString(product.ImportPrice); control.txbPrice.Text = ConvertToString(product.ExportPrice); control.txbCount.Text = ConvertToString(product.Count); this.HomeWindow.stkProducts.Children.Add(control); } } }
private void EditProduct(ProductControlUC para) { Product product = new Product(); int id = int.Parse(para.txbID.Text); product = (Product)DataProvider.Instance.DB.Products.Where(x => x.ID == id).First(); ImageBrush imageBrush = new ImageBrush(); imageBrush.ImageSource = Converter.Instance.ConvertByteToBitmapImage(product.Image); AddProductWindow window = new AddProductWindow(); window.txtID.Text = product.ID.ToString(); window.txtName.Text = product.Name; window.txtName.SelectionStart = window.txtName.Text.Length; window.txtUnit.Text = product.Unit; window.txtUnit.SelectionStart = window.txtUnit.Text.Length; window.txtPrice.Text = ConvertToString(product.ExportPrice); window.txtPrice.SelectionStart = window.txtPrice.Text.Length; window.Title = "Update info product"; window.grdImage.Background = imageBrush; if (window.grdImage.Children.Count != 0) { window.grdImage.Children.Remove(window.grdImage.Children[0]); window.grdImage.Children.Remove(window.grdImage.Children[0]); } window.ShowDialog(); }
private void DeleteProduct(ProductControlUC para) { Product product = new Product(); int id = int.Parse(para.txbID.Text); product = (Product)DataProvider.Instance.DB.Products.Where(x => x.ID == id).First(); product.IsDelete = true; DataProvider.Instance.DB.Products.AddOrUpdate(product); DataProvider.Instance.DB.SaveChanges(); this.HomeWindow.stkProducts.Children.Remove(para); }
private void ImportProduct(ProductControlUC para) { Product product = new Product(); int productID = int.Parse(para.txbID.Text); int stockReceiptID; product = DataProvider.Instance.DB.Products.Where(x => x.ID == productID).First(); try { stockReceiptID = DataProvider.Instance.DB.StockReceipts.Max(p => p.ID) + 1; } catch { stockReceiptID = 1; } ImageBrush imageBrush = new ImageBrush(); imageBrush.ImageSource = Converter.Instance.ConvertByteToBitmapImage(product.Image); ImportProductWindow window = new ImportProductWindow(); window.txtID.Text = product.ID.ToString(); window.txtStockReceiptID.Text = stockReceiptID.ToString(); window.txtProductName.Text = product.Name; window.txtProductName.SelectionStart = window.txtProductName.Text.Length; window.txtUnit.Text = product.Unit; window.txtUnit.SelectionStart = window.txtUnit.Text.Length; window.txtImportPrice.Text = ConvertToString(product.ImportPrice); window.txtImportPrice.SelectionStart = window.txtImportPrice.Text.Length; window.txtAmount.Text = ConvertToString(product.Count); window.txtAmount.SelectionStart = window.txtAmount.Text.Length; window.grdImage.Background = imageBrush; if (window.grdImage.Children.Count != 0) { window.grdImage.Children.Remove(window.grdImage.Children[0]); window.grdImage.Children.Remove(window.grdImage.Children[0]); } window.Title = "Import exits product"; window.ShowDialog(); }