/***********************************************************************
 * frm_MainMap.cs
 * Author: Ryan Abendroth
 * AHCS: _______________________
 * Assignment: Capstone Experience Project - Door To Door
 * Date Due: Tuesday, May, 13th, 2013
***********************************************************************/
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Net;
using GMap.NET;
using GMap.NET.WindowsForms;
using GMap.NET.MapProviders;
//using System.IO;
using System.Xml;
using System.Xml.XPath;


namespace Door2Door
{
    public partial class frm_MainMap : Form
    {
        private string address;
        private int totalDestinations = 0;
        private double totalDistance;
        Bitmap from_marker = new Bitmap("marker.png"); //Next destination on route
        Bitmap dest_marker = new Bitmap("bluemarker.png"); //Future destination on route
        Bitmap curr_loc = new Bitmap("greenmarker.png"); //Current location
        GMapOverlay markers = new GMapOverlay();
        //private string[] inputArray = new string[12];
        private string[] addressArray = new string[20];
        //private transaction[] passengerArray = new transaction[10];
        //private destination[] destinationArray = new destination[20];
        //private destination[] routeArray = new destination[20];
        public List<CheckBox> destinationList = new List<CheckBox>(20);
        public List<Label> routeList = new List<Label>(20);
        //private StreamReader f = new StreamReader(Environment.CurrentDirectory + "\\passengers.txt");
        //private const char c_delimiter = '*';
        //private string v_FileLineData;
        //private PointLatLng v_newPoint;
        private OleDbConnection theConnection;
        private OleDbCommand theCmd;
        private string theConnectionString;
        private int v_DBcount;
        //private string temp;
        private PointLatLng v_CurrentPos;

        /// <summary>
        /// Address property.
        /// </summary>
        public string Address
        {
            get{ return address; }
            set{ address = value; }
        }

        /// <summary>
        /// Property to access total number of destinations selected for routing.
        /// </summary>
        public int TotalDestinations
        {
            get { return totalDestinations; }
            set { totalDestinations = value; }
        }

        /// <summary>
        /// Property to access the total distance to the final destination.
        /// </summary>
        public double TotalDistance
        {
            get { return totalDistance; }
            set { totalDistance = value; }
        }

        ///// <summary>
        ///// Property to access the current line of data read into the application from the streamreader.
        ///// </summary>
        //public string FileLineData
        //{
        //    get { return v_FileLineData; }
        //    set { v_FileLineData = value; }
        //}

        /// <summary>
        /// Property to access the result of a count conducted in a SQL query.
        /// </summary>
        public int DBcount
        {
            get { return v_DBcount; }
            set { v_DBcount = value; }
        }

        ///// <summary>
        ///// Property to access a temporary string.
        ///// </summary>
        //public string Temporary
        //{
        //    get { return temp; }
        //    set { temp = value; }
        //}

        /// <summary>
        /// Property to access the current position of the driver.
        /// </summary>
        public PointLatLng CurrentPos
        {
            get { return v_CurrentPos; }
            set { v_CurrentPos = value; }
        }
        
        /// <summary>
        /// Main method to initialize the main map form.
        /// </summary>
        public frm_MainMap()
        {
            //int tracker = 0;
            //int j = 1;

            InitializeComponent();

            //Initialize with a default starting location for the taxi
            CurrentPos = GetLatLngFromAdd("100 Grant Street De Pere, Wisconsin 54115");

            //Load back-end
            theConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" //Access 2010
            + @"data source=" + Environment.CurrentDirectory.ToString() + "\\Door2Door.accdb";
            theConnection = new OleDbConnection(theConnectionString);
            theConnection.Open();
            //if (theConnection.State == System.Data.ConnectionState.Open)
            //    MessageBox.Show("Yay!");
            //MessageBox.Show("db should be open!");
            theCmd = theConnection.CreateCommand();

            //for (int i = 0; i < 20; i++)
            //    addressArray[i] = "";

            //theCmd.CommandText = "SELECT COUNT(*) FROM transactions";
            ////OleDbDataReader reader = null ;// = theCmd.ExecuteReader();
            //DBcount = (int)theCmd.ExecuteScalar();///*reader.GetInt32(0);*/Convert.ToInt32(reader.GetValue(0));
            //MessageBox.Show(DBcount.ToString());

            //if (DBcount > 20)
            //    DBcount = 20;

            //while (j <= DBcount)
            //{
            //    theCmd.CommandText = "SELECT FADDR1 FROM transactions WHERE ID = " + j + ";";
            //    //reader = theCmd.ExecuteReader();
            //    Address = (string)theCmd.ExecuteScalar();//reader.GetValue(0).ToString();
            //    theCmd.CommandText = "SELECT FCITY FROM transactions WHERE ID = " + j + ";";
            //    //reader = theCmd.ExecuteReader();
            //    Address += " " + (string)theCmd.ExecuteScalar();//reader.GetValue(0).ToString();
            //    theCmd.CommandText = "SELECT FSTATE FROM transactions WHERE ID = " + j + ";";
            //    //reader = theCmd.ExecuteReader();
            //    Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
            //    theCmd.CommandText = "SELECT FZIP FROM transactions WHERE ID = " + j + ";";
            //    //reader = theCmd.ExecuteReader();
            //    Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
            //    addressArray[tracker] = Address;
            //    MessageBox.Show(Address);
                
            //    tracker++;
            //    Address = "";

            //    theCmd.CommandText = "SELECT TADDR1 FROM transactions WHERE ID = " + j + ";";
            //    //reader = theCmd.ExecuteReader();
            //    Address = (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
            //    theCmd.CommandText = "SELECT TCITY FROM transactions WHERE ID = " + j + ";";
            //    //reader = theCmd.ExecuteReader();
            //    Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
            //    theCmd.CommandText = "SELECT TSTATE FROM transactions WHERE ID = " + j + ";";
            //    //reader = theCmd.ExecuteReader();
            //    Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
            //    theCmd.CommandText = "SELECT TZIP FROM transactions WHERE ID = " + j + ";";
            //    //reader = theCmd.ExecuteReader();
            //    Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
            //    addressArray[tracker] = Address;
            //    MessageBox.Show(Address);

            //    tracker++;
            //    Address = "";
            //    j++;
            //}
            ////reader.Close();
            //Address = "";

            ////Load first 20 addresses into queue.
            //addressArray[0] = "100 Grant Street De Pere, Wisconsin";
            //addressArray[1] = "410 South Main Street Markesan, Wisconsin";
            //addressArray[2] = "620 3rd Street De Pere, Wisconsin";

            /*Populating destination and route lists with respective checkboxes and textboxes*/
            //Destinations (checkboxes)
            destinationList.Add(cb_Dest1);
            destinationList.Add(cb_Dest2);
            destinationList.Add(cb_Dest3);
            destinationList.Add(cb_Dest4);
            destinationList.Add(cb_Dest5);
            destinationList.Add(cb_Dest6);
            destinationList.Add(cb_Dest7);
            destinationList.Add(cb_Dest8);
            destinationList.Add(cb_Dest9);
            destinationList.Add(cb_Dest10);
            destinationList.Add(cb_Dest11);
            destinationList.Add(cb_Dest12);
            destinationList.Add(cb_Dest13);
            destinationList.Add(cb_Dest14);
            destinationList.Add(cb_Dest15);
            destinationList.Add(cb_Dest16);
            destinationList.Add(cb_Dest17);
            destinationList.Add(cb_Dest18);
            destinationList.Add(cb_Dest19);
            destinationList.Add(cb_Dest20);

            //Route (textboxes)
            routeList.Add(lb_rte1);
            routeList.Add(lb_rte2);
            routeList.Add(lb_rte3);
            routeList.Add(lb_rte4);
            routeList.Add(lb_rte5);
            routeList.Add(lb_rte6);
            routeList.Add(lb_rte7);
            routeList.Add(lb_rte8);
            routeList.Add(lb_rte9);
            routeList.Add(lb_rte10);
            routeList.Add(lb_rte11);
            routeList.Add(lb_rte12);
            routeList.Add(lb_rte13);
            routeList.Add(lb_rte14);
            routeList.Add(lb_rte15);
            routeList.Add(lb_rte16);
            routeList.Add(lb_rte17);
            routeList.Add(lb_rte18);
            routeList.Add(lb_rte19);
            routeList.Add(lb_rte20);

            populateAddresses();

            //for (int i = 0; i < 20; i++)
            //{
            //    if (addressArray[i] != "")
            //    {
            //        destinationList[i].Text = addressArray[i];
            //        destinationList[i].Enabled = true;
            //    }
            //}
        }

