void Load_Agent_Data() { try { 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 (dtAgentSummary.Rows.Count > 0) //{ // lblMonthlyPoints.Text = "Monthly Points : <b>" + dtAgentSummary.Rows[0]["MTDPOINTS"].ToString() + "</b>"; // //lblYesterDaysPoint.Text = dtAgentSummary.Rows[0]["YESTERDAYPOINTS"].ToString(); // lblTargetAchived.Text = "Target Achieved : <b>" + dtAgentSummary.Rows[0]["AchievedContacts"].ToString() + "</b>"; // lblTargetMissed.Text = "Target Missed : <b>" + dtAgentSummary.Rows[0]["TM_CNT"].ToString() + "</b>"; //} //else //{ // lblMonthlyPoints.Text = "Monthly Points : <b>0</b>"; // lblTargetAchived.Text = "Target Achieved : <b>0</b>"; // lblTargetMissed.Text = "Target Missed : <b>0</b>"; //} 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; } } catch (Exception ex) { GM.Error_Log(System.Reflection.MethodBase.GetCurrentMethod(), ex, true, true); //MessageBoxEx.Show(ex.Message, "Campaign Manager", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
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); } }