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