public static bool UpdateCustomer(Customer oldCustomer, Customer newCustomer) { // create a connection MySqlConnection connection = MMABooksDB.GetConnection(); string updateStatement = "UPDATE Customers SET " + "Name = @NewName, " + "Address = @NewAddress, " + "City = @NewCity, " + "State = @NewState, " + "ZipCode = @NewZipCode " + "WHERE CustomerID = @OldCustomerID " + "AND Name = @OldName " + "AND Address = @OldAddress " + "AND City = @OldCity " + "AND State = @OldState " + "AND ZipCode = @OldZipCode"; // setup the command object MySqlCommand updateCommand = new MySqlCommand(updateStatement, connection); updateCommand.Parameters.AddWithValue( "@newName", newCustomer.Name); updateCommand.Parameters.AddWithValue( "@newAddress", newCustomer.Address); updateCommand.Parameters.AddWithValue( "@newCity", newCustomer.City); updateCommand.Parameters.AddWithValue( "@newState", newCustomer.State); updateCommand.Parameters.AddWithValue( "@newZipCode", newCustomer.ZipCode); updateCommand.Parameters.AddWithValue( "@oldCustomerID", oldCustomer.CustomerID); updateCommand.Parameters.AddWithValue( "@oldName", oldCustomer.Name); updateCommand.Parameters.AddWithValue( "@oldAddress", oldCustomer.Address); updateCommand.Parameters.AddWithValue( "@oldCity", oldCustomer.City); updateCommand.Parameters.AddWithValue( "@oldState", oldCustomer.State); updateCommand.Parameters.AddWithValue( "@oldZipCode", oldCustomer.ZipCode); try { // open the connection connection.Open(); // execute the command int updateCommandReturn = updateCommand.ExecuteNonQuery(); // if the number of records returned = 1, return true otherwise return false if (updateCommandReturn == 1) { return(true); } } catch (MySqlException ex) { // throw the exception throw ex; } finally { // close the connection connection.Close(); } return(false); }