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 buttonAsocProfMatClasaUp_Click(object sender, EventArgs e) { //ProfesorBL profBL = new ProfesorBL(); //MaterieBL matBL = new MaterieBL(); ClasaBL clasaBL = new ClasaBL(); int profesorID = int.Parse(comboBoxProfiAsocPMCUp.SelectedValue.ToString()); int materieID = int.Parse(comboBoxMateriiAsocPMCUp.SelectedValue.ToString()); int clasaID = int.Parse(comboBoxClaseAsocPMCUp.SelectedValue.ToString()); bool teza = bool.Parse(textBoxTezaAsocPMCUp.Text); int profIDNew = int.Parse(comboBoxProfiAsocPMCUpNew.SelectedValue.ToString()); DataTable id = clasaBL.GetIdForProfMaterieClasaTeza(profesorID, materieID, clasaID, teza); int prof_clasaID = 0; bool ok = false; for (int i = 0; i < id.Rows.Count; i++) { if (id.Rows[i] != null) { prof_clasaID = int.Parse(id.Rows[i][id.Columns[0]].ToString()); ok = true; } } if (ok) { clasaBL.UpdateAsocProfesorClasa(prof_clasaID, profIDNew); labelMsgAsocPMCUp.Text = "Actualizarea a fost realizata cu succes!"; } else { labelMsgAsocPMCUp.Text = "Actualizare esuata. Asocierea initiala nu exista!"; } }
private void ListClasa() { ClasaBL clasaBL = new ClasaBL(); comboBoxDeleteClasa.DisplayMember = "nume_clasa"; comboBoxDeleteClasa.ValueMember = "id_clasa"; comboBoxDeleteClasa.DataSource = clasaBL.GetClase(); }
private void PopulateUpdateControls() { int clasaID = int.Parse(comboBoxClasaUpdate.SelectedValue.ToString()); ClasaBL clasaBL = new ClasaBL(); DataTable ds = clasaBL.GetClasaById(clasaID); textBoxNumeClasa.Text = ds.Rows[0]["nume_clasa"].ToString(); }
private void buttonAsociereClasaDirig_Click(object sender, EventArgs e) { int clasaID = int.Parse(comboBoxClaseAsoc.SelectedValue.ToString()); int profID = int.Parse(comboBoxProfiAsoc.SelectedValue.ToString()); ClasaBL clasaBL = new ClasaBL(); clasaBL.AsocDiriginteClasa(profID, clasaID); }
private void buttonAsociereClasaAnStudiu_Click(object sender, EventArgs e) { int clasaID = int.Parse(comboBoxClaseAsoc.SelectedValue.ToString()); int an_studiuID = int.Parse(comboBoxAnStudiuAsoc.SelectedValue.ToString()); ClasaBL clasaBL = new ClasaBL(); clasaBL.AsocAn_StudiuClasa(an_studiuID, clasaID); }
private void buttonAsocProfMatClasa_Click(object sender, EventArgs e) { int profID = int.Parse(comboBoxProfiAsocPMC.SelectedValue.ToString()); int materieID = int.Parse(comboBoxMateriiAsocPMC.SelectedValue.ToString()); int clasaID = int.Parse(comboBoxClaseAsocPMC.SelectedValue.ToString()); bool teza = bool.Parse(textBoxTezaAsocPMC.Text); ClasaBL clasaBL = new ClasaBL(); clasaBL.AsocProfesorClasa(profID, materieID, clasaID, teza); labelMsgAsocPMC.Text = "Asociere reusita!"; }
private void buttonDeleteClasa_Click(object sender, EventArgs e) { int clasaID = int.Parse(comboBoxDeleteClasa.SelectedValue.ToString()); if (MessageBox.Show("Sigur vreti sa stergeti clasa?", "Intrebare", MessageBoxButtons.YesNo) == DialogResult.Yes) { ClasaBL clasaBL = new ClasaBL(); clasaBL.DeleteClasa(clasaID); labelDeleteClasa.Text = "Stergerea a fost realizata cu succes! "; } ListClasa(); }
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"; // } }
private void ListClasa() { int materieID = int.Parse(comboBoxNotaMaterie.SelectedValue.ToString()); try { ClasaBL clasaBL = new ClasaBL(); comboBoxNotaClasa.DisplayMember = "nume_clasa"; comboBoxNotaClasa.ValueMember = "id_clasa"; comboBoxNotaClasa.DataSource = clasaBL.GetClasaByProfMatId(id_prof_logat, materieID).Rows; } catch (Exception e) { labelEroareNotaForm.Text = "Profesorul nu are clase asociate materiei!"; } }
private void ButtonUpdateProf_Click(object sender, EventArgs e) { string nume = textBoxNumeClasa.Text; ClasaBL clasaBL = new ClasaBL(); if (!string.IsNullOrWhiteSpace(nume)) { int clasaID = int.Parse(comboBoxClasaUpdate.SelectedValue.ToString()); clasaBL.UpdateClasa(clasaID, nume); labelMsgUpdateClasa.Text = "Actualizarea a fost realizata cu succes! "; } else { labelMsgUpdateClasa.Text = "Date incomplete ! "; } ListClasa(); }
private void buttonAddClasa_Click(object sender, EventArgs e) { string nume = textBoxClasaNume.Text; ClasaBL clasaBL = new ClasaBL(); if (!string.IsNullOrWhiteSpace(nume)) { clasaBL.AddClasa(nume); labelMsgAddClasa.Text = "Adaugare cu succes! "; textBoxClasaNume.Text = ""; } else { labelMsgAddClasa.Text = "Date incomplete ! "; } }