Ejemplo n.º 1
0
    public static void GetAlert(ref AlertData alert, string comID, string deviceID, 
        string recDateTime)
    {
        string strSQL = "SELECT unitID FROM tblUnits WHERE deviceID = " + deviceID +
                        " and comID = " + comID;
        ProcessAlerts processAlerts = new ProcessAlerts();
        ExecuteSQL exec = new ExecuteSQL();
        DataSet ds;
        int unitID;

        try
        {
            ds = exec.getDataSet(strSQL);
            unitID = int.Parse(ds.Tables[0].Rows[0]["unitID"].ToString());

            processAlerts.UnitID = unitID;
            processAlerts.ComID = int.Parse(comID);
            processAlerts.AlertTime = recDateTime;
            processAlerts.GetAlert();
            alert = processAlerts.Alert;
        }
        catch (Exception ex)
        {
            Console.WriteLine("GetAlert(): " + ex.Message);
        }
        finally
        {
            processAlerts = null;
            exec = null;
        }
    }
Ejemplo n.º 2
0
    protected void _gridRecords_DataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            AlertData _alert = new AlertData();
            MapDataCommon.GetAlert(ref _alert, Session["trkCompany"].ToString(),
                                 	deviceID, XtremeK.TimeZone.ToServerTime(e.Item.Cells[4].Text).ToString());

            Color item_color = new Color();

            if (_alert.AlertType == "Event") {
                 item_color = ColorTranslator.FromHtml("#FFF26A");
            } else if (_alert.AlertType == "Geofence" || _alert.AlertType == "Red Alert" ||
                       _alert.AlertType == "Speeding") {
                item_color = ColorTranslator.FromHtml("#FF766A");
            } else {
                item_color = ColorTranslator.FromHtml("#61C04E");
            }

            e.Item.BackColor = item_color;

            string html_color = ColorTranslator.ToHtml(item_color);

            e.Item.Attributes.Add("id", e.Item.ItemIndex.ToString());
            e.Item.Attributes.Add("onclick", "highlightRow(this)");

            e.Item.Attributes.Add("onmouseover", "this.style.cursor='pointer';this.style.backgroundColor = '#DCDCDC';");
            e.Item.Attributes.Add("onmouseout", "this.style.cursor='pointer';this.style.backgroundColor = '" + html_color + "';");
        }
    }
Ejemplo n.º 3
0
 public void GetAlert()
 {
     AlertData data = new AlertData();
     AlertSelect alertSelect = new AlertSelect();
     alertSelect.UnitID = _unitID;
     alertSelect.ComID = _comID;
     alertSelect.AlertTime = _alertTime;
     alertSelect.Alert = data;
     alertSelect.GetAlert();
     _alert = alertSelect.Alert;
 }
