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(); } }