private void buscar()
{
Form1 obj = new Form1();
String selected;
if (listView1.SelectedItems.Count > 0)
{
selected = listView1.SelectedItems[0].Text;
}
else
{
return;
}
string qs = "SELECT * FROM medicos WHERE nome=@nome order by nome;";
MySqlParameter pam2 = new MySqlParameter("nome", selected);
List <MySqlParameter> sqlParameters = new List <MySqlParameter> {
pam2
};
DataTable detalhesTable = obj.executeSelect(qs, sqlParameters);
if (detalhesTable == null)
{
return;
}
if (detalhesTable.Rows.Count <= 0)
{
return;
}
DataRow informacoesMedico = detalhesTable.Rows[0];
// string encodedImage = System.Convert.ToBase64String(ImageToByteArray(pictureBox1.Image));
string base64image = informacoesMedico["foto"].ToString();
Image profilePicture = (Bitmap)((new ImageConverter()).ConvertFrom(System.Convert.FromBase64String(base64image)));
pictureBox2.Image = profilePicture;
selectedDoctor = Convert.ToInt32(informacoesMedico["codigo"].ToString());
label6.Text = informacoesMedico["nome"].ToString();
label7.Text = informacoesMedico["especialidade"].ToString();
label8.Text = "RG: " + informacoesMedico["rg"].ToString();
label9.Text = "Telefone: " + informacoesMedico["telefone"].ToString();
label10.Text = "CRM: " + informacoesMedico["crm"].ToString();
textBox7.Text = informacoesMedico["nome"].ToString();
textBox8.Text = informacoesMedico["especialidade"].ToString();
textBox9.Text = informacoesMedico["rg"].ToString();
textBox10.Text = informacoesMedico["telefone"].ToString();
textBox11.Text = informacoesMedico["crm"].ToString();
label18.Text = "Imagem da DB";
button8.Visible = true;
button4.Visible = true;
}
private void button2_Click(object sender, EventArgs e)
{
Form1 obj = new Form1();
string qs = "SELECT * FROM medicos WHERE rg=@rg;";
MySqlParameter pam2 = new MySqlParameter("rg", textBox3.Text);
List <MySqlParameter> sqlParameters = new List <MySqlParameter> {
pam2
};
DataTable rgTable = obj.executeSelect(qs, sqlParameters);
if (rgTable.Rows.Count > 0)
{
MessageBox.Show("Um doutor com esse RG já existe!");
return;
}
string query = $"INSERT INTO medicos(nome,especialidade,rg,telefone,crm,foto) VALUES (@nome,@especialidade,@rg,@telefone,@crm,@foto);";
string encodedImage = "";
if (pictureBox1.Image == null)
{
Assembly asm = Assembly.GetExecutingAssembly();
Stream strm = asm.GetManifestResourceStream("Clinica_Medica.unknownPicture.png");
Bitmap bmp = new Bitmap(strm);
encodedImage = System.Convert.ToBase64String(ImageToByteArray((Image)bmp));
}
else
{
encodedImage = System.Convert.ToBase64String(ImageToByteArray(pictureBox1.Image));
}
MySqlParameter pamNome = new MySqlParameter("nome", textBox1.Text);
MySqlParameter pamEspecialidade = new MySqlParameter("especialidade", textBox2.Text);
MySqlParameter pamRg = new MySqlParameter("rg", textBox3.Text);
MySqlParameter pamTelefone = new MySqlParameter("telefone", textBox4.Text);
MySqlParameter pamCrm = new MySqlParameter("crm", textBox5.Text);
MySqlParameter pamFoto = new MySqlParameter("foto", encodedImage);
sqlParameters = new List <MySqlParameter> {
pamNome, pamEspecialidade, pamRg, pamTelefone, pamCrm, pamFoto
};
obj.executarQuery(query, sqlParameters);
MessageBox.Show("Médico " + textBox1.Text + " inserido!");
}
private void listView1_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e)
{
if ((sender as ListView).FocusedItem != null)
{
(sender as ListView).FocusedItem.Selected = true;
}
Form1 obj = new Form1();
String queryPacient = "SELECT * FROM paciente WHERE nome = @cod;";
if (listView1.SelectedItems.Count == 0)
{
return;
}
MySqlParameter pam1 = new MySqlParameter("cod", listView1.SelectedItems[0].Text);
List <MySqlParameter> sqlParameters = new List <MySqlParameter> {
pam1
};
DataTable dtPacientes = obj.executeSelect(queryPacient, sqlParameters);
queryPacient = "SELECT * FROM consultas WHERE codigo_paciente = @cod;";
pam1 = new MySqlParameter("cod", dtPacientes.Rows[0][0].ToString());
sqlParameters = new List <MySqlParameter> {
pam1
};
dtPacientes = obj.executeSelect(queryPacient, sqlParameters);
listView2.Clear();
foreach (DataRow row in dtPacientes.Rows)
{
ListViewItem item = new ListViewItem(row[0].ToString());
for (int i = 1; i < dtPacientes.Columns.Count; i++)
{
item.SubItems.Add(row[i].ToString());
}
listView2.Items.Add(item);
}
}
private void Button1_Click(object sender, EventArgs e)
{
Form1 obj = new Form1();
if (listView1.SelectedItems.Count == 0)
{
return;
}
String selectedPacientName = listView1.SelectedItems[0].Text;
String queryPacient = "SELECT codigo FROM paciente WHERE nome = @name";
MySqlParameter pam1 = new MySqlParameter("name", selectedPacientName);
List <MySqlParameter> sqlParameters = new List <MySqlParameter> {
pam1
};
DataTable dtPacientes = obj.executeSelect(queryPacient, sqlParameters);
selectedPacientId = Convert.ToInt32(dtPacientes.Rows[0][0].ToString());
DateTime selectedDate = dateTimePicker1.Value + dateTimePicker2.Value.TimeOfDay;
String query = "INSERT INTO HORARIOS(horario,codigo_medico,codigo_paciente) VALUES(@date,@codMedic,@codPacient);";
MySqlParameter pam2 = new MySqlParameter("date", selectedDate);
MySqlParameter pam3 = new MySqlParameter("codMedic", consultasSelectedDoctorId);
MySqlParameter pam4 = new MySqlParameter("codPacient", selectedPacientId);
sqlParameters = new List <MySqlParameter> {
pam2, pam3, pam4
};
long insertTimeId = obj.executarQuery(query, sqlParameters);
query = "INSERT INTO CONSULTAS(CODIGO_HORARIO,CODIGO_PACIENTE,CODIGO_MEDICO,PRONTUARIO,EXAMES,RECEITAS) VALUES(@codTime, @codPacient, @codMedic,@prontuario,@exames,@receitas);";
MySqlParameter pam5 = new MySqlParameter("codTime", insertTimeId);
MySqlParameter pam6 = new MySqlParameter("prontuario", richTextBox1.Text);
MySqlParameter pam7 = new MySqlParameter("receitas", richTextBox3.Text);
MySqlParameter pam8 = new MySqlParameter("exames", richTextBox2.Text);
sqlParameters = new List <MySqlParameter> {
pam3, pam4, pam5, pam6, pam7, pam8
};
long insertedConsultId = obj.executarQuery(query, sqlParameters);
MessageBox.Show("Consulta Cadastrada!");
}
private void button2_Click(object sender, EventArgs e)
{
Form1 obj = new Form1();
string query = "select nome AS 'Nome',rg AS 'RG',telefone AS 'Telefone',plano_saude AS 'Plano de Saude',observacao AS 'Observacao',data_nascimento AS 'Data de Nascimento' from paciente where nome like @nome; ";
string builtName = '%' + textBox1.Text + '%';
MySqlParameter pamNome = new MySqlParameter("nome", builtName);
List <MySqlParameter> sqlParameters = new List <MySqlParameter> {
pamNome
};
DataTable dt = obj.executeSelect(query, sqlParameters);;
dataGridView1.DataSource = dt;
}
private void ListView2_SelectedIndexChanged(object sender, EventArgs e)
{
Form1 obj = new Form1();
String queryPacient = "SELECT * FROM consultas WHERE codigo = @cod;";
if (listView2.SelectedItems.Count == 0)
{
return;
}
MySqlParameter pam1 = new MySqlParameter("cod", listView2.SelectedItems[0].Text);
List <MySqlParameter> sqlParameters = new List <MySqlParameter> {
pam1
};
DataTable dtPacientes = obj.executeSelect(queryPacient, sqlParameters);
if (dtPacientes.Rows.Count != 0)
{
textBox1.Text = dtPacientes.Rows[0][4].ToString();
textBox2.Text = dtPacientes.Rows[0][5].ToString();
textBox3.Text = dtPacientes.Rows[0][6].ToString();
}
}
private void button3_Click(object sender, EventArgs e)
{
Form1 obj = new Form1();
string qs = "SELECT nome FROM medicos WHERE Nome LIKE @busca OR Especialidade LIKE @busca OR rg LIKE @busca OR telefone LIKE @busca OR crm LIKE @busca;";
MySqlParameter pam2 = new MySqlParameter("busca", '%' + textBox6.Text + '%');
List <MySqlParameter> sqlParameters = new List <MySqlParameter> {
pam2
};
DataTable searchTable = obj.executeSelect(qs, sqlParameters);
listView1.Clear();
foreach (DataRow row in searchTable.Rows)
{
ListViewItem item = new ListViewItem(row[0].ToString());
for (int i = 1; i < searchTable.Columns.Count; i++)
{
item.SubItems.Add(row[i].ToString());
}
listView1.Items.Add(item);
}
}
private void buscaPacientes()
{
Form1 obj = new Form1();
String query = "SELECT codigo,nome FROM paciente;";
List <MySqlParameter> sqlParameters = new List <MySqlParameter> {
};
DataTable dtPacientes = obj.executeSelect(query, sqlParameters);
listView1.Clear();
foreach (DataRow row in dtPacientes.Rows)
{
ListViewItem item = new ListViewItem(row[1].ToString());
for (int i = 1; i < dtPacientes.Columns.Count; i++)
{
item.SubItems.Add(row[i].ToString());
}
listView1.Items.Add(item);
}
}
