private void button4_Click(object sender, EventArgs e) { Form1 obj = new Form1(); String selected; if (listView1.SelectedItems.Count > 0) { selected = listView1.SelectedItems[0].Text; } else { return; } string qs = "DELETE FROM medicos WHERE nome=@nome;"; MySqlParameter pam2 = new MySqlParameter("nome", selected); List <MySqlParameter> sqlParameters = new List <MySqlParameter> { pam2 }; obj.executarQuery(qs, sqlParameters); MessageBox.Show("Médico Deletado!"); buscar(); }
private void button1_Click(object sender, EventArgs e) { Form1 obj = new Form1(); if (string.IsNullOrWhiteSpace(txtUsuario.Text) || string.IsNullOrWhiteSpace(textBox1.Text) || string.IsNullOrWhiteSpace(textBox2.Text)) { label4.Text = "Você precisa preencher todos os campos!"; return; } string hashedPassword = obj.hashPassword(textBox1.Text); string query = $"INSERT INTO usuarios(username,password) VALUES (@username,@password);"; MySqlParameter pam3 = new MySqlParameter("username", txtUsuario.Text); MySqlParameter pam4 = new MySqlParameter("password", hashedPassword); List <MySqlParameter> sqlParameters2 = new List <MySqlParameter> { pam3, pam4 }; obj.executarQuery(query, sqlParameters2); MessageBox.Show($"Usuário {txtUsuario.Text} registrado!"); registrationForm registrationForm = this; registrationForm.Dispose(false); }
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 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 Button3_Click(object sender, EventArgs e) { Form1 obj = new Form1(); String queryPacient = "DELETE 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 }; obj.executarQuery(queryPacient, sqlParameters); }
private void Button2_Click(object sender, EventArgs e) { Form1 obj = new Form1(); String queryPacient = "UPDATE consultas SET prontuario=@prontuario,exames=@exames,receitas=@receitas WHERE codigo=@cod;"; if (listView2.SelectedItems.Count == 0) { return; } MySqlParameter pam1 = new MySqlParameter("cod", listView2.SelectedItems[0].Text); MySqlParameter pam2 = new MySqlParameter("prontuario", textBox1.Text); MySqlParameter pam3 = new MySqlParameter("exames", textBox2.Text); MySqlParameter pam4 = new MySqlParameter("receitas", textBox3.Text); List <MySqlParameter> sqlParameters = new List <MySqlParameter> { pam1, pam2, pam3, pam4 }; obj.executarQuery(queryPacient, sqlParameters); }
private void button1_Click(object sender, EventArgs e) { Form1 obj = new Form1(); string query = $"INSERT INTO paciente(nome,rg,telefone,plano_saude,observacao,data_nascimento) VALUES (@nome,@rg,@telefone,@plano_saude,@observacao,@data_nascimento);"; string escapedPhone = new String(txtFone.Text.Where(Char.IsDigit).ToArray()); MySqlParameter pamUser = new MySqlParameter("nome", txtNome.Text); MySqlParameter pamRg = new MySqlParameter("rg", txtRg.Text); MySqlParameter pamFone = new MySqlParameter("telefone", escapedPhone); MySqlParameter pamPlano = new MySqlParameter("plano_saude", txtPlano.Text); MySqlParameter pamObservacao = new MySqlParameter("observacao", rtxtDescription.Text); MySqlParameter pamDtNasc = new MySqlParameter("data_nascimento", dateBirth.Value.Date); List <MySqlParameter> sqlParameters = new List <MySqlParameter> { pamUser, pamRg, pamFone, pamPlano, pamObservacao, pamDtNasc }; obj.executarQuery(query, sqlParameters); MessageBox.Show("Paciente " + txtNome.Text + " inserido!"); }
private void button6_Click(object sender, EventArgs e) { Form1 obj = new Form1(); String selected; if (listView1.SelectedItems.Count > 0) { selected = listView1.SelectedItems[0].Text; } else { return; } string qs = "UPDATE medicos SET nome=@newName,especialidade=@newSkill,rg=@newRg,telefone=@newPhone,crm=@newCrm,foto=@newPhoto WHERE nome=@name;"; string encodedImage; if (openFileDialog2.FileName != "openFileDialog2") { encodedImage = System.Convert.ToBase64String(ImageToByteArray(Image.FromFile(openFileDialog2.FileName))); } else { encodedImage = System.Convert.ToBase64String(ImageToByteArray(pictureBox2.Image)); } MySqlParameter pam1 = new MySqlParameter("name", selected); MySqlParameter pam2 = new MySqlParameter("newName", textBox7.Text); MySqlParameter pam3 = new MySqlParameter("newSkill", textBox8.Text); MySqlParameter pam4 = new MySqlParameter("newRg", textBox9.Text); MySqlParameter pam5 = new MySqlParameter("newPhone", textBox10.Text); MySqlParameter pam6 = new MySqlParameter("newCrm", textBox11.Text); MySqlParameter pam7 = new MySqlParameter("newPhoto", encodedImage); /* * 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(); */ List <MySqlParameter> sqlParameters = new List <MySqlParameter> { pam1, pam2, pam3, pam4, pam5, pam6, pam7 }; obj.executarQuery(qs, sqlParameters); MessageBox.Show("Médico Modificado!"); buscar(); }