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