protected void trySorting() { SortedPoints.Clear(); if (SortHidden.Value == "pIdeaNum") { if (SortDirectionHidden.Value == "DESC") { SortedPoints = IndPoints.OrderByDescending(p => p.pIdeaNum).ToList(); } else { SortedPoints = IndPoints.OrderBy(p => p.pIdeaNum).ToList(); } } if (SortHidden.Value == "pReasonCode") { if (SortDirectionHidden.Value == "DESC") { SortedPoints = IndPoints.OrderByDescending(p => p.pReasonCode).ThenByDescending(p => p.pSortDate).ThenByDescending(p => p.pIdeaNum).ToList(); } else { SortedPoints = IndPoints.OrderBy(p => p.pReasonCode).ThenBy(p => p.pSortDate).ThenBy(p => p.pIdeaNum).ToList(); } } if (SortHidden.Value == "pActivityDate") { if (SortDirectionHidden.Value == "DESC") { SortedPoints = IndPoints.OrderByDescending(p => p.pSortDate).ThenByDescending(p => p.pIdeaNum).ThenByDescending(p => p.pReasonCode).ToList(); } else { SortedPoints = IndPoints.OrderBy(p => p.pSortDate).ThenBy(p => p.pIdeaNum).ThenBy(p => p.pReasonCode).ToList(); } } PointsGrid.DataSource = SortedPoints; PointsGrid.DataBind(); }
protected void loadPoints() { checkLocation = Request.QueryString["location"]; stringidea = Request.QueryString["Idea"]; int.TryParse(stringidea, out checkIdea); IndPoints.Clear(); read_outPoints(); if (IndPoints.Count != 0) { PointsIdeaTextBox.Text = stringidea; PointsLocationTextBox.Text = checkLocation; } else { PointsIdeaTextBox.Text = stringidea; PointsLocationTextBox.Text = checkLocation; } PointsGrid.DataSource = IndPoints; PointsGrid.DataBind(); returnDiv.Visible = true; Screen4.Visible = true; screen4bottom.Visible = true; }
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 = " "; } }