/
Organos.cs
157 lines (144 loc) · 4.88 KB
/
Organos.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace DeepTec
{
public partial class Organos : Form
{
public Organos()
{
InitializeComponent();
}
private int rango;
public void envia_rango(int ran)
{
rango = ran;
if (rango == 1)
{
btnAgregar.Visible = true;
btnEditar.Visible = true;
btnEliminar.Visible = true;
}
else if (rango == 2)
{
btnAgregar.Visible = true;
btnEditar.Visible = true;
btnEliminar.Visible = false;
}
else if (rango == 3)
{
btnAgregar.Visible = false;
btnEditar.Visible = false;
btnEliminar.Visible = false;
}
}
private void btnMostrar_Click(object sender, EventArgs e)
{
switch (cbBusqueda.Text)
{
case "Todos":
ConsultaDB("");
break;
case "ID Organo":
ConsultaDB(" where id_organo='" + txtEspecifica.Text + "'");
break;
case "Nombre del Organo":
ConsultaDB(" where nombre_organo='" + txtEspecifica.Text + "'");
break;
case "Peso":
ConsultaDB(" where peso='" + txtEspecifica.Text + "'");
break;
case "Fecha de Extraccion":
ConsultaDB(" where fecha_extraccion='" + txtEspecifica.Text + "'");
break;
case "ID Donador":
ConsultaDB(" where id_donador='" + txtEspecifica.Text + "'");
break;
}
}
private void ConsultaDB(string where)
{
frmMenu mn = new frmMenu();
try
{
var consulta = "select * from organos" + where + ";";
var c = new MySqlConnection(mn.ConexDBGlobal);
var adaptador = new MySqlDataAdapter(consulta, c);
var commandBuilder = new MySqlCommandBuilder(adaptador);
var ds = new DataSet();
adaptador.Fill(ds);
dtaOrganos.ReadOnly = true;
dtaOrganos.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Organos_FormClosed(object sender, FormClosedEventArgs e)
{
frmMenu mn = new frmMenu();
mn.rango(rango.ToString());
mn.Show();
this.Dispose();
}
private void btnAgregar_Click(object sender, EventArgs e)
{
Organos_Datos OD = new Organos_Datos();
OD.btnModificar.Visible = false;
OD.Show();
}
private void btnEliminar_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Seguro que dese Borrar?", "Salir", MessageBoxButtons.YesNoCancel);
switch (result)
{
case DialogResult.Yes:
frmMenu mn = new frmMenu();
string query = "Delete From organos Where id_organo ='" + id_organo + "'";
MySqlConnection Conn = new MySqlConnection(mn.ConexDBGlobal);
MySqlCommand cmd = new MySqlCommand(query, Conn);
MySqlDataReader Read;
try
{
Conn.Open();
Read = cmd.ExecuteReader();
MessageBox.Show("Borrado!");
while (Read.Read())
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
btnMostrar.PerformClick();
break;
case DialogResult.No:
MessageBox.Show("No");
break;
case DialogResult.Cancel:
MessageBox.Show("Cancel");
break;
}
}
string id_organo;
private void dtaOrganos_CellClick(object sender, DataGridViewCellEventArgs e)
{
id_organo = dtaOrganos.Rows[e.RowIndex].Cells[0].Value.ToString();
}
private void btnEditar_Click(object sender, EventArgs e)
{
Organos_Datos OD = new Organos_Datos();
OD.CargarDatos(id_organo);
OD.Show();
}
}
}