public void funGuardar() { String sAccion = "Guardar"; String sTabla = "Bitacora"; String stringpad = "server=localhost;user id=root;database=BD_seguridad"; security_dll.security_dll connection = new security_dll.security_dll(stringpad); try { connection.OpenConnection(); connection.InsertarRegistro("insert into bitacora(id_usuario,fecha_bitacora,hora_bitacora,accion_usuario,tabla,resultado_bitacora,error_bitacora,ip_pc) values(500, sysdate(), now(), '" + sAccion + "', '" + sTabla + "', '" + sExitoso + "', '" + sError + "','" + localIP + "')"); connection.CloseConnection(); MessageBox.Show("Se ha Ingresado Correctamente!"); } catch (Exception ex) { MessageBox.Show(ex.Message); s_error = "." + ex.Message + "."; MessageBox.Show(s_error); connection.OpenConnection(); connection.InsertarRegistro("insert into bitacora(id_usuario,fecha_bitacora,hora_bitacora,accion_usuario,tabla,resultado_bitacora,error_bitacora,ip_pc) values(500, sysdate(), now(), '" + sAccion + "', '" + sTabla + "', '" + sExitoso_n + "', '" + s_error + "','" + localIP + "')"); connection.CloseConnection(); MessageBox.Show("Se ha Ingresado Correctamente!"); } }
private void button1_Click_1(object sender, EventArgs e) { obtenerIP(); String sAccion = "Guardar"; String sTabla = "Detalle aplicacion derecho"; String stringpad = "server=localhost;user id=root;database=BD_seguridad"; security_dll.security_dll connection = new security_dll.security_dll(stringpad); //connection.OpenConnection(); //connection.InsertarRegistro("insert into bitacora(id_usuario,fecha_bitacora,hora_bitacora,accion_usuario,tabla,resultado_bitacora,error_bitacora,ip_pc) values(500, sysdate(), now(), '" + sAccion + "', '" + sTabla + "', '" + sExitoso + "', '" + sError + "','"+localIP+"')"); //connection.CloseConnection(); try { connection.OpenConnection(); connection.InsertarRegistro("insert into bitacora(id_usuario,fecha_bitacora,hora_bitacora,accion_usuario,tabla,resultado_bitacora,error_bitacora,ip_pc) values(500, sysdate(), now(), '" + sAccion + "', '" + sTabla + "', '" + sExitoso + "', '" + sError + "','" + localIP + "')"); connection.CloseConnection(); MessageBox.Show("Se ha Ingresado Correctamente!"); }catch (Exception ex) { MessageBox.Show(ex.Message); s_error = "." + ex.Message + "."; MessageBox.Show(s_error); } }