private void plotTrain()
{
this.Text = DateTime.Now.ToString();
timer1.Enabled = false;
List <PointLatLng> positions = new List <PointLatLng>();
List <int> list = selected();
#region Read File Data
if (list.Count > 0)
{
string query = "SELECT * FROM logs" +
" inner join devices on devices.id = logs.device_id" +
" WHERE device_id IN(" + String.Join(",", list.ToArray()) + ") " +
" GROUP BY device_id ORDER BY id DESC";
DataTable dt = SqliteDal.getData(query);
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
PointLatLng p = new PointLatLng
{
Lat = float.Parse(row["lat"].ToString()),
Lng = float.Parse(row["lng"].ToString())
};
Image markerImage = Image.FromFile(config.MyDirectory() + @"\marker\" + row["image"].ToString());
/* Bitmap bmp = new Bitmap(markerImage.Width, markerImage.Height);
* using (Graphics g = Graphics.FromImage(bmp))
* {
* g.Clear(Color.SkyBlue);
* g.InterpolationMode = InterpolationMode.NearestNeighbor;
* g.PixelOffsetMode = PixelOffsetMode.None;
* g.DrawImage(markerImage, Point.Empty);
* }
*/
GMapMarkerImage marker = new GMapMarkerImage(p, markerImage);
objects.Markers.Add(marker);
// marker.ToolTipMode = MarkerTooltipMode.Always; enable tooltip
marker.ToolTipText = row["subscriber_name"].ToString();
}
}
MainMap.Refresh();
#endregion
timer1.Enabled = true;
}
private void plotTrain_old()
{
this.Text = DateTime.Now.ToString();
timer1.Enabled = false;
List <PointLatLng> positions = new List <PointLatLng>();
List <int> list = selected();
#region Read File Data
if (list.Count > 0)
{
string query = "SELECT * FROM logs" +
" inner join devices on devices.id = logs.device_id" +
" WHERE device_id IN(" + String.Join(",", list.ToArray()) + ") " +
" GROUP BY device_id ORDER BY id DESC";
DataTable dt = SqliteDal.getData(query);
foreach (DataRow row in dt.Rows) // Loop over the rows.
{
PointLatLng p = new PointLatLng
{
Lat = float.Parse(row["lat"].ToString()),
Lng = float.Parse(row["lng"].ToString())
};
//positions.Add(p);
//GMapCustomImageMarker marker = new GMapCustomImageMarker(markerImage, p);
Image markerImage = Image.FromFile(config.MyDirectory() + @"\marker\" + row["image"]);
GMapMarkerImage marker = new GMapMarkerImage(p, markerImage);
objects.Markers.Add(marker);
//add marker
}
}
/*TextReader file = new StreamReader(config.MyDirectory() + @"\data\data.csv");
* string aLine;
* while ((aLine = file.ReadLine()) != null)
* {
* string[] pos = aLine.Split(',');
* PointLatLng p = new PointLatLng
* {
* Lat = float.Parse(pos[1]),
* Lng = float.Parse(pos[2])
* };
* //positions.Add(p);
* //GMarkerGoogle m = new GMarkerGoogle(p, GMarkerGoogleType.green);
* Image markerImage = Image.FromFile(config.MyDirectory() + @"\marker\train_red.png");
* //GMapCustomImageMarker marker = new GMapCustomImageMarker(markerImage, p);
* GMapMarkerImage marker = new GMapMarkerImage(p, markerImage);
* objects.Markers.Add(marker);
*
* //add marker
*
*
* }*/
MainMap.Refresh();
#endregion
//Random rnd = new Random();
//int index = rnd.Next(1, positions.Count); // creates a number between 1 and 12
//GMarkerGoogle m = new GMarkerGoogle(positions[index], GMarkerGoogleType.orange);
//objects.Markers.Add(m);
timer1.Enabled = true;
}