Esempio n. 1
0
        private void buttonEdit_Click(object sender, EventArgs e)
        {
            try
            {
                int      id      = Convert.ToInt32(textBoxID.Text);
                string   fname   = textBoxPrenume.Text;
                string   lname   = textBoxNume.Text;
                string   clasa   = comboBoxClasa.Text;
                DateTime bdate   = dateTimePicker1.Value;
                string   phone   = textBoxTelefon.Text;
                string   address = textBoxAdresa.Text;
                string   gender  = "Male";
                if (radioButtonFemale.Checked)
                {
                    gender = "Female";
                }
                MemoryStream pic = new MemoryStream();

                int born_year = dateTimePicker1.Value.Year;
                int this_year = DateTime.Now.Year;
                if ((this_year - born_year < 10) || (this_year - born_year > 100))
                {
                    MessageBox.Show("Vârstă invalidă", "Dată de naștere invalidă", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else if (verif())
                {
                    pictureBoxStudentImage.Image.Save(pic, pictureBoxStudentImage.Image.RawFormat);
                    if (student.updateStudent(id, fname, lname, clasa, bdate, phone, gender, address, pic))
                    {
                        MessageBox.Show("Detalii student editate", "Editează student", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        fillGrid(new MySqlCommand("SELECT * FROM `student` ORDER BY `last_name`"));
                    }
                    else
                    {
                        MessageBox.Show("Eroare!", "Editează student", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
                else
                {
                    MessageBox.Show("Există câmpuri necompletate!", "Editează student", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
            }
            catch
            {
                MessageBox.Show("Introduceți un ID valid", "Editează student", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }