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