public void Insertar(C_Rol Dato)
{
try
{
abrirConexion();
MySqlCommand cmd1 = new MySqlCommand("SELECT COUNT(*) FROM roles", conn);
string id = (cmd1.ExecuteScalar()).ToString();
if (Convert.ToInt32(id) > 0)
{
MySqlCommand idmax = new MySqlCommand("SELECT MAX(rol_id) FROM roles", conn);
string _id = (idmax.ExecuteScalar()).ToString();
MySqlCommand cmd = new MySqlCommand("INSERT INTO roles (rol_id,nombre) VALUES ('" + (Convert.ToInt32(_id) + 1) + "', '" + Dato.Nombre + "')", conn);
cmd.ExecuteNonQuery();
}
else
{
MySqlCommand cmd3 = new MySqlCommand("INSERT INTO roles (rol_id,nombre) VALUES ('" + 1 + "', '" + Dato.Nombre + "')", conn);
cmd3.ExecuteNonQuery();
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error al registrar" + ex);
throw new Exception("Error !!!");
}
}
public void Editar(C_Rol Dato)
{
try
{
abrirConexion();
MySqlCommand cmd = new MySqlCommand("UPDATE roles SET nombre = '" + Dato.Nombre + "'WHERE rol_id = '" + Dato.ID + "'", conn);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error al Actualizar" + ex);
throw new Exception("Error !!!");
}
}
public void Eliminar(C_Rol Dato)
{
try
{
abrirConexion();
MySqlCommand cmd = new MySqlCommand("DELETE FROM roles WHERE rol_id = '" + Dato.ID + "'", conn);
if (MessageBox.Show("¿Está seguro que que desea eliminar '" + Dato.Nombre + "'?", "¡Advertencia!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
cmd.ExecuteNonQuery();
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error al Eliminar" + ex);
throw new Exception("Error !!!");
}
}
private void datostabla(string buscar)
{
C_Rol obj = new C_Rol();
dgvR.DataSource = obj.Listado(buscar);
}
