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