// <%STEMCELL:PerDirectoryNoticeText%>
// ALL RIGHTS RESERVED:
// ====================
// The contents of this file, and associated files in this directory, are
// Copyright (C) ThinkGeo,LLC , all rights reserved, 2003-2008.
//
// All software Source Code, Images, Database-Design and code, Graphics Design
// and source files, and related content (collectively referred to as SOURCE)
// are Copyright (c) ThinkGeo,LLC, 2003-2008, All Rights Reserved.
// ThinkGeo,LLC is a USA corporation at 1617 St. Andrews Dr.Suite 201,Lawrence,
// KS 66047.
// http://ThinkGeo.com
//
// MapSuite is a Registered Trademark of ThinkGeo,LLC.
//
//</%STEMCELL:PerDirectoryNoticeText%>

using System;
using System.Configuration;
using System.Drawing.Imaging;
using System.Web.UI;
using ThinkGeo.MapSuite.Core;
using ThinkGeo.MapSuite.WebEdition;
using System.Collections.ObjectModel;
using System.Text;
using System.Globalization;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI.WebControls;
using System.Web.Configuration;
using System.Diagnostics;
using System.Collections;
using System.IO;
using System.Collections.Specialized;

namespace Errma
{
    public partial class KitMap : System.Web.UI.Page
    {
        private SqlConnection _connection;
        private SqlCommand _command;
        private SqlDataReader _reader;
        public DataTable MapData;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                Map1.MapBackground.BackgroundBrush = new GeoSolidBrush(GeoColor.FromArgb(255, 242, 239, 233));
                Map1.MapUnit = GeographyUnit.DecimalDegree;

                string dataPath = ConfigurationManager.AppSettings.Get("WorldMapKitDataFolder");
                RenderMap renderMap = new RenderMap(dataPath);
                renderMap.LoadLayers(Map1.StaticOverlay.Layers, Map1.DynamicOverlay.Layers);
                Map1.CurrentExtent = RenderMap.DefaultExtent;
                Map1.StaticOverlay.WebImageFormat = WebImageFormat.Jpeg;

                //Map1.StaticOverlay.ServerCache.CacheDirectory = ConfigurationManager.AppSettings.Get("ImageCacheFolder");
                //Map1.StaticOverlay.ClientCache.Duration = new TimeSpan(1, 0, 0, 0);
                //Map1.StaticOverlay.ClientCache.CacheId = "ThinkGeoClientCache";

                Map1.MapTools.LoadingImage.Enabled = true;
                Map1.MapTools.KeyboardMapTool.Enabled = true;
                Map1.MapTools.MiniMap.Enabled = false;
                Map1.MapTools.ScaleLine.Enabled = true;
                Map1.MapTools.MouseCoordinate.Enabled = true;
                Map1.MapTools.PanZoomBar.Enabled = true;

                //RunDemoCode();
                DataTable dt = new DataTable();
                dt = SetupDataSet();

                DrawMap(dt);

                Timer1.Enabled = true;
            }
        }

        //////////////////////////////////////////////////
        // Production code
        // Initial query
        // Load points to define extent
        // Draw in memory markers
        // ReDraw in memory markers on update if changed 
        /// /////////////////////////////////////////////

        private DataTable SetupDataSet()
        {
            string connect = WebConfigurationManager.ConnectionStrings["AsyncConnection"].ConnectionString;
            _connection = new SqlConnection(connect);
            _connection.Open();
            _command = new SqlCommand("SelectSiteDisplayDataByObserverID", _connection);
            _command.Parameters.AddWithValue("@ObserverID", Convert.ToInt32(Session["ObserverID"]));

            _reader = _command.ExecuteReader();

            DataTable dt = new DataTable("Sites");

            //dt = CreateSitesDataTable();
            dt = CreateUpdateDataTableSchema();

            //load the DataTable
            while (_reader.Read())
            {
                DataRow workRow = dt.NewRow();
                workRow["lSiteID"] = _reader["lSiteID"];
                workRow["ObserverID"] = Session["Municipality"].ToString();
                workRow["lLatitude"] = _reader["lLatitude"];
                workRow["lLongitude"] = _reader["lLongitude"];
                workRow["szChannelName"] = _reader["szChannelName"];
                workRow["szSiteDesc"] = _reader["szSiteDesc"];
                workRow["DisplayState"] = _reader["DisplayState"];
                workRow["DisplayText"] = _reader["DisplayText"];

                dt.Rows.Add(workRow);
                MapData = dt;
            }
            _reader.Close();

            // Cache the initialized DataTable per municipality.
            string id = Session["Municipality"].ToString();
            string name = id + "Sites";
            Cache[name] = (object)dt;

            return dt;
        }

        public static DataTable CreateUpdateDataTableSchema()
        {
            //lSiteID
            //ObserverID
            //lLatitude
            //lLongitude
            //szChannelName
            //szSiteDesc
            //DisplayState
            //DisplayText
            //Ticks

            try
            {
                // Create a new DataTable.
                DataTable table = new DataTable("MapItems");
                // Declare variables for DataColumn and DataRow objects.
                DataColumn column;

                // Create new DataColumns, set DataType, 
                // ColumnName and add to DataTable.    
                column = new DataColumn();
                column.DataType = System.Type.GetType("System.Int32");
                column.ColumnName = "lSiteID";
                column.ReadOnly = true;
                column.Unique = false;
                // Add the Column to the DataColumnCollection.
                table.Columns.Add(column);

                //Continue...
                column = new DataColumn();
                column.DataType = System.Type.GetType("System.Int32");
                column.ColumnName = "ObserverID";
                column.ReadOnly = true;
                column.Unique = false;
                // Add the Column to the DataColumnCollection.
                table.Columns.Add(column);

                column = new DataColumn();
                column.DataType = System.Type.GetType("System.Decimal");
                column.ColumnName = "lLatitude";
                column.AutoIncrement = false;
                column.ReadOnly = true;
                column.Unique = false;
                // Add the column to the table.
                table.Columns.Add(column);

                column = new DataColumn();
                column.DataType = System.Type.GetType("System.Decimal");
                column.ColumnName = "lLongitude";
                column.AutoIncrement = false;
                column.ReadOnly = true;
                column.Unique = false;
                // Add the column to the table.
                table.Columns.Add(column);

                column = new DataColumn();
                column.DataType = System.Type.GetType("System.String");
                column.ColumnName = "szChannelName";
                column.AutoIncrement = false;
                column.ReadOnly = true;
                column.Unique = false;
                // Add the column to the table.
                table.Columns.Add(column);

                column = new DataColumn();
                column.DataType = System.Type.GetType("System.String");
                column.ColumnName = "szSiteDesc";
                column.AutoIncrement = false;
                column.ReadOnly = true;
                column.Unique = false;
                // Add the column to the table.
                table.Columns.Add(column);

                column = new DataColumn();
                column.DataType = System.Type.GetType("System.Int32");
                column.ColumnName = "DisplayState";
                column.AutoIncrement = false;
                column.ReadOnly = true;
                column.Unique = false;
                // Add the column to the table.
                table.Columns.Add(column);

                column = new DataColumn();
                column.DataType = System.Type.GetType("System.String");
                column.ColumnName = "DisplayText";
                column.AutoIncrement = false;
                column.ReadOnly = true;
                column.Unique = false;
                // Add the column to the table.
                table.Columns.Add(column);

                column = new DataColumn();
                column.DataType = System.Type.GetType("System.String");
                column.ColumnName = "Ticks";
                column.AutoIncrement = false;
                column.ReadOnly = true;
                column.Unique = false;
                // Add the column to the table.
                table.Columns.Add(column);

                DataColumn[] keys = new DataColumn[2];
                keys[0] = table.Columns["lSiteID"];
                table.PrimaryKey = keys;

                return table;
            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex);
                throw ex;
            }
        }

        private void DrawMap(DataTable dt)
        {
            //Draw points for extent
            InMemoryFeatureLayer shapeLayer = new InMemoryFeatureLayer();
            shapeLayer.ZoomLevelSet.ZoomLevel01.DefaultPointStyle =
                PointStyles.CreateSimplePointStyle(PointSymbolType.Circle, GeoColor.StandardColors.Blue, 5);
            shapeLayer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20;
            Map1.DynamicOverlay.Layers.Add("pointShapeLayer", shapeLayer);

            //Create the points at lat/lon for BoundingBox
            DrawPointsLayer(dt, shapeLayer);

            //configure extent
            shapeLayer.Open();
            Map1.CurrentExtent.ScaleUp(60);
            Map1.CurrentExtent = shapeLayer.GetBoundingBox();
            Map1.RestrictedExtent = Map1.CurrentExtent;
            Map1.CurrentExtent = Map1.CurrentExtent;
            shapeLayer.Close();

            //Add value markers based on state of rail crossing 
            //0 = unoccupied
            //1 = occupied
            //2 = unknown

            ValueMarkerStyle currValueStyle = new ValueMarkerStyle("Crossings");

            DrawMarkerOverlays(dt, currValueStyle);
            //DrawMarkerOverlays(dt);

            //apply MarkerLayer
            Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.CustomMarkerStyle = currValueStyle;
            Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20;

            //align bottom of marker with point previously set
            Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.DefaultMarkerStyle.WebImage.ImageOffsetX = -10.5f;
            Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.DefaultMarkerStyle.WebImage.ImageOffsetY = -25f;

            Map1.MarkerOverlay.FeatureSource.Open();
            Map1.MarkerOverlay.Columns.Add(new FeatureSourceColumn("Crossings"));
            Map1.MarkerOverlay.Columns.Add(new FeatureSourceColumn("szSiteDesc"));
            Map1.MarkerOverlay.FeatureSource.Close();
        }

        private void DrawMapUpdate(DataTable dt)
        {
            //Remove existing Layer
            Map1.DynamicOverlay.Layers.Remove("pointShapeLayer");

            //Draw points for extent
            InMemoryFeatureLayer shapeLayer = new InMemoryFeatureLayer();
            shapeLayer.ZoomLevelSet.ZoomLevel01.DefaultPointStyle =
                PointStyles.CreateSimplePointStyle(PointSymbolType.Circle, GeoColor.StandardColors.Blue, 5);
            shapeLayer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20;
            
            Map1.DynamicOverlay.Layers.Add("pointShapeLayer", shapeLayer);

            //Create the points at lat/lon for BoundingBox
            DrawPointsLayer(dt, shapeLayer);

            //configure extent
            shapeLayer.Open();            
            Map1.CurrentExtent.ScaleUp(60);
            Map1.CurrentExtent = shapeLayer.GetBoundingBox();
            Map1.RestrictedExtent = Map1.CurrentExtent;
            Map1.CurrentExtent = Map1.CurrentExtent;
            shapeLayer.Close();

            Map1.DynamicOverlay.Redraw();

            //Add value markers based on state of rail crossing 
            //0 = unoccupied
            //1 = occupied
            //2 = unknown

            Map1.MarkerOverlay.Features.Clear();

            ValueMarkerStyle currValueStyle = new ValueMarkerStyle("Crossings");

            DrawMarkerOverlays(dt, currValueStyle);
            //DrawMarkerOverlays(dt);
            
            //apply MarkerLayer
            Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.CustomMarkerStyle = currValueStyle;
            Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20;

            //align bottom of marker with point previously set
            Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.DefaultMarkerStyle.WebImage.ImageOffsetX = -10.5f;
            Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.DefaultMarkerStyle.WebImage.ImageOffsetY = -25f;

            Map1.MarkerOverlay.FeatureSource.Open();
            Map1.MarkerOverlay.Columns.Add(new FeatureSourceColumn("Crossings"));
            Map1.MarkerOverlay.Columns.Add(new FeatureSourceColumn("szSiteDesc"));
            Map1.MarkerOverlay.FeatureSource.Close();
        }

        private void DrawPointsLayer(DataTable dt, InMemoryFeatureLayer myShapeLayer)
        {
            //=======================================================
            //Create the points at lat/lon for BoundingBox

            DataView dv = dt.DefaultView;

            IEnumerator iterator = dv.GetEnumerator();

            DataRowView drv;
            System.Int32 i = 0;

            string lon = string.Empty;
            string lat = string.Empty;

            while (iterator.MoveNext())
            {
                drv = (DataRowView)iterator.Current;

                lon = drv.Row["lLongitude"].ToString();
                lat = drv.Row["lLatitude"].ToString();

                if (VerifyLatLon(lat, lon))
                {
                    CreatePoints(myShapeLayer, lon, lat);
                }
                i++;
            }
        }

        private bool VerifyLatLon(string lat, string lon)
        {
            if (lon != string.Empty)
            {
                if (lat != string.Empty)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            else
            {
                return false;
            }
        }

        private void DrawMarkerOverlays(DataTable dt, ValueMarkerStyle myValueStyle)
        {            
            DataView dv = dt.DefaultView;

            IEnumerator iterator = dv.GetEnumerator();

            DataRowView drv;
            System.Int32 i = 0;

            string lon = string.Empty;
            string lat = string.Empty;
            Double dlon = 0.0;
            Double dlat = 0.0;
            string desc = string.Empty;
            string lSiteID = string.Empty;

            while (iterator.MoveNext())
            {
                drv = (DataRowView)iterator.Current;

                lon = drv.Row["lLongitude"].ToString();
                lat = drv.Row["lLatitude"].ToString();
                lSiteID = drv.Row["lSiteID"].ToString();

                if (VerifyLatLon(lat, lon))
                {
                    dlon = Convert.ToDouble(drv.Row["lLongitude"]);
                    dlat = Convert.ToDouble(drv.Row["lLatitude"]);
                    desc = drv.Row["szSiteDesc"].ToString();

                    CreateValueMarker((int)drv.Row["DisplayState"],
                        myValueStyle,
                        lSiteID,
                        dlon,
                        dlat);

                    AppendFeatures(Map1.MarkerOverlay,
                        drv.Row["DisplayState"].ToString(),
                        dlon,
                        dlat,
                        desc);
                }
                i++;
            }
        }

        private void CreateValueMarker(Int32 state, ValueMarkerStyle vmStyle, string key, double lon, double lat)
        {
            switch (state)
            {
                case 0:
                    vmStyle.ValueItems.Add(new MarkerValueItem(state.ToString(),
                        new PointMarkerStyle(new WebImage("/CrossingsMap/theme/default/img/marker_green.gif", 25, 25, -11.5F, -25F),
                            CreatePopup(key),
                            CreateContext(key, lon, lat))));
                    break;
                case 1:
                    vmStyle.ValueItems.Add(new MarkerValueItem(state.ToString(),
                        new PointMarkerStyle(new WebImage("/CrossingsMap/theme/default/img/marker.gif", 25, 25, -11.5F, -25F),
                            CreatePopup(key),
                            CreateContext(key, lon, lat))));
                    break;
                case 2:
                    vmStyle.ValueItems.Add(new MarkerValueItem(state.ToString(),
                        new PointMarkerStyle(new WebImage("/CrossingsMap/theme/default/img/marker_grey.gif", 25, 25, -11.5F, -25F),
                            CreatePopup(key),
                            CreateContext(key, lon, lat))));
                    break;
                default:
                    break;
            }
        }

        private void AppendFeatures(InMemoryMarkerOverlay markerOverlay, string state, double lon, double lat, string hoverText)
        {
            {
                Feature feature = new Feature(lon, lat);
                feature.ColumnValues.Add("Crossings", state);
                feature.ColumnValues.Add("szSiteDesc", hoverText);
                markerOverlay.Features.Add(feature);
            }
        }

        private void UpdateTrackShape()
        {
            string ticks = string.Empty;

            var proxy = new UpdateSvc();
            object[] objValues = proxy.GetMyUpdate(Session["Municipality"].ToString(), ticks);
            if (objValues != null)
            {
                //update/redraw the dynamic map layer
                //if there is data, there has been a change
                //1. update the dataset with datarow
                //2. find the point to redraw
                //3. redraw the map

                //retrieve the cached datatable object per municipality
                string id = Session["Municipality"].ToString();
                string name = id + "Sites";
                DataTable updateTable = (DataTable)Cache[name];

                //convert to datarow
                DataRow dr = updateTable.NewRow();
                dr.ItemArray = objValues;

                //update Datatable
                string lSiteID = dr["lSiteID"].ToString();
                ticks = dr["ticks"].ToString();

                DataRow foundRow = updateTable.Rows.Find(lSiteID);

                try
                {
                    if (foundRow != null)
                    {
                        foreach (DataRow item in updateTable.Rows)
                        {
                            //found a row so delete it and add new
                            if (item["lSiteID"].ToString() == lSiteID)
                            {
                                item.Delete();
                                break;
                            }
                        }
                        updateTable.AcceptChanges();
                        updateTable.ImportRow(foundRow);
                    }
                    else
                    {
                        updateTable.ImportRow(foundRow);
                    }
                }
                catch (Exception ex)
                {
                    Debug.WriteLine(ex.Message);                    
                }

                // Cache the updated DataTable per municipality.
                Cache[name] = (object)updateTable;

                DrawMapUpdate(updateTable);
            }

            //ScriptManager.RegisterStartupScript(this, this.GetType(), "UpdateMarker", "UpdateMarkers()", true);
        }

        protected void Timer1_Tick(object sender, EventArgs e)
        {
            UpdateTrackShape();
        }

        private void CreatePoints(InMemoryFeatureLayer layer, string lon, string lat)
        {
            //could use the id param to identify 
            Feature pointFeature = new Feature(new PointShape(
                double.Parse(lon, CultureInfo.InvariantCulture), double.Parse(lat, CultureInfo.InvariantCulture)));
            layer.InternalFeatures.Add(pointFeature.Id, pointFeature);
        }

        private ContextMenu CreateContext(string key, double lon, double lat)
        {
            //Map1.MarkerOverlay.AutoRefreshInterval = timespan;

            try
            {
                ContextMenu menuOnMarker = new ContextMenu(key, 180);

                ContextMenuItem redirectItem = new ContextMenuItem("<a href='' target='_blank'>Send Poll?<a>");
                ContextMenuItem zoomOutItem = new ContextMenuItem("<div onclick='Map1.ZoomIn();'>Zoom in</div>");
                //ContextMenuItem zoomOutItem = new ContextMenuItem("<div onclick='zoomIn();'>Zoom in</div>");
                ContextMenuItem zoomInItem = new ContextMenuItem("<div onclick='Map1.ZoomOut();'>Zoom out</div>");
                //ContextMenuItem centerItem = new ContextMenuItem("<div onclick='Map1.PanToWorldCoordinate(" + lon + ", " + lat + ");'>Center map here</div>");
                
                menuOnMarker.MenuItems.Add(redirectItem);
                menuOnMarker.MenuItems.Add(zoomOutItem);
                menuOnMarker.MenuItems.Add(zoomInItem);
                //menuOnMarker.MenuItems.Add(centerItem);
                Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.DefaultMarkerStyle.ContextMenu = menuOnMarker;
                return menuOnMarker;
            }
            catch
            {
                return null;
            }
        }

        private CustomPopup CreatePopup(string lSiteID)
        {
            try
            {
                CustomPopup popup = new CustomPopup(lSiteID);

                StringBuilder contentHtml = new StringBuilder();
                contentHtml.Append("<span class='popup'>")
                    .Append("[#szSiteDesc#]")
                    .Append("</span>");

                popup.ContentHtml = contentHtml.ToString();
                popup.AutoSize = true;
                popup.BorderWidth = 1;
                popup.IsVisible = false;
                popup.AutoPan = true;
                Map1.MarkerOverlay.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel = ApplyUntilZoomLevel.Level20;
                return popup;
            }
            catch
            {
                return null;
            }
        } 

        //////////////////////////////////////////////////
        // End Production code
        /// /////////////////////////////////////////////

    }
}