private void buttonAdd_Click(object sender, EventArgs e) { // add new patient sick sick = new sick(); string fname = textBoxFirstName.Text; string lname = textBoxLastName.Text; DateTime dob = dateTimePicker1.Value; string pnum = textBoxPhoneNumber.Text; string addrs = textBoxAddress.Text; string cntry = textBoxCountry.Text; string city = textBoxCity.Text; string email = textBoxEmail.Text; string psp = textBoxPassport.Text; string disease = textBoxDisease.Text; string dname = textBoxDoctorsName.Text; string gender = "Male"; if (radioButtonFemale.Checked) { gender = "Female"; } MemoryStream pic = new MemoryStream(); // we need to check the age of the doctors // the doctors age must be between 10-100 int born_year = dateTimePicker1.Value.Year; int this_year = DateTime.Now.Year; if (((this_year - born_year) < 1) || ((this_year - born_year) > 100)) { MessageBox.Show("The Patients age must be between 1 and 100", "Invalid Birth Date", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (verif()) { pictureBoxImage.Image.Save(pic, pictureBoxImage.Image.RawFormat); if (sick.insertMgonjwa(fname, lname, gender, dob, pnum, addrs, pic, cntry, city, email, psp, disease, dname)) { MessageBox.Show("New Patient Added", "Add Patient", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Error", "Add Patient", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Empty Fields", "Add Patient", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void buttonFind_Click(object sender, EventArgs e) { sick sick = new sick(); //search nurse by id try { int id = Convert.ToInt32(textBoxID.Text); MySqlCommand command = new MySqlCommand("SELECT `id`, `First_Name`, `Last_Name`, `Gender`, `Date_Of_Birth`, `Phone_Number`, `Address`, `Picture`, `Country`, `City`, `Email`, `Passport`, `Disease`, `Doctors_Name` FROM `mgonjwa` WHERE `id`=" + id); DataTable table = sick.getMgonjwa(command); if (table.Rows.Count > 0) { textBoxFirstName.Text = table.Rows[0]["First_Name"].ToString(); textBoxLastName.Text = table.Rows[0]["Last_Name"].ToString(); //gender if (table.Rows[0]["Gender"].ToString() == "Female") { radioButtonFemale.Checked = true; } else { radioButtonMale.Checked = true; } dateTimePicker1.Value = (DateTime)table.Rows[0]["Date_Of_Birth"]; textBoxPhoneNumber.Text = table.Rows[0]["Phone_Number"].ToString(); textBoxAddress.Text = table.Rows[0]["Address"].ToString(); //image byte[] pic = (byte[])table.Rows[0]["Picture"]; MemoryStream picture = new MemoryStream(pic); pictureBox1.Image = Image.FromStream(picture); textBoxCountry.Text = table.Rows[0]["Country"].ToString(); textBoxCity.Text = table.Rows[0]["City"].ToString(); textBoxEmail.Text = table.Rows[0]["Email"].ToString(); textBoxPassport.Text = table.Rows[0]["Passport"].ToString(); textBoxDisease.Text = table.Rows[0]["Disease"].ToString(); textBoxDoctorsName.Text = table.Rows[0]["Doctors_Name"].ToString(); } } catch { MessageBox.Show("Enter a Valid Patient ID", "Invalid ID", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonDelete_Click(object sender, EventArgs e) { //remove the selected Nurse from the database try { int id = Convert.ToInt32(textBoxID.Text); sick sick = new sick(); //show a confirmation before deleting the nurse if (MessageBox.Show("Are You Sure You Want To Delete This Patient", "Delete Patient", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (sick.deleteMgonjwa(id)) { MessageBox.Show("Patient Deleted", "Delete Patient", MessageBoxButtons.OK, MessageBoxIcon.Information); //clear fields textBoxID.Text = ""; textBoxFirstName.Text = ""; textBoxLastName.Text = ""; textBoxAddress.Text = ""; dateTimePicker1.Value = DateTime.Now; textBoxPhoneNumber.Text = ""; textBoxCountry.Text = ""; textBoxCity.Text = ""; textBoxEmail.Text = ""; textBoxPassport.Text = ""; textBoxDisease.Text = ""; textBoxDoctorsName.Text = ""; pictureBox1.Image = null; } else { MessageBox.Show("Patient Not Deleted", "Delete Patient", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch { MessageBox.Show("Enter a Valid Patient ID", "Delete Patient", MessageBoxButtons.OK, MessageBoxIcon.Error); } }