public List <CourseTaken> viewgrades()
{
List <CourseTaken> list = new List <CourseTaken>();
searchbyid fm1 = new searchbyid();
if (fm1.ShowDialog() == DialogResult.OK)
{
List <DbParameter> newlist = new List <DbParameter>();
DataTable dt = null;
string sql = "select CourseNum, Grade from CoursesTaken where StudentId ='" + fm1.StudentId + "'";
dt = idac.GetManyRowsCols(sql, newlist);
List <double> glist = new List <double>();
double sum;
foreach (DataRow drow in dt.Rows)
{
string g = drow["Grade"].ToString();
if (g == "A")
{
sum = 4.0;
}
else if (g == "A-")
{
sum = 3.8;
}
else if (g == "B+")
{
sum = 3.6;
}
else if (g == "B")
{
sum = 3.5;
}
else if (g == "B-")
{
sum = 3.4;
}
else if (g == "C+")
{
sum = 3.2;
}
else if (g == "C")
{
sum = 3.1;
}
else if (g == "C-")
{
sum = 3.0;
}
else if (g == "D")
{
sum = 2.5;
}
else
{
sum = 0;
}
glist.Add(sum);
}
double avg = glist.Average();
foreach (DataRow drow in dt.Rows)
{
CourseTaken ct = new CourseTaken();
ct.CourseNum = drow["CourseNum"].ToString();
ct.Grade = drow["Grade"].ToString();
ct.gpa = avg;
list.Add(ct);
}
}
return(list);
}
public double get_grades()
{
List <DbParameter> newlist = new List <DbParameter>();
searchbyid fm1 = new searchbyid();
double sum = 0;
string sql = "select Grade from CoursesTaken where StudentId ='" + fm1.StudentId + "'";
char[] seps = { ',' };
string[] parts = sql.Split(seps);
SqlParameter p1 = new SqlParameter("@Grade", parts[0]);
newlist.Add(p1);
DataTable dt = idac.GetManyRowsCols(sql, newlist);
int count = dt.Rows.Count;
for (int i = 0; i < dt.Rows.Count; i++)
{
string g = dt.Rows[i]["Grade"].ToString();
if (g == "A")
{
sum += 4.0;
}
else if (g == "A-")
{
sum += 3.8;
}
else if (g == "B+")
{
sum += 3.6;
}
else if (g == "B")
{
sum += 3.5;
}
else if (g == "B-")
{
sum += 3.4;
}
else if (g == "C+")
{
sum += 3.2;
}
else if (g == "C")
{
sum += 3.1;
}
else if (g == "C-")
{
sum += 3.0;
}
else if (g == "D")
{
sum += 2.5;
}
else
{
sum += 0;
}
}
double gpa = sum / 12;
return(gpa);
}