        private void populateAddresses()
        {
            int tracker = 0;
            int j = 1;

            for (int i = 0; i < 20; i++)
                addressArray[i] = "";

            theCmd.CommandText = "SELECT COUNT(*) FROM transactions;";
            //OleDbDataReader reader = null ;// = theCmd.ExecuteReader();
            DBcount = (int)theCmd.ExecuteScalar();///*reader.GetInt32(0);*/Convert.ToInt32(reader.GetValue(0));
            //MessageBox.Show(DBcount.ToString());

            if (DBcount > 20)
                DBcount = 20;

            while (j <= DBcount)
            {
                theCmd.CommandText = "SELECT FADDR1 FROM transactions WHERE ID = " + j + ";";
                //reader = theCmd.ExecuteReader();
                Address = (string)theCmd.ExecuteScalar();//reader.GetValue(0).ToString();
                theCmd.CommandText = "SELECT FCITY FROM transactions WHERE ID = " + j + ";";
                //reader = theCmd.ExecuteReader();
                Address += " " + (string)theCmd.ExecuteScalar();//reader.GetValue(0).ToString();
                theCmd.CommandText = "SELECT FSTATE FROM transactions WHERE ID = " + j + ";";
                //reader = theCmd.ExecuteReader();
                Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
                theCmd.CommandText = "SELECT FZIP FROM transactions WHERE ID = " + j + ";";
                //reader = theCmd.ExecuteReader();
                Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
                addressArray[tracker] = Address;
                //MessageBox.Show(Address);

                tracker++;
                Address = "";

                theCmd.CommandText = "SELECT TADDR1 FROM transactions WHERE ID = " + j + ";";
                //reader = theCmd.ExecuteReader();
                Address = (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
                theCmd.CommandText = "SELECT TCITY FROM transactions WHERE ID = " + j + ";";
                //reader = theCmd.ExecuteReader();
                Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
                theCmd.CommandText = "SELECT TSTATE FROM transactions WHERE ID = " + j + ";";
                //reader = theCmd.ExecuteReader();
                Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
                theCmd.CommandText = "SELECT TZIP FROM transactions WHERE ID = " + j + ";";
                //reader = theCmd.ExecuteReader();
                Address += " " + (string)theCmd.ExecuteScalar(); //reader.GetValue(0).ToString();
                addressArray[tracker] = Address;
                //MessageBox.Show(Address);

                tracker++;
                Address = "";
                j++;
            }
            //reader.Close();
            Address = "";

            for (int i = 0; i < 20; i++)
            {
                if (addressArray[i] != "")
                {
                    destinationList[i].Text = addressArray[i];
                    destinationList[i].Enabled = true;
                }
            }
        }

        /// <summary>
        /// Method to initialize map on the main form.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void frm_MainMap_Load(object sender, EventArgs e)
        {
            //Initialize map:
            gM_Map.MapProvider = GMap.NET.MapProviders.GoogleMapProvider.Instance;
            GMap.NET.GMaps.Instance.Mode = GMap.NET.AccessMode.ServerOnly;
            gM_Map.SetPositionByKeywords("Wisconsin");
            gM_Map.Zoom = 9;
        }

        /// <summary>
        /// Logic to enter an address and receive and latitude/longitude point.
        /// Written by: Eric Sallmann
        /// </summary>
        /// <param name="Address"></param>
        /// <returns name="returnPos"></returns>
        public PointLatLng GetLatLngFromAdd(string Address)
        {
            PointLatLng returnPos = new PointLatLng();
            //set a url equal to the google map's api with an xml geocode containing the address called from the function
            string URL = "http://maps.googleapis.com/maps/api/geocode/" + "xml?address=" + Address + ",+CA&sensor=false";
            WebResponse response = null;            //create a webresponse instance
            //test the address's web request to see if the address can be processed
            try
            {
                HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);        //create a new http web request with the url given above
                request.Method = "GET";             //set the request method to get the http web request
                response = request.GetResponse();           //set the response from the request given
                //if the response is not blank
                if(response != null)
                {
                    //create a new XPathDocument instance with the document to receive the response stream
                    XPathDocument document = new XPathDocument(response.GetResponseStream());
                    XPathNavigator navigator = document.CreateNavigator();      //create a new XPathNavigator instance with the document that creates the navigator

                    // get response status code
                    XPathNodeIterator statusIterator = navigator.Select("/GeocodeResponse/status");
                    // while not at the end of the status iterator value
                    while(statusIterator.MoveNext())
                    {
                        //if the current value of the iterator is not valid
                        if(statusIterator.Current.Value != "OK")
                        {
                            //respond with a status for that status error with it's current value
                            MessageBox.Show("Error: response status = '" + statusIterator.Current.Value + "'");
                            //return a -1 for the latitude and longitude coordinate locations for the map
                            returnPos.Lat = -1;
                            returnPos.Lng = -1;
                            return returnPos;
                        }
                    }
                    // get results with an XPathNodeIterator using the Geocode result response
                    XPathNodeIterator resultIterator = navigator.Select("/GeocodeResponse/result");
                    // while not at the end of the result iterator value
                    while(resultIterator.MoveNext())
                    {
                        //create a new XPathNodeIterator instance with the geometry selected
                        XPathNodeIterator geometryIterator = resultIterator.Current.Select("geometry");
                        //while not at the end of the geometry iterator value
                        while (geometryIterator.MoveNext())
                        {
                            //create a new XPathNodeIterator instance with the location selected
                            XPathNodeIterator locationIterator = geometryIterator.Current.Select("location");
                            //while not at the end of the location iterator value
                            while (locationIterator.MoveNext())
                            {
                                //create a new XPathNodeIterator instance with the latitude selected
                                XPathNodeIterator latIterator = locationIterator.Current.Select("lat");
                                //while not at the end of the latitude iterator value
                                while (latIterator.MoveNext())
                                    //set the latitude of the postition to be returned to the iterator value
                                    returnPos.Lat = Convert.ToDouble(latIterator.Current.Value);
                                //create a new XPathNodeIterator instance with the longitude selected
                                XPathNodeIterator lngIterator = locationIterator.Current.Select("lng");
                                //while not at the end of the longitude iterator value
                                while (lngIterator.MoveNext())
                                    //set the longitude of the position to be returned to the iterator value
                                    returnPos.Lng = Convert.ToDouble(lngIterator.Current.Value);
                            }
                        }
                    }
                }
            }
            //if an exception was caught by the web address given display the message of the exception
            catch(Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            //after the request has been processed or if an exception was caught
            finally
            {
                //if the response is not null
                if(response != null)
                {
                    response.Close();       //remove the response
                    response = null;        //and set the response to null
                }
            }
            return returnPos;               //return the resulted position from the iterator
        }

        /// <summary>
        /// Method to exit the application via the menustrip button.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void exitToolStripMenuItem_Click(object sender, EventArgs e)
        {
            theConnection.Close();
            Application.Exit();
        }

        /// <summary>
        /// Method to update the route based on what destination is clicked first.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void destinationClicked(object sender, EventArgs e)
        {
            //Update route
            for (int i = 0; i < 20; i++)
            {
                if (destinationList[i].Checked == true && destinationList[i].Enabled == true)
                {
                    Address = destinationList[i].Text;
                    destinationList[i].Enabled = false;
                    break;
                }
            }
            for (int i = 0; i < 20; i++)
            {
                if (routeList[i].Text == "")
                {
                    routeList[i].Text = Address;
                    break;
                }
            }

            //Refresh the map
            refresh_markers();
        }

        /// <summary>
        /// Method to update the route and destination lists when the drive has reached a destination.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_Arrived_Click(object sender, EventArgs e)
        {
            int i, tracker = 0;

            //Save off the address that is to be cleared in the destination list.
            Address = routeList[0].Text;
            CurrentPos = GetLatLngFromAdd(Address); //Set the current position to the address reached.

            //Shift the remaining destinations on the current route, up one position.
            for (i = 1; i < 20; i++)
                routeList[i - 1].Text = routeList[i].Text;
            routeList[19].Text = "";

            //Find and clear the entry in the destination list that was just reached.
            for (i = 0; i < 20; i++)
            {
                if (destinationList[i].Text == Address)
                {
                    destinationList[i].Text = "";
                    tracker = i;
                    break;
                }
            }

            //Shift the remaining destinations in the list up one position.
            for (i = tracker + 1; i < 20; i++)
            {
                if (destinationList[i].Text == "")
                    destinationList[i - 1].Text = "";
                else
                {
                    destinationList[i - 1].Text = destinationList[i].Text;
                    if (destinationList[i].Enabled == false)
                    {
                        destinationList[i - 1].Enabled = false;
                        destinationList[i].Enabled = true;
                    }
                    else
                        destinationList[i - 1].Enabled = true;
                }
            }

            //Refresh the map
            refresh_markers();
        }

        /// <summary>
        /// Method to refresh the markers on the map as the driver reaches destinations.
        /// </summary>
        private void refresh_markers()
        {
            //Clear the current set to overlays and markers on marker overlay.
            gM_Map.Overlays.Clear();
            markers.Markers.Clear();
            TotalDistance = 0;

            markers.Markers.Add(new GMap.NET.WindowsForms.Markers.GMarkerGoogle(CurrentPos, curr_loc));

            //Repopulate the marker overlay.
            for (int i = 0; i < 20; i++)
            {
                if (routeList[i].Text != "")
                {
                    PointLatLng mark = new PointLatLng();
                    PointLatLng last = new PointLatLng();
                    mark = GetLatLngFromAdd(routeList[i].Text);
                    if (i == 0)
                    {
                        markers.Markers.Add(new GMap.NET.WindowsForms.Markers.GMarkerGoogle(mark, from_marker));
                        TotalDistance = Distance(CurrentPos, mark);
                    }
                    else
                    {
                        last = GetLatLngFromAdd(routeList[i - 1].Text);
                        markers.Markers.Add(new GMap.NET.WindowsForms.Markers.GMarkerGoogle(mark, dest_marker));
                        TotalDistance += Distance(mark, last);
                    }
                }
                else
                    break;
            }

            gM_Map.Overlays.Add(markers); //Add marker overlay back to the GMAP control.
            lb_DstTotal.Text = Convert.ToString(Math.Round((decimal)TotalDistance, 6)) + " miles";
        }

        /// <summary>
        /// Method to calculate the distance between to points
        /// of latitude and longitude using the haversine formula.
        /// </summary>
        /// <param name="pos1"></param>
        /// <param name="pos2"></param>
        /// <returns></returns>
        public double Distance(PointLatLng pos1, PointLatLng pos2)
        {
            double R = 6371;

            double dLat = toRadian(pos2.Lat - pos1.Lat);
            double dLon = toRadian(pos2.Lng - pos1.Lng);

            double a = Math.Sin(dLat / 2) * Math.Sin(dLat / 2) + 
                       Math.Cos(toRadian(pos1.Lat)) * Math.Cos(toRadian(pos2.Lat)) * 
                       Math.Sin(dLon / 2) * Math.Sin(dLon / 2);

            double c = 2 * Math.Asin(Math.Min(1, Math.Sqrt(a)));
            double d = R * c;

            return d; //Return the distance in miles
        }

        /// <summary>
        /// Method to covert degrees to radian.
        /// </summary>
        /// <param name="value"></param>
        /// <returns></returns>
        private double toRadian(double value)
        {
            return (Math.PI / 180) * value;
        }

        /// <summary>
        /// Method to initialize form to display information about the application.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void aboutToolStripMenuItem_Click(object sender, EventArgs e)
        {
            frmAboutDoor2Door about = new frmAboutDoor2Door();
            about.ShowDialog();
        }

        /// <summary>
        /// Method to introduce a new customer to the back-end (database).
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void newCustomerToolStripMenuItem_Click(object sender, EventArgs e)
        {
            int temp_id = 0;
            string FName, LName, FAddr1, FAddr2, FCity, FState, FZIP, TAddr1, TAddr2, TCity, TState, TZIP;

            frm_NewCustomer newCust = new frm_NewCustomer();
            newCust.ShowDialog();
            if (newCust.DialogResult == DialogResult.OK)
            {
                FName = newCust.FName;
                LName = newCust.LName;
                FAddr1 = newCust.FAddr1;
                FAddr2 = newCust.FAddr2;
                FCity = newCust.FCity;
                FState = newCust.FState;
                FZIP = newCust.FZIP;
                TAddr1 = newCust.TAddr1;
                TAddr2 = newCust.TAddr2;
                TCity = newCust.TCity;
                TState = newCust.TState;
                TZIP = newCust.TZIP;

                //Assign the new entry an ID that is higher than any currently in the table.
                theCmd.CommandText = "SELECT MAX(ID) FROM transactions";
                temp_id = (int)theCmd.ExecuteScalar();
                if (temp_id == 0)
                    temp_id = 1;
                else
                    temp_id++;
                //MessageBox.Show(temp_id.ToString());

                theCmd.CommandText = "INSERT INTO transactions (ID, FName, LName, FAddr1, FAddr2,FCity, " +
                                     "FState, FZIP, TAddr1, TAddr2, TCity, TState, TZIP) VALUES (" +
                                      + temp_id + ", '" + FName + "', '" + LName + "', '" + FAddr1 + 
                                      "', '" + FAddr2 + "', '" + FCity + "', '" + FState + "', '" + 
                                      FZIP + "', '" + TAddr1 + "', '" + TAddr2 + "', '" + TCity + 
                                      "', '" + TState + "', '" + TZIP + "');";
                theCmd.ExecuteNonQuery();
                //MessageBox.Show(
                //                      + temp_id + ", '" + FName + "', '" + LName + "', '" + FAddr1 + 
                //                      "', '" + FAddr2 + "', '" + FCity + "', '" + FState + "', '" + 
                //                      FZIP + "', '" + TAddr1 + "', '" + TAddr2 + "', '" + TCity + 
                //                      "', '" + TState + "', '" + TZIP);
                //MessageBox.Show("Check table for new record");
            }

        }


        /// <summary>
        /// Method to clear out the list of destinations on the current route and load any new destinations
        /// that may have been added to the back-end since the application initiated, or the last refresh 
        /// of the destination list.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_ClearDist_Click(object sender, EventArgs e)
        {
            foreach (Label lb in gb_RteQueue.Controls)
                lb.Text = "";
            populateAddresses();
            foreach (CheckBox cb in gb_DstQueue.Controls)
            {
                if (cb.Text != "")
                {
                    cb.Checked = false;
                    cb.Enabled = true;
                }
                else
                    cb.Enabled = false;
            }
            TotalDistance = 0;
            lb_DstTotal.Text = TotalDistance.ToString() + " miles";
            gM_Map.Overlays.Clear();
            markers.Markers.Clear();
        }
    }//frm_MainMap

