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

        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);
            }
        }

        public Collection <RequestForm> GetApprovedRequestsBetweenDates(SqlDateTime begin, SqlDateTime end)
        {
            Collection <RequestForm> requestCollection = new Collection <RequestForm>();
            SqlConnection            connection        = new SqlConnection(_connectionString);
            string     commandString = "SELECT [UniqueRequestID] FROM [Intern_CoyoteMoves].[dbo].[RequestData] WHERE [CreateDate] <= @end AND [CreateDate] >= @begin AND [Pending] = 0";
            SqlCommand command       = new SqlCommand(commandString);

            command.Parameters.AddWithValue("@begin", begin);
            command.Parameters.AddWithValue("@end", end);
            command.Connection = connection;
            connection.Open();
            SqlDataReader         reader         = command.ExecuteReader();
            SqlToFormModelFactory RequestFactory = new SqlToFormModelFactory(reader);

            while (reader.Read())
            {
                requestCollection.Add(_requester.RetrieveRequest(reader.GetGuid(reader.GetOrdinal("UniqueRequestID"))));
            }
            connection.Close();
            return(requestCollection);
        }