コード例 #1
0
        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!");
            }
        }
コード例 #2
0
        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);
            }
        }