Click here to Skip to main content
6,822,123 members and growing! (18,966 online)
Email Password   helpLost your password?
Enterprise Systems » SharePoint Server » Web Parts     Intermediate License: The Code Project Open License (CPOL)

Calendar Web Part for SharePoint that displays and gives fetails of events from an event list

By Isha Attlee

A custom Calendar WebPart which highlights the dates with events pulled from an event list.
C#, ASP.NET, Ajax, Dev
Revision:2 (See All)
Posted:27 Mar 2008
Updated:27 Apr 2008
Views:37,983
Bookmarked:28 times
printPrint   add Share
      Discuss Discuss   Broken Article?Report  
5 votes for this article.
Popularity: 1.46 Rating: 2.09 out of 5
2 votes, 40.0%
1
2 votes, 40.0%
2

3

4
1 vote, 20.0%
5

New_CAL.JPG

Introduction

This is a calendar part which displays events from an existing event list (dates highlighted), and also provides details about an event on the click of the event date.

Background

To create this WebPart, I chose the ASP.NET Calendar control and has overridden its OndayRender method to give colors to the dates with events.

The SharePoint object model (Microsoft.sharepoint.dll) is then used to pull the event details, displayed on the click of the date.

There are two classes used:

  1. A class to highlight the event dates and to give colors to the dates of the calendar (e.g., gray for weekends).
  2. A WebPart to create and render the Calender control and to display the event details pulled from the event list, on click of the highlighted date.

Using the code

Steps to create the Calendar class:

  1. Create a C# class library project in ASP.NET.
  2. Name it as WebPart_Calendar.
  3. Name the class CustomCalendar.
  4. Add these libraries to the project:
    • System.web.UI.Webcontrols,
    • System.Drawing,
    • System.Data,
    • Microsoft.Sharepoint.dll, and others if needed.

Use the following code to give colors for weekend dates, dates of other months, and dates with events. In the code below, events are pulled from an event list named Team Calendar (you can change the list name if you wan to).

