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);
}
}
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("&", "&") + "</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 : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["TenurebasedRanking"] + "</b></font></div>";
}
else
{
sHTMLValue += "<div align = 'left'>MTD Rank : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
}
sHTMLValue += "<font size = '9'><div align = 'left'>Tenure : " + dr["Tenure"].ToString().Replace("&", "&") + "</div>";
sHTMLValue += "<div align = 'left'>Contacts Achieved : " + dr["AchievedContacts"] + "</div>";
//sHTMLValue += "<div>Company Processed : " + dr["NO_OF_CONTACTS_VALIDATED"] + "</div>";
if (sShowType == "Show Peer")
{
sHTMLValue += "<div align = 'right'>MTD Rank : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div></font> </div></font>";
}
else
{
sHTMLValue += "<div align = 'right'>Peer Rank : <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 : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["TenurebasedRanking"] + "</b></font></div>";
//else
// sHTMLValue += "<div align = 'left'>MTD Rank : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
//sHTMLValue += "<font size = '9'><div align = 'left'>Tenure : " + dr["Tenure"].ToString().Replace("&", "&") + "</div>";
//sHTMLValue += "<div align = 'left'>Contacts Achieved : " + 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>";
}
}
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);
}
}
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("&", "&") + "</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 : " + dr["Tenure"].ToString().Replace("&", "&") + "</div>";
sHTMLValue += "<div align = 'left'>Target : " + dr["SELF_TARGET"] + "</div>";
sHTMLValue += "<div align = 'left'>Contacts Achieved : " + dr["AchievedContacts"] + "</div>";
if (sShowType == "Show Peer")
{
sHTMLValue += "<div align = 'left'>Peer Rank : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
}
else
{
sHTMLValue += "<div align = 'left'>Project Rank : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
}
if (sShowType == "Show Peer")
{
sHTMLValue += "<div align = 'right'>Project Rank : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["OVERALLRANKING"] + "</b></font></div>";
}
else
{
sHTMLValue += "<div align = 'right'>Peer Rank : <font face = 'Arial' color = 'SeaGreen'><b>" + dr["TenurebasedRanking"] + "</b></font></div>";
}
sHTMLValue += "<div align = 'right'>Last Seen : " + 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>";
}
}
