using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.PerformancePoint.Scorecards;
using Microsoft.PerformancePoint.Scorecards.Extensions;
using Microsoft.PerformancePoint.Scorecards.GridViewTransforms;

namespace Extensions.Dashboard
{

    public class FormattingTransform : IGridViewTransform
    {

        // Set the "PreRender" transform type to run the transform
        // immediately before the scorecard is rendered.
        public GridViewTransformType GetTransformType()
        {
            return GridViewTransformType.PreRender;
        }

        // Return the string idenfitier of your transform.
        public string GetId()
        {
            return "FormattingTransform";
        }

        // Run the transform. This transform changes the font and background 
        // color for all scorecards.
        public void Execute(GridViewData viewData, PropertyBag parameters, IGlobalCache cache)
        {

            // Change the default font.
            viewData.DefaultCellFormatInfo.FontInfo.FamilyName = "Cambria";

            // Change the default header background color by creating new GridColor
            // objects and then assigning them as the value for the BackColor property.
            GridColor columnHeaderBackColor = new GridColor(0xaa, 0xee, 0xff, 0xaa);
            GridColor rowHeaderBackColor = new GridColor(0xff, 0xee, 0xff, 0xcc);
            viewData.DefaultColumnHeaderFormatInfo.BackColor = columnHeaderBackColor;
            viewData.DefaultRowHeaderFormatInfo.BackColor = rowHeaderBackColor;

        }
    }
}

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.PerformancePoint.Scorecards;
using Microsoft.PerformancePoint.Scorecards.Extensions;
using Microsoft.PerformancePoint.Scorecards.GridViewTransforms;


namespace Extensions.Dashboard
{
    public class ShowAnnotationDate : IGridViewTransform
    {

        // Set transform type to "PreRender," which runs the 
        // transform immediately before the scorecard is rendered.
        public GridViewTransformType GetTransformType()
        {
            return GridViewTransformType.PreRender;
        }

        // Return the string identifier of your transform.
        public string GetId()
        {
            return "ShowAnnotationDate";
        }

        // Run the transform to show the number of days since the
        // annotation was last updated. This number is inserted
        // into an existing target KPI column in the scorecard.
        // The scorecard view is represented by the GridViewData class.
        public void Execute(GridViewData viewData, PropertyBag parameters, IGlobalCache cache)
        {

            #region Make sure "Allow Comments" is enabled

            // Check to see if the Allow Comments feature (View Options menu)
            // is enabled for the scorecard view. This example assumes that
            // there is only one scorecard in the dashboard.
            Scorecard scorecardInlocalCache = cache.GetScorecard(viewData.ScorecardId);
            ConfiguredView configuredView = scorecardInlocalCache.ConfiguredViews[0];
            if (configuredView == null || configuredView.AllowAnnotations != true)
            {
                return;
            }

            #endregion

        #region Find the "Comments" column

            // Create a placeholder object to represent the "Comment" column.
            // Row and column headers are GridHeaderItem objects.
            GridHeaderItem commentColumn = new GridHeaderItem();

            // Get the "Comment" column by finding the column headers
            // with the display text "Comment". 
            List<GridHeaderItem> allColumnHeaders = viewData.RootColumnHeader.GetAllLeafHeadersInTree();
            foreach (GridHeaderItem colHeader in allColumnHeaders)
            {
                if (colHeader.DisplayText == "Comment")
                {

                  // Set the placeholder to the "Comment" column.
                  commentColumn = colHeader;
                }
            }

            #endregion


            #region Find cells with comments and add the updated date to the "Comment" column

            // Loop through each row header.
            List<GridHeaderItem> leafRowHeaders = viewData.RootRowHeader.GetAllHeadersInTree();
            foreach (GridHeaderItem rowHeader in leafRowHeaders)
            {

               // Loop through each column header.
               List<GridHeaderItem> leafColumnHeaders = viewData.RootColumnHeader.GetAllLeafHeadersInTree();
               foreach (GridHeaderItem columnHeader in leafColumnHeaders)
               {
                    // Get the scorecard cells, which are represented by the
                    // GridCell class. Cell coordinates can be identified
                    // by the intersection of a row and column header.
                    GridCell cell = viewData.Cells[rowHeader, columnHeader];

                    // Look at only those cells that have an annotation, which
                    // contains a collection of Comment objects.
                    if (cell.HasAnnotation == true)
                    {

                        // Create the DateTime and TimeSpan objects to use to
                        // compare against the last updated DateTime object.
                        DateTime lastUpdatedDate = cell.CellAnnotation.LastUpdatedOn;
                        TimeSpan daysSinceLastUpdate = DateTime.Now - lastUpdatedDate;

                        // Create the string that will populate the cells in
                        // the "Comment" column.
                        string sTimeDiff = "";

                        // Set the string contents based on the number of
                        // days since the annotation was last updated.
                        int iTimeDiff = daysSinceLastUpdate.Days;
                        if (iTimeDiff < 0)
                        {
                            sTimeDiff = "error";
                        }
                        else
                        {
                            switch (iTimeDiff)
                            {
                                case 0:

                                    // The string "NEW" indicates that the
                                    // annotation was updated in the
                                    // last day.
                                    sTimeDiff = "NEW";
                                    break;
                                case 1:
                                    sTimeDiff = iTimeDiff.ToString() + " day";
                                    break;
                                default:
                                    sTimeDiff = iTimeDiff.ToString() + " days";
                                    break;
                            }
                        }

                        // Get the cell in the "Comment" column that
                        // corresponds to the cell with the annotation.
                        // Get these cells by passing in the "commentColumn"
                        // GridHeaderItem that was created earlier.
                        GridCell commentCell = viewData.Cells[rowHeader, commentColumn];
                        
                        // Set the GridDisplayElement.Text property used
                        // by the GridCell object for the display text
                        // of the cell.
                        foreach (GridDisplayElement cellDisplayElement in commentCell.DisplayElements)
                        {
                            cellDisplayElement.Text = sTimeDiff;
                        }
                    }
                }

            #endregion

            }
        }
    }
}