private void btnAddStudent_Click(object sender, EventArgs e) { //añadir nuevo estudiante STUDENT student = new STUDENT(); string fname = textBoxFname.Text; string lname = textBoxLname.Text; DateTime bdate = dateTimePicker1.Value; string phone = maskedTextBoxPhone.Text; string address = textBoxAddress.Text; string gender = "Male"; if (radioButtonFemale.Checked) { gender = "Female"; } MemoryStream pic = new MemoryStream(); //la edad del estudiante debe ser entre 10 y 100 int born_year = dateTimePicker1.Value.Year; int this_year = DateTime.Now.Year; if ((this_year - born_year) < 10) { MessageBox.Show("The student age most be over 10", "Invalid birthdate", MessageBoxButtons.OK); } else if ((this_year - born_year) >= 100) { MessageBox.Show("The student age most be below 100", "Invalid birthdate", MessageBoxButtons.OK); } else if (verifyData()) { pictureBoxStudent.Image.Save(pic, pictureBoxStudent.Image.RawFormat); if (student.insertStudent(fname, lname, bdate, phone, gender, address, pic)) { MessageBox.Show("New Student Added", "Add Student", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Error", "Add Student", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Empty Fields", "Add Student", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void StaticsForm_Load(object sender, EventArgs e) { //colores del panel panTotalColor = panelTotal.BackColor; panMaleColor = panelMale.BackColor; panFemaleColor = panelFemale.BackColor; //desplegar los valores STUDENT student = new STUDENT(); double totalStudents = Convert.ToDouble(student.TotalStudents()); double totalMaleStudent = Convert.ToDouble(student.TotalMaleStudents()); double totalFemaleStudent = Convert.ToDouble(student.TotalFemaleStudents()); //contar % de estudiantes double malePercentage = totalMaleStudent * 100 / totalStudents; double femalePercentage = totalFemaleStudent * 100 / totalStudents; labelTotal.Text = "Total Students: " + totalStudents.ToString(); labelMale.Text = "Male: " + malePercentage.ToString("0.00") + "%"; labelFemale.Text = "Female:" + femalePercentage.ToString("0.00") + "%"; }