private void buttonAddTezaForm_Click(object sender, EventArgs e)
{
int teza = int.Parse(textBoxAddTeza.Text);
NotaBL notaBL = new NotaBL();
if (teza != 0)
{
ClasaBL cls = new ClasaBL();
DataTable verifTeza = cls.VerifTeza(materieID, clasaID);
bool areTeza = bool.Parse(verifTeza.Rows[0]["teza"].ToString());
if (areTeza)
{
notaBL.AddTeza(elevID, materieID, semID, teza);
labelMsgAddTezaForm.Text = "Adaugare teza cu succes!";
}
else
{
labelMsgAddTezaForm.Text = "Materia selectat nu are teza la acesta clasa!";
}
}
else
{
labelMsgAddTezaForm.Text = "Adaugare esuta, camp incomplet!";
}
}
private void CalcMediePeSem_Click(object sender, EventArgs e)
{
// try
// {
int semID = int.Parse(comboBoxNotaSem.SelectedValue.ToString());
int elevID = int.Parse(comboBoxNotaElev.SelectedValue.ToString());
int materieID = int.Parse(comboBoxNotaMaterie.SelectedValue.ToString());
int clasaId = int.Parse(comboBoxNotaClasa.SelectedValue.ToString());
NotaBL notBL = new NotaBL();
ClasaBL clBl = new ClasaBL();
DataTable t = clBl.VerifTeza(materieID, clasaId);
bool tezica = bool.Parse(t.Rows[0]["teza"].ToString());
DataTable note = notBL.GetNoteByIDuri1(elevID, materieID, semID);
if (note.Rows.Count >= 3)
{
int medie = 0;
int teza = 0;
for (int i = 0; i < note.Rows.Count; i++)
{
//if (note.Rows.Rows[i]["nota"] != null)
medie = medie + int.Parse(note.Rows[i]["nota"].ToString());
}
//else
//teza = int.Parse(note.Rows.Rows[i]["teza"].ToString());
medie = medie / note.Rows.Count;
if (tezica)
{
t = notBL.GetTezaByIDuri(elevID, materieID, semID);
teza = int.Parse(t.Rows[0]["teza"].ToString());
medie = (medie * 3 + teza) / 4;
}
MedieSemestruBL mdsem = new MedieSemestruBL();
mdsem.AddMedie(elevID, materieID, semID, medie);
labelEroareNotaForm.Text = "Media este: " + medie.ToString();
}
else
{
labelEroareNotaForm.Text = "Media nu poate fi calculata deoarece nu sunt minim 3 note!";
}
//}
// catch(Exception except)
// {
// labelEroareNotaForm.Text = "eroare";
// }
}