Display the report based on passing the values

create procedure usp_commdish (@month int,@year int)
as
begin

if (@month is null and @year is null)
begin
select count(*),uname,commission_type,
convert(int,datepart(day,date_paid)) as Day,
convert(int,datepart(mm,date_paid) ) as Month,
convert(int,datepart(yyyy,date_paid)) as Year from commissions_dish
WHERE commission_type in ('DVR','DVRBONUS','HD_DVR')
AND payment_amount >= 0
AND uname is not null
--AND datepart(month,date_paid)
--AND datepart(YEAR,DATE_PAID)
group by uname,commission_type,date_paid
end




else if (@month is null)
begin
select count(*),uname,commission_type,
convert(int,datepart(day,date_paid)) as Day,
convert(int,datepart(mm,date_paid) ) as Month,
convert(int,datepart(yyyy,date_paid)) as Year
from commissions_dish
WHERE commission_type in ('DVR','DVRBONUS','HD_DVR')
AND payment_amount >= 0
AND uname is not null
--AND datepart(month,date_paid) =@month
AND datepart(YEAR,DATE_PAID) = @year
group by uname,commission_type,date_paid
end
else if (@year is null)
begin
select count(*),uname,commission_type,
convert(int,datepart(day,date_paid)) as Day,
convert(int,datepart(mm,date_paid) ) as Month,
convert(int,datepart(yyyy,date_paid)) as Year
from commissions_dish
WHERE commission_type in ('DVR','DVRBONUS','HD_DVR')
AND payment_amount >= 0
AND uname is not null
AND datepart(month,date_paid) =@month
--AND datepart(YEAR,DATE_PAID) = @year
group by uname,commission_type,date_paid
end
else
begin
select count(*),uname,commission_type,
convert(int,datepart(day,date_paid)) as Day,
convert(int,datepart(mm,date_paid) ) as Month,
convert(int,datepart(yyyy,date_paid)) as Year
from commissions_dish
WHERE commission_type in ('DVR','DVRBONUS','HD_DVR')

AND payment_amount >= 0
AND uname is not null
AND datepart(month,date_paid) =@month
AND datepart(YEAR,DATE_PAID) = @year
group by uname,commission_type,date_paid
end
end