private void UpdateProducts()
{
SqlConnection con = Database.DatabaseLocator.GenerateConnection.GenerateNewConnection();
SqlDataAdapter sda1 = new SqlDataAdapter("SELECT * From [PRODUCT]", con);
DataTable dt = new DataTable();
sda1.Fill(dt);
con.Open();
ViewModels.ViewModelLocator.MainWindowViewModel.ProductList.Clear();
for (int x = 0; x < dt.Rows.Count; x++)
{
Classes.PRODUCT newProduct = new Classes.PRODUCT();
newProduct.ID = Convert.ToInt16(dt.Rows[x]["ID"]);
newProduct.ProductName = dt.Rows[x]["ProductName"].ToString();
newProduct.GenericName = dt.Rows[x]["GenericName"].ToString();
newProduct.Type = dt.Rows[x]["Type"].ToString();
newProduct.Form = dt.Rows[x]["Form"].ToString();
newProduct.BuyingPrice = Convert.ToDecimal(dt.Rows[x]["BuyingPrice"]);
newProduct.SellingPrice = Convert.ToDecimal(dt.Rows[x]["SellingPrice"]);
newProduct.Quantity = Convert.ToInt16(dt.Rows[x]["Quantity"]);
ViewModels.ViewModelLocator.MainWindowViewModel.ProductList.Add(newProduct);
}
con.Close();
}
public ORDER(int iD, PRODUCT orderProduct, int quantity)
{
ID = iD;
OrderProduct = orderProduct;
Quantity = quantity;
}