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);
}
}
