public void PingHost(Host host, int numeroTestes) { bool pingou = true; Ping pinger = new Ping(); try { for (int i = 0; i < numeroTestes; i++) { if (!pingou) break; PingReply reply = pinger.Send(host.ip); pingou = reply.Status == IPStatus.Success; } } catch (PingException) { pingou = false; } if (host.em_pe != pingou) { host.em_pe = pingou; host.ultima_alteracao = DateTime.Now.ToString(); banco.atualizarHost(host); } }
public void removerHost(Host host) { DataTable dt = new DataTable(); String insSQL = "DELETE FROM TB_HOST WHERE ID_HOST = " + host.id_host; SQLiteDataAdapter da = new SQLiteDataAdapter(insSQL, stringConn); da.Fill(dt); }
public void atualizarHost(Host host) { DataTable dt = new DataTable(); String insSQL = "UPDATE TB_HOST SET NOME = '" + host.nome + "', IP='" + host.ip + "', ATIVO = '" + host.ativo + "', EM_PE = '" + host.em_pe + "', ULTIMA_ALTERACAO = '" + host.ultima_alteracao +"' WHERE ID_HOST = "+host.id_host; SQLiteDataAdapter da = new SQLiteDataAdapter(insSQL, stringConn); da.Fill(dt); }
public void inserirHost(Host host) { DataTable dt = new DataTable(); String insSQL = "INSERT INTO TB_HOST (NOME, IP, ATIVO, EM_PE, ULTIMA_ALTERACAO) VALUES ('"+ host.nome + "', '" + host.ip + "','" + host.ativo + "','" + host.em_pe + "', '" + host.ultima_alteracao + "')"; SQLiteDataAdapter da = new SQLiteDataAdapter(insSQL, stringConn); da.Fill(dt); }
private void btn_cadastrar_Click(object sender, EventArgs e) { host = new Host(); host.nome = txt_nome.Text; host.ip = txt_ip.Text; host.em_pe = false; host.ativo = true; host.ultima_alteracao = DateTime.Now.ToString(); banco.inserirHost(host); cadastrou = true; this.Close(); }
public List<Host> obterHosts() { DataTable dt = new DataTable(); List<Host> hosts = new List<Host>(); String insSQL = "select id_host, nome, ip, cast (ativo as varchar) as ativo, cast(em_pe as varchar) as em_pe, ultima_alteracao from TB_HOST"; SQLiteDataAdapter da = new SQLiteDataAdapter(insSQL, stringConn); da.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++ ) { Host h = new Host(); h.id_host = Convert.ToInt32(dt.Rows[i]["ID_HOST"].ToString()); h.nome = dt.Rows[i]["NOME"].ToString(); h.ip = dt.Rows[i]["IP"].ToString(); h.ativo = Convert.ToBoolean(dt.Rows[i]["ATIVO"]); h.em_pe = Convert.ToBoolean(dt.Rows[i]["EM_PE"]); h.ultima_alteracao = dt.Rows[i]["ULTIMA_ALTERACAO"].ToString(); hosts.Add(h); } return hosts; }
public void vaiTestando(Host host) { while (host.ativo) { Thread t = new Thread(() => PingHost(host, 5)); t.Start(); Thread.Sleep(5000); } }