    ////Code for if you want to read from a file and store data in class objects while application is running.
    //class transaction
    //{
    //    public int tid;
    //    public double from_longitude;
    //    public double from_latitude;
    //    public double to_longitude;
    //    public double to_latitude;
    //    public string to_address;
    //    public string from_address;
    //    public PointLatLng from_point;
    //    public PointLatLng to_point;
    //    public bool delivered;
    //    public bool cancelled;
    //    public bool pickedup;

    //    /// <summary>
    //    /// Default constructor method for new transaction objects.
    //    /// </summary>
    //    public transaction()
    //    {
    //        tid = 0;
    //        from_latitude = 0;
    //        from_longitude = 0;
    //        to_latitude = 0;
    //        to_longitude = 0;
    //        to_address = "";
    //        from_address = "";
    //        delivered = false;
    //        cancelled = false;
    //        pickedup = false;
    //    }

    //    /// <summary>
    //    /// Constructor overload method to input parameters of a new transaction object.
    //    /// </summary>
    //    /// <param name="ID"></param>
    //    /// <param name="ADDR"></param>
    //    /// <param name="FROM"></param>
    //    /// <param name="TO"></param>
    //    public transaction(int ID, string FROM_ADDR, string TO_ADDR, PointLatLng FROM, PointLatLng TO)
    //    {
    //        tid = ID;
    //        from_address = FROM_ADDR;
    //        to_address = TO_ADDR;
    //        from_point = FROM;
    //        from_latitude = FROM.Lat;
    //        from_longitude = FROM.Lng;
    //        to_point = TO;
    //        to_latitude = TO.Lat;
    //        to_longitude = TO.Lng;
    //        pickedup = false;
    //        delivered = false;
    //        cancelled = false;
    //    }

