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