public void loadGrid()
{
gradeImpl = new GradeImpl();
dgvDatos.ItemsSource = null;
switch (trimester)
{
case 1:
dgvDatos.ItemsSource = gradeImpl.SelectStudentsFirst(idClass).DefaultView;
break;
case 2:
dgvDatos.ItemsSource = gradeImpl.SelectStudentsSecond(idClass).DefaultView;
break;
case 3:
dgvDatos.ItemsSource = gradeImpl.SelectStudentsThird(idClass).DefaultView;
break;
}
}
private void BtnAddGrade_Click(object sender, RoutedEventArgs e)
{
try
{
#region controlgrade
double grade1 = Convert.ToDouble(txtGrade1.Text);
double grade2 = Convert.ToDouble(txtGrade2.Text);
double grade3 = Convert.ToDouble(txtGrade3.Text);
double grade4 = Convert.ToDouble(txtGrade4.Text);
double gradetest = Convert.ToDouble(txtTest.Text);
double gradeaverage;
double first = (grade1 * 0.175) + (grade2 * 0.175) + (grade3 * 0.175) + (grade4 * 0.175);
double second = (gradetest * 0.3);
gradeaverage = first + second;
double total = 0;
double sumatotal = 0;
switch (trimester)
{
case 1:
total = gradeaverage * 0.35;
break;
case 2:
total = gradeaverage * 0.35;
break;
case 3:
total = gradeaverage * 0.30;
break;
}
grade1 = Math.Round(grade1, 0);
grade2 = Math.Round(grade2, 0);
grade3 = Math.Round(grade3, 0);
grade4 = Math.Round(grade4, 0);
gradetest = Math.Round(gradetest, 0);
gradeaverage = Math.Round(gradeaverage, 0);
total = Math.Round(total, 2);
grade = new Grade(idGrade, grade1, grade2, grade3, grade4, gradetest, gradeaverage, idTotal);
MessageBox.Show("" + grade.IdAverage);
gradeImpl = new GradeImpl();
DataTable dt = new DataTable();
dt = gradeImpl.SelectTotal(idTotal);
switch (trimester)
{
case 1:
foreach (DataRow d in dt.Rows)
{
sumatotal = total + Convert.ToDouble(d[2].ToString()) + Convert.ToDouble(d[3].ToString());
}
gradeImpl.UpdateTransactionFirst(grade, total, sumatotal);
break;
case 2:
foreach (DataRow d in dt.Rows)
{
sumatotal = total + Convert.ToDouble(d[1].ToString()) + Convert.ToDouble(d[3].ToString());
}
gradeImpl.UpdateTransactionSecond(grade, total, sumatotal);
break;
case 3:
foreach (DataRow d in dt.Rows)
{
sumatotal = total + Convert.ToDouble(d[1].ToString()) + Convert.ToDouble(d[2].ToString());
}
gradeImpl.UpdateTransactionThird(grade, total, sumatotal);
break;
}
#endregion
if (grade1 > 0)
{
txtGrade1.IsEnabled = false;
}
else
{
txtGrade1.IsEnabled = true;
}
if (grade2 > 0)
{
txtGrade2.IsEnabled = false;
}
else
{
txtGrade2.IsEnabled = true;
}
if (grade3 > 0)
{
txtGrade3.IsEnabled = false;
}
else
{
txtGrade3.IsEnabled = true;
}
if (grade4 > 0)
{
txtGrade4.IsEnabled = false;
}
else
{
txtGrade4.IsEnabled = true;
}
if (gradetest > 0)
{
txtTest.IsEnabled = false;
}
else
{
txtTest.IsEnabled = true;
}
MessageBox.Show("Upload Grades Succesfuly");
loadGrid();
ocultar();
}
catch
{
MessageBox.Show("Something happened \nCommunicate with the Suport department \[email protected]");
}
}
public void loadGrids()
{
gradeImpl = new GradeImpl();
dgvDatos.ItemsSource = null;
dgvDatos.ItemsSource = gradeImpl.SelectStudentsGrades(Session.SessionID).DefaultView;
}
