CoyoteMoves.Data_Access.RequestFormDB.UpdateRequestToApprovedStatus C# (CSharp) Method

        private bool UpdateRequestToApprovedStatus(Guid UniqueRequestID, string ApprovalDept)
        {
            SqlConnection connection = new SqlConnection(_connectionString);
            SqlCommand command = new SqlCommand("UPDATE Intern_CoyoteMoves.dbo.RequestData SET " + ApprovalDept + "=1 WHERE UniqueRequestID=@UniqueRequestID");
            command.Parameters.Add("@UniqueRequestID", SqlDbType.UniqueIdentifier).Value = UniqueRequestID;
            command.Connection = connection;
            command.Connection.Open();

            int result = command.ExecuteNonQuery();
            command.Connection.Close();

            bool theOtherDepartmentHasApproved = CheckOtherDepartmentApproval(UniqueRequestID, ApprovalDept);
            if (theOtherDepartmentHasApproved)
            {
                setTheRequestAsNotPending(UniqueRequestID);
            }

            return (result == 1);
        }