/*
* EventName: btnFailResults_Click
* Summary: Prints the Pass report of the requested course, with threshold above or below the grade selected.
*/
private void btnPassReport_Click(object sender, EventArgs e)
{
rtbResults.Clear();
tbZid.Clear();
cmbThreshGrade.SelectedIndex = -1;
tbThreshCour.Clear();
cmbFMajor.SelectedIndex = -1;
tbFailCour.Clear();
textBox3.Clear();
nudPercent.Value = 0;
Program p = new Program();
string grade = cmbPassGrade.Text.ToUpper();
var passStudents = new ListWithDuplicates(); //store percentage of passed students in each course
var totalStudents = new ListWithDuplicates();
var percentages = new ListWithDup();
var output = new ListWithDup();
int index = 0;
List <Grades> passGrades = new List <Grades>();
List <string> dis_grades = new List <string>();
List <string> thresh_grades = new List <string>();
dis_grades.AddRange(new string[] { "A", "A-", "B+", "B", "B-", "C++", "C", "C-", "D" });
List <string> coursename = new List <string>();
List <string> distinct_cour = new List <string>();
int percent = Convert.ToInt32(nudPercent.Value);
List <string> gr = new List <string>();
for (int i = 0; i < p.NewGrades.Count; i++)
{
string c = p.NewGrades[i].Major + "-" + p.NewGrades[i].Cnum;
coursename.Add(c);
}
distinct_cour = coursename.Distinct().ToList();
if (rbPLess.Checked)
{
index = dis_grades.FindIndex(a => a == grade); //query to find the grade which the user wants.
for (int i = index; i < dis_grades.Count; i++)
{
thresh_grades.Add(dis_grades[i]); //consider all the grades less than the requested grade
}
var result = from g in p.NewGrades orderby g.Major, g.Cnum select g;
var groupedresult = from s in result
group s by new { s.Major, s.Cnum };
var pStudents = from g in groupedresult //counting the number of failures for each course
select new { Course = g.Key, totalcount = g.Count(S => thresh_grades.Contains(S.Grade)) };
foreach (var i in pStudents)
{
passStudents.Add(i.Course.ToString(), i.totalcount);
}
var tStudents = from g in groupedresult
select new { Course = g.Key, totalcount = g.Count() };
foreach (var j in tStudents)
{
totalStudents.Add(j.Course.ToString(), j.totalcount);
}
for (int i = 0; i < passStudents.Count; i++)
{
int pcount = passStudents[i].Value;
int tcount = totalStudents[i].Value;
float percentage = ((float)pcount / (float)tcount) * 100;
percentages.Combine(passStudents[i].Key, (float)Math.Round(percentage, 2));
string res = "Out of " + tcount + " enrolled in " + distinct_cour[i] + ", " + pcount + " passed at or below this threshold (" + (float)Math.Round(percentage, 2) + "% )";
output.Combine(res, (float)Math.Round(percentage, 2));
}
int nor = 0;
rtbResults.AppendText("Fail Percentage (<= " + grade + ") Report for Classes." + "\n-----------------------------------------------\n");
for (int i = 0; i < output.Count; i++)
{
if (output[i].Value != 0)
{
rtbResults.AppendText(output[i].Key + "\n\n");
nor++;
}
}
if (nor == 0)
{
rtbResults.AppendText("No courses matched the query criteria.");
}
else
{
rtbResults.AppendText("\n###END RESULTS###");
}
}
else if (rbPGreater.Checked)
{
index = dis_grades.FindIndex(a => a == grade); //query to find the grade which the user wants.
for (int i = index; i >= 0; i--)
{
thresh_grades.Add(dis_grades[i]); //consider all the grades greater than the requested grade
}
var result = from g in p.NewGrades orderby g.Major, g.Cnum select g;
var groupedresult = from s in result
group s by new { s.Major, s.Cnum };
var pStudents = from g in groupedresult //counting the number of passedstudents for each course
select new { Course = g.Key, totalcount = g.Count(S => thresh_grades.Contains(S.Grade)) };
foreach (var i in pStudents)
{
passStudents.Add(i.Course.ToString(), i.totalcount);
}
var tStudents = from g in groupedresult
select new { Course = g.Key, totalcount = g.Count() };
foreach (var j in tStudents)
{
totalStudents.Add(j.Course.ToString(), j.totalcount);
}
for (int i = 0; i < passStudents.Count; i++)
{
int pcount = passStudents[i].Value;
int tcount = totalStudents[i].Value;
float percentage = ((float)pcount / (float)tcount) * 100;
percentages.Combine(passStudents[i].Key, (float)Math.Round(percentage, 2));
string res = "Out of " + tcount + " enrolled in " + distinct_cour[i] + ", " + pcount + " passed at or above this threshold (" + (float)Math.Round(percentage, 2) + "% )";
output.Combine(res, (float)Math.Round(percentage, 2));
}
int nor = 0;
rtbResults.AppendText("Fail Percentage (>= " + grade + ") Report for Classes." + "\n-----------------------------------------------\n");
for (int i = 0; i < output.Count; i++)
{
if (output[i].Value != 0)
{
rtbResults.AppendText(output[i].Key + "\n\n");
nor++;
}
}
if (nor == 0)
{
rtbResults.AppendText("No courses matched the query criteria");
}
else
{
rtbResults.AppendText("\n###END RESULTS###");
}
}
else
{
MessageBox.Show("Please select one of the threshold's (from the radio buttons)");
}
}
/*
* EventName: btnFailResults_Click
* Summary: Prints the Fail report of the requested course, with threshold above or below the percentage given.
*/
private void btnFailResults_Click(object sender, EventArgs e)
{
rtbResults.Clear();
tbZid.Clear();
cmbThreshGrade.SelectedIndex = -1;
tbThreshCour.Clear();
cmbFMajor.SelectedIndex = -1;
tbFailCour.Clear();
textBox3.Clear();
cmbPassGrade.SelectedIndex = -1;
Program p = new Program();
var failStudents = new ListWithDuplicates(); //store percentage of failures in each course
var totalStudents = new ListWithDuplicates();
var percentages = new ListWithDup();
var output = new ListWithDup();
List <string> coursename = new List <string>();
List <string> distinct_cour = new List <string>();
int percent = Convert.ToInt32(nudPercent.Value);
List <string> gr = new List <string>();
for (int i = 0; i < p.NewGrades.Count; i++)
{
string c = p.NewGrades[i].Major + "-" + p.NewGrades[i].Cnum;
coursename.Add(c);
}
distinct_cour = coursename.Distinct().ToList();
var result = from g in p.NewGrades orderby g.Major, g.Cnum select g;
var groupedresult = from s in result
group s by new { s.Major, s.Cnum };
var fStudents = from g in groupedresult //counting the number of failures for each course
select new { Course = g.Key, totalcount = g.Count(S => S.Grade == "F") };
foreach (var i in fStudents)
{
failStudents.Add(i.Course.ToString(), i.totalcount);
}
var tStudents = from g in groupedresult
select new { Course = g.Key, totalcount = g.Count() };
foreach (var j in tStudents)
{
totalStudents.Add(j.Course.ToString(), j.totalcount);
}
for (int i = 0; i < failStudents.Count; i++)
{
int fcount = failStudents[i].Value;
int tcount = totalStudents[i].Value;
float percentage = ((float)fcount / (float)tcount) * 100;
percentages.Combine(failStudents[i].Key, (float)Math.Round(percentage, 2));
string res = "Out of " + tcount + " enrolled in " + distinct_cour[i] + ", " + fcount + " failed (" + (float)Math.Round(percentage, 2) + "% )";
output.Combine(res, (float)Math.Round(percentage, 2));
}
if (rbFLess.Checked)
{
int nor = 0;
rtbResults.AppendText("Fail Percentage (<= " + percent + "%) Report for Classes." + "\n-----------------------------------------------\n");
for (int i = 0; i < output.Count; i++)
{
if (output[i].Value <= (float)percent && output[i].Value != 0)
{
rtbResults.AppendText(output[i].Key + "\n\n");
nor++;
}
}
if (nor == 0)
{
rtbResults.AppendText("No courses matched the query criteria.");
}
else
{
rtbResults.AppendText("\n###END RESULTS###");
}
}
else if (rbFGreater.Checked)
{
int nor = 0;
rtbResults.AppendText("Fail Percentage (>= " + percent + "%) Report for Classes." + "\n-----------------------------------------------\n");
for (int i = 0; i < output.Count; i++)
{
if (output[i].Value >= (float)percent && output[i].Value != 0)
{
nor++;
rtbResults.AppendText(output[i].Key + "\n\n");
}
}
if (nor == 0)
{
rtbResults.AppendText("No courses matched the query criteria");
}
else
{
rtbResults.AppendText("\n###END RESULTS###");
}
}
else
{
MessageBox.Show("Please select one of the threshold's (from the radio buttons)");
}
}