internal void MateriaNota(int IDAA, int IDM) { bool existencia = true; Nota aux; SqlCommand cmm; try { aux = new Nota(); aux.IdMateria = IDM; cmm = new SqlCommand("GetNotas", conn); cmm.CommandType = CommandType.StoredProcedure; cmm.Parameters.AddWithValue("@IdAlumnoAno", IDAA); cmm.Parameters.AddWithValue("@IdMateria", IDM); SqlDataReader reader2; conn.Open(); reader2 = cmm.ExecuteReader(); if (reader2.HasRows) { while (reader2.Read()) { int trimestre = 0; trimestre = int.Parse(reader2["Trimestre"].ToString().Trim()); if (trimestre == 1) { aux.Notas[0] += double.Parse(reader2["Porcentaje"].ToString().Trim()); } else if (trimestre == 2) { aux.Notas[1] += double.Parse(reader2["Porcentaje"].ToString().Trim()); } else if (trimestre == 3) { aux.Notas[2] += double.Parse(reader2["Porcentaje"].ToString().Trim()); } } } else { existencia = false; } reader2.Close(); if (existencia == true) { aux.GetPromedioFinal(); } else { aux.PFinal = 0; aux.Aprobada = false; } if (aux.Aprobada == false) { Aprobado = false; } aux.GetMateria(); NM.Add(aux); conn.Close(); } catch { conn.Close(); MessageBox.Show("Error extrayendo las notas", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }