public void DbUpdateTest()
{
dbaddress = newdb.getdbparam("config.txt").GetValue(1).ToString();
newdb.updatedb(dbaddress, "UPDATE forscan SET (Код='0', ip='0.0.0.0', grp=test) WHERE id=0");
}
public void checknow()
{
Console.WriteLine("Monitor started.\n");
string dbaddress = null;
Process MyProc = new Process();
MyProc.StartInfo.FileName = "MSservice.exe";
icmp icmp = new icmp();
dbwork db = new dbwork();
string newnowstate = "", newlasterror = "", newlastsuccess = "";
DateTime newlasttime = DateTime.Parse("00:00:00");
int tempkod = 0, errortimes = 0;
int scanint;
while (true)
{
if (db.getdbparam("config.txt").GetValue(1).ToString() != dbaddress)
{
dbaddress = db.getdbparam("config.txt").GetValue(1).ToString();
Console.WriteLine("\nNew db address: " + dbaddress + "\n");
}
else
{
//check scan
if (db.getdbparam("config.txt").GetValue(2).ToString() != "scanworknow")
{
if (db.tableexist(dbaddress, "forscan"))
{
MyProc.StartInfo.Arguments = "scantd";
MyProc.Start();
Console.WriteLine("\nNew hosts found. Run scan\n");
}
}
//run monitoring
OleDbDataReader tempread = db.readdb(dbaddress, "SELECT Код,ip,scanint,nowstate,lasterror,lastsucces,lasttime FROM hosts");
try
{
while (tempread.Read())
{
tempkod = Convert.ToInt32(tempread["Код"]);
try
{
scanint = Convert.ToInt32(tempread["scanint"]);
}
catch (Exception ex) { Console.WriteLine("Convert scanint error: " + ex); scanint = 0; }
host temp = new host(tempkod, (tempread["ip"]).ToString(), scanint, (tempread["nowstate"]).ToString(), (tempread["lasterror"]).ToString(), (tempread["lastsucces"]).ToString(), (tempread["lasttime"]).ToString());
if (temp.timecheck())
{
newnowstate = "";
newlasterror = "";
newlastsuccess = "";
newlasttime = DateTime.Parse("00:00:00");
Console.Write("host: " + temp.Ip + "\t");
if (icmp.ping(temp.Ip, 1))
{
newnowstate = "ok";
newlastsuccess = icmp.ping(temp.Ip);
newlasttime = DateTime.Now;
db.updatedb(dbaddress, "UPDATE hosts SET nowstate='" + newnowstate + "', lastsucces='" + newlastsuccess + "', lasttime='" + newlasttime + "' WHERE Код =" + tempkod);
}
else
{
newnowstate = "na";
newlasterror = DateTime.Now.ToString();
newlasttime = DateTime.Now;
db.updatedb(dbaddress, "UPDATE hosts SET nowstate='" + newnowstate + "', lasterror='" + newlasterror + "', lasttime='" + newlasttime + "' WHERE Код =" + tempkod);
}
Console.WriteLine(newnowstate);
}
}
}
catch (Exception ex)
{
Console.Write("Ошибка tempread.Read()\n" + ex + "\n" + errortimes++ + " times already");
if (errortimes > 3)
{
MyProc.StartInfo.Arguments = "check";
MyProc.Start();
return;
}
}
Thread.Sleep(5000);
}
}
}
public void checknow()
{
Console.WriteLine("Monitor started.\n");
string dbaddress = null;
Process MyProc = new Process();
MyProc.StartInfo.FileName = "MSservice.exe";
icmp icmp = new icmp();
dbwork db = new dbwork();
string newnowstate = "", newlasterror = "", newlastsuccess = "";
DateTime newlasttime = DateTime.Parse("00:00:00");
int tempkod = 0, errortimes = 0;
int scanint;
while (true)
{
if (db.getdbparam("config.txt").GetValue(1).ToString() != dbaddress)
{
dbaddress = db.getdbparam("config.txt").GetValue(1).ToString();
Console.WriteLine("\nNew db address: " + dbaddress + "\n");
}
else
{
//check scan
if (db.getdbparam("config.txt").GetValue(2).ToString() != "scanworknow")
{
if (db.tableexist(dbaddress, "forscan"))
{
MyProc.StartInfo.Arguments = "scantd";
MyProc.Start();
Console.WriteLine("\nNew hosts found. Run scan\n");
}
}
//run monitoring
OleDbDataReader tempread = db.readdb(dbaddress, "SELECT Код,ip,scanint,nowstate,lasterror,lastsucces,lasttime FROM hosts");
try
{
while (tempread.Read())
{
tempkod = Convert.ToInt32(tempread["Код"]);
try
{
scanint = Convert.ToInt32(tempread["scanint"]);
}
catch (Exception ex) { Console.WriteLine("Convert scanint error: " + ex); scanint = 0; }
host temp = new host(tempkod, (tempread["ip"]).ToString(), scanint, (tempread["nowstate"]).ToString(), (tempread["lasterror"]).ToString(), (tempread["lastsucces"]).ToString(), (tempread["lasttime"]).ToString());
if (temp.timecheck())
{
newnowstate = "";
newlasterror = "";
newlastsuccess = "";
newlasttime = DateTime.Parse("00:00:00");
Console.Write("host: " + temp.Ip + "\t");
if (icmp.ping(temp.Ip, 1))
{
newnowstate = "ok";
newlastsuccess = icmp.ping(temp.Ip);
newlasttime = DateTime.Now;
db.updatedb(dbaddress, "UPDATE hosts SET nowstate='" + newnowstate + "', lastsucces='" + newlastsuccess + "', lasttime='" + newlasttime + "' WHERE Код =" + tempkod);
}
else
{
newnowstate = "na";
newlasterror = DateTime.Now.ToString();
newlasttime = DateTime.Now;
db.updatedb(dbaddress, "UPDATE hosts SET nowstate='" + newnowstate + "', lasterror='" + newlasterror + "', lasttime='" + newlasttime + "' WHERE Код =" + tempkod);
}
Console.WriteLine(newnowstate);
}
}
}
catch (Exception ex)
{
Console.Write("Ошибка tempread.Read()\n" + ex + "\n" + errortimes++ + " times already");
if (errortimes > 3)
{
MyProc.StartInfo.Arguments = "check";
MyProc.Start();
return;
}
}
Thread.Sleep(5000);
}
}
}