private void btnSavePicture_Click(object sender, EventArgs e) { //Store picture as an array of bytes. To do this, create a fileStream object and a binReader obj. //Set fileStream to target image in picbox. Then read bytes into array with binReader. //After array is successfully filled, gather other information about product. //Fill product object with information and then attempt to insert into database. try { //Declare product object Product aProduct = new Product(); //Declare array of bytes byte[] pic = null; //Declare file reading objects FileStream fileStream = new FileStream(fileLocation, FileMode.Open, FileAccess.Read); BinaryReader binReader = new BinaryReader(fileStream); //Read file with binary reader into pic array pic = binReader.ReadBytes((int)fileStream.Length); //Read input from form to object as well as pic array aProduct.ProductName = txtProductName.Text; aProduct.ProductDescription = txtProductDescription.Text; aProduct.Price = (float)Convert.ToDouble(txtPrice.Text); aProduct.ProductPicture = pic; command = new SqlCommand(commandStatement, connection); //Add params to command object command.Parameters.AddWithValue("@ProductName", aProduct.ProductName); command.Parameters.AddWithValue("@ProductDescription", aProduct.ProductDescription); command.Parameters.AddWithValue("@Price", aProduct.Price); command.Parameters.AddWithValue("@ProductPicture", aProduct.ProductPicture); //Open connection connection.Open(); //Attempt insert into database command.ExecuteNonQuery(); //Close connection connection.Close(); MessageBox.Show("New product successfully saved to database"); } catch (Exception ex) { MessageBox.Show("Failed to save product to database! " + ex.Message); connection.Close(); } }
private void getAssignedProducts() { try { //Gather form input int PersonID = Convert.ToInt32(txtPersonID.Text); //Select statement selecting only the products associated with the person's assigned gifts String commandStatement = "SELECT Products.ProductName, Products.Price " + "FROM AssignedGifts INNER JOIN " + "Products ON AssignedGifts.ProductID = Products.ProductID " + "WHERE (AssignedGifts.PersonID = @PersonID)"; //Add parameters SqlCommand command = new SqlCommand(commandStatement, connection); command.Parameters.AddWithValue("@PersonID", PersonID); //Read database connection.Open(); SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { Product aProd = new Product(); aProd.ProductName = reader["ProductName"].ToString(); aProd.Price = (float)Convert.ToDouble(reader["Price"]); //Put the person's gifts into the datagrid and add their prices to the list curUserPrices.Add(aProd.Price); dataGridAssignedProducts.Rows.Add(aProd.ProductName, aProd.Price.ToString("c")); } connection.Close(); } catch(Exception ex) { MessageBox.Show(ex.Message); } }