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; }