private void Mgonjwa_List_Load(object sender, EventArgs e)
{
// populate the datagridview with nurse data
MySqlCommand command = new MySqlCommand("SELECT * FROM `mgonjwa`");
dataGridView2.ReadOnly = true;
DataGridViewImageColumn piCol = new DataGridViewImageColumn();
dataGridView2.RowTemplate.Height = 80;
dataGridView2.DataSource = sick.getMgonjwa(command);
piCol.ImageLayout = DataGridViewImageCellLayout.Zoom;
dataGridView2.AllowUserToAddRows = false;
}
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);
}
}