Horizontal Bar Graph Based on Task List Status Column

Ascx

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %> <%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register Tagprefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %> <%@ Import Namespace="Microsoft.SharePoint" %> <%@ Register Tagprefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="TaskStatusBGHUserControl.ascx.cs" Inherits="TaskStatusBGH.TaskStatusBGH.TaskStatusBGHUserControl" %> <asp:Panel ID="pnlBar" runat="server"> </asp:Panel> <asp:Label ID="lblMessage" runat="server"></asp:Label>

Ascx.cs

using System; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using Microsoft.SharePoint; using System.Security; namespace TaskStatusBGH.TaskStatusBGH {     public partial class TaskStatusBGHUserControl : UserControl     {         int AllItemsCount;         protected void Page_Load(object sender, EventArgs e)         {             try             {                 AllItemsCount = getAllItemsCount();                 double InProgressCount = getStatusCount("In Progress");                 double CompletedCount = getStatusCount("Completed");                 double DeferredCount = getStatusCount("Deferred");                 double waitingonSomeOneElseCount = getStatusCount("Waiting on someone else");                 string strBarGraph = "";                 strBarGraph += "<Table width='100%' cellpading='0' cellspacing='0'>";                 strBarGraph += "<Tr>";                 strBarGraph += "<Td width='20%'>";                 strBarGraph += "<Strong>";                 strBarGraph += "In Progress";                 strBarGraph += "</Strong>";                 strBarGraph += "</Td>";                 strBarGraph += "<Td>";                 strBarGraph += "<Div style='background-color:Yellow;height:10px;width:" + InProgressCount + "%'></Div>";                 strBarGraph += "</Td>";                 strBarGraph += "</Tr>";                 strBarGraph += "<Tr>";                 strBarGraph += "<Td width='20%'>";                 strBarGraph += "<Strong>";                 strBarGraph += "Completed";                 strBarGraph += "</Strong>";                 strBarGraph += "</Td>";                 strBarGraph += "<Td>";                 strBarGraph += "<Div style='background-color:Yellow;height:10px;width:" + CompletedCount + "%'></Div>";                 strBarGraph += "</Td>";                 strBarGraph += "</Tr>";                 strBarGraph += "<Tr>";                 strBarGraph += "<Td width='20%'>";                 strBarGraph += "<Strong>";                 strBarGraph += "Deferred";                 strBarGraph += "</Strong>";                 strBarGraph += "</Td>";                 strBarGraph += "<Td>";                 strBarGraph += "<Div style='background-color:Yellow;height:10px;width:" + DeferredCount + "%'></Div>";                 strBarGraph += "</Td>";                 strBarGraph += "</Tr>";                 strBarGraph += "<Tr>";                 strBarGraph += "<Td width='20%'>";                 strBarGraph += "<Strong>";                 strBarGraph += "Waiting on someone else";                 strBarGraph += "</Strong>";                 strBarGraph += "</Td>";                 strBarGraph += "<Td>";                 strBarGraph += "<Div style='background-color:Yellow;height:10px;width:" + waitingonSomeOneElseCount + "%'></Div>";                 strBarGraph += "</Td>";                 strBarGraph += "</Tr>";                 strBarGraph += "</Table>";                 pnlBar.Controls.Add(new LiteralControl(strBarGraph));             }             catch (Exception ex)             {                 lblMessage.Text = ex.ToString();             }         }         public double getStatusCount(string strStatus)         {             double TotalCount = 0;             try             {                 double StatusItemCount = 0;                 SPWeb currentWeb = SPContext.Current.Web;                 SPList lst = currentWeb.Lists["Tasks"];                 SPQuery sQuery = new SPQuery();                 sQuery.Query = "<Where><Eq><FieldRef Name='Status' /><Value Type='Choice'>"+strStatus.ToString().ToLower()+"</Value></Eq></Where>";                 SPListItemCollection myColl = lst.GetItems(sQuery);                 if (myColl.Count > 0)                 {                     StatusItemCount = myColl.Count;                     TotalCount = Math.Round((double)((StatusItemCount / AllItemsCount) * 100),2);                 }                             }             catch (Exception ex)             {                 lblMessage.Text = ex.ToString();                             }             return TotalCount;         }         public int getAllItemsCount()         {             int count = 0;             try             {                 SPWeb currentWeb = SPContext.Current.Web;                 SPList lst = currentWeb.Lists["Tasks"];                 SPListItemCollection myColl = lst.Items;                 if (myColl.Count > 0)                 {                     count = myColl.Count;                 }             }             catch (Exception ex)             {                 lblMessage.Text = ex.ToString();             }             return count;         }     } }