Ejemplo n.º 4
0
    public static string GetAlertColor(AlertData alert)
    {
        string color = "green";
        string alertType = alert.AlertType;

        if (alertType == "Speeding" || alertType == "Geofence" || alertType == "Red Alert")
        {
            color = "red";
        }
        else if (alertType == "Event" || alertType == "Time")
        {
            color = "yellow";
        }

        return color;
    }
    public string GetMarkerScript()
    {
        DataSet ds = null;
        string _bfMarkerScript = "";
        string _script = "";
        string _bfPolyLine = "";
        int end = 0;
        int start = 0;
        int _labelID = 0;

        try
        {
            ds = (DataSet)Session["historicalData"];

            if (ds.Tables[0].Rows.Count> 0)
            {

                string _markerText = "";
                decimal _lat = 0, _lng = 0;
                decimal latest_lat = 0, latest_lon = 0;

                start = int.Parse(Session["historicalPageID"].ToString()) * 25;
                end = start + 25;

                if (ds.Tables[0].Rows.Count < 25 || end > ds.Tables[0].Rows.Count)
                {
                    end = ds.Tables[0].Rows.Count;
                }

                latest_lat = decimal.Parse(ds.Tables[0].Rows[start]["lat"].ToString());
                latest_lon = decimal.Parse(ds.Tables[0].Rows[start]["long"].ToString());

                _bfPolyLine += " var polyline=new GPolyline([ ";

                for (int i = start; i < end; i++)
                {
                    int offset = i - start;

                    AlertData _alert = new AlertData();
                    MapDataCommon.GetAlert(ref _alert, Session["trkCompany"].ToString(),
                             ds.Tables[0].Rows[i]["deviceID"].ToString(),
                             ds.Tables[0].Rows[i]["recDateTime"].ToString());

                    _markerText = MapDataCommon.GetDataSetMarkerText(ds, i, _alert.AlertMessage);

                    _bfMarkerScript += " point=new GPoint(" + decimal.Parse(ds.Tables[0].Rows[i]["long"].ToString()) + "," +decimal.Parse(ds.Tables[0].Rows[i]["Lat"].ToString()) + ");";

                    _bfPolyLine += " new GLatLng(" + decimal.Parse(ds.Tables[0].Rows[i]["lat"].ToString()) + "," + decimal.Parse(ds.Tables[0].Rows[i]["Long"].ToString()) + "), ";

                    if(i==0)
                    {

                        _bfMarkerScript += " icon0 = new GIcon();";
                        _bfMarkerScript += " icon0.image = '../Icon/" + ds.Tables[0].Rows[i]["iconName"].ToString() + ".png';";
                        _bfMarkerScript += " icon0.iconSize = new GSize(" + iconHeight + "," + iconWidth + ");";
                        _bfMarkerScript += " icon0.iconAnchor = new GPoint(" + iconHeight / 2 + "," + iconWidth / 2 + ");";
                        _bfMarkerScript += " icon0.infoWindowAnchor = new GPoint(15, 15);";
                        _bfMarkerScript += " marker[" + offset + "]=new GMarker(point,icon0);";

                    }
                    else
                    {
                        string color = MapDataCommon.GetAlertColor(_alert);

                        _bfMarkerScript += " icon0 = new GIcon();";
                        _bfMarkerScript += " icon0.image = '../Images/crumb_" + color + ".png';";
                        _bfMarkerScript += " icon0.iconSize = new GSize(" + 20  + "," + 34  + ");";
                        _bfMarkerScript += " icon0.iconAnchor = new GPoint(9,34);";
                        _bfMarkerScript += " icon0.infoWindowAnchor = new GPoint(9,9);";
                        _bfMarkerScript += " marker[" + offset + "]=new GMarker(point,icon0);";
                    }

                    _bfMarkerScript += "label[" + offset + "] = new ELabel(new GLatLng(" + decimal.Parse(ds.Tables[0].Rows[i]["Lat"].ToString()) + "," +
                                      decimal.Parse(ds.Tables[0].Rows[i]["long"].ToString()) + "), '" +
                                     (ds.Tables[0].Rows.Count - i).ToString() + "', 'style1');";
                    _bfMarkerScript += "label[" + offset + "].pixelOffset=new GSize(5,10);";
                    _bfMarkerScript += "map.addOverlay(label[" + offset + "]);";

                    _bfMarkerScript += " myEvent[" + offset + "] = GEvent.addListener(marker[" + offset + "],'click',function(){";
                    _bfMarkerScript += " ";
                    _bfMarkerScript += " marker[" + offset + "].openInfoWindowHtml('" + _markerText + "'); });";
                    _bfMarkerScript += "map.addOverlay(marker[" + offset + "]);";
                    _bfMarkerScript += " gmarkers[" + offset + "] = marker[" + offset + "];";
                    _bfMarkerScript += "htmls[" + offset + "] = '" + _markerText + "';";
                }

           				_lat = decimal.Parse(ds.Tables[0].Rows[end - 1]["lat"].ToString());
                _lng = decimal.Parse(ds.Tables[0].Rows[end - 1]["long"].ToString());

                _bfPolyLine += " new GLatLng(" + _lat + "," + _lng + ")], ";
                _bfPolyLine += " '#008000', 10);";
                _bfPolyLine += "map.addOverlay(polyline);";

                _bfMarkerScript += _bfPolyLine;

                _script += " map.clearOverlays();";
                _script += " map.setCenter(new GLatLng(" + latest_lat + "," + latest_lon + "),11,G_HYBRID_MAP);";
                _script += " GEvent.addListener(map,'zoomend',afterZoomEnd);";
                _script += _bfMarkerScript.ToString();
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message.ToString());
        }

        return _script;
    }
    public AlertData getLastAlert()
    {
        string strSQL = "SELECT * FROM tblAlert WHERE unitID = " +
                        "(SELECT DISTINCT unitID FROM tblUnits WHERE deviceID = " + Session["deviceID"].ToString() +
                        " AND comID = " + Session["trkCompany"].ToString() + ") ORDER BY id DESC LIMIT 1;";
        ExecuteSQL exec = new ExecuteSQL();
        DataSet ds = new DataSet();
        AlertData alert = new AlertData();

        try
        {
            ds = exec.getDataSet(strSQL);

            if (ds.Tables[0].Rows.Count > 0)
            {
                alert.AlertTime = ds.Tables[0].Rows[0]["alertTime"].ToString();
                alert.AlertMessage = ds.Tables[0].Rows[0]["alertMessage"].ToString();
                alert.AlertType = ds.Tables[0].Rows[0]["alertType"].ToString();

            }
        }
        catch (Exception ex)
        {
            throw new Exception ("getLastAlert(): " + ex.Message + "\n" + strSQL);
        }

        return alert;
    }
