Day 2 Assignment Part-2

You don’t know it yet that you have already completed it. You just need to make them viewable from page layout and you know it now how to do it.

It is again a data model configuration question to create fields.

We have to create a Inline Visualforce page to solve this problem.

And here is the controller class for this problem:

Class:

public with sharing class ListOfProfessorInUniversity {

public boolean flag{get; set;}

public string ids{get; set;}

public ListOfProfessorInUniversity(ApexPages.StandardController controller){

ids = controller.getId();

} public List<Professor__c> getAllProfessor() {

List<Course__c> allCourses = [SELECT Name, Professor_del__c, Select_University__c

FROM Course__c

WHERE Professor_del__c != NULL AND Select_University__c =: ids];

Set<Id> CourseIdList = new Set<Id>();

for (Course__c courses : allCourses) {

CourseIdList.add(courses.Professor_del__c);

}

system.debug(‘>>>>>>>>>>’ +CourseIdList);

List<Class__c> allClass = [SELECT Name, Class_Teacher__c FROM Class__c

WHERE Class_Teacher__c !=: CourseIdList OR Id IN : CourseIdList];

Set<Id> classIdList = new set<Id>();

for (Class__c classes : allClass){

classIdList.add(classes.Class_Teacher__c);

}

system.debug(‘>>>>>>>>>>’ +classIdList);

List<Professor__c> professors = [SELECT Name, email__c, Experience__c, Expertise__c FROM Professor__c

WHERE Id IN : CourseIdList OR Id IN : classIdList];

system.debug(‘*****************’ +professors);

Set<Professor__c> IdSet = new Set<Professor__c>(); idSet.addAll(professors);

system.debug(‘>>>>>>>>>>>’ + idSet);

if (NULL != IdSet){

flag = true;

}

else{

flag = false;

}

return professors;

}

}

and here is the Visualforce page for this controller:

<apex:page standardController=”St_Judes_University__c” extensions=”ListOfProfessorInUniversity”>

<apex:sectionHeader title=”All Professors Related to University”/>

<apex:outputpanel rendered=”{!flag}” > These are the students which are teached by teacher. </apex:outputpanel>

<apex:pageBlock >

<apex:pageBlockTable value=”{!AllProfessor}” var=”professor”>

<apex:column value=”{!professor.Name}”/>

<apex:column value=”{!professor.email__c}”/>

<apex:column value=”{!professor.Experience__c}”/>

<apex:column value=”{!professor.Expertise__c}”/>

</apex:pageBlockTable>

</apex:pageBlock>

</apex:page>

Now your work is done and now you just need to add the Visualforce page in the page layout section.

For this you must create the field on Student of Course mandatory and in Course the Class field make it mandatory too. That’s it your work is done.

For this you must create two Validation rules. You have made a Validation rule previously so it is not going to be a problem for you.

Now the validation rule is like this:

StartDate::: IF( ISBLANK( Start_Date__c ),true, IF ( Start_Date__c < TODAY(),true,false))

EndDate::: IF( ISBLANK( End_Date__c ),true, IF ( End_Date__c < TODAY(),true,false))

For this again you have to create validation rule:

ISBLANK( Course_select__r.Professor_del__c )

We are back on creating a inline Visualforce page. To create the Visualforce page first lets start with the controller class.

Class:

public with sharing class ListOfStudentsinClass{

public string coursesString{get;set;}

public List<Course__c> CourseName{get; set;}

public boolean flag{get;set;}

List<Course__c> CourseList = new List<Course__c>();

public ListOfStudentsinClass(ApexPages.StandardController ST){

string coursesString=ST.getId();

CourseList = [

SELECT Name, Professor_del__c, Select_University__c

FROM Course__c

WHERE Select_University__c =: coursesString

AND Professor_del__c =: NULL];

system.debug(‘>>>>>>’ +CourseList);

if ( NULL != Course__c.Professor_del__c){

flag=true;

}

else{

flag=false;

}

}

public List<Course__c> getCourses() {

return CourseList;

}

}

Now that we have our controller class we can create the Visualforce Page and it can be created like this.

(NOTE: I have already told you this is totally my perception you can modify anything by your style but do it to like at-least you fulfill the criteria and about the page you can modify it and make it more beautiful by using HTML and CSS tags. )

<apex:page standardController=”St_Judes_University__c” tabStyle=”University__c” extensions=”ListOfStudentsinClass”>

<apex:sectionHeader title=”Error”/>

<apex:outputpanel rendered=”{!flag}” > These Courses dont have professors in them. </apex:outputpanel>

<apex:pageBlock >

<apex:pageBlockTable value=”{!Courses}” var=”course”>

<apex:column value=”{!course.Name}”/>

</apex:pageBlockTable>

</apex:pageBlock>

</apex:page>

Now you have to add it in your university page layout and now you know it already how to do it.