示例#1
0
        public frmStudentskaSluzbaProfesor(string user, string vrsta)
        {
            InitializeComponent();

            FillComboboxGrupa();
            FillCombobox profesori = new FillCombobox(FillComboboxProfesor);

            profesori.Invoke();
            FillCombobox studenti = new FillCombobox(FillComboboxStudent);

            studenti.Invoke();
            FillComboboxProfesor();
            FillComboboxStudent();
            FillComboboxSmer();
            lblProfesorPrikazLogin.Text = user;

            lblVrstaKorisnikaSistema.Text = vrsta;
            LoadTable(lblVrstaKorisnikaSistema.Text);
            if (vrsta.Equals("PROFESOR"))
            {
                grpBoxStudent.DataBindings.Control.Enabled = false;
            }
            if (vrsta.Equals("STUDENT"))
            {
                grpBoxProfesor.DataBindings.Control.Enabled = false;
            }
        }
示例#2
0
        private void btnProfesorUnos_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrEmpty(txtProfesorUsername.Text) || String.IsNullOrWhiteSpace(txtProfesorUsername.Text) || txtProfesorUsername.Text.Length == 0 || String.IsNullOrEmpty(txtProfesorIme.Text) || String.IsNullOrWhiteSpace(txtProfesorIme.Text) || txtProfesorIme.Text.Length == 0 || String.IsNullOrEmpty(txtProfesorPrezime.Text) || String.IsNullOrWhiteSpace(txtProfesorPrezime.Text) || txtProfesorPrezime.Text.Length == 0 || String.IsNullOrEmpty(txtProfesorEmail.Text) || String.IsNullOrWhiteSpace(txtProfesorEmail.Text) || txtProfesorEmail.Text.Length == 0)
            {
                MessageBox.Show("Niste popunili sva polja");
            }
            else
            {
                string          myConnection  = "datasource=localhost;port=3306;username=root;password=Fil2105ozof!";
                string          Query         = "START TRANSACTION; INSERT INTO studentskasluzba.korisnici (username,password,grupa_id)VALUES('" + this.txtProfesorUsername.Text + "','" + this.txtProfesorPassword.Text + "','" + grupaId + "');INSERT INTO studentskasluzba.profesor (profesor_ime,profesor_prezime,profesor_zvanje,profesor_email,profesor_korisnik_id) VALUES ('" + this.txtProfesorIme.Text.ToUpper() + "','" + this.txtProfesorPrezime.Text.ToUpper() + "','" + this.txtProfesorZvanje.Text.ToUpper() + "','" + this.txtProfesorEmail.Text + "',last_insert_id()); COMMIT;";
                MySqlConnection myConn        = new MySqlConnection(myConnection);
                MySqlCommand    SelectCommand = new MySqlCommand(Query, myConn);
                MySqlDataReader myReader;
                try
                {
                    myConn.Open();
                    myReader = SelectCommand.ExecuteReader();
                    MessageBox.Show("Slog je upisan u bazu");
                    txtProfesorUsername.Text       = "";
                    txtProfesorPassword.Text       = "";
                    cmbProfesorVrstaKorisnika.Text = "";
                    txtProfesorIme.Text            = "";
                    txtProfesorPrezime.Text        = "";
                    txtProfesorZvanje.Text         = "";
                    txtProfesorEmail.Text          = "";
                    txtProfesorUsername.Focus();
                    while (myReader.Read())
                    {
                    }
                    myConn.Close();
                    myReader.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    txtProfesorUsername.Text       = "";
                    txtProfesorPassword.Text       = "";
                    cmbProfesorVrstaKorisnika.Text = "";
                    txtProfesorIme.Text            = "";
                    txtProfesorPrezime.Text        = "";
                    txtProfesorZvanje.Text         = "";
                    txtProfesorEmail.Text          = "";
                    txtProfesorUsername.Focus();
                    myConn.Close();
                }
            }

            LoadTable(lblVrstaKorisnikaSistema.Text);
            FillCombobox profesori = new FillCombobox(FillComboboxProfesor);

            profesori.Invoke();
        }
