public void AddNewProduct() { AddNewProductWindow productWindow = new AddNewProductWindow(); productWindow.Owner = Application.Current.MainWindow; productWindow.WindowStartupLocation = WindowStartupLocation.CenterOwner; PRODUCT prod = new PRODUCT(); productWindow.DataContext = prod; var result = productWindow.ShowDialog(); if (result == true) { productList.Add(prod); } }
public void RefreshProduct() { SqlConnection con = SQLCONNECTION.GetConnection(); SqlDataAdapter sda = new SqlDataAdapter("SELECT * From [PRODUCT]", con); DataTable dt = new DataTable(); sda.Fill(dt); ProductList.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { PRODUCT prod = new PRODUCT(); prod.ProductID = Convert.ToInt16(dt.Rows[i]["Product_ID"]); prod.ProductName = dt.Rows[i]["Product_Name"].ToString(); prod.ProductType = dt.Rows[i]["Product_Type"].ToString(); prod.Quantity = Convert.ToInt16(dt.Rows[i]["Quantity"]); prod.Measurement = dt.Rows[i]["Measurement"].ToString(); prod.OriginalPrice = Convert.ToDouble(dt.Rows[i]["Original_Price"]); prod.SellingPrice = Convert.ToDouble(dt.Rows[i]["Selling_Price"]); ProductList.Add(prod); } }