namespace WebPart_Calendar
{
    public class CustomCalendar : System.Web.UI.WebControls.Calendar
    {
        protected override void OnDayRender(TableCell cell, CalendarDay day)
        {
            if (day.IsToday)
            {
                cell.Attributes.Add("style", 
                  "font-weight:bold;background:#cee7ff;");
            }
            else if (day.IsWeekend)
            {
                cell.BackColor = System.Drawing.Color.LightGray;
            }
            else if (day.IsOtherMonth)
            {
                cell.BackColor = System.Drawing.Color.LightGray;
            }
            else
            {
                SPSite siteCollection = SPContext.Current.Site;
                SPList calendarList = 
                  siteCollection.RootWeb.Lists["Team Calendar"];
                // Construct a query that expands recurring events
                SPQuery query = new SPQuery();
                query.ExpandRecurrence = true;
                query.CalendarDate = day.Date;
                query.Query = "EventDate FieldName<where>" + 
                      "<eq><fieldref name="""\""">" + 
                      "<value type="""\""">" + 
                      day.Date.ToString("yyyy-MM-ddTHH\\:mm\\:ssZ") + 
                      "</value></eq></where>";

                // Returns all items that would appear
                // in the calendar view for the current day
                SPListItemCollection calendarItems = 
                                     calendarList.GetItems(query);

                if(calendarItems.Count > 0){
                    cell.BackColor = System.Drawing.Color.Khaki;
                    cell.Attributes.Add("style", "font-weight:bold;");
                }
            }
        }
    }

Build the project to get WebPart_Calendar.dll.

Steps to create a Webpart class:

  1. Create a Webpart Template Project (New -> Project-> C#-> SharePoint -> WebPart).
  2. Name it SPWebPart_Calendar.
  3. Add a reference to these libraries:
    • System.web.UI.Webcontrols
    • System.Drawing
    • System.Data
    • And, WebPart_Calendar.dll

The code goes below:

namespace SPWebPart_Calendar 
{ 
    [Guid("7cd9a020-6a9d-4765-8138-ed85d648e553")] 
    public class WebPart_Calendar_Class : 
           System.Web.UI.WebControls.WebParts.WebPart 
    { 
        CustomCalendar cal; 
        Label lbl; 

        public WebPart_Calendar_Class() 
        { 
            this.ExportMode = WebPartExportMode.All; 
        } 

        protected override void Render(HtmlTextWriter writer) 
        { 
            EnsureChildControls(); 
            cal.RenderControl(writer); 
            lbl.RenderControl(writer); 
        } 

        protected override void CreateChildControls() 
        { 
            cal = new CustomCalendar(); 
            this.cal.ID = "Calendar1"; 
            this.cal.CellPadding = 5; 
            this.cal.CellSpacing = 2; 
            this.cal.BorderColor = System.Drawing.Color.LightGray; 
            this.cal.TitleStyle.BackColor = 
              System.Drawing.ColorTranslator.FromHtml("#f2f2f2"); 
            this.cal.TitleStyle.ForeColor = 
              System.Drawing.ColorTranslator.FromHtml("#6c6b6b"); 
            this.cal.DayHeaderStyle.ForeColor = 
              System.Drawing.ColorTranslator.FromHtml("#818080"); 
            this.cal.DayStyle.ForeColor = 
              System.Drawing.ColorTranslator.FromHtml("#9f9e9e"); 
            this.cal.OtherMonthDayStyle.ForeColor = 
              System.Drawing.ColorTranslator.FromHtml("#CCCCCC"); 
            this.cal.OtherMonthDayStyle.BackColor = 
              System.Drawing.ColorTranslator.FromHtml("#f2f2f2"); 
            this.Controls.Add(cal); 
            lbl = new Label(); 
            this.lbl.ID = "Label1"; 

            this.lbl.Visible = false; 
            this.lbl.EnableViewState = false; 
            this.Controls.Add(lbl); 
            this.cal.SelectionChanged += new EventHandler(cal_SelectionChanged); 
        } 

        protected void cal_SelectionChanged(object sender, EventArgs e) 
        { 
            //this.lbl.Text = this.cal.SelectedDate.Date.ToShortDateString(); 
            SPSecurity.CodeToRunElevated listEvents = 
              new SPSecurity.CodeToRunElevated(delegate() 
              { RenderEventsByDate(this.cal.SelectedDate); }); 
            SPSecurity.RunWithElevatedPrivileges(listEvents); 
            //RenderEventsByDate(this.cal.SelectedDate); 
            this.lbl.Visible = true; 
        } 

        public void RenderEventsByDate(DateTime selectedDate) 
        { 
            //Get the calendar events for that day 
            SPSite siteCollection = SPContext.Current.Site; 

            SPList calendarList = 
              siteCollection.RootWeb.Lists["Team Calendar"]; 

            // Construct a query that expands recurring events 
            SPQuery query = new SPQuery(); 
            query.ExpandRecurrence = true; 
            query.CalendarDate = selectedDate; 
            query.Query = "EventDate FieldName <where />" + 
               "<eq><fieldref name="""\""" />" + 
               "<value type="""\""" />" + 
               selectedDate.ToString("yyyy-MM-ddTHH\\:mm\\:ssZ") + 
               "</value></eq></where>"; 
            query.ViewFields = " Fields to View fromEvent List";
            SPListItemCollection calendarItems = calendarList.GetItems(query); 

            foreach (SPListItem item in calendarItems) 
            { 
                this.lbl.Text += item["Title"] + ": starts " + 
                     item["EventDate"].ToString() + " and ends " + 
                     item["EndDate"].ToString() + ""; 
            } 
            //If there are no events, display the message 
            if (String.IsNullOrEmpty(this.lbl.Text)) 
                this.lbl.Text = " There are no events for this date "; 
        } 
    } 
}

Finally, deploy the WebPart as a solution. Here is how to deploy this as a solution package: http://programmingsharepoint.blogspot.com/2008/03/deploy-webpart-as-solution-package.html. For more details, see: http://programmingsharepoint.blogspot.com/.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

Isha Attlee


Member

Occupation: Software Developer (Senior)
Location: United States United States

Other popular SharePoint Server articles:

Article Top
You must Sign In to use this message board.
FAQ FAQ 
 
Noise Tolerance  Layout  Per page   
 Msgs 1 to 12 of 12 (Total in Forum: 12) (Refresh)FirstPrevNext
GeneralMy vote of 1 [modified] Pinmemberlwp85021018:43 29 Oct '09  
GeneralRe: My vote of 1 Pinmembersilverstars21:15 31 Oct '09  
GeneralErrors :( Pinmembersilverstars3:27 29 Oct '09  
GeneralUnexpected Charactor Pinmemberkrishna36919:36 28 Oct '09  
GeneralAgregar un Calendar y asociar los eventos a una lista de SP Pinmemberedudebolivar7:00 22 Oct '08  
GeneralOne Question About Calendar Types. Pinmemberhdv2127:11 9 Oct '08  
Generalcode not built due to error... PinmemberKuldeep Kadyan3:22 6 May '08  
General[Message Deleted] Pinmembersubanboy6:29 7 May '08  
GeneralRe: code not built due to error... PinmemberKuldeep Kadyan20:27 7 May '08  
GeneralRe: code not built due to error... Pinmemberedudebolivar6:59 22 Oct '08  
GeneralRe: code not built due to error... Pinmemberkrishna36919:38 28 Oct '09  
GeneralRe: code not built due to error... Pinmemberedudebolivar10:52 31 Oct '09  

General General    News News    Question Question    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads.

PermaLink | Privacy | Terms of Use
Last Updated: 27 Apr 2008
Editor: Smitha Vijayan
Copyright 2008 by Isha Attlee
Everything else Copyright © CodeProject, 1999-2010
Web19 | Advertise on the Code Project