/// <summary> /// Makes an update in database and in form fields with entered data /// </summary> private void UpdateProfessorDetails() { try { _currentProfessor.Ime = txtIme.Text; _currentProfessor.Prezime = txtPrezime.Text; _currentProfessor.KorisnickoIme = txtKorisnickoIme.Text; _currentProfessor.Lozinka = txtLozinka.Text; _currentProfessor.DatumRodjenja = txtDatumRodjenja.Text; _currentProfessor.DatumZaposlenja = txtDatumZaposlenja.Text; _currentProfessor.Email = txtEmail.Text; _currentProfessor.JMBG = txtJMBG.Text; _currentProfessor.Ucionica = txtUcionica.Text; _currentProfessor.RadnaPozicija = txtRadnaPozicija.Text; _currentProfessor.BrojTelefona = txtBrojTelefona.Text; if (rbMale.Checked) { _currentProfessor.Spol = "Musko"; } else { _currentProfessor.Spol = "Zensko"; } _currentProfessor.Slika = ImageConventer.FromImageToByte(pbSlikaProfesora.Image); databaseConnection.Entry(_currentProfessor).State = EntityState.Modified; databaseConnection.SaveChanges(); MessageBox.Show($"Data successfully changed!"); } catch (Exception ex) { MessageBox.Show($"Greska u povezivanju sa bazom -> {ex.Message} {ex.InnerException?.Message}"); } }
/// <summary> /// Adds new subject with all his data in DB /// </summary> private void btnAddSubject_Click(object sender, EventArgs e) { if (ValidirajPolja()) { konekcijaNaBazu.Predmeti.Add(new Predmet() { PredmetCode = txtSubjectCode.Text, NazivPredmeta = txtSubjectName.Text, GodinaStudija = cmbYearOfStudy.SelectedItem.ToString(), ECTS = int.Parse(txtECTS.Text), BrojSatiPredavanja = int.Parse((cmbLessonHours.SelectedItem).ToString()), BrojSatiVjezbi = int.Parse((cmbPracticeHours.SelectedItem).ToString()), Profesor = (cmbProfesori.SelectedItem as Profesor).ToString(), Dogadjaj = txtAction.Text, Syllabus = ImageConventer.FromImageToByte(pbSyllabusPic.Image) }); konekcijaNaBazu.SaveChanges(); MessageBox.Show($"Subject {txtSubjectName.Text} successfully added!"); DialogResult = DialogResult.OK; Close(); } }
/// <summary> /// Validates and saves all data from input fields to a new student and adds him to DB /// </summary> private void btnSaveStudent_Click(object sender, EventArgs e) { if (ValidinaPolja()) { string godina = cmbGodine.SelectedItem.ToString(); konekcijaNaBazu.Studenti.Add(new Student() { BrojIndeksa = txtBrojIndeksa.Text, Ime = txtIme.Text, Prezime = txtPrezime.Text, ImeOca = txtImeOca.Text, DatumRodjenja = dtmDatumRodjenja.Value.ToShortDateString(), Email = txtEmail.Text, Spol = ProvjeraChecked(), GodinaStudija = cmbGodinaStudija.SelectedItem.ToString(), Godine = int.Parse(godina), Slika = ImageConventer.FromImageToByte(pbSlikaStudenta.Image) }); konekcijaNaBazu.SaveChanges(); MessageBox.Show($"Student successfully added!"); DialogResult = DialogResult.OK; Close(); } }