public void Piechart() { int A = 0; int B = 0; int C = 0; int D = 0; int E = 0; int count = 0; AbcDAL MyDAL = new AbcDAL(""); DataTable ResultTable = MyDAL.SelectStudentByAuthID(1); string StudentID = ResultTable.Rows[0]["StudentID"].ToString().Trim(); DataTable ResultTableClass = MyDAL.PopulateClassByStudentID(StudentID); RadChart radChart = new RadChart(); radChart.ChartTitle.TextBlock.Text = "My RadChart"; ChartSeries chartSeries = new ChartSeries(); chartSeries.Name = "Overall Grade"; chartSeries.Type = ChartSeriesType.Bar; // add new items to the series, // passing a value and a label string foreach (DataRow row in ResultTableClass.Rows) { if (ResultTableClass.Rows[count]["Grade"].ToString().Trim() == "A") { A++; } else if (ResultTableClass.Rows[count]["Grade"].ToString().Trim() == "B") { B++; } else if (ResultTableClass.Rows[count]["Grade"].ToString().Trim() == "C") { C++; } else if (ResultTableClass.Rows[count]["Grade"].ToString().Trim() == "D") { D++; } else if (ResultTableClass.Rows[count]["Grade"].ToString().Trim() == "E") { E++; } count++; } chartSeries.AddItem(A, "A"); chartSeries.AddItem(B, "B"); chartSeries.AddItem(C, "C"); chartSeries.AddItem(D, "D"); chartSeries.AddItem(E, "E"); RCStudent.AddChartSeries(chartSeries); }
public void PopulateStudentName() { int Present = 0; int Absent = 0; int count = 0; AbcDAL MyDAL = new AbcDAL(""); DataTable ResultTable = MyDAL.SelectStudentByAuthID(1); if (ResultTable.Rows.Count != 0) { Piechart(); string StudentID = ResultTable.Rows[0]["StudentID"].ToString().Trim(); RLName.Text = ResultTable.Rows[0]["StudentName"].ToString(); RLPhoneNo.Text = ResultTable.Rows[0]["PhoneNo"].ToString(); RLAddress.Text = ResultTable.Rows[0]["Address"].ToString(); DataTable ResultTableClass = MyDAL.PopulateClassByStudentID(StudentID); //string Attendance = ResultTableClass.Rows[0]["Attendance"].ToString().Trim(); foreach (DataRow row in ResultTableClass.Rows) { if (ResultTableClass.Rows[count]["Attendance"].ToString().Trim() == "Present") { Present++; } else { Absent++; } count++; } if (Present == Absent) { RLAttendance.Text = "Fair"; } else if (Present > Absent) { RLAttendance.Text = "Good"; } else { RLAttendance.Text = "Poor"; } } else { RLName.Text = "Super Admin"; RLAttendance.Text = "Super Admin has Logged in"; } }
public void DropdownlistGrade() { AbcDAL MyDAL = new AbcDAL(""); DataTable ResultTable = new DataTable(); ResultTable = MyDAL.PopulateClassByStudentID(RCBStudentName.SelectedValue.ToString().Trim()); string grade; int count = 0; foreach (DataRow row in ResultTable.Rows) { grade = ResultTable.Rows[count]["Grade"].ToString().Trim(); if (RCBSubject.SelectedValue.ToString().Trim() == ResultTable.Rows[count]["SubjectID"].ToString().Trim()) { if (grade == "A") { RDDLGrade.SelectedIndex = 1; break; } else if (grade == "B") { RDDLGrade.SelectedIndex = 2; break; } else if (grade == "C") { RDDLGrade.SelectedIndex = 3; break; } else if (grade == "D") { RDDLGrade.SelectedIndex = 4; break; } else if (grade == "E") { RDDLGrade.SelectedIndex = 5; break; } else if (grade == "F") { RDDLGrade.SelectedIndex = 6; break; } } count++; } }
protected void RCBStudentName_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) { string Attendance = ""; RLStudentName.Text = RCBStudentName.Text; AbcDAL MyDAL = new AbcDAL(""); DataTable ResultTable = new DataTable(); ResultTable = MyDAL.PopulateClassByStudentID(RCBStudentName.SelectedValue.ToString().Trim()); int count = 0; int countStop = 0; foreach (DataRow row in ResultTable.Rows) { Attendance = ResultTable.Rows[count]["Attendance"].ToString().Trim(); if (RCBSubject.SelectedValue.ToString().Trim() == ResultTable.Rows[count]["SubjectID"].ToString().Trim()) { DropdownlistGrade(); ClassID = ResultTable.Rows[count]["ClassID"].ToString(); if (Attendance == "Present") { countStop++; RDDLAttendance.SelectedIndex = 0; break; } else if (Attendance == "Absent") { countStop++; RDDLAttendance.SelectedIndex = 1; break; } else { countStop++; RDDLAttendance.SelectedIndex = 2; break; } } count++; } if (countStop == 0) { RDDLAttendance.SelectedIndex = 2; } }