private void loadCharts()
{
string employee = Request.QueryString["employee"];
notlang = Request.QueryString["notlang"];
if (notlang == "English")
{
showspanish = true;
}
else
{
showspanish = false;
}
if (showspanish)
{
switchtospanish();
}
if (!showspanish)
{
switchtoenglish();
}
string deptName = "";
string deptNumber = "";
string empName = "";
if (employee != "0" && employee != "")
{
double redeemedpoints = 0;
double availablepoints = 0;
getDept(employee, ref deptName, ref deptNumber, ref empName);
SummaryEmpBox.Text = employee;
SummaryNameBox.Text = empName;
IndPoints.Clear();
read_outSummaryPoints(employee, ref totalpoints, ref redeemedpoints, ref availablepoints);
if (SortHidden.Value == " ")
{
PointsGrid.DataSource = IndPoints;
PointsGrid.DataBind();
}
else
{
trySorting();
}
//TotalPointsBox.Text = totalpoints.ToString();
//RedeemedPointsBox.Text = (redeemedpoints * -1).ToString();
//AvailablePointsBox.Text = availablepoints.ToString();
string[] x = { " ", " " };
double[] y = { 0, 0 };
if (!showspanish)
{
x[0] = "Redeemed" + "\n" + (redeemedpoints * -1).ToString();
x[1] = "Available" + "\n" + availablepoints.ToString();
}
if (showspanish)
{
x[0] = "Redimido" + "\n" + (redeemedpoints * -1).ToString();
x[1] = "Disponible" + "\n" + availablepoints.ToString();
}
y[0] = redeemedpoints * -1;
y[1] = availablepoints;
PointsChart.Series[0].Points.DataBindXY(x, y);
PointsChart.Series[0].Points[0].Color = System.Drawing.ColorTranslator.FromHtml("#FFA64D");
PointsChart.Series[0].Points[1].Color = System.Drawing.ColorTranslator.FromHtml("#2E6399");
PointsChart.Series[0].Points[1].LabelForeColor = System.Drawing.Color.White;
PointsChart.Series[0].Font = new System.Drawing.Font("Arial", 10, System.Drawing.FontStyle.Bold);
PointsChart.BackColor = System.Drawing.ColorTranslator.FromHtml("#D9E9FE");
PointsChart.ChartAreas["ChartArea1"].BackColor = System.Drawing.ColorTranslator.FromHtml("#D9E9FE");
PointsChart.Series[0]["PieLabelStyle"] = "Inside";
string criteria = " WHERE ";
criteria = criteria + " (Emp1 = '" + employee.Trim() + "' OR Emp2 = '"
+ employee.Trim() + "' OR Emp3 ='"
+ employee.Trim() + "' OR Emp4 = '"
+ employee.Trim() + "') and archived <> 'Y'";
int newidea = 0;
int accepted = 0;
int rejected = 0;
int invest = 0;
int waiting = 0;
int implemented = 0;
int prelinv = 0;
int prelcomp = 0;
ideasList.Clear();
summaryideasInit(ref criteria, ref newidea, ref accepted, ref rejected, ref invest, ref waiting,
ref implemented, ref prelinv, ref prelcomp);
int totalideas = newidea + accepted + rejected + invest + waiting + implemented + prelinv + prelcomp;
string[] x2 = { " ", " ", " ", " ", " ", " ", " ", " ", " " };
double[] y2 = { 0, 0, 0, 0, 0, 0, 0, 0, 0 };
if (!showspanish)
{
x2[0] = "Total: " + (totalideas).ToString();
x2[1] = "New: " + newidea.ToString();
x2[2] = "Pre. Invest: " + prelinv.ToString();
x2[3] = "Pre. Invest Cmp: " + prelcomp.ToString();
x2[4] = "Accepted: " + accepted.ToString();
x2[5] = "Not Accepted: " + rejected.ToString();
x2[6] = "Investigating: " + invest.ToString();
x2[7] = "Investigation Completed: " + waiting.ToString();
x2[8] = "Implemented: " + implemented.ToString();
}
if (showspanish)
{
x2[0] = "Total: " + (totalideas).ToString();
x2[1] = "Nuevo: " + newidea.ToString();
x2[2] = "Pre. Invest: " + prelinv.ToString();
x2[3] = "Pre. Invest Cmp: " + prelcomp.ToString();
x2[4] = "Aceptado: " + accepted.ToString();
x2[5] = "No Aceptada: " + rejected.ToString();
x2[6] = "Investigando: " + invest.ToString();
x2[7] = "Investigación completada: " + waiting.ToString();
x2[8] = "Implementado: " + implemented.ToString();
}
y2[0] = totalideas;
y2[1] = newidea;
y2[2] = prelinv;
y2[3] = prelcomp;
y2[4] = accepted;
y2[5] = rejected;
y2[6] = invest;
y2[7] = waiting;
y2[8] = implemented;
IdeaChart.Series[0].Points.DataBindXY(x2, y2);
if (!showspanish)
{
IdeaChart.ChartAreas["ChartArea1"].AxisX.Title = "Idea Status";
IdeaChart.ChartAreas["ChartArea1"].AxisY.Title = "Number of Ideas";
}
if (showspanish)
{
IdeaChart.ChartAreas["ChartArea1"].AxisX.Title = "Estado de la Idea";
IdeaChart.ChartAreas["ChartArea1"].AxisY.Title = "Numero de Ideas";
}
IdeaChart.BackColor = System.Drawing.ColorTranslator.FromHtml("#D9E9FE");
IdeaChart.ChartAreas["ChartArea1"].BackColor = System.Drawing.ColorTranslator.FromHtml("#D9E9FE");
IdeaChart.Series[0].Font = new System.Drawing.Font("Arial", 10, System.Drawing.FontStyle.Bold);
IdeaChart.ChartAreas["ChartArea1"].AxisX.LabelStyle.Font = new System.Drawing.Font("Arial", 10);
IdeaChart.ChartAreas["ChartArea1"].AxisX.LabelStyle.Angle = -45;
IdeaChart.ChartAreas["ChartArea1"].AxisX.LabelStyle.Interval = 1;
IdeaChart.ChartAreas["ChartArea1"].AxisY.LabelStyle.Font = new System.Drawing.Font("Arial", 10);
IdeaChart.ChartAreas["ChartArea1"].AxisX.TitleFont = new System.Drawing.Font("Arial", 10);
IdeaChart.ChartAreas["ChartArea1"].AxisY.TitleFont = new System.Drawing.Font("Arial", 10);
IdeaChart.Series["Series1"]["PixelPointWidth"] = "15";
IdeaChart.Series[0].Points[0].Color = System.Drawing.ColorTranslator.FromHtml("#2E6399");
IdeaChart.Series[0].Points[1].Color = System.Drawing.ColorTranslator.FromHtml("#E6C023");
IdeaChart.Series[0].Points[2].Color = System.Drawing.ColorTranslator.FromHtml("#42CA86");
IdeaChart.Series[0].Points[3].Color = System.Drawing.ColorTranslator.FromHtml("#CA6742");
IdeaChart.Series[0].Points[4].Color = System.Drawing.ColorTranslator.FromHtml("#08D7F0");
IdeaChart.Series[0].Points[5].Color = System.Drawing.ColorTranslator.FromHtml("#B242CA");
IdeaChart.Series[0].Points[6].Color = System.Drawing.ColorTranslator.FromHtml("#82CA42");
IdeaChart.Series[0].Points[7].Color = System.Drawing.ColorTranslator.FromHtml("#A2729A");
IdeaChart.Series[0].Points[8].Color = System.Drawing.ColorTranslator.FromHtml("#0F1D83");
IdeaChart.Series[0].Points[8].Url = "SubIdeas.aspx?employee=" + employee + "&type=IMP&returnlink=" + returnlink.Value + "¬lang=" + notlang;
IdeaChart.Series[0].Points[7].Url = "SubIdeas.aspx?employee=" + employee + "&type=WTI&returnlink=" + returnlink.Value + "¬lang=" + notlang;
IdeaChart.Series[0].Points[6].Url = "SubIdeas.aspx?employee=" + employee + "&type=INV&returnlink=" + returnlink.Value + "¬lang=" + notlang;
IdeaChart.Series[0].Points[5].Url = "SubIdeas.aspx?employee=" + employee + "&type=REJ&returnlink=" + returnlink.Value + "¬lang=" + notlang;
IdeaChart.Series[0].Points[4].Url = "SubIdeas.aspx?employee=" + employee + "&type=ACP&returnlink=" + returnlink.Value + "¬lang=" + notlang;
IdeaChart.Series[0].Points[3].Url = "SubIdeas.aspx?employee=" + employee + "&type=PIC&returnlink=" + returnlink.Value + "¬lang=" + notlang;
IdeaChart.Series[0].Points[2].Url = "SubIdeas.aspx?employee=" + employee + "&type=PIN&returnlink=" + returnlink.Value + "¬lang=" + notlang;
IdeaChart.Series[0].Points[1].Url = "SubIdeas.aspx?employee=" + employee + "&type=NEW&returnlink=" + returnlink.Value + "¬lang=" + notlang;
IdeaChart.Series[0].Points[0].Url = "SubIdeas.aspx?employee=" + employee + "&type=ALL&returnlink=" + returnlink.Value + "¬lang=" + notlang;
Screen5.Visible = true;
screen5bottom.Visible = true;
if (GridHidden.Value == "N")
{
PointsGrid.Visible = true;
}
else
{
PointsGrid.Visible = false;
}
SortHidden.Value = " ";
}
}
