Querying from domain class

[sarava77]

Hi,

I am suggest how to write query for below scenario.

In Controller:
bookstoreCont.bookapply(new list<Bookstore__c> { bookstoreIns });

In Domain
public static void bookapply(list<Bookstore__c> bookstoreInsPraram)
{
list<Bookstore__c> bookStroeList=new list<Bookstore__c>();
//This is the place where i am facing problem.
bookStroeList=[select id,Name from Bookstore__c where Email__c=:bookstoreInsPraram.Email__c];
}

Because I can't query directly by using the list variable . so i need to convert to single instance and then I need to use in the where condition to query the record. Is there any other way to achieve this without creating one more variable.

Thanks,

[afawcett]

I'm trying to understand your code here, so let me tell you how i've interpreted the above to arrive at my recommendation...

• The 'bookapply' method does not look like a Domain class method. Since it is static and Domain class methods are instance level methods working on the Records property in conjunction with parameters passed in and i don't see this either.
• Normally the Controller calls a Service class method, so is this what 'bookapply' method is?
• So if the 'bookappy' method is really a Service class method, what is the purpose of it in a business sense? Is it to take a list of Email addresses and query for BookStore__c records?

If so, you should have three classes, controller > service class > selector class. In this case you don't strictly need a Domain class at this stage, though see my note below.

public class BookStoreController {
    public PageReference bookApply()
    {
         List<String> emails = null; // < Get list of Emails from view state?
         try {
              BookStoreService.bookApply(emails);
         } catch (Exception e) {
              ApexPages.addMessage(e):
        }
    }
}

public class BookStoreService {
    public static void bookApply(Set<String> emailAddresses) {
        List<BookStore__c> bookStores = 
             new BookStoresSelector().selectByEmail(emailAddresses);
        // Do something with the bookStores?
        // ...
     }
}

public class BookStoresSelector extends fflib_SObjectSelector {
    // See documentation for full example of methods to implement
    // ....

    public List<BookStore__c> selectByEmail(Set<String> emails) {
        assertIsAccessible();
        return Database.query(
            String.format('SELECT {0} FROM {1} WHERE Email__c in :emails ORDER BY {2}', 
            new List<String>{getFieldListString(),getSObjectName(),getOrderBy()}));
    }
}

You may wish to create a BookStores Domain class (especially if you have an Apex Trigger on this object). In which case you could encapsulate the behaviour of the bookApply logic in such a class and then call the BookStores Domain class from the Service method above. So the flow would be BookStoreController.bookApply > BookStoreService.bookApply > BookStoresSelector.selectByEmail > BookStores.bookApply

[afawcett]

Let me know if you want to continue to discuss, hopefully this moved things along for you! 👍