SQL Server C#

person_id (PK, int)
person_firstName(nvarchar)
person_lastName(nvarchar)
person_gender(nvarchar)
person_birth(date)

sqlConnection.Open();
            Console.Write("Search for a person by his or her's ID: ");
            int id = int.Parse(Console.ReadLine());
            SqlCommand cmd = new SqlCommand("SELECT * FROM Person WHERE @id = person_id", sqlConnection);
            using (SqlDataReader reader = cmd.ExecuteReader())
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        if (reader.Equals(id))
                        {
                            Console.Clear();
                            Console.WriteLine($"Person with ID {reader.GetInt32(0)} found!\n");
                        }
                    }
                    Console.Write("Press any key to return to the menu. . .");
                    Console.ReadKey();
                }
                else
                {
                    Console.Clear();
                    Console.WriteLine("No person was found, did you enter correct value?\n");
                    Console.Write("Press any key to return to the menu. . .");
                    Console.ReadKey();
                }
                sqlConnection.Close();
            }

CREATE PROCEDURE [dbo].[spAddPerson]
	(
	@person_firstname nvarchar(30),
	@person_lastname nvarchar(30),
	@person_gender nvarchar(30),
	@person_birth date,
	@person_id INT OUT
	)
AS
BEGIN
INSERT INTO Person VALUES(@person_firstname, @person_lastname, @person_gender, @person_birth)
SELECT @person_id = SCOPE_IDENTITY()
END

Person addPerson = new Person();
            string connString = ConfigurationManager.ConnectionStrings["connectToDataBase"].ConnectionString;
            string storedProcedure = "spAddPerson";
            using(SqlConnection dbConn = new SqlConnection(connString))
            {
                SqlCommand cmd = new SqlCommand(storedProcedure, dbConn);
                cmd.CommandType = CommandType.StoredProcedure;

                addPerson.FirstName = UserInputHandler.FirstName();
                addPerson.LastName = UserInputHandler.LastName();
                addPerson.Gender = UserInputHandler.Gender();
                addPerson.Birth = UserInputHandler.Birth();

                cmd.Parameters.AddWithValue("@person_firstname", addPerson.FirstName);
                cmd.Parameters.AddWithValue("@person_lastname", addPerson.LastName);
                cmd.Parameters.AddWithValue("@person_gender", addPerson.Gender);
                cmd.Parameters.AddWithValue("@person_birth", addPerson.Birth);

                SqlParameter outputParam = new SqlParameter();
                outputParam.ParameterName = "@person_id";
                outputParam.SqlDbType = SqlDbType.Int;
                outputParam.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(outputParam);

                try
                {
                    dbConn.Open();
                    cmd.ExecuteNonQuery();
                    PrintText.PrintSuccessfullyAdded();
                }
                catch
                {
                    PrintText.PrintSomethingWentWrong();
                }
                finally
                {
                    dbConn.Close();
                }

CREATE PROCEDURE [dbo].[spSearchForPerson]
	(
	@PersonID INT
	)
AS
BEGIN
SELECT * 
FROM Person
WHERE @PersonID = Person.person_id
END

string storedProcedure = "spSearchForPerson";
            using (SqlConnection dbConn = new SqlConnection(connString))
            {
                SqlCommand cmd = new SqlCommand(storedProcedure, dbConn);
                cmd.CommandType = CommandType.StoredProcedure;

                int personID = UserInputHandler.PersonID();

                SqlParameter outputParam = new SqlParameter();
                outputParam.ParameterName = "@person_id";
                outputParam.SqlDbType = SqlDbType.Int;
                outputParam.Direction = ParameterDirection.Output;
                cmd.Parameters.Add(outputParam);
                try
                {
                    dbConn.Open();
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                Console.WriteLine(
                                    $"{reader.GetValue(0)}, " +
                                    $"{reader.GetValue(1)}, " +
                                    $"{reader.GetValue(2)}, " +
                                    $"{reader.GetValue(3)}, " +
                                    $"{reader.GetDateTime(4)}"
                                    );
                            }
                            PrintText.PrintReturnToMenu();
                        }
                        else
                        {
                            PrintText.PrintNoRowsWereFound();
                        }
                    }
                }
                catch(Exception msg)
                {
                    Console.Clear();
                    Console.WriteLine(msg);
                    Console.ReadKey();
                }
                finally
                {
                    dbConn.Close();
                }
            }