/* private static void CleanGPSFiles(DirectoryInfo dir) { foreach (FileInfo f in dir.GetFiles("Kismet*.gps")) { string input; StreamReader fs2 = File.OpenText("c:\\documents and settings\\luke\\my documents\\kismetlogs\\" + f.Name); //Console.WriteLine("Processing " + f.Name); // GP:SD:TR:AC:KL:OG Regex theregex = new Regex(@"GP:SD:TR:AC:KL:OG", RegexOptions.Compiled); Regex theregex2 = new Regex(@"bssid"); while((input=fs2.ReadLine()) != null) { if(!theregex.IsMatch(input)) { if(theregex2.IsMatch(input)) { Console.WriteLine(input); } } } } } */ public static void CreateKmlFile(gpsdata thegpsdata, string theconnectionstring) { thedata newdata = new thedata(); //clientdata thecd = new clientdata(); thegpsdata.FlushData(); clientdata theclientdata = new clientdata(); //Decimal thebestlon; //Decimal thebestlat; //Decimal thebestsignal; Console.WriteLine("Creating KML File"); theclientdata.ConnectionString = theconnectionstring; newdata.ConnectionString = theconnectionstring; thegpsdata.ConnectionString = theconnectionstring; //thecd.ConnectionString=theconnectionstring; newdata.Where.NetType.Value = "infrastructure"; ///newdata.Where.NetType.Operator = WhereParameter.Operand.Equal; newdata.Where.Encryption.Value = "None"; ///newdata.Where.Encryption.Operator = WhereParameter.Operand.NotEqual; //string firstquery = "Select * from data where nettype=\"infrastructure\" and encryption=\"None\""; //Kisdata.Where.BSSID.Value="00:0F:3D:3E:41:9A"; //Kisdata.Where.BSSID.Operator=WhereParameter.Operand.Equal; //Console.WriteLine(thegpsdata.Query.GenerateSQL()); newdata.Query.Load(); XmlTextWriter myXmlTextWriter = new XmlTextWriter(Application.StartupPath + "\\kismet.kml", null); myXmlTextWriter.Formatting = Formatting.Indented; myXmlTextWriter.WriteStartDocument(false); myXmlTextWriter.WriteStartElement("Folder"); myXmlTextWriter.WriteElementString("name", null, "KismetLogger"); myXmlTextWriter.WriteStartElement("Folder"); myXmlTextWriter.WriteElementString("name", null, "Encrypted"); //Console.WriteLine(newdata.RowCount); if (newdata.RowCount != 0) { newdata.Rewind(); do { thegpsdata.Where.Bssid.Value = newdata.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(); //thebestlat = 0; //thebestlon = 0; //thebestsignal=-257; if (thegpsdata.RowCount != 0) { thegpsdata.Rewind(); //do //{ // 00:0D:72:2A:9A:39 Anne /* myXmlTextWriter.WriteStartElement("Placemark"); myXmlTextWriter.WriteElementString("name",null,newdata.ESSID); myXmlTextWriter.WriteElementString("styleUrl",null,"#track"); myXmlTextWriter.WriteStartElement("Point"); myXmlTextWriter.WriteElementString("coordinates",null, thegpsdata.Lon+","+thegpsdata.Lat); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteEndElement(); */ // if(thegpsdata.Signal > thebestsignal) // { // thebestsignal=thegpsdata.Signal; // thebestlon=thegpsdata.Lon; // thebestlat=thegpsdata.Lat; // } //Console.WriteLine(thegpsdata.Bssid); //Console.WriteLine(thegpsdata.Lat); //Console.WriteLine(thegpsdata.Lon); //} while(thegpsdata.MoveNext()); string clientstring = ""; myXmlTextWriter.WriteStartElement("Placemark"); myXmlTextWriter.WriteElementString("name", null, newdata.ESSID); myXmlTextWriter.WriteElementString("styleUrl", null, "#track"); myXmlTextWriter.WriteStartElement("description"); theclientdata.Where.Bssid.Value = newdata.BSSID; ///theclientdata.Where.Bssid.Operator = WhereParameter.Operand.Equal; theclientdata.Query.Load(); if (theclientdata.RowCount != 0) { theclientdata.Rewind(); clientstring = "<p>Number of clients=" + theclientdata.RowCount + "<p>"; do { clientstring += "<p>" + theclientdata.Clientmac + "-" + theclientdata.Oui + "</p>"; } while (theclientdata.MoveNext()); } myXmlTextWriter.WriteCData(newdata.BSSID + "-" + newdata.Oui + "<p><b>First Seen: </b><br>" + newdata.FirstTime + "<br>" + "<BR><b> Last Seen </b>" + newdata.LastTime + clientstring); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteStartElement("Style"); myXmlTextWriter.WriteStartElement("Icon"); myXmlTextWriter.WriteElementString("href", null, "root://icons/palette-3.png"); myXmlTextWriter.WriteElementString("x", null, "96"); myXmlTextWriter.WriteElementString("y", null, "160"); myXmlTextWriter.WriteElementString("w", null, "32"); myXmlTextWriter.WriteElementString("h", null, "32"); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteStartElement("Point"); /* myXmlTextWriter.WriteStartElement("Style"); if(newdata.Encryption=="None") { myXmlTextWriter.WriteElementString("icon",null,"node.open.png"); } else { myXmlTextWriter.WriteElementString("icon",null,"node.closed.png"); } myXmlTextWriter.WriteEndElement(); */ myXmlTextWriter.WriteElementString("coordinates", null, thegpsdata.Lon + "," + thegpsdata.Lat); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteEndElement(); } } while (newdata.MoveNext()); } myXmlTextWriter.WriteEndElement(); newdata.Where.NetType.Value = "infrastructure"; ///newdata.Where.NetType.Operator = WhereParameter.Operand.Equal; newdata.Where.Encryption.Value = "None"; ///newdata.Where.Encryption.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()); newdata.Query.Load(); myXmlTextWriter.WriteStartElement("Folder"); myXmlTextWriter.WriteElementString("name", null, "Open"); //Console.WriteLine(newdata.RowCount); if (newdata.RowCount != 0) { newdata.Rewind(); do { thegpsdata.Where.Bssid.Value = newdata.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(); //thebestlat = 0; //thebestlon = 0; //thebestsignal=-257; if (thegpsdata.RowCount != 0) { thegpsdata.Rewind(); //do //{ // 00:0D:72:2A:9A:39 Anne /* myXmlTextWriter.WriteStartElement("Placemark"); myXmlTextWriter.WriteElementString("name",null,newdata.ESSID); myXmlTextWriter.WriteElementString("styleUrl",null,"#track"); myXmlTextWriter.WriteStartElement("Point"); myXmlTextWriter.WriteElementString("coordinates",null, thegpsdata.Lon+","+thegpsdata.Lat); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteEndElement(); */ // if(thegpsdata.Signal > thebestsignal) // { // thebestsignal=thegpsdata.Signal; // thebestlon=thegpsdata.Lon; // thebestlat=thegpsdata.Lat; // } //Console.WriteLine(thegpsdata.Bssid); //Console.WriteLine(thegpsdata.Lat); //Console.WriteLine(thegpsdata.Lon); //} while(thegpsdata.MoveNext()); string clientstring = ""; myXmlTextWriter.WriteStartElement("Placemark"); myXmlTextWriter.WriteElementString("name", null, newdata.ESSID); myXmlTextWriter.WriteElementString("styleUrl", null, "#track"); myXmlTextWriter.WriteStartElement("description"); theclientdata.Where.Bssid.Value = newdata.BSSID; ///theclientdata.Where.Bssid.Operator = WhereParameter.Operand.Equal; theclientdata.Query.Load(); if (theclientdata.RowCount != 0) { theclientdata.Rewind(); clientstring = "<p>Number of clients=" + theclientdata.RowCount + "<p>"; do { clientstring += "<p>" + theclientdata.Clientmac + "-" + theclientdata.Oui + "</p>"; } while (theclientdata.MoveNext()); } myXmlTextWriter.WriteCData(newdata.BSSID + "-" + newdata.Oui + "<p><b>First Seen: </b><br>" + newdata.FirstTime + "<br>" + "<BR><b> Last Seen </b>" + newdata.LastTime + clientstring); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteStartElement("Style"); if (newdata.Encryption == "None") { myXmlTextWriter.WriteStartElement("Icon"); myXmlTextWriter.WriteElementString("href", null, "root://icons/palette-3.png"); myXmlTextWriter.WriteElementString("x", null, "64"); myXmlTextWriter.WriteElementString("y", null, "96"); myXmlTextWriter.WriteElementString("w", null, "32"); myXmlTextWriter.WriteElementString("h", null, "32"); myXmlTextWriter.WriteEndElement(); } myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteStartElement("Point"); /* myXmlTextWriter.WriteStartElement("Style"); if(newdata.Encryption=="None") { myXmlTextWriter.WriteElementString("icon",null,"node.open.png"); } else { myXmlTextWriter.WriteElementString("icon",null,"node.closed.png"); } myXmlTextWriter.WriteEndElement(); */ myXmlTextWriter.WriteElementString("coordinates", null, thegpsdata.Lon + "," + thegpsdata.Lat); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteEndElement(); } } while (newdata.MoveNext()); } myXmlTextWriter.WriteEndElement(); /* thecd.LoadAll(); thegpsdata.FlushData(); do { thegpsdata.Where.Source.Value=thecd.Clientmac; thegpsdata.Where.Source.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(); thebestlat = 0; thebestlon = 0; thebestsignal=-257; if(thegpsdata.RowCount !=0) { thegpsdata.Rewind(); do { // 00:0D:72:2A:9A:39 Anne myXmlTextWriter.WriteStartElement("Placemark"); myXmlTextWriter.WriteElementString("name",null,thecd.Bssid); myXmlTextWriter.WriteElementString("styleUrl",null,"#track"); myXmlTextWriter.WriteStartElement("Point"); myXmlTextWriter.WriteElementString("coordinates",null, thebestlon+","+thebestlat); myXmlTextWriter.WriteEndElement(); myXmlTextWriter.WriteEndElement(); if(thegpsdata.Signal > thebestsignal) { thebestsignal=thegpsdata.Signal; thebestlon=thegpsdata.Lon; thebestlat=thegpsdata.Lat; } //Console.WriteLine(thegpsdata.Bssid); //Console.WriteLine(thegpsdata.Lat); //Console.WriteLine(thegpsdata.Lon); } while(thegpsdata.MoveNext()); } }while(thecd.MoveNext()); */ myXmlTextWriter.Flush(); myXmlTextWriter.Close(); }
private static void ProcessCSVFiles(string theconnectionstring, DirectoryInfo dir) { thedata Kisdata = new thedata(); gpsdata thegpsdata = new gpsdata(); Kisdata.ConnectionString = theconnectionstring; thegpsdata.ConnectionString = theconnectionstring; int count = 0; double timestamp = 1161883162; DateTime dateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0); // Add the number of seconds in UNIX timestamp to be converted. dateTime = dateTime.AddSeconds(timestamp); // The dateTime now contains the right date/time so to format the string, // use the standard formatting methods of the DateTime object. // string printDate = dateTime.ToShortDateString() + " " + dateTime.ToShortTimeString(); // Print the date and time Console.WriteLine(dateTime); thegpsdata.LoadAll(); do { if (!Kisdata.LoadByPrimaryKey(thegpsdata.Bssid)) { count++; //Console.WriteLine(thegpsdata.Bssid); } } while (thegpsdata.MoveNext()); Console.WriteLine(count); foreach (FileInfo f in dir.GetFiles("Kismet*.csv")) { StreamReader sr = File.OpenText(Application.StartupPath + "\\logs\\" + f.Name); string input; Console.WriteLine(f.Name); //string aoui = ""; //string[] theoui; //string thecompany = ""; sr.ReadLine(); while ((input = sr.ReadLine()) != null) { if (input.Length != 0) { //Console.WriteLine(input); string[] thestrings; thestrings = input.Split(new char[] { ';' }); //Console.WriteLine(thestrings.Length); if(!Kisdata.LoadByPrimaryKey(thestrings[3])) { Console.WriteLine(thestrings[2]); Console.WriteLine(thestrings[3]); } } } } }