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