    //    /// <summary>
    //    /// Method to combine a passenger's latitude and longitude
    //    /// into a single position that can be used for a point for pickup.
    //    /// </summary>
    //    /// <returns></returns>
    //    public PointLatLng GetFromPos()
    //    {
    //        PointLatLng pos = new PointLatLng();
    //        pos.Lat = from_latitude;
    //        pos.Lng = from_longitude;
    //        return pos;
    //    }

    //    /// <summary>
    //    /// Method to combine a passenger's latitue and longitude
    //    /// into a single position that can be used for a point for delivery.
    //    /// </summary>
    //    /// <returns></returns>
    //    public PointLatLng GetToPos()
    //    {
    //        PointLatLng pos = new PointLatLng();
    //        pos.Lat = to_latitude;
    //        pos.Lng = to_longitude;
    //        return pos;
    //    }
    //}//passenger

    //class destination
    //{
    //    public int DID;
    //    public int TID;
    //    public string address;
    //    public PointLatLng position;
    //    public double latitude;
    //    public double longitude;

    //    /// <summary>
    //    /// Default constructor for new destination objects.
    //    /// </summary>
    //    public destination()
    //    {
    //        DID = 0;
    //        TID = 0;
    //        address = "";
    //        latitude = 0;
    //        longitude = 0;
    //    }

    //    /// <summary>
    //    /// Overload constructor for new destination objects.
    //    /// </summary>
    //    /// <param name="destID"></param>
    //    /// <param name="transID"></param>
    //    /// <param name="addr"></param>
    //    /// <param name="pos"></param>
    //    /// <param name="lat"></param>
    //    /// <param name="lng"></param>
    //    public destination(int destID, int transID, string addr, PointLatLng pos, double lat, double lng)
    //    {
    //        DID = destID;
    //        TID = transID;
    //        address = addr;
    //        position = pos;
    //        latitude = lat;
    //        longitude = lng;
    //    }
    //}
}//Door2Door