Database

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
   {

if (e.Day.Date < DateTime.Today)
        {

            e.Day.IsSelectable = false;

e.Cell.ForeColor = System.Drawing.Color.Gray;
       }
       else
       {
           e.Cell.ForeColor = System.Drawing.Color.Green;
       }

WITH months (num) as(
		SELECT 1
		UNION ALL 
		SELECT num+1
		FROM months
		WHERE num<12)SELECT m.num as Month,
							--isnull(t.count,0) as Total,
							isnull(t.resolved,0) as Totalresolved,  
							t.YearValue as YearData FROM months m
					left join (SELECT month(ProgramStartedDate) as Month,YEAR(ProgramStartedDate) as YearValue,
								--count(*) as count,
								
								
								
								sum(case when (ProgrammerStatus = 1 OR ReviewerStatus = 1)  THEN 1 ELSE 0 END)as resolved  
								FROM tb_ProgramCheckList 
								LEFT JOIN dbo.tb_ProgramDetails on 
								tb_ProgramDetails.ProgramID =tb_ProgramCheckList.ProgramID AND tb_ProgramDetails.Version=tb_ProgramCheckList.VersionID
							   WHERE ProgramStartedDate >='10/1/2012' 
								and ProgramStartedDate <'10/01/2013' --AND month(ProgramStartedDate)=m.num  
								GROUP BY month(ProgramStartedDate),YEAR(ProgramStartedDate)