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); } }