示例#3
0
        private void btnStudentUpis_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrEmpty(txtProfesorUsername.Text) || String.IsNullOrWhiteSpace(txtProfesorUsername.Text) || txtProfesorUsername.Text.Length == 0 || String.IsNullOrEmpty(txtStudentIme.Text) || String.IsNullOrWhiteSpace(txtStudentIme.Text) || txtStudentIme.Text.Length == 0 || String.IsNullOrEmpty(txtStudentPrezime.Text) || String.IsNullOrWhiteSpace(txtStudentPrezime.Text) || txtStudentPrezime.Text.Length == 0 || String.IsNullOrEmpty(txtStudentEmail.Text) || String.IsNullOrWhiteSpace(txtStudentEmail.Text) || txtStudentEmail.Text.Length == 0 || String.IsNullOrEmpty(txtStudentJMBG.Text) || String.IsNullOrWhiteSpace(txtStudentJMBG.Text) || txtStudentJMBG.Text.Length == 0)
            {
                MessageBox.Show("Niste popunili sva polja");
            }
            else if (txtStudentJMBG.Text.Length < 13 || txtStudentJMBG.Text.Length > 13)
            {
                MessageBox.Show("JMBG nije ispravan");
            }
            else if (!isValidEmail(txtStudentEmail.Text))
            {
                MessageBox.Show("Email adresa nije validna");
            }

            else
            {
                string          myConnection  = "datasource=localhost;port=3306;username=root;password=Fil2105ozof!";
                string          Query         = "START TRANSACTION; INSERT INTO studentskasluzba.korisnici (username,password,grupa_id)VALUES('" + this.txtProfesorUsername.Text + "','" + this.txtProfesorPassword.Text + "','" + grupaId + "');INSERT INTO studentskasluzba.student (student_ime,student_prezime,student_jmbg,student_datumrodjenja,student_telefon,student_smer_id,student_broj_indeksa,student_godina_upisa,student_email,student_korisnik_id) VALUES ('" + this.txtStudentIme.Text.ToUpper() + "','" + this.txtStudentPrezime.Text.ToUpper() + "','" + this.txtStudentJMBG.Text + "','" + dateTimePickerDatumRodjenja.Value.ToString("yyyy-MM-dd") + "','" + txtStudentTelefon.Text + "','" + studentSmerId + "','" + txtStudentBrIndeksa.Text + "','" + txtStudentGodinaUpisa.Text + "','" + this.txtStudentEmail.Text + "',last_insert_id()); COMMIT;";
                MySqlConnection myConn        = new MySqlConnection(myConnection);
                MySqlCommand    SelectCommand = new MySqlCommand(Query, myConn);
                MySqlDataReader myReader;
                try
                {
                    myConn.Open();
                    myReader = SelectCommand.ExecuteReader();
                    MessageBox.Show("Slog je upisan u bazu");
                    txtProfesorUsername.Text         = "";
                    txtProfesorPassword.Text         = "";
                    cmbProfesorVrstaKorisnika.Text   = "";
                    txtStudentIme.Text               = "";
                    txtStudentPrezime.Text           = "";
                    txtStudentJMBG.Text              = "";
                    dateTimePickerDatumRodjenja.Text = "";
                    txtStudentTelefon.Text           = "";
                    txtStudentBrIndeksa.Text         = "";
                    txtStudentGodinaUpisa.Text       = "";
                    txtProfesorEmail.Text            = "";
                    txtProfesorUsername.Focus();
                    while (myReader.Read())
                    {
                    }
                    myConn.Close();
                    myReader.Close();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    txtProfesorUsername.Text         = "";
                    txtProfesorPassword.Text         = "";
                    cmbProfesorVrstaKorisnika.Text   = "";
                    txtStudentIme.Text               = "";
                    txtStudentPrezime.Text           = "";
                    txtStudentJMBG.Text              = "";
                    dateTimePickerDatumRodjenja.Text = "";
                    txtStudentTelefon.Text           = "";
                    txtStudentBrIndeksa.Text         = "";
                    txtStudentGodinaUpisa.Text       = "";
                    cmbStudentSmer.Text              = "";
                    txtStudentEmail.Text             = "";
                    txtProfesorUsername.Focus();
                    myConn.Close();
                }
            }

            LoadTable(lblVrstaKorisnikaSistema.Text);
            FillCombobox studenti = new FillCombobox(FillComboboxStudent);

            studenti.Invoke();
        }