Ejemplo n.º 7
0
    private DataSet createDataSet(DataSet ds)
    {
        if (ds.Tables[0].Rows.Count == 0)
        {
            return null;
        }

        DataTable dt = new DataTable();

        dt.Columns.Add("location", typeof(string));
        dt.Columns.Add("velocity", typeof(int));
        dt.Columns.Add("distance", typeof(decimal));
        dt.Columns.Add("recDateTime", typeof(string));
        dt.Columns.Add("alert", typeof(string));

        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            DataRow row = dt.NewRow();

            AlertData _alert = new AlertData();
            MapDataCommon.GetAlert(ref _alert, Session["trkCompany"].ToString(),
                             		ds.Tables[0].Rows[i]["deviceID"].ToString(),
                             		ds.Tables[0].Rows[i]["recDateTime"].ToString());

            if (i > 0)
            {
                double lat1, lon1;
                double lat2, lon2;

                lat1 = double.Parse(ds.Tables[0].Rows[i - 1]["lat"].ToString());
                lon1 = double.Parse(ds.Tables[0].Rows[i - 1]["long"].ToString());

                lat2 = double.Parse(ds.Tables[0].Rows[i]["lat"].ToString());
                lon2 = double.Parse(ds.Tables[0].Rows[i]["long"].ToString());

                dt.Rows[i - 1]["distance"] = DistanceCalculator.CalcDistance(lat1, lon1, lat2, lon2);
            }

            row["location"] = MapDataCommon.GetReverseGeocodingString(ds.Tables[0].Rows[i]["lat"].ToString(),
                                  									  ds.Tables[0].Rows[i]["long"].ToString());
            row["velocity"] = ds.Tables[0].Rows[i]["velocity"];
            row["recDateTime"] = XtremeK.TimeZone.ToLocalTime(ds.Tables[0].Rows[i]["recDateTime"].ToString()).ToString();
            if (_alert.AlertMessage.Length > 0) {
                row["alert"] = _alert.AlertMessage;
            } else {
                row["alert"] = "Position";
            }

            dt.Rows.Add(row);
        }

        dt.Rows[dt.Rows.Count - 1]["distance"] = 0;

        DataSet data = new DataSet();
        data.Tables.Add(dt);

        return data;
    }
