CoyoteMoves.Models.SqlToFormModelFactory.GetRequest C# (CSharp) Method

        public RequestForm GetRequest(Guid requestID)
        {
            if (this.reader == null)
            {
                return null;
            }

            RequestForm temp = null;
            while (this.reader.Read())
            {
                temp =  new RequestForm()
                {
                    CreatedByID = GetCreateByID(),
                    Current = MakeCurrentInfo(),
                    Future = MakeFutureInfo(),
                    EmailInfo = MakeEmailInfo(),
                    EmployeeId = GetEmployeeID(),
                    ReviewInfo = MakeReviewInfo(),
                    UniqueId = requestID,
                };
                break;
            }
            return temp;
        }

        public RequestForm RetrieveRequest(Guid uniqueRequestID)
        {
            SqlConnection connection = new SqlConnection(_connectionString);
            string commandstring = "EXEC [Intern_CoyoteMoves].[dbo].[spRequestData_GetRequestDataByUniqueID] @guid";
            SqlCommand command = new SqlCommand(commandstring);

            try
            {
                command.Parameters.AddWithValue("@guid", uniqueRequestID);
                command.Connection = connection;
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                SqlToFormModelFactory formFactory = new SqlToFormModelFactory(reader);
                return formFactory.GetRequest(uniqueRequestID);
            }

            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }