コード例 #1
0
ファイル: frmTarget.cs プロジェクト: prakash3129/CM
        void Load_Agent_Data()
        {
            try
            {
                lblPanelHeader.Text       = "Overall Statistics <br/>(" + GM.GetDateTime().ToString("MMMM") + ")";
                dtAgentSummary            = GV.MSSQL1.BAL_ExecuteQuery(GetQuery.AgentSummary(GV.sEmployeeName));
                dtDaily_Agent_Perfoemance = GV.MSSQL1.BAL_FetchTable("RM..DAILY_AGENT_PERFORMANCE_V1", "DASHBOARD_ID = " + GV.sDashBoardID + " AND FLAG='" + GV.sAccessTo + "' AND AGENTNAME = '" + GV.sEmployeeName + "' AND DATECALLED = '" + GM.GetDateTime().ToString("yyyyMMdd") + "'");
                if (dtAgentSummary.Rows.Count > 0)
                {
                    lblMonthlyPoints.Text = "<b>" + dtAgentSummary.Rows[0]["MTDPOINTS"].ToString() + "</b> point(s) accumulated this month.";
                    //lblYesterDaysPoint.Text = dtAgentSummary.Rows[0]["YESTERDAYPOINTS"].ToString();
                    lblTargetAchived.Text = "Goal accomplished for <b>" + dtAgentSummary.Rows[0]["TA_CNT"] + "</b> day(s) this month.";
                    lblTargetMissed.Text  = "Goal not achieved for <b>" + dtAgentSummary.Rows[0]["TM_CNT"] + "</b> day(s) this month.";
                }
                else
                {
                    lblMonthlyPoints.Text = "<b>0.00</b> point(s) accumulated this month.";
                    lblTargetAchived.Text = "Goal accomplished for <b>0</b> day(s) this month.";
                    lblTargetMissed.Text  = "Goal not achieved for <b>0</b> day(s) this month.";
                }

                if (dtDaily_Agent_Perfoemance.Rows.Count > 0 && dtDaily_Agent_Perfoemance.Rows[0]["SELF_TARGET"].ToString().Length > 0)
                {
                    txtTarget.Value   = Convert.ToInt32(dtDaily_Agent_Perfoemance.Rows[0]["SELF_TARGET"].ToString());
                    txtTarget.Enabled = false;
                    btnTarget.Visible = false;
                }
                else//By default empty.
                {
                    txtTarget.Text = string.Empty;
                }

                if (GV.sUserType != "Agent")
                {
                    btnTarget.Enabled = false;
                }

                pictureDP.Image   = GV.imgEmployeeImage;
                lblEmpName.Text   = ProperCaseHelper.NameANDJobTitleCasing(GV.sEmployeeActualName.ToLower(), "Name");
                lblUpload.Visible = false;
                lblUpload.Parent  = pictureDP;
                lblUpload.Dock    = DockStyle.Bottom;
            }
            catch (Exception ex)
            {
                GM.Error_Log(System.Reflection.MethodBase.GetCurrentMethod(), ex, true, true);
                //MessageBoxEx.Show(ex.Message, "Campaign Manager", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
コード例 #2
0
        void OverAllPerformance_FillGrid()
        {
            if (dtOverallPerformence != null && dtOverallPerformence.Rows.Count > 0)
            {
                DataRow[] drrTenure   = dtOverallPerformence.Select("EmployeeNo = '" + GV.sEmployeeNo + "'");
                string    sTenure     = string.Empty;
                string    sHeaderRank = string.Empty;
                string    sShowType   = btnShowAllMTD.Text;
                DataRow[] drrOverall;
                if (drrTenure.Length > 0)
                {
                    sTenure = drrTenure[0]["Tenure"].ToString();
                }

                if (sShowType == "Show Peer")
                {
                    if (drrTenure.Length > 0)
                    {
                        sHeaderRank = drrTenure[0]["OVERALLRANKING"].ToString();
                    }
                    else
                    {
                        sHeaderRank = "-";
                    }

                    drrOverall = dtOverallPerformence.Select("1=1", "OVERALLRANKING ASC");
                }
                else
                {
                    if (drrTenure.Length > 0)
                    {
                        sHeaderRank = drrTenure[0]["TenurebasedRanking"].ToString();
                        drrOverall  = dtOverallPerformence.Select("Tenure='" + sTenure + "'", "TenurebasedRanking ASC");
                    }
                    else
                    {
                        drrOverall  = dtOverallPerformence.Select("1=1", "OVERALLRANKING ASC");
                        sHeaderRank = "-";
                        ToastNotification.Show(this, "You are not found in any Peer.");
                        btnShowAllMTD.Text = "Show All";
                    }
                }

                if (drrTenure.Length > 0)
                {
                    sdgvOverallPerformance.PrimaryGrid.Header.Text = "<div align = 'Right'><font size = '13'><b>Month to Date Performance</b></font><br/> <font size = '11'>You are <b>" + sHeaderRank + "</b> out of <b>" + drrOverall.Length + "</b></font></div>";
                }
                else
                {
                    sdgvOverallPerformance.PrimaryGrid.Header.Text = "<div align = 'Right'><font size = '13'><b>Month to Date Performance</b></font></div>";
                }

                lblTenure.Text = "Tenure: <b>" + sTenure.Replace("&", "&amp;") + "</b>";

                if (sdgvOverallPerformance.PrimaryGrid != null && sdgvOverallPerformance.PrimaryGrid.Rows != null)
                {
                    sdgvOverallPerformance.PrimaryGrid.Rows.Clear();
                }

                foreach (DataRow dr in drrOverall)
                {
                    Image     img;
                    DataRow[] drrImage = dtImages.Select("EmployeeID = '" + dr["EmployeeNo"] + "'");
                    if (drrImage.Length > 0)
                    {
                        byte[]       bStream = (byte[])drrImage[0]["EmployeeImage"];
                        MemoryStream ms      = new MemoryStream(bStream);
                        img = Image.FromStream(ms);
                    }
                    else
                    {
                        img = GCC.Properties.Resources.Misc_User_icon__1_;
                    }


                    GridCell gr0 = new GridCell(img);
                    gr0.EditorParams = new object[] { ImageSizeMode.Zoom };

                    string sHTMLValue = string.Empty;

                    sHTMLValue += "<font size = '10' face = 'Arial' ><div align = 'Left'> <div  align = 'left'><font size = '15' face = 'Arial' color ='CornflowerBlue'><b>" + ProperCaseHelper.NameANDJobTitleCasing(dr["AgentFullname"].ToString().ToLower(), "Name") + "</b></font></div>";
                    sHTMLValue += "<div align = 'right'>Points :<font size = '12' face = 'Arial' color ='IndianRed'><b>" + dr["MTDPOINTS"] + "</b></font></div>";
                    if (sShowType == "Show Peer")
                    {
                        sHTMLValue += "<div align = 'left'>Peer Rank &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["TenurebasedRanking"] + "</b></font></div>";
                    }
                    else
                    {
                        sHTMLValue += "<div align = 'left'>MTD Rank &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
                    }

                    sHTMLValue += "<font size = '9'><div align = 'left'>Tenure &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: " + dr["Tenure"].ToString().Replace("&", "&amp;") + "</div>";
                    sHTMLValue += "<div align = 'left'>Contacts Achieved &nbsp;&nbsp;: " + dr["AchievedContacts"] + "</div>";


                    //sHTMLValue += "<div>Company Processed : " + dr["NO_OF_CONTACTS_VALIDATED"] + "</div>";
                    if (sShowType == "Show Peer")
                    {
                        sHTMLValue += "<div align = 'right'>MTD Rank &nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div></font> </div></font>";
                    }
                    else
                    {
                        sHTMLValue += "<div align = 'right'>Peer Rank &nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["TenurebasedRanking"] + "</b></font></div></font> </div></font>";
                    }



                    //sHTMLValue += "<font size = '10' face = 'Arial' ><div align = 'Left'> <div  align = 'left'><font size = '15' face = 'Arial' color ='CornflowerBlue'><b>" + ProperCaseHelper.NameANDJobTitleCasing(dr["AgentFullname"].ToString().ToLower(), "Name") + "</b></font></div>";
                    //sHTMLValue += "<div align = 'right'>Points :<font size = '12' face = 'Arial' color ='IndianRed'><b>" + dr["MTDPOINTS"] + "</b></font></div>";
                    //if (sShowType == "Show Peer")
                    //    sHTMLValue += "<div align = 'left'>Peer Rank &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["TenurebasedRanking"] + "</b></font></div>";
                    //else
                    //    sHTMLValue += "<div align = 'left'>MTD Rank &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";

                    //sHTMLValue += "<font size = '9'><div align = 'left'>Tenure &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: " + dr["Tenure"].ToString().Replace("&", "&amp;") + "</div>";
                    //sHTMLValue += "<div align = 'left'>Contacts Achieved &nbsp;&nbsp;: " + dr["AchievedContacts"] + "</div>";

                    //sHTMLValue += "<table><tr><td>abcd</td><td>def</td></tr></table>";



                    GridCell gr1 = new GridCell();
                    //DevComponents.DotNetBar.SuperGrid.Style.Background b;
                    //switch (dr["Tenure"].ToString())
                    //{
                    //    case "1 Month":
                    //        b = new DevComponents.DotNetBar.SuperGrid.Style.Background(Color.LightCyan);
                    //        break;

                    //    case "2 Months":
                    //        b = new DevComponents.DotNetBar.SuperGrid.Style.Background(Color.BlanchedAlmond);
                    //        break;

                    //    case "3 Months":
                    //        b = new DevComponents.DotNetBar.SuperGrid.Style.Background(Color.FromArgb(255, 197, 242, 203));
                    //        break;

                    //    case "4 & 5 Months":
                    //        b = new DevComponents.DotNetBar.SuperGrid.Style.Background(Color.MistyRose);
                    //        break;

                    //    case "6 Months & Above":
                    //        b = new DevComponents.DotNetBar.SuperGrid.Style.Background(Color.Wheat);
                    //        break;

                    //    case "Not Qualified":
                    //        b = new DevComponents.DotNetBar.SuperGrid.Style.Background(Color.Tomato);
                    //        break;

                    //    default:
                    //        b = new DevComponents.DotNetBar.SuperGrid.Style.Background(Color.White);
                    //        break;
                    //}
                    //gr1.CellStyles.Default.Background = b;
                    //gr0.CellStyles.Default.Background = b;
                    //gr1.EditorType = typeof(GridTextBoxXEditControl);
                    //gr1.RenderType = typeof(GridTextBoxXEditControl);
                    gr1.Value = sHTMLValue;

                    //GridCell gr1 = new GridCell(ProperCaseHelper.NameANDJobTitleCasing(dr[0].ToString().ToLower(), "Name"));

                    GridRow gr = new GridRow();
                    gr.Cells.Add(gr0);
                    gr.Cells.Add(gr1);
                    sdgvOverallPerformance.PrimaryGrid.Rows.Add(gr);
                }
            }
            else
            {
                sdgvOverallPerformance.PrimaryGrid.Header.Text = "<div align = 'Right'><font size = '13'><b>Month to Date Performance</b></font></div>";
            }
        }
コード例 #3
0
        private void TeamPerformance_Load(object sender, EventArgs e)
        {
            try
            {
                lblUpload.Parent  = pictureDP;
                lblUpload.Dock    = DockStyle.Bottom;
                pictureDP.Image   = GV.imgEmployeeImage;
                lblUpload.Visible = false;
                //lblUpload.Width = pictureDP.Width;
                Load_Agent_Data();

                lblAgentName.Text      = ProperCaseHelper.NameANDJobTitleCasing(GV.sEmployeeActualName, "Name");
                lblCurrentProject.Text = "Current Project: <b>" + GV.sProjectName.Replace("_", " ") + "</b>";
                lblEmpID.Text          = "Employee ID: <b>" + GV.sEmployeeNo + "</b>";
                if (GV.sAccessTo == "TR")
                {
                    lblResearchType.Text = "Research Type: <b>Voice</b>";
                }
                else
                {
                    lblResearchType.Text = "Research Type: <b>Web</b>";
                }
                lblUserType.Text = "User Type: <b>" + GV.sUserType + "</b>";


                //if (GlobalVariables.sDashBoardID.Length > 0)
                {
                    //DataTable dtAgentWisePerformence = GV.MSSQL.BAL_ExecuteQuery("SELECT U.Fullname,SELF_TARGET,NO_OF_CONTACTS_VALIDATED,U.DateOfJoin, LastSeen FROM DAILY_AGENT_PERFORMANCE D INNER JOIN Timesheet.dbo.USERS U ON D.AGENTNAME = U.UserName WHERE D.DASHBOARD_ID=" + GlobalVariables.sDashBoardID + " AND U.Active = 'Y' AND DATECALLED='"+GlobalMethods.GetDateTime().ToString("yyyyMMdd")+"'");
                    //DataTable dtAgentWisePerformence = GV.MSSQL.BAL_ExecuteQuery("SELECT U.Fullname,SELF_TARGET,NO_OF_CONTACTS_VALIDATED,CASE WHEN DATEDIFF(YEAR, DateOfJoin,GETDATE())>1 THEN CONVERT(VARCHAR(100), DATEDIFF(YEAR, DateOfJoin,GETDATE())) +' Years' WHEN DATEDIFF(YEAR, DateOfJoin,GETDATE())=1 THEN CONVERT(VARCHAR(100), DATEDIFF(YEAR, DateOfJoin,GETDATE())) +' Year' WHEN (DATEDIFF(YEAR, DateOfJoin,GETDATE())<1 AND DATEDIFF(MONTH, DateOfJoin,GETDATE())>1)  THEN CONVERT(VARCHAR(100), DATEDIFF(MONTH, DateOfJoin,GETDATE())) +' Months' WHEN (DATEDIFF(YEAR, DateOfJoin,GETDATE())<1 AND DATEDIFF(MONTH, DateOfJoin,GETDATE())=1)  THEN CONVERT(VARCHAR(100), DATEDIFF(MONTH, DateOfJoin,GETDATE())) +' Month' WHEN (DATEDIFF(YEAR, DateOfJoin,GETDATE())<1 AND DATEDIFF(MONTH, DateOfJoin,GETDATE())<1)  THEN CONVERT(VARCHAR(100), DATEDIFF(DAY, DateOfJoin,GETDATE())) +' Days' END Tenure, LastSeen FROM DAILY_AGENT_PERFORMANCE D INNER JOIN Timesheet.dbo.USERS U ON D.AGENTNAME = U.UserName WHERE D.DASHBOARD_ID=174 AND U.Active = 'Y' AND DATECALLED='" + GlobalMethods.GetDateTime().ToString("yyyyMMdd") + "'");
                    //byte[] image = ReadImageFile(@"C:\Users\thangaprakashm\Desktop\Road\3759007_orig.jpg");
                    // Image img = Image.FromFile(@"C:\Users\thangaprakashm\Desktop\Road\3759007_orig.jpg");
                    dtImages = GV.MSSQL_RM.BAL_ExecuteQuery("SELECT A.* FROM RM..EmployeeImage A INNER JOIN CH1020BD02.Timesheet.DBO.Users B ON A.EmployeeID = B.EmployeeNo WHERE B.Active = 'Y'");
                    Load_ProjectPerformance();
                    Load_OverAllPerformance();
                    GridPanel panel1 = sdgvProjectPerformance.PrimaryGrid;
                    GridPanel panel2 = sdgvOverallPerformance.PrimaryGrid;

                    GridColumn column1 = panel1.Columns["Photo"];
                    GridColumn column2 = panel2.Columns["Photo"];

                    GridImageEditControl gc1 = column1.EditControl as GridImageEditControl;
                    GridImageEditControl gc2 = column1.RenderControl as GridImageEditControl;
                    gc1.ImageSizeMode = ImageSizeMode.Zoom;
                    gc2.ImageSizeMode = ImageSizeMode.Zoom;


                    GridImageEditControl gc11 = column2.EditControl as GridImageEditControl;
                    GridImageEditControl gc21 = column2.RenderControl as GridImageEditControl;
                    gc11.ImageSizeMode = ImageSizeMode.Zoom;
                    gc21.ImageSizeMode = ImageSizeMode.Zoom;

                    //superGridControl1.PrimaryGrid.Columns[1].CellStyles.Default.Font = new Font("Microsoft Sans Serif", 18, FontStyle.Bold);


                    splitContainerGrids.SplitterDistance = (splitContainerGrids.Size.Width / 2);
                    sdgvProjectPerformance.PrimaryGrid.Columns[0].FillWeight = 30;
                    sdgvProjectPerformance.PrimaryGrid.DefaultRowHeight      = 140;

                    sdgvOverallPerformance.PrimaryGrid.Columns[0].FillWeight = 30;
                    sdgvOverallPerformance.PrimaryGrid.DefaultRowHeight      = 140;

                    sdgvProjectPerformance.PrimaryGrid.Columns[1].Width = splitContainerGrids.Panel1.Width; // -135;

                    sdgvOverallPerformance.PrimaryGrid.Columns[1].Width = splitContainerGrids.Panel2.Width; // -135;
                }

                //if ((Screen.PrimaryScreen.WorkingArea.Width - (sdgvProjectPerformance.PrimaryGrid.Columns[1].Width + sdgvOverallPerformance.PrimaryGrid.Columns[1].Width) - 100) > 600)
                //    panelInformation.Width = 600;
                //else if ((Screen.PrimaryScreen.WorkingArea.Width - (sdgvProjectPerformance.PrimaryGrid.Columns[1].Width + sdgvOverallPerformance.PrimaryGrid.Columns[1].Width) - 100) < 470)
                //{
                //    panelInformation.Width = Screen.PrimaryScreen.WorkingArea.Width - (sdgvProjectPerformance.PrimaryGrid.Columns[1].Width + sdgvOverallPerformance.PrimaryGrid.Columns[1].Width) - 100;
                //    panelInformation.Width = 490;

                //}
                //else
                //    panelInformation.Width = Screen.PrimaryScreen.WorkingArea.Width - (sdgvProjectPerformance.PrimaryGrid.Columns[1].Width + sdgvOverallPerformance.PrimaryGrid.Columns[1].Width) - 100;

                //panelInformation.Height = this.Height- 80;
                ////panelInformation.Height = sdgvOverallPerformance.Height + 80;
            }
            catch (Exception ex)
            {
                GM.Error_Log(System.Reflection.MethodBase.GetCurrentMethod(), ex, true, true);
                //MessageBoxEx.Show(ex.Message, "Campaign Manager", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
コード例 #4
0
        void ProjectPerformance_FillGrid()
        {
            if (dtProjectPerformence != null && dtProjectPerformence.Rows.Count > 0)
            {
                DataRow[] drrTenure   = dtProjectPerformence.Select("EmployeeNo = '" + GV.sEmployeeNo + "'");
                string    sTenure     = string.Empty;
                string    sHeaderRank = string.Empty;
                string    sShowType   = btnShowAllProject.Text;
                DataRow[] drrProject;

                if (drrTenure.Length > 0)
                {
                    sTenure = drrTenure[0]["Tenure"].ToString();
                }

                if (sShowType == "Show Peer")
                {
                    if (drrTenure.Length > 0)
                    {
                        sHeaderRank = drrTenure[0]["OVERALLRANKING"].ToString();
                    }
                    else
                    {
                        sHeaderRank = "-";
                    }
                    drrProject = dtProjectPerformence.Select("1=1", "OVERALLRANKING ASC");
                }
                else
                {
                    if (drrTenure.Length > 0)
                    {
                        sHeaderRank = drrTenure[0]["TenurebasedRanking"].ToString();
                        drrProject  = dtProjectPerformence.Select("Tenure='" + sTenure + "'", "TenurebasedRanking ASC");
                    }
                    else
                    {
                        drrProject  = dtProjectPerformence.Select("1=1", "OVERALLRANKING ASC");
                        sHeaderRank = "-";
                        ToastNotification.Show(this, "You are not found in any of the bucket.");
                        btnShowAllProject.Text = "Show All";
                    }
                }

                if (drrTenure.Length > 0)
                {
                    sTenure = drrTenure[0]["Tenure"].ToString();
                    sdgvProjectPerformance.PrimaryGrid.Header.Text = "<div align = 'Right'><font size = '13'><b>Project Performance</b></font><br/> <font size = '11'>You are <b>" + sHeaderRank + "</b> out of <b>" + drrProject.Length + "</b></font></div>";
                    //lblProjectPostiton.Text = "You are <b>" + GM.NumberSuffix(drrTenure[0]["Ranking"].ToString()) + "</b> out of <b>" + dtAgentWisePerformence.Rows.Count + "</b>";
                }
                else
                {
                    sdgvProjectPerformance.PrimaryGrid.Header.Text = "<div align = 'Right'><font size = '13'><b>Project Performance</b></font></div>";
                }

                lblTenure.Text = "Tenure: <b>" + sTenure.Replace("&", "&amp;") + "</b>";

                if (sdgvProjectPerformance.PrimaryGrid != null && sdgvProjectPerformance.PrimaryGrid.Rows != null)
                {
                    sdgvProjectPerformance.PrimaryGrid.Rows.Clear();
                }


                foreach (DataRow dr in dtProjectPerformence.Rows)
                {
                    Image     img;
                    DataRow[] drrImage = dtImages.Select("EmployeeID = '" + dr["EmployeeNo"] + "'");
                    if (drrImage.Length > 0)
                    {
                        img = GM.GetImageFromByte(((byte[])drrImage[0]["EmployeeImage"]));
                    }
                    else
                    {
                        img = GCC.Properties.Resources.Misc_User_icon__1_;
                    }

                    GridCell gr0 = new GridCell(img);
                    ///gr0.InfoText = "asjdgajsdgas";
                    gr0.EditorParams = new object[] { ImageSizeMode.Zoom };

                    string sHTMLValue = string.Empty;

                    sHTMLValue += "<font size = '10' face = 'Arial' ><div align = 'Left'> <div  align = 'left'><font size = '15' face = 'Arial' color ='CornflowerBlue'><b>" + ProperCaseHelper.NameANDJobTitleCasing(dr["AgentFullName"].ToString().ToLower(), "Name") + "</b></font></div>";
                    sHTMLValue += "<div align = 'right'>Points : <font size = '12' face = 'Arial' color ='IndianRed'><b>" + dr["Points"] + "</b></font></div>";
                    sHTMLValue += "<font size = '9'><div align = 'left'>Tenure &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: " + dr["Tenure"].ToString().Replace("&", "&amp;") + "</div>";
                    sHTMLValue += "<div align = 'left'>Target &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: " + dr["SELF_TARGET"] + "</div>";
                    sHTMLValue += "<div align = 'left'>Contacts Achieved &nbsp;&nbsp;: " + dr["AchievedContacts"] + "</div>";

                    if (sShowType == "Show Peer")
                    {
                        sHTMLValue += "<div align = 'left'>Peer Rank &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
                    }
                    else
                    {
                        sHTMLValue += "<div align = 'left'>Project Rank &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
                    }


                    if (sShowType == "Show Peer")
                    {
                        sHTMLValue += "<div align = 'right'>Project Rank &nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
                    }
                    else
                    {
                        sHTMLValue += "<div align = 'right'>Peer Rank &nbsp;: <font face = 'Arial' color = 'SeaGreen'><b>" + dr["TenurebasedRanking"] + "</b></font></div>";
                    }

                    sHTMLValue += "<div align = 'right'>Last Seen &nbsp;: " + dr["Lastseen"] + "</div></font> </div></font>";


                    GridCell gr1 = new GridCell();
                    //gr1.EditorType = typeof(GridTextBoxXEditControl);
                    //gr1.RenderType = typeof(GridTextBoxXEditControl);
                    gr1.Value = sHTMLValue;

                    //GridCell gr1 = new GridCell(ProperCaseHelper.NameANDJobTitleCasing(dr[0].ToString().ToLower(), "Name"));

                    GridRow gr = new GridRow();
                    gr.Cells.Add(gr0);
                    gr.Cells.Add(gr1);
                    sdgvProjectPerformance.PrimaryGrid.Rows.Add(gr);
                }
            }
            else
            {
                sdgvProjectPerformance.PrimaryGrid.Header.Text = "<div align = 'Right'><font size = '13'><b>Project Performance</b></font></div>";
            }
        }