public void LoadForSoldWindow() { try { cmd = new SqlCommand(); con.Open(); cmd.Connection = con; //location table cmd.CommandText = "SELECT * FROM Inventory.Product WHERE productId = @Id"; cmd.Parameters.AddWithValue("@Id", UpdateProdId); _reader = cmd.ExecuteReader(); if (_reader.Read()) { //add image to the last node LtProducts.AddLast(new Product(Base64ToImage(_reader["prodImage"].ToString()), _reader["prodName"].ToString(), Convert.ToDouble(_reader["prodPrice"].ToString()), Convert.ToInt32(_reader["prodQty"].ToString()))); } _reader.Close(); } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { con.Close(); } }
public int PrepareProductToUpdate() { try { cmd = new SqlCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "SELECT [product].prodImage ,[product].prodName ,[product].prodPrice, [product].prodShelfLife,[location].name,[supplier].suppName, [supplier].contactNumber FROM Inventory.Product AS product INNER JOIN Inventory.Supplier AS supplier ON [product].Supplier = [supplier].suppId INNER JOIN Inventory.Location AS location ON [location].locaId = [product].Location WHERE [product].productId = @PRODUCT_ID"; cmd.Parameters.AddWithValue("@PRODUCT_ID", UpdateProdId); _reader = cmd.ExecuteReader(); if (_reader.Read()) { LtProducts.AddLast(new Product(Base64ToImage(_reader["prodImage"].ToString()), _reader["prodName"].ToString(), double.Parse(_reader["prodPrice"].ToString()), _reader["name"].ToString(), _reader["prodShelfLife"].ToString(), _reader["suppName"].ToString(), _reader["contactNumber"].ToString())); } return(0); } catch (SqlException e) { Console.WriteLine(e.ToString()); return(1); } finally { con.Close(); } }