private void button5_Click(object sender, EventArgs e)
{
frm_reporte_recibo rec = new frm_reporte_recibo();
string id = lbl_id.Text;
object celda = dataGridView1.CurrentCell.Value;
string data = "";
string campo = "";
string campo2 = "";
switch (id)
{
case "1":
data = mtb_cedula_c.Text;
campo = "cedula";
campo2 = "cedula_c";
break;
case "2":
data = maskedTextBox1.Text;
campo = "cedula";
campo2 = "cedula_c";
break;
case "3":
data = textBox4.Text;
campo = "nombre";
campo2 = "nombre_c";
break;
case "4":
data = textBox2.Text;
campo = "apellido";
campo2 = "apellido_c";
break;
}
//string datos = cbx_estado.SelectedItem.ToString();
string cadsql5 = "SELECT nombre, apellido from pr_clientes where " + campo + "='" + data + "' ";
MySqlCommand com5 = new MySqlCommand(cadsql5, con);
con.Open();
MySqlDataReader leer5 = com5.ExecuteReader();
if (leer5.Read() == true)
{
rec.label11.Text = leer5[0].ToString();
rec.label18.Text = leer5[1].ToString();
con.Close();
}
con.Close();
con.Open();
string cadsql4 = "SELECT SUM(b.monto)AS monto FROM pr_clientes AS a INNER JOIN pr_gastos AS b ON a.client_Id = b.client_Id where " + campo + "='" + data + "' and b.tipo='" + celda + "'";
MySqlCommand com4 = new MySqlCommand(cadsql4, con);
MySqlDataReader leer4 = com4.ExecuteReader();
if (leer4.Read() == true)
{
rec.label12.Text = leer4[0].ToString();
con.Close();
}
con.Close();
rec.Show();
}
private void button5_Click(object sender, EventArgs e)
{
frm_reporte_recibo rec = new frm_reporte_recibo();
string id = lbl_id.Text;
object celda = dataGridView1.CurrentCell.Value;
string data = "";
string campo = "";
string campo2 = "";
switch (id)
{
case "1":
data = mtb_cedula_c.Text;
campo = "cedula";
campo2 = "cedula_c";
break;
case "2":
data = maskedTextBox1.Text;
campo = "cedula";
campo2 = "cedula_c";
break;
case "3":
data = textBox4.Text;
campo = "nombre";
campo2 = "nombre_c";
break;
case "4":
data = textBox2.Text;
campo = "apellido";
campo2 = "apellido_c";
break;
}
//string datos = cbx_estado.SelectedItem.ToString();
string cadsql5 = "SELECT nombre, apellido from pr_clientes where " + campo + "='" + data + "' ";
MySqlCommand com5 = new MySqlCommand(cadsql5, con);
con.Open();
MySqlDataReader leer5 = com5.ExecuteReader();
if (leer5.Read() == true)
{
rec.label11.Text = leer5[0].ToString();
rec.label18.Text = leer5[1].ToString();
con.Close();
}
con.Close();
con.Open();
string cadsql4 = "SELECT SUM(b.monto)AS monto FROM pr_clientes AS a INNER JOIN pr_gastos AS b ON a.client_Id = b.client_Id where " + campo + "='" + data + "' and b.tipo='" + celda + "'";
MySqlCommand com4 = new MySqlCommand(cadsql4, con);
MySqlDataReader leer4 = com4.ExecuteReader();
if (leer4.Read() == true)
{
rec.label12.Text = leer4[0].ToString();
con.Close();
}
con.Close();
rec.Show();
}
private void button7_Click(object sender, EventArgs e)
{
frm_reporte_recibo rec = new frm_reporte_recibo();
string cadsql = "select * from pr_compra where cedula_c='" + mtb_cedula_c.Text + "'";
MySqlCommand com = new MySqlCommand(cadsql, con);
con.Open();
MySqlDataReader leer = com.ExecuteReader();
if (leer.Read() == true)
{
MySqlConnection cn;
MySqlCommand cmd;
MySqlDataReader dr;
try
{
cn = new MySqlConnection("server=localhost;user id=root; database=proyecto3; password="******"select servicio, objeto, monto, nombre_g, nombre_i, direccion from pr_compra where hidden=0 and apellido_c='" + textBox2.Text + "'", cn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
this.dataGridView1.Rows.Add(dr.GetValue(0), dr.GetValue(1), dr.GetValue(2), dr.GetValue(3), dr.GetValue(4), dr.GetValue(5));
}
cn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}
}
con.Close();
string cadsql1 = "select * from pr_divorcios where cedula_c='" + mtb_cedula_c.Text + "'";
MySqlCommand com1 = new MySqlCommand(cadsql1, con);
con.Open();
MySqlDataReader leer1 = com1.ExecuteReader();
if (leer1.Read() == true)
{
MySqlConnection cn;
MySqlCommand cmd;
MySqlDataReader dr;
try
{
cn = new MySqlConnection("server=localhost;user id=root; database=proyecto3; password="******"select servicio, razon, costo, abogado from pr_divorcios where hidden=0 and cedula_c='" + mtb_cedula_c.Text + "'", cn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
this.dataGridView1.Rows.Add(dr.GetValue(0), dr.GetValue(1), dr.GetValue(2), dr.GetValue(3));
}
cn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}
}
con.Close();
string cadsql2 = "select * from pr_alquiler where cedula_c='" + mtb_cedula_c.Text + "'";
MySqlCommand com2 = new MySqlCommand(cadsql2, con);
con.Open();
MySqlDataReader leer2 = com2.ExecuteReader();
if (leer2.Read() == true)
{
MySqlConnection cn;
MySqlCommand cmd;
MySqlDataReader dr;
try
{
cn = new MySqlConnection("server=localhost;user id=root; database=proyecto3; password="******"select servicio, objeto, alquiler, notario, direccion from pr_alquiler where hidden=0 and cedula_c='" + mtb_cedula_c.Text + "'", cn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
this.dataGridView1.Rows.Add(dr.GetValue(0), dr.GetValue(1), dr.GetValue(2), dr.GetValue(3), dr.GetValue(4));
rec.label11.Text = dr[2].ToString();
}
cn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}
}
con.Close();
}
private void button7_Click(object sender, EventArgs e)
{
frm_reporte_recibo rec = new frm_reporte_recibo();
string cadsql = "select * from pr_compra where cedula_c='" + mtb_cedula_c.Text + "'";
MySqlCommand com = new MySqlCommand(cadsql, con);
con.Open();
MySqlDataReader leer = com.ExecuteReader();
if (leer.Read() == true)
{
MySqlConnection cn;
MySqlCommand cmd;
MySqlDataReader dr;
try
{
cn = new MySqlConnection("server=localhost;user id=root; database=proyecto3; password="******"select servicio, objeto, monto, nombre_g, nombre_i, direccion from pr_compra where hidden=0 and apellido_c='" + textBox2.Text + "'", cn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
this.dataGridView1.Rows.Add(dr.GetValue(0), dr.GetValue(1), dr.GetValue(2), dr.GetValue(3), dr.GetValue(4), dr.GetValue(5));
}
cn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}
}
con.Close();
string cadsql1 = "select * from pr_divorcios where cedula_c='" + mtb_cedula_c.Text + "'";
MySqlCommand com1 = new MySqlCommand(cadsql1, con);
con.Open();
MySqlDataReader leer1 = com1.ExecuteReader();
if (leer1.Read() == true)
{
MySqlConnection cn;
MySqlCommand cmd;
MySqlDataReader dr;
try
{
cn = new MySqlConnection("server=localhost;user id=root; database=proyecto3; password="******"select servicio, razon, costo, abogado from pr_divorcios where hidden=0 and cedula_c='" + mtb_cedula_c.Text + "'", cn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
this.dataGridView1.Rows.Add(dr.GetValue(0), dr.GetValue(1), dr.GetValue(2), dr.GetValue(3));
}
cn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}
}
con.Close();
string cadsql2 = "select * from pr_alquiler where cedula_c='" + mtb_cedula_c.Text + "'";
MySqlCommand com2 = new MySqlCommand(cadsql2, con);
con.Open();
MySqlDataReader leer2 = com2.ExecuteReader();
if (leer2.Read() == true)
{
MySqlConnection cn;
MySqlCommand cmd;
MySqlDataReader dr;
try
{
cn = new MySqlConnection("server=localhost;user id=root; database=proyecto3; password="******"select servicio, objeto, alquiler, notario, direccion from pr_alquiler where hidden=0 and cedula_c='" + mtb_cedula_c.Text + "'", cn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
this.dataGridView1.Rows.Add(dr.GetValue(0), dr.GetValue(1), dr.GetValue(2), dr.GetValue(3), dr.GetValue(4));
rec.label11.Text = dr[2].ToString();
}
cn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message);
}
}
con.Close();
}