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