////GET PRODUCT BY ID //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///Retrieves product by ID public ProductsModel GetProductByID() { ProductsModel product = new ProductsModel(); Console.WriteLine(" +----------------------------------------------------------------+"); Console.WriteLine(" Enter your Product ID Number "); Console.WriteLine(" +----------------------------------------------------------------+"); long productID = Convert.ToInt32(Console.ReadLine()); string sqlQuery = "Select * from products where productID=@ID"; //Using SqlConnection to establish connection to database //using SqlCommand passing in the SqlConnection and the sqlQuery using (SqlConnection con = new SqlConnection(CONNECTION)) using (SqlCommand cmd = new SqlCommand(sqlQuery, con)) { con.Open(); cmd.Parameters.Add("@ID", SqlDbType.Int).Value = productID; //SqlDataReader is used because we are reading data from the database using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { product.productID = Convert.ToInt32(reader["productID"]); product.productName = reader["productName"].ToString(); product.productPrice = Convert.ToDouble(reader["productPrice"]); product.productQuantity = Convert.ToInt32(reader["productQuantity"]); product.productLocationID = Convert.ToInt32(reader["productLocationID"]); Console.WriteLine("Add Product quantity"); int amount = Convert.ToInt32(Console.ReadLine()); product.Addstock(amount); } { Console.WriteLine(); Console.WriteLine(" +================================================================+"); Console.WriteLine(" +----------------------------------------------------------------+"); Console.WriteLine(" PRODUCT ID " + " | " + productID); Console.WriteLine(" PRODUCT NAME " + " | " + product.productName); Console.WriteLine(" PRODUCT PRICE " + " | " + product.productPrice); Console.WriteLine(" PRODUCT QUANTITY " + " | " + product.productQuantity); Console.WriteLine(" PRODUCT LOCATION " + " | " + product.productLocationID); Console.WriteLine(" +----------------------------------------------------------------+"); Console.WriteLine(); } } return(product); } }