Introduction to Object-Oriented Programming

Hello Community,

I’m attempting to use one SOQL query to get many data point that can be displayed on a Visualforce page. My query returns the expected results but I am not sure of how to parse through the query results and assign them to variables. My thought was that I could simply loop through the results and, based on the conditions, assign them to variables with getters. This does not generate an error, but my page will not return anything when calling {!MembershipsYTD}. if someone could help point me in the right direction it would be greatly appreciated.

public class MDEventResults
{

// Properties
public integer ThisMonth = date.today().month();
public integer MembershipsYTD {get; set;}
public integer MembershipsMTD {get; set;}

// Query Event Data
List EventAgg = [SELECT Sum(Total_Memberships__c) MembershipSum, count(ID) CNT, Calendar_month(Event_Date__c) Month, Facilitated_by_MD__c FacilitatedBy, Booked_By__c BookedBy,
GROUPING (Facilitated_by_MD__C) FacilGroup, GROUPING (Booked_By__c) BookedGroup, GROUPING (Event_Date__c) monthGroup
FROM Campaign
// WHERE Booked_by__r.id = :UserInfo.getUserid()//
WHERE End_Date_Time__c = This_Year
// AND Status = ‘Completed’ //
GROUP BY ROLLUP (Facilitated_by_MD__c , Booked_By__c, Event_Date__c)];

// method to parse results
public void MembershipsYTD() {
for (AggregateResult ar : EventAgg) {
if (integer.valueOf(ar.get(‘monthGroup’ )) == ThisMonth &&
integer.valueOf(ar.get(‘BookedGroup’)) == 1 &&
integer.valueOf(ar.get(‘FacilGroup’ )) == 1)
{
MembershipsYTD = integer.valueOf(ar.get(‘MembershipSum’));
system.debug(‘MembershipsYTD’ + MembershipsYTD);
}
}

}
}

OOP is very interesting and can empower so many novice programmers….I wish I had more time to learn!!
Im thinking of going full time study, 6 months of intense Java learning and Apex, then start an exciting job.
Who dares wins!