Ejemplo n.º 8
0
    private string GetMarkerScript(bool init)
    {
        StringBuilder _bfScript = new StringBuilder();
           	StringBuilder _bfMarkerScript = new StringBuilder();
        StringBuilder _bfPolyLine = new StringBuilder();
        StringBuilder _script = new StringBuilder();

        IList<MapData> _mapData;
        ProcessBreadCrumbsData _breadCrumbs = new ProcessBreadCrumbsData();

        try
        {
         	if (Session["recTime"] != null)
          	{
                _breadCrumbs.ComID = int.Parse(Session["trkCompany"].ToString());
              	_breadCrumbs.DeviceID = int.Parse(Request.QueryString["deviceID"].ToString());
                _breadCrumbs.RecTime = long.Parse(Session["recTime"].ToString());
             	_breadCrumbs.GetData1();
                _mapData = _breadCrumbs.MapData;
                _bfScript.Append(" map.clearOverlays();");
               	_bfScript.Append(" DisPoseNodes(); ");

            }
            else
            {
                if (!init)
                    return null;

              	_breadCrumbs.ComID = int.Parse(Session["trkCompany"].ToString());
              	_breadCrumbs.DeviceID = int.Parse(Request.QueryString["deviceID"].ToString());
               	_breadCrumbs.GetData2();
             	_mapData = _breadCrumbs.MapData;
          	}

                if (_mapData.Count > 0)
                {
                    string _markerText = "";
                    decimal _lat = 0, _lng = 0;

                   	_bfPolyLine.Append(" polyline=new GPolyline([ ");

                    for (int i = 0; i < _mapData.Count; i++)
                    {
                        AlertData _alert = new AlertData();
                        MapDataCommon.GetAlert(ref _alert, Session["trkCompany"].ToString(),
                                         	   _mapData[i].DeviceID, _mapData[i].RecTimeRevised);

                        // Get the marker text for the map data object
                        _markerText = MapDataCommon.GetMapMarkerText(_mapData[i], _alert.AlertMessage.Replace("\"", @"\\"""));

                        if (init)
                        {
                            if (Session["recTime"] == null)
                           	{
                              	Session["recTime"] = long.Parse(_mapData[i].RecTime.ToString());
                           	}
                        }

                        _bfPolyLine.Append(" new GLatLng(" + _mapData[i].Latitude + "," + _mapData[i].Longitude + "), ");

                        _bfMarkerScript.Append("  point=new GPoint(" + _mapData[i].Longitude + "," + _mapData[i].Latitude + ");");

                        if (i == 0)
                        {
                            _bfMarkerScript.Append(" icon0 = new GIcon();");
                            _bfMarkerScript.Append(" icon0.image = \\'../Icon/" + _mapData[i].IconName + ".png\\';");
                            _bfMarkerScript.Append(" icon0.iconSize = new GSize(" + iconHeight  + "," + iconWidth  + ");");
                            _bfMarkerScript.Append(" icon0.iconAnchor = new GPoint(" + iconHeight/2 + "," + iconWidth/2 + ");");
                            _bfMarkerScript.Append(" icon0.infoWindowAnchor = new GPoint(15, 15);");
                            _bfMarkerScript.Append(" icon0.infoShadowAnchor = new GPoint(18, 25);");
                            _bfMarkerScript.Append(" label = new ELabel(new GLatLng(" + _mapData[i].Latitude + "," + _mapData[i].Longitude + "), \\'" + _mapData[i].UnitName + "\\',\\'tag_red\\');");
                            _bfMarkerScript.Append(" label.pixelOffset=new GSize(15,0);");
                            _bfMarkerScript.Append(" map.addOverlay(label);");
                            _bfMarkerScript.Append(" if (hide) label.hide();");
                            _bfMarkerScript.Append(" marker[" + i + "]=new GMarker(point,icon0);");

                        }
                        else
                        {
                            string color = MapDataCommon.GetAlertColor(_alert);
                            _bfMarkerScript.Append(" icon0 = new GIcon();");
                            _bfMarkerScript.Append(" icon0.image = \\'../Images/crumb_" + color + ".png\\';");
                            _bfMarkerScript.Append(" icon0.iconSize = new GSize(" + 20  + "," + 34  + ");");
                            _bfMarkerScript.Append(" icon0.iconAnchor = new GPoint(9,34);");
                            _bfMarkerScript.Append(" icon0.infoWindowAnchor = new GPoint(9,9);");
                            _bfMarkerScript.Append(" marker[" + i + "]=new GMarker(point,icon0);");

                        }

                        _bfMarkerScript.Append(" myEvent[" + i + "]= GEvent.addListener(marker[" + i + "],\\'click\\',function(){");
                        _bfMarkerScript.Append(" ");
                        _bfMarkerScript.Append(" marker[" + i + "].openInfoWindowHtml(\\'" + _markerText + "\\'); });");
                        _bfMarkerScript.Append("map.addOverlay(marker[" + i + "]);");

                        _lat = _mapData[i].Latitude;
                        _lng = _mapData[i].Longitude;

                        if (_mapData[i].Velocity == "0")
                        {
                            i = _mapData.Count;
                        }

                    }

                    _bfPolyLine.Append(" new GLatLng(" + _lat + "," + _lng + ")], ");
                    _bfPolyLine.Append(" \\'#008000\\', 10);");
                    _bfPolyLine.Append("map.addOverlay(polyline)");

                    _bfMarkerScript.Append(_bfPolyLine.ToString());

                    if (init)
                        _script.Append("map.setCenter(new GLatLng(" + _lat + "," + _lng + "),13,G_HYBRID_MAP);");
                    else
                        _script.Append("map.setCenter(new GLatLng(" + _mapData[0].Latitude + "," + _mapData[0].Longitude + "));");
                    _script.Append(_bfMarkerScript.ToString());

                    _bfScript.Append(" setTimeout('evalMarker(\"" + _script.ToString() + "\")',5); ");

                    return _bfScript.ToString();
            }
        }
        catch (Exception ex)
           	{
            Console.WriteLine(ex.Message);
         	}
        finally
         	{
            _mapData = null;
          	_bfMarkerScript = null;
          	_bfPolyLine = null;
          	_bfScript = null;
          	_breadCrumbs = null;
           	}

        return "";
    }