private void loadTable()
{
MSSQL ms = new MSSQL();
List <Events> evs = ms.GetEvents();
foreach (Events ev in evs)
{
String el = "";
switch (ev.eventLevel)
{
case 0:
el = "0: Normal";
break;
case 1:
el = "1: Concern";
break;
case 2:
el = "2: Warning";
break;
case 3:
el = "3: Critical";
break;
}
EventsTable.Items.Add(new EVTableRow {
Code = ev.eventCode, Date = ev.eventDate.ToString("dd/MMM/yyyy hh:mm:ss tt"), Message = ev.eventMessage, IP = ev.eventIP, GUID = ev.eventGUID, Severity = el
});
}
ms.CloseCon();
}
private void LoadTable()
{
MSSQL ms = new MSSQL();
List <Whitelists> wls = ms.GetWhitelists();
foreach (Whitelists wl in wls)
{
WhitelistTable.Items.Add(new WLTableRow {
Datetime = wl.Datetime1.ToString("dd/MMM/yyyy hh:mm:ss tt"), Pid = wl.Pid1, Vid = wl.Vid1, SerialNumber = wl.SerialNumber1, WhitelistID = wl.WhitelistID1
});
}
ms.CloseCon();
}
private void BtnAddOne_Click(object sender, RoutedEventArgs e)
{
Whitelists wl;
if ((VidAddOne.Text.Trim().Length == 0 || VidAddOne.Text.Trim().Length > 4) && (SerialAddOne.Text.Trim().Length > 255 || SerialAddOne.Text.Trim().Length == 0) && (PidAddOne.Text.Trim().Length == 0 || PidAddOne.Text.Trim().Length > 4))
{
VidAddOne.BorderBrush = new SolidColorBrush(Colors.Red);
PidAddOne.BorderBrush = new SolidColorBrush(Colors.Red);
SerialAddOne.BorderBrush = new SolidColorBrush(Colors.Red);
}
else
{
wl = new Whitelists(DateTime.Now,
VidAddOne.Text.Trim().ToUpper(),
PidAddOne.Text.Trim().ToUpper(),
SerialAddOne.Text.Trim());
MSSQL ms = new MSSQL();
if (ms.AddWhitelist(wl) == 0)
{
//Set Success
ms.SetLastUpdated(DateTime.Now, MSSQL.GET_WHITELIST_LIST);
VidAddOne.ClearValue(Border.BorderBrushProperty);
PidAddOne.ClearValue(Border.BorderBrushProperty);
SerialAddOne.ClearValue(Border.BorderBrushProperty);
VidAddOne.Text = "";
PidAddOne.Text = "";
SerialAddOne.Text = "";
MsgAddOne.Content = "Success!";
WhitelistTable.Items.Clear();
LoadTable();
}
else if (ms.AddWhitelist(wl) == 1)
{
MsgAddOne.Content = "Database Error";
}
else
{
MsgAddOne.Content = "Unknown Error";
}
ms.CloseCon();
}
}
private void LoadTable()
{
MSSQL ms = new MSSQL();
List <KnownHost> khs = ms.GetKnownHosts();
List <String> ips = ms.GetIPs();
khrs = new List <KHTableRow>();
List <GUIDMACVersionIP> gmvis = GetActiveHosts();
foreach (KnownHost kh in khs)
{
bool found = false;
foreach (GUIDMACVersionIP gmvi in gmvis)
{
if (kh.GUID.Trim().Equals(gmvi.GUID.Trim()))
{
khrs.Add(new KHTableRow {
GUID = kh.GUID, DateAdded = kh.dateAdded.ToString(), IP = gmvi.IP, MAC = gmvi.MAC, Status = KnownHost.ByteToString(KnownHost.STATE_ONLINE), Version = gmvi.Version, Hostname = gmvi.Hostname
});
found = true;
break;
}
}
if (!found)
{
khrs.Add(new KHTableRow {
GUID = kh.GUID, DateAdded = kh.dateAdded.ToString(), IP = kh.hostIP, MAC = kh.hostMAC, Status = KnownHost.ByteToString(kh.status), Version = kh.version, Hostname = kh.hostname
});
}
}
KnownHostTable.ItemsSource = khrs;
KnownHostTable.Items.Refresh();
ms.CloseCon();
LastUpdated.Content = DateTime.Now;
}
private void DoFilter()
{
List <Whitelists> wls = new List <Whitelists>();
String aserial = "";
String avid = "";
String apid = "";
DateTime adt1 = DateTime.Parse("1/1/2000 12:00:00 AM",
System.Globalization.CultureInfo.InvariantCulture);
DateTime adt2 = DateTime.Now;
if (FilterPid.Text.Equals("") && FilterVid.Text.Equals("") && FilterSerial.Text.Equals("") && FilterDate1.Value == null && FilterDate2.Value == null)
{
MSSQL ms = new MSSQL();
List <Whitelists> wlss = ms.GetWhitelists();
WhitelistTable.Items.Clear();
foreach (Whitelists wl in wlss)
{
WhitelistTable.Items.Add(new WLTableRow {
Datetime = wl.Datetime1.ToString("dd/MMM/yyyy hh:mm:ss tt"), Pid = wl.Pid1, Vid = wl.Vid1, SerialNumber = wl.SerialNumber1, WhitelistID = wl.WhitelistID1
});
}
ms.CloseCon();
}
else
{
if (!FilterPid.Text.Equals(""))
{
apid = FilterPid.Text;
}
if (!FilterVid.Text.Equals(""))
{
avid = FilterVid.Text;
}
if (!FilterSerial.Text.Equals(""))
{
aserial = FilterSerial.Text;
}
if (!(FilterDate1.Value == null))
{
adt1 = (DateTime)FilterDate1.Value;
}
if (!(FilterDate2.Value == null))
{
adt2 = (DateTime)FilterDate2.Value;
}
MSSQL ms = new MSSQL();
wls = ms.FilteredWhitelists(apid, avid, aserial, adt1, adt2);
WhitelistTable.Items.Clear();
foreach (Whitelists wl in wls)
{
WhitelistTable.Items.Add(new WLTableRow {
Datetime = wl.Datetime1.ToString("dd/MMM/yyyy hh:mm:ss tt"), Pid = wl.Pid1, Vid = wl.Vid1, SerialNumber = wl.SerialNumber1, WhitelistID = wl.WhitelistID1
});
}
ms.CloseCon();
}
}
private void DoFilter()
{
List <Events> wls = new List <Events>();
String acode = "";
String amessage = "";
String aip = "";
String aguid = "";
DateTime adt1 = DateTime.Parse("1/1/2000 12:00:00 AM",
System.Globalization.CultureInfo.InvariantCulture);
DateTime adt2 = DateTime.Now;
if (FilterAlertCode.Text.Equals("") && FilterMessage.Text.Equals("") && FilterIP.Text.Equals("") && FilterGUID.Text.Equals("") &&
FilterDate1.Value == null && FilterDate2.Value == null &&
(bool)BtnL0.IsChecked && (bool)BtnL1.IsChecked && (bool)BtnL2.IsChecked && (bool)BtnL3.IsChecked)
{
MSSQL ms = new MSSQL();
List <Events> evss = ms.GetEvents();
foreach (Events ev in evss)
{
String el = "";
switch (ev.eventLevel)
{
case 0:
el = "0: Normal";
break;
case 1:
el = "1: Concern";
break;
case 2:
el = "2: Warning";
break;
case 3:
el = "3: Critical";
break;
}
EventsTable.Items.Clear();
EventsTable.Items.Add(new EVTableRow {
Code = ev.eventCode, Date = ev.eventDate.ToString("dd/MMM/yyyy hh:mm:ss tt"), Message = ev.eventMessage, IP = ev.eventIP, GUID = ev.eventGUID, Severity = el
});
}
ms.CloseCon();
}
else
{
if (!FilterAlertCode.Text.Equals(""))
{
acode = FilterAlertCode.Text;
}
if (!FilterMessage.Text.Equals(""))
{
amessage = FilterMessage.Text;
}
if (!FilterIP.Text.Equals(""))
{
aip = FilterIP.Text;
}
if (!FilterGUID.Text.Equals(""))
{
aguid = FilterGUID.Text;
}
if (!(FilterDate1.Value == null))
{
adt1 = (DateTime)FilterDate1.Value;
}
if (!(FilterDate2.Value == null))
{
adt2 = (DateTime)FilterDate2.Value;
}
List <int> alevels = new List <int>();
if ((bool)BtnL0.IsChecked)
{
alevels.Add(0);
}
if ((bool)BtnL1.IsChecked)
{
alevels.Add(1);
}
if ((bool)BtnL2.IsChecked)
{
alevels.Add(2);
}
if ((bool)BtnL3.IsChecked)
{
alevels.Add(3);
}
MSSQL ms = new MSSQL();
List <Events> evss = ms.FilteredEvents(acode, amessage, alevels.ToArray(), aip, aguid, adt1, adt2);
EventsTable.Items.Clear();
foreach (Events ev in evss)
{
String el = "";
switch (ev.eventLevel)
{
case 0:
el = "0: Normal";
break;
case 1:
el = "1: Concern";
break;
case 2:
el = "2: Warning";
break;
case 3:
el = "3: Critical";
break;
}
EventsTable.Items.Add(new EVTableRow {
Code = ev.eventCode, Date = ev.eventDate.ToString("dd/MMM/yyyy hh:mm:ss tt"), Message = ev.eventMessage, IP = ev.eventIP, GUID = ev.eventGUID, Severity = el
});
}
ms.CloseCon();
}
}
