All --

I am quite new to creating Apex classes and test methods so please be gentle.  I have been coming through posts on the forms and trying to follow some of the cookbook examples but I have not been able to figure htis out.  I have created an extension controller to get some support information that relates to an account.  Here is the code for the controller extension:

public class ServicesExtension {

    public ServicesExtension(ApexPages.StandardController controller) {

    }

        Public Integer getCaseCount(){
                return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id')];
        }
        Public Integer getCaseCountOpen(){
                return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = false];

        }
        Public Integer getCaseCountOpenThisYear(){
                return [Select Count() from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = true and CreatedDate = THIS_YEAR];

        }
        Public Case getLastOpenCase(){
                return [Select Id, CaseNumber, Subject, CreatedDate from Case where AccountId= :System.currentPageReference().getParameters().get('id') and isClosed = false Order By CreatedDate desc limit 1];
        }

}

And I have the following created for the test method:

@isTest
private class ServicesExtentionTests {

    static testMethod void myUnitTest() {
    
    Account testAccount = new Account();
    testAccount.Name = 'Echo360 Test Company';
    testAccount.Classroom_Management_System__c='Blackboard';
	testAccount.Name='My Test Company';
	testAccount.Type='Customer';
	insert testAccount;
	
	Case testCase = new Case();
	testCase.Subject = 'My Test Case';
	testCase.Status = 'Open';
	testCase.AccountId = testAccount.Account_ID__c;
	insert testCase;

	PageReference pageRef = Page.AccountSummary;
    Test.setCurrentPage(pageRef);
    ApexPages.currentPage().getParameters().put('id', testAccount.id);
    
    ServicesExtension acctController = new ServicesExtension(new ApexPages.StandardController(testAccount));
    Account updatedAccount = [select Classroom_Management_System__c, name, type FROM account where id = :testAccount.Id];
    system.assertEquals('Blackboard', updatedAccount.Classroom_Management_System__c);
    system.assertEquals('My Test Company', updatedAccount.Name);
    system.assertEquals('Customer', updatedAccount.Type);
    
    ServicesExtension caseController = new ServicesExtension(new ApexPages.StandardController(testCase));
    integer caseCount = caseController.getCaseCount();
    Case updatedCase = [Select Subject, Status, AccountID from Case.ID where AccountId = :testCase.Id];
    system.assertEquals('My Test Case', updatedCase.Subject);
    system.assertEquals('Open', updatedCase.Status);
    }	        
}

The code coverage is only 27% and I think that this is because I am not covering the 3 count queries I have in the controller and the last open case query.  I am not sure how I would test this for these types of queries.

Again if this is something that is APEX 101 for many of you I am sorry.

Thanks,

Wes