private static void AddorUpdateClientsSqliteNew(ref detectionrun ds, int i, ref int clienttotal, ref int clientnew, ref int clientseen) { SQLiteConnectionStringBuilder builder = new SQLiteConnectionStringBuilder(); builder.DataSource = string.Format("{0}\\kismetdata.db", Application.StartupPath); builder.SyncMode = SynchronizationModes.Off; builder.CacheSize = 5000; SQLiteConnection connection = new SQLiteConnection(builder.ToString()); //SQLiteCommand command = connection.CreateCommand(); connection.Open(); SQLiteCommand insertclients = connection.CreateCommand(); SQLiteCommand updateclients = connection.CreateCommand(); insertclients.CommandText = "Insert into clients values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; updateclients.CommandText=@"UPDATE [Clients] SET [Clientipaddress]=?, [oui]=?, [clientencryption]=?, [clientfirsttime]=?, [clientgpsminlat]=?, [clientgpsminlon]=?, [clientgpsmaxlat]=?, [clientgpsmaxlon]=?, [clientgpsminalt]=?, [clientgpsmaxalt]=?, [clientgpsminspeed]=?, [clientgpsmaxspeed]=?, [clientdatasize]=?, [clientmaxrate]=?, [clientmaxseenrate]=?, [clientlasttime]=?, [clientpacketscrypt]=?, [clientpacketsdata]=?, [clientpacketsweak]=?, [Number]=?, [Type]=?, [wep]=? WHERE [bssid]=? AND [clientmac]=?"; SQLiteParameter Clientipaddress = insertclients.CreateParameter(); SQLiteParameter updateClientipaddress = updateclients.CreateParameter(); SQLiteParameter insertoui = insertclients.CreateParameter(); SQLiteParameter updateoui = updateclients.CreateParameter(); SQLiteParameter bssid = insertclients.CreateParameter(); SQLiteParameter clientmac = insertclients.CreateParameter(); SQLiteParameter clientencryption = insertclients.CreateParameter(); SQLiteParameter updateclientencryption = updateclients.CreateParameter(); SQLiteParameter clientfirsttime = insertclients.CreateParameter(); SQLiteParameter updateclientfirsttime = updateclients.CreateParameter(); SQLiteParameter clientgpsminlat=insertclients.CreateParameter(); SQLiteParameter clientgpsminlon=insertclients.CreateParameter(); SQLiteParameter clientgpsmaxlat=insertclients.CreateParameter(); SQLiteParameter clientgpsmaxlon=insertclients.CreateParameter(); SQLiteParameter clientgpsminalt=insertclients.CreateParameter(); SQLiteParameter clientgpsmaxalt=insertclients.CreateParameter(); SQLiteParameter clientgpsminspeed=insertclients.CreateParameter(); SQLiteParameter clientgpsmaxspeed=insertclients.CreateParameter(); SQLiteParameter clientdatasize=insertclients.CreateParameter(); SQLiteParameter clientmaxrate=insertclients.CreateParameter(); SQLiteParameter clientmaxseenrate=insertclients.CreateParameter(); SQLiteParameter clientlasttime=insertclients.CreateParameter(); SQLiteParameter clientpacketscrypt=insertclients.CreateParameter(); SQLiteParameter clientpacketsdata=insertclients.CreateParameter(); SQLiteParameter clientpacketsweak=insertclients.CreateParameter(); SQLiteParameter Number=insertclients.CreateParameter(); SQLiteParameter Type=insertclients.CreateParameter(); SQLiteParameter wep = insertclients.CreateParameter(); SQLiteParameter updateclientgpsminlat = updateclients.CreateParameter(); SQLiteParameter updateclientgpsminlon = updateclients.CreateParameter(); SQLiteParameter updateclientgpsmaxlat = updateclients.CreateParameter(); SQLiteParameter updateclientgpsmaxlon = updateclients.CreateParameter(); SQLiteParameter updateclientgpsminalt = updateclients.CreateParameter(); SQLiteParameter updateclientgpsmaxalt = updateclients.CreateParameter(); SQLiteParameter updateclientgpsminspeed = updateclients.CreateParameter(); SQLiteParameter updateclientgpsmaxspeed = updateclients.CreateParameter(); SQLiteParameter updateclientdatasize = updateclients.CreateParameter(); SQLiteParameter updateclientmaxrate = updateclients.CreateParameter(); SQLiteParameter updateclientmaxseenrate = updateclients.CreateParameter(); SQLiteParameter updateclientlasttime = updateclients.CreateParameter(); SQLiteParameter updateclientpacketscrypt = updateclients.CreateParameter(); SQLiteParameter updateclientpacketsdata = updateclients.CreateParameter(); SQLiteParameter updateclientpacketsweak = updateclients.CreateParameter(); SQLiteParameter updateNumber = updateclients.CreateParameter(); SQLiteParameter updateType = updateclients.CreateParameter(); SQLiteParameter updatewep = updateclients.CreateParameter(); SQLiteParameter updatebssid = insertclients.CreateParameter(); SQLiteParameter updateclientmac = updateclients.CreateParameter(); insertclients.Parameters.Add(Clientipaddress); insertclients.Parameters.Add(insertoui); insertclients.Parameters.Add(bssid); insertclients.Parameters.Add(clientmac); insertclients.Parameters.Add(clientencryption); insertclients.Parameters.Add(clientfirsttime); insertclients.Parameters.Add(clientgpsminlat); insertclients.Parameters.Add(clientgpsminlon); insertclients.Parameters.Add(clientgpsmaxlat); insertclients.Parameters.Add(clientgpsmaxlon); insertclients.Parameters.Add(clientgpsminalt); insertclients.Parameters.Add(clientgpsmaxalt); insertclients.Parameters.Add(clientgpsminspeed); insertclients.Parameters.Add(clientgpsmaxspeed); insertclients.Parameters.Add(clientdatasize); insertclients.Parameters.Add(clientmaxrate); insertclients.Parameters.Add(clientmaxseenrate); insertclients.Parameters.Add(clientlasttime); insertclients.Parameters.Add(clientpacketscrypt); insertclients.Parameters.Add(clientpacketsdata); insertclients.Parameters.Add(clientpacketsweak); insertclients.Parameters.Add(Number); insertclients.Parameters.Add(Type); insertclients.Parameters.Add(wep); updateclients.Parameters.Add(updateClientipaddress); updateclients.Parameters.Add(updateoui); updateclients.Parameters.Add(updateclientencryption); updateclients.Parameters.Add(updateclientfirsttime); updateclients.Parameters.Add(updateclientgpsminlat); updateclients.Parameters.Add(updateclientgpsminlon); updateclients.Parameters.Add(updateclientgpsmaxlat); updateclients.Parameters.Add(updateclientgpsmaxlon); updateclients.Parameters.Add(updateclientgpsminalt); updateclients.Parameters.Add(updateclientgpsmaxalt); updateclients.Parameters.Add(updateclientgpsminspeed); updateclients.Parameters.Add(updateclientgpsmaxspeed); updateclients.Parameters.Add(updateclientdatasize); updateclients.Parameters.Add(updateclientmaxrate); updateclients.Parameters.Add(updateclientmaxseenrate); updateclients.Parameters.Add(updateclientlasttime); updateclients.Parameters.Add(updateclientpacketscrypt); updateclients.Parameters.Add(updateclientpacketsdata); updateclients.Parameters.Add(updateclientpacketsweak); updateclients.Parameters.Add(updateNumber); updateclients.Parameters.Add(updateType); updateclients.Parameters.Add(updatewep); updateclients.Parameters.Add(updatebssid); updateclients.Parameters.Add(updateclientmac); ClientsTableAdapter theclientstableadaptor = new ClientsTableAdapter(); DataTable t; clienttotal += ds.wirelessnetwork[i].wirelessclient.Length; for (int j = 0; j < ds.wirelessnetwork[i].wirelessclient.Length; j++) { t=theclientstableadaptor.GetDataByClientBssid(ds.wirelessnetwork[i].wirelessclient[j].clientmac, ds.wirelessnetwork[i].BSSID); if(t.Rows.Count == 0) { //theClientData.AddNew(); //Console.WriteLine("Client Add"); clientnew++; bssid.Value = ds.wirelessnetwork[i].BSSID; insertoui.Value = LookupOuiData(ds.wirelessnetwork[i].wirelessclient[j].clientmac); clientmac.Value = ds.wirelessnetwork[i].wirelessclient[j].clientmac; clientdatasize.Value = ds.wirelessnetwork[i].wirelessclient[j].clientdatasize; clientencryption.Value = ds.wirelessnetwork[i].wirelessclient[j].clientencryption; clientfirsttime.Value = ds.wirelessnetwork[i].wirelessclient[j].firsttime; clientlasttime.Value = ds.wirelessnetwork[i].wirelessclient[j].lasttime; if (ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo != null) { clientgpsmaxalt.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxalt; clientgpsmaxlat.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxlat; clientgpsmaxlon.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxlon; clientgpsminalt.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminalt; clientgpsminlat.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminlat; clientgpsminlon.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminlon; } clientmaxrate.Value = ds.wirelessnetwork[i].wirelessclient[j].clientmaxrate; if (ds.wirelessnetwork[i].wirelessclient[j].clientipaddress != null) { Clientipaddress.Value = ds.wirelessnetwork[i].wirelessclient[j].clientipaddress; } clientmaxseenrate.Value = ds.wirelessnetwork[i].wirelessclient[j].clientmaxseenrate; clientpacketscrypt.Value = ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientcrypt; clientpacketsdata.Value = ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientdata; clientpacketsweak.Value = ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientweak; insertclients.ExecuteNonQuery(); //theClientData.Save(); } else { clientseen++; DataTableReader thereader = t.CreateDataReader(); thereader.Read(); //Console.WriteLine("Client Update"); updateoui.Value = LookupOuiData(ds.wirelessnetwork[i].wirelessclient[j].clientmac); updateclientdatasize.Value = Convert.ToInt32(thereader["clientdatasize"]) + ds.wirelessnetwork[i].wirelessclient[j].clientdatasize; updateclientencryption.Value = ds.wirelessnetwork[i].wirelessclient[j].clientencryption; IFormatProvider format = new CultureInfo("en-US"); string[] expectedformats = { "ddd MMM d HH:mm:ss yyyy", "ddd MMM d HH:mm:ss yyyy" }; string firsttime = thereader["clientfirsttime"].ToString(); string lasttime = thereader["clientlasttime"].ToString(); DateTime dbfirsttime; DateTime xmlfirsttime; DateTime dblasttime; DateTime xmllasttime; // Wed Mar 29 14:52:56 2006 dbfirsttime = DateTime.ParseExact(firsttime, expectedformats, format, DateTimeStyles.AllowWhiteSpaces); xmlfirsttime = DateTime.ParseExact(ds.wirelessnetwork[i].wirelessclient[j].firsttime, expectedformats, format, DateTimeStyles.AllowWhiteSpaces); dblasttime = DateTime.ParseExact(lasttime, expectedformats, format, DateTimeStyles.AllowWhiteSpaces); xmllasttime = DateTime.ParseExact(ds.wirelessnetwork[i].wirelessclient[j].lasttime, expectedformats, format, DateTimeStyles.AllowWhiteSpaces); if (xmlfirsttime < dbfirsttime) { updateclientfirsttime.Value = ds.wirelessnetwork[i].firsttime; } else { updateclientfirsttime.Value = thereader["clientfirsttime"]; } if (xmllasttime > dblasttime) { updateclientlasttime.Value = ds.wirelessnetwork[i].lasttime; } else { updateclientlasttime.Value = thereader["clientlasttime"]; } //theClientData.Clientfirsttime = ds.wirelessnetwork[i].wirelessclient[j].firsttime; //theClientData.Clientlasttime = ds.wirelessnetwork[i].wirelessclient[j].lasttime; if (ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo != null) { updateclientgpsmaxalt.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxalt; updateclientgpsmaxlat.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxlat; updateclientgpsmaxlon.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxlon; updateclientgpsminalt.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminalt; updateclientgpsminlat.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminlat; updateclientgpsminlon.Value = ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminlon; } updateclientmaxrate.Value = ds.wirelessnetwork[i].wirelessclient[j].clientmaxrate; if (ds.wirelessnetwork[i].wirelessclient[j].clientipaddress != null) { updateClientipaddress.Value = ds.wirelessnetwork[i].wirelessclient[j].clientipaddress; } updateclientmaxseenrate.Value = ds.wirelessnetwork[i].wirelessclient[j].clientmaxseenrate; updateclientpacketscrypt.Value = Convert.ToInt32(thereader["clientpacketscrypt"])+ ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientcrypt; updateclientpacketsdata.Value = Convert.ToInt32(thereader["clientpacketsdata"])+ ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientdata; updateclientpacketsweak.Value = Convert.ToInt32(thereader["clientpacketsweak"])+ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientweak; //theClientData.Save(); updateclients.ExecuteNonQuery(); thereader.Close(); } } }
private static void AddDataTableNew(detectionrun ds, int i, SQLiteCommand insertdata) { //insertdata.Parameters["Oui"].Value = LookupOuiData(ds.wirelessnetwork[i].BSSID); insertdata.Parameters["Cloaked"].Value = ds.wirelessnetwork[i].cloaked; insertdata.Parameters["FirstTime"].Value = ds.wirelessnetwork[i].firsttime; insertdata.Parameters["LastTime"].Value = ds.wirelessnetwork[i].lasttime; insertdata.Parameters["BSSID"].Value = ds.wirelessnetwork[i].BSSID; insertdata.Parameters["Network"].Value = ds.wirelessnetwork[i].number; insertdata.Parameters["NetType"].Value = ds.wirelessnetwork[i].type; insertdata.Parameters["Channel"].Value = ds.wirelessnetwork[i].channel; insertdata.Parameters["Encryption"].Value = ds.wirelessnetwork[i].encryption; insertdata.Parameters["Totalpacketscrypt"].Value = ds.wirelessnetwork[i].packets.crypt; insertdata.Parameters["Totalpacketsdata"].Value = ds.wirelessnetwork[i].packets.data; insertdata.Parameters["Totalpacketsdupeiv"].Value = ds.wirelessnetwork[i].packets.dupeiv; insertdata.Parameters["Totalpacketsllc"].Value = ds.wirelessnetwork[i].packets.LLC; insertdata.Parameters["Totalpacketstotal"].Value = ds.wirelessnetwork[i].packets.total; insertdata.Parameters["Totalpacketsweak"].Value = ds.wirelessnetwork[i].packets.weak; insertdata.Parameters["ESSID"].Value = ds.wirelessnetwork[i].SSID ?? "no ssid"; insertdata.Parameters["GPSMaxLat"].Value = ds.wirelessnetwork[i].gpsinfo.maxlat; insertdata.Parameters["GPSMaxLon"].Value = ds.wirelessnetwork[i].gpsinfo.maxlon; insertdata.Parameters["GPSMinLat"].Value = ds.wirelessnetwork[i].gpsinfo.minlat; insertdata.Parameters["GPSMinLon"].Value = ds.wirelessnetwork[i].gpsinfo.minlon; insertdata.ExecuteNonQuery(); }
/* private static string CreateOuiData(string bssid) { string temp; string temp2; temp=bssid.Substring(0, 8); temp2=temp.Replace(':','-'); ouidata theouitable= new ouidata(); string theconnectionstring = "Data Source="+ Application.StartupPath + "\\kismetdata.db;Version=3;New=False;Compress=False;Synchronous=Off"; theouitable.ConnectionString=theconnectionstring; if(theouitable.LoadByPrimaryKey(temp2)) { return theouitable.Company_name; } else { return "Unknown"; } } */ private static void AddorUpdateClientsSqlite(detectionrun ds, int i, _Clients theClientData) { for(int j=0; j<ds.wirelessnetwork[i].wirelessclient.Length; j++) { if(!theClientData.LoadByPrimaryKey(ds.wirelessnetwork[i].BSSID, ds.wirelessnetwork[i].wirelessclient[j].clientmac)) { theClientData.AddNew(); //Console.WriteLine("Client Add"); theClientData.Bssid=ds.wirelessnetwork[i].BSSID; theClientData.Oui=LookupOuiData(ds.wirelessnetwork[i].wirelessclient[j].clientmac); theClientData.Clientmac=ds.wirelessnetwork[i].wirelessclient[j].clientmac; theClientData.Clientdatasize=ds.wirelessnetwork[i].wirelessclient[j].clientdatasize; theClientData.Clientencryption=ds.wirelessnetwork[i].wirelessclient[j].clientencryption; theClientData.Clientfirsttime=ds.wirelessnetwork[i].wirelessclient[j].firsttime; theClientData.Clientlasttime=ds.wirelessnetwork[i].wirelessclient[j].lasttime; if(ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo != null) { theClientData.Clientgpsmaxalt=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxalt; theClientData.Clientgpsmaxlat=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxlat; theClientData.Clientgpsmaxlon=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxlon; theClientData.Clientgpsminalt=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminalt; theClientData.Clientgpsminlat=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminlat; theClientData.Clientgpsminlon=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminlon; } theClientData.Clientmaxrate=ds.wirelessnetwork[i].wirelessclient[j].clientmaxrate; if(ds.wirelessnetwork[i].wirelessclient[j].clientipaddress != null) { theClientData.Clientipaddress=ds.wirelessnetwork[i].wirelessclient[j].clientipaddress; } theClientData.Clientmaxseenrate=ds.wirelessnetwork[i].wirelessclient[j].clientmaxseenrate; theClientData.Clientpacketscrypt=ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientcrypt; theClientData.Clientpacketsdata=ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientdata; theClientData.Clientpacketsweak=ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientweak; theClientData.Save(); } else { //Console.WriteLine("Client Update"); theClientData.Clientdatasize+=ds.wirelessnetwork[i].wirelessclient[j].clientdatasize; theClientData.Clientencryption=ds.wirelessnetwork[i].wirelessclient[j].clientencryption; theClientData.Clientfirsttime=ds.wirelessnetwork[i].wirelessclient[j].firsttime; theClientData.Clientlasttime=ds.wirelessnetwork[i].wirelessclient[j].lasttime; if(ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo != null) { theClientData.Clientgpsmaxalt=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxalt; theClientData.Clientgpsmaxlat=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxlat; theClientData.Clientgpsmaxlon=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientmaxlon; theClientData.Clientgpsminalt=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminalt; theClientData.Clientgpsminlat=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminlat; theClientData.Clientgpsminlon=ds.wirelessnetwork[i].wirelessclient[j].clientgpsinfo.clientminlon; } theClientData.Clientmaxrate=ds.wirelessnetwork[i].wirelessclient[j].clientmaxrate; if(ds.wirelessnetwork[i].wirelessclient[j].clientipaddress != null) { theClientData.Clientipaddress=ds.wirelessnetwork[i].wirelessclient[j].clientipaddress; } theClientData.Clientmaxseenrate=ds.wirelessnetwork[i].wirelessclient[j].clientmaxseenrate; theClientData.Clientpacketscrypt+=ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientcrypt; theClientData.Clientpacketsdata+=ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientdata; theClientData.Clientpacketsweak+=ds.wirelessnetwork[i].wirelessclient[j].clientpackets.clientweak; theClientData.Save(); } } }
/* private static void ProcessGPSFiles(string theconnectionstring, DirectoryInfo dir, XmlSerializer xs2, gpsdata thegpsdata, gpsfiles thegpsfiles) { thegpsdata = new gpsdata(); thegpsfiles = new gpsfiles(); thegpsfiles.ConnectionString = theconnectionstring; thegpsdata.ConnectionString = theconnectionstring; foreach (FileInfo f in dir.GetFiles("Kismet*.gps")) { //Console.WriteLine(dir.ToString()); FileStream fs2 = new FileStream(f.DirectoryName + "\\" + f.Name, FileMode.Open); Console.WriteLine("Processing " + f.Name); if (!thegpsfiles.LoadByPrimaryKey(f.Name)) { try { gpsrun ds2; int thecount; ds2 = (gpsrun) xs2.Deserialize(fs2); thegpsfiles.AddNew(); thegpsfiles.Filename = f.Name; thegpsfiles.Save(); thecount = ds2.Items.Length; Console.WriteLine(thecount); for (int i = 0; i < thecount; i++) { if (ds2.Items[i].bssid != "GP:SD:TR:AC:KL:OG") { //thegpsdata.Where.Bssid.Value=ds2.Items[i].bssid; //thegpsdata.Where.Bssid.Operator=WhereParameter.Operand.Equal; //Kisdata.Where.BSSID.Value="00:0F:3D:3E:41:9A"; //Kisdata.Where.BSSID.Operator=WhereParameter.Operand.Equal; //Console.WriteLine(thegpsdata.Query.GenerateSQL()); //thegpsdata.Query.Load(); if (!thegpsdata.LoadByPrimaryKey(ds2.Items[i].bssid)) { //Console.WriteLine(i); thegpsdata.AddNew(); thegpsdata.Bssid = ds2.Items[i].bssid; thegpsdata.Timesec = ds2.Items[i].timesec; thegpsdata.Timeusec = ds2.Items[i].timeusec; thegpsdata.Source = ds2.Items[i].source; thegpsdata.Lat = ds2.Items[i].lat; thegpsdata.Lon = ds2.Items[i].lon; thegpsdata.Alt = ds2.Items[i].alt; thegpsdata.Speed = ds2.Items[i].spd; thegpsdata.Heading = ds2.Items[i].heading; thegpsdata.Fix = ds2.Items[i].fix; thegpsdata.Signal = ds2.Items[i].signal; thegpsdata.Quality = ds2.Items[i].quality; thegpsdata.Noise = ds2.Items[i].noise; thegpsdata.Save(); } else { if ((thegpsdata.Signal <= ds2.Items[i].signal) && ds2.Items[i].fix=="3") { thegpsdata.Timesec = ds2.Items[i].timesec; thegpsdata.Timeusec = ds2.Items[i].timeusec; thegpsdata.Source = ds2.Items[i].source; thegpsdata.Lat = ds2.Items[i].lat; thegpsdata.Lon = ds2.Items[i].lon; thegpsdata.Alt = ds2.Items[i].alt; thegpsdata.Speed = ds2.Items[i].spd; thegpsdata.Heading = ds2.Items[i].heading; thegpsdata.Fix = ds2.Items[i].fix; thegpsdata.Signal = ds2.Items[i].signal; thegpsdata.Quality = ds2.Items[i].quality; thegpsdata.Noise = ds2.Items[i].noise; thegpsdata.Save(); } } } } } catch (Exception) { //Console.WriteLine(ex.ToString()); Console.WriteLine("Bad gps file " + f.Name); } } } } */ public static void AddDataTableSqlite(_Data Kisdata, detectionrun ds, int i) { Kisdata.AddNew(); //Console.WriteLine("Network add"); //Console.WriteLine(ds.wirelessnetwork[i].BSSID); Kisdata.Oui=LookupOuiData(ds.wirelessnetwork[i].BSSID); Kisdata.Cloaked=ds.wirelessnetwork[i].cloaked; Kisdata.FirstTime=ds.wirelessnetwork[i].firsttime; Kisdata.LastTime=ds.wirelessnetwork[i].lasttime; Kisdata.BSSID=ds.wirelessnetwork[i].BSSID; Kisdata.Network=ds.wirelessnetwork[i].number; Kisdata.NetType=ds.wirelessnetwork[i].type; Kisdata.Channel=ds.wirelessnetwork[i].channel; Kisdata.Encryption=ds.wirelessnetwork[i].encryption; Kisdata.Totalpacketscrypt=ds.wirelessnetwork[i].packets.crypt; Kisdata.Totalpacketsdata=ds.wirelessnetwork[i].packets.data; Kisdata.Totalpacketsdupeiv=ds.wirelessnetwork[i].packets.dupeiv; Kisdata.Totalpacketsllc=ds.wirelessnetwork[i].packets.LLC; Kisdata.Totalpacketstotal=ds.wirelessnetwork[i].packets.total; Kisdata.Totalpacketsweak=ds.wirelessnetwork[i].packets.weak; Kisdata.ESSID = ds.wirelessnetwork[i].SSID ?? "no ssid"; Kisdata.GPSMaxLat=ds.wirelessnetwork[i].gpsinfo.maxlat; Kisdata.GPSMaxLon=ds.wirelessnetwork[i].gpsinfo.maxlon; Kisdata.GPSMinLat=ds.wirelessnetwork[i].gpsinfo.minlat; Kisdata.GPSMinLon=ds.wirelessnetwork[i].gpsinfo.minlon; Kisdata.Save(); }