-
Notifications
You must be signed in to change notification settings - Fork 0
/
usuarios.cs
134 lines (119 loc) · 3.72 KB
/
usuarios.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
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 usuarios : Form
{
private int rango;
public usuarios()
{
InitializeComponent();
}
public void envia_rango(int ran)
{
rango = ran;
if (rango == 1)
{
}
else if (rango == 2)
{
}
else if (rango == 3)
{
}
}
private void usuarios_Load(object sender, EventArgs e)
{
recarga();
}
private void usuarios_FormClosed(object sender, FormClosedEventArgs e)
{
frmMenu mn = new frmMenu();
mn.rango(rango.ToString());
mn.Show();
this.Dispose();
}
public void recarga()
{
frmMenu mn = new frmMenu();
try
{
var consulta = "select * from usuarios;";
var c = new MySqlConnection(mn.ConexDBGlobal);
var adaptador = new MySqlDataAdapter(consulta, c);
var ds = new DataSet();
adaptador.Fill(ds);
dtaUsuarios.ReadOnly = true;
dtaUsuarios.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void txtAgregar_Click(object sender, EventArgs e)
{
Usuarios_Datos UD = new Usuarios_Datos();
UD.btnEditar.Visible = false;
UD.Show();
}
private void btnAct_Click(object sender, EventArgs e)
{
recarga();
}
private void button2_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 usuarios Where id_usuario ='" + id + "'";
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);
}
btnAct.PerformClick();
break;
case DialogResult.No:
MessageBox.Show("No");
break;
case DialogResult.Cancel:
MessageBox.Show("Cancel");
break;
}
}
string id;
private void dtaUsuarios_CellClick(object sender, DataGridViewCellEventArgs e)
{
id = dtaUsuarios.Rows[e.RowIndex].Cells[0].Value.ToString();
}
private void btnEditar_Click(object sender, EventArgs e)
{
Usuarios_Datos UD = new Usuarios_Datos();
UD.btnAgregar.Visible = false;
UD.CargarDatos(id);
UD.Show();
}
}
}