public fm_editarProf(string id)
{
InitializeComponent();
int proId = Int32.Parse(id);
string query = "SELECT * FROM profissional WHERE prof_id=@idPro";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand(query, conexao.conn);
cmd.Parameters.AddWithValue("@idPro", proId);
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
lb_id.Text = (dr["prof_id"].ToString());
tb_nome.Text = (dr["nome"].ToString());
tb_tel.Text = (dr["telefone"].ToString());
tb_cel.Text = (dr["celular"].ToString());
}
else
{
MessageBox.Show("Ops! Algo deu errado, favor entrar em contato com o suporte.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
conexao.desconectar();
}
private void bt_salvar_Click(object sender, EventArgs e)
{
string nome = tb_nome.Text;
string tel1 = tb_tel.Text;
string cel1 = tb_cel.Text;
Int32.TryParse(tel1, out int tel);
Int32.TryParse(cel1, out int cel);
int proid = Int32.Parse(lb_id.Text);
string query = "UPDATE profissional SET nome=@n, telefone=@t, celular=@c WHERE prof_id=@idPro";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conexao.conn;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("idPro", proid);
cmd.Parameters.AddWithValue("n", nome);
cmd.Parameters.AddWithValue("t", tel);
cmd.Parameters.AddWithValue("c", cel);
cmd.ExecuteNonQuery();
conexao.desconectar();
this.Close();
}
public fm_editarConta(string id)
{
InitializeComponent();
int contId = Int32.Parse(id);
string query = "SELECT * FROM conta WHERE conta_id=@idCont";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand(query, conexao.conn);
cmd.Parameters.AddWithValue("@idCont", contId);
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
lb_id.Text = (dr["conta_id"].ToString());
tb_nome.Text = (dr["nome"].ToString());
tb_valor.Text = (dr["valor"].ToString());
dp_data.Text = (dr["data_venc"].ToString());
}
else
{
MessageBox.Show("Ops! Algo deu errado, favor entrar em contato com o suporte.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
conexao.desconectar();
}
private void bt_salvar_Click(object sender, EventArgs e)
{
string nome = tb_nome.Text;
string tel = tb_tel.Text;
string cel = tb_cel.Text;
DateTime data = dp_data_nasc.Value;
string que = tb_queixa.Text;
string obj = tb_objetivo.Text;
int pacid = Int32.Parse(lb_id.Text);
string query = "UPDATE paciente SET nome=@n, telefone=@t, celular=@c, data_nasc=@d, queixa=@q, objetivo=@o WHERE paciente_id=@idPac";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conexao.conn;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("idPac", pacid);
cmd.Parameters.AddWithValue("n", nome);
cmd.Parameters.AddWithValue("t", tel);
cmd.Parameters.AddWithValue("c", cel);
cmd.Parameters.AddWithValue("d", data);
cmd.Parameters.AddWithValue("q", que);
cmd.Parameters.AddWithValue("o", obj);
cmd.ExecuteNonQuery();
conexao.desconectar();
this.Close();
}
public fm_pag_final(string id)
{
InitializeComponent();
int contId = Int32.Parse(id);
string query = "SELECT * FROM conta WHERE conta_id=@idCont ";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand(query, conexao.conn);
cmd.Parameters.AddWithValue("@idCont", contId);
cmd.Parameters.AddWithValue("@est", "aberto");
NpgsqlDataReader dr = cmd.ExecuteReader();
dr.Read();
DateTime data;
lb_id.Text = (dr["conta_id"].ToString());
string dt = (dr["data_venc"].ToString());
lb_valor.Text = (dr["valor"].ToString());
tb_nome.Text = (dr["nome"].ToString());
DateTime.TryParse(dt, out data);
lb_data_venc.Text = data.ToString("dd/MM/yyyy");
conexao.desconectar();
}
public fm_editarPlan(string id)
{
InitializeComponent();
int planId = Int32.Parse(id);
string query = "SELECT * FROM plano WHERE plano_id=@idPlan";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand(query, conexao.conn);
cmd.Parameters.AddWithValue("@idPlan", planId);
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
lb_id.Text = (dr["plano_id"].ToString());
tb_nome.Text = (dr["nome"].ToString());
tb_valor.Text = (dr["valor"].ToString());
cb_periodo.Text = (dr["periodo"].ToString());
cb_nPessoas.Text = (dr["nPessoas"].ToString());
cb_nPessoas.Items.Add("1");
cb_nPessoas.Items.Add("2");
cb_periodo.Items.Add("Avulso");
cb_periodo.Items.Add("Mensal");
cb_periodo.Items.Add("Trimestral");
}
else
{
MessageBox.Show("Ops! Algo deu errado, favor entrar em contato com o suporte.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
conexao.desconectar();
}
public fm_editarPac(string id)
{
InitializeComponent();
int pacId = Int32.Parse(id);
string query = "SELECT * FROM paciente WHERE paciente_id=@idPac";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand(query, conexao.conn);
cmd.Parameters.AddWithValue("@idPac", pacId);
NpgsqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
lb_id.Text = (dr["paciente_id"].ToString());
tb_nome.Text = (dr["nome"].ToString());
tb_tel.Text = (dr["telefone"].ToString());
tb_cel.Text = (dr["celular"].ToString());
dp_data_nasc.Text = (dr["data_nasc"].ToString());
tb_queixa.Text = (dr["queixa"].ToString());
tb_objetivo.Text = (dr["objetivo"].ToString());
lb_nAulas.Text = (dr["aulas"].ToString());
try
{
string id_str = (dr["paciente_id"].ToString());
int ret = -1;
byte[] ImageData = new byte[256 * 288];
string ImagePath = "C://teste/" + id_str + ".bmp";
ret = biometria.PSImgData2BMP(ImageData, ImagePath);
if (ret == 0)
{
bt_img.BackgroundImage = Image.FromFile("C://teste/" + id_str + ".bmp");
bt_img.BackgroundImageLayout = ImageLayout.Stretch;
}
else
{
MessageBox.Show("Erro ao coletar a biometria.", "Informação", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch {
bt_img.Text = "Sem Imagem";
}
}
else
{
MessageBox.Show("Ops! Algo deu errado, favor entrar em contato com o suporte.", "Erro", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
conexao.desconectar();
}
private void bt_salvar_Click(object sender, EventArgs e)
{
string nome = tb_nome.Text;
DateTime data = dp_data.Value;
Decimal valor = Convert.ToDecimal(tb_valor.Text);
int conid = Int32.Parse(lb_id.Text);
string query = "UPDATE conta SET nome=@n, data_venc=@dv, valor=@v WHERE conta_id=@idCont";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conexao.conn;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("idCont", conid);
cmd.Parameters.AddWithValue("n", nome);
cmd.Parameters.AddWithValue("dv", data);
cmd.Parameters.AddWithValue("v", valor);
cmd.ExecuteNonQuery();
conexao.desconectar();
this.Close();
}
private void bt_salvar_Click(object sender, EventArgs e)
{
string nome = tb_nome.Text;
string per = cb_periodo.Text;
double valor = Convert.ToDouble(tb_valor.Text);
int nPes = Int32.Parse(cb_nPessoas.Text);
int planid = Int32.Parse(lb_id.Text);
string query = "UPDATE plano SET nome=@n, periodo=@p, valor=@v, npessoas=@np WHERE plano_id=@idPlan";
conexao conexao = new conexao();
conexao.conectar();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = conexao.conn;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("idPlan", planid);
cmd.Parameters.AddWithValue("n", nome);
cmd.Parameters.AddWithValue("p", per);
cmd.Parameters.AddWithValue("v", valor);
cmd.Parameters.AddWithValue("np", nPes);
cmd.ExecuteNonQuery();
conexao.desconectar();
this.Close();
}
