Hi all,

Below is my apex class and test class , After count3 query in countyrating pagereference method my coverage is red. I am unable to cover if else statement. Please help me Thanks in advance.

public class SalesTacticsClass {
public boolean ex {get;set;}
public boolean ex1 {get;set;}
public boolean ex2 {get;set;}
public boolean ex3 {get;set;}
public double i;
public list<Counties__c> counties{get;set;}
public Sales_Tactics__c SalesTactic{get;set;}
public Counties__c count2{get;set;}
public Counties__c count3 {get;set;}
public ApexPages.StandardController myStdController;
public List<selectOption> dateList1 {get;set;}
public recordtype rt {get;set;}
public Monsanto_Organizations__c district {get;set;}
public String queryString {get;set;}
public String dateName1{get;set;}
public string test1{get;set;}
public Sales_Plans__c sp{get;set;}
public Sales_Tactics__c st{get;set;}
public string pickvalue {get;set;}
public string mypickvalue {get;set;}
public List<Sales_Tactics__c> SalesTactics = new List<Sales_Tactics__c>();
public Map<Id,String> districtID = new Map<Id,String>() ;
public Map<Id,String> salesplan = new Map<Id,String>();
ID Recordtypeid;

public SalesTacticsClass(ApexPages.StandardController StdController) {
this.SalesTactic = new Sales_Tactics__c();
rt= new recordtype ();
counties= new list<Counties__c>();
count2= new Counties__c();
rt= [select name, id from recordtype where name=:'Distribution Tactics'];
SalesTactic= new Sales_Tactics__c();
SalesTactic.Sales_Plan_SFID__c=ApexPages.currentPage().getParameters().get('CF00N3000000BhWhI_lkid');

sp = [SELECT id,name,Sales_Plan_Year_SFID__c,District_Org_SFID__c from Sales_Plans__c
where id = :ApexPages.currentPage().getParameters().get('CF00N3000000BhWhI_lkid') ] ;


district = [select name,Org_Cd__c from Monsanto_Organizations__c where id =: sp.District_Org_SFID__c];

counties = [select name, id, Distirct_Org_Cd__c, County_Rating__c from Counties__c
where (Distirct_Org_Cd__c =:district.Org_Cd__c) ORDER BY name ASC] ;


}

public List<SelectOption> getMyOptions123(){
list<selectOption> dateList1 = new List<selectOption>();
for(Counties__c c: counties){

test1 = string.valueof(c.name);
dateList1.add(new Selectoption(test1,test1));
}
system.debug('::::::::::::::::::+++;;;;;;;;;;;;;;'+dateList1);
return datelist1;
}

public PageReference countyrating() {

count3 =[select name, id, County_Rating__c from Counties__c
where name=:SalesTactic.Distribution_County_Name__c and Distirct_Org_Cd__c=:district.name];
if (count3.County_Rating__c == Null)
i = 0;
else
i=double.valueof(count3.County_Rating__c);

if(i <= 1.5)
{
ex=true;
ex1=false;
ex2=false;
ex3=false;
}
else if(i>=1.501&&i<=2)
{
ex=false;
ex1=true;
ex2=false;
ex3=false;
}
else if(i>=2.01&&i<=3)
{
ex=false;
ex1=false;
ex2=true;
ex3=false;
}
else if(i>=3.01)
{
ex=false;
ex1=false;
ex2=false;
ex3=true;
}

system.debug(':::::::::::::::::54;;;;;;;;;;;;;;'+count3.County_Rating__c);
return null;}

public PageReference save1(){
salestactic.recordtypeid=rt.id; //'01230000001D6ib';
salestactic.Overall_Distribution_Rtg__c=count3.County_Rating__c ;
insert SalesTactic;
/*
count2 = [select name, id, Distirct_Org_Cd__c, Distribution_Rating__c, County_Rating__c from Counties__c
where name=:salestactic.Distribution_County_Name__c and Distirct_Org_Cd__c=:district.name];

salestactic.Overall_Distribution_Rtg__c=count2.County_Rating__c ;

update SalesTactic;*/

return (new ApexPages.StandardController(SalesTactic)).view();
}
}

//////////////test class///////////////////

@isTest
private class testDistributionTactic{
@isTest
private static void testDistributionTactic()
{

Periods__c P=new Periods__c();
P.Name='Tes Period';
P.Period_Level_Descr__c='Year';
Datetime d=system.now();
P.Period_ID__c='2090';
insert P;


Map <String,Schema.RecordTypeInfo> recordTypesadjustment = Monsanto_Organizations__c.sObjectType.getDescribe().getRecordTypeInfosByName();
Id RecTypeIdinadj = recordTypesadjustment.get('Agronomist').getRecordTypeId();
Monsanto_Organizations__c M=new Monsanto_Organizations__c();
M.Name='Test Name';
M.Org_Cd__c='Test Org';
M.Fiscal_Year_SFID__c=P.id;
M.RecordTypeId=RecTypeIdinadj;
M.Org_Description__c='Tes OrgDescription';
M.Org_Key_Cd__c='Text';
insert M;

Map <String,Schema.RecordTypeInfo> recordTypesadjustment_ST = Sales_Plans__c.sObjectType.getDescribe().getRecordTypeInfosByName();
RecTypeIdinadj = recordTypesadjustment_ST.get('District Sales Plan').getRecordTypeId();

Sales_Plans__c sp = new Sales_Plans__c ();
sp.Name='Name';
sp.District_Org_SFID__c=M.id;
insert sp;


Map <String,Schema.RecordTypeInfo> recordTypesadjustment_Spp = Sales_Tactics__c.sObjectType.getDescribe().getRecordTypeInfosByName();
RecTypeIdinadj = recordTypesadjustment_Spp.get('Distribution Tactics').getRecordTypeId();

Sales_Tactics__c SalesTactics = new Sales_Tactics__c();
SalesTactics.Sales_Plan_SFID__c = sp.id;
salestactics.recordtypeid='01230000001D6ib';
SalesTactics.Distribution_County_Name__c='cname';
salestactics.Overall_Distribution_Rtg__c='6';
insert SalesTactics;



Counties__c c=new Counties__c();
C.name='cname';
c.Distirct_Org_Cd__c='test name';
C.County_Rating__c ='6';

insert C;



double i = double.valueof(c.County_Rating__c);
system.debug('_______________________________________'+i);
ApexPages.StandardController sc = new ApexPages.standardController(SalesTactics);
ApexPages.currentPage().getParameters().put('CF00N3000000BhWhI_lkid', sp.id);
SalesTacticsClass ST=new SalesTacticsClass (sc);
ST.getMyOptions123();
ST.countyrating();
ST.save1();


}}