示例#1
0
        //performs an aggregation search based on a single aggregation (can be used to remove aggregation as well
        public static void Perform_Aggregation_Search(string[] aggregationIds, Custom_Tracer Tracer)
        {
            //hooks (eventual expansion) 
            int HOOK_maxFIDCount = 8; 

            #region FIDs Support

            //get fids
            
            //old
            if (HttpContext.Current.Session["FIDKey"] == null)
                HttpContext.Current.Session["FIDKey"] = ""; //init
            string FIDKey = HttpContext.Current.Session["FIDKey"].ToString();
            List<string> FIDs = (List<string>)HttpContext.Current.Cache[FIDKey];
            List<string> temp_FIDs = new List<string>();
            foreach (string FID in FIDs)
            {
                //add the metadata name (converted to dbColumn name format)
                temp_FIDs.Add(FID.Replace(" ", "_"));
            }

            //make sure we have alll the FIDs, if not create blank holders
            if (HOOK_maxFIDCount > temp_FIDs.Count)
            {
                while (HOOK_maxFIDCount > temp_FIDs.Count)
                {
                    temp_FIDs.Add("");
                }
            }
            

            #endregion

            #region MSRKey Support

            int MSRKeyHashSpecial = 0;
            foreach (string aggregationId in aggregationIds)
            {
                byte[] tempAggChars = Encoding.ASCII.GetBytes(aggregationId);
                foreach (byte tempAggChar in tempAggChars)
                {
                    MSRKeyHashSpecial += Convert.ToInt32(tempAggChar);
                }
            }
            //finish processing msrkeyhash and store
            MSRKeyHashSpecial = Convert.ToInt32(MSRKeyHashSpecial * aggregationIds.Length);
            HttpContext.Current.Session["MapSearchResultsKey"] = "MapSearchResults_" + MSRKeyHashSpecial.ToString();
            
            #endregion

            #region search the database for all items in all of the provided aggregationPermissions and merge them into one datatable

            //define MSR support objects
            DataTable searchResults = new DataTable();
            DataTable displaySearchResults = new DataTable();
            
            //create MSR columns
            searchResults.Columns.Add("ItemID", typeof(string));
            searchResults.Columns.Add("Point_Latitude", typeof(string));
            searchResults.Columns.Add("Point_Longitude", typeof(string));
            searchResults.Columns.Add("Start_DateTime", typeof(string));
            searchResults.Columns.Add("End_DateTime", typeof(string));
            #region create MSR filter columns
            //get the db column name for each filter
            foreach (string filterName in FIDs)
            {
                searchResults.Columns.Add(filterName.Replace(" ", "_"), typeof(string));
            }

            //determine if we have used all 8 of the real filters, if not, create gap (8 + x where x= non fid column count to date)
            for (int i = searchResults.Columns.Count; i < (8 + 5); i++)
            {
                searchResults.Columns.Add("empty" + i.ToString(), typeof(string));
                //FIDs.Add("empty" + i.ToString());
                FIDs.Add("");
            }
            #endregion

            //create DSR columns
            displaySearchResults.Columns.Add("ItemID", typeof(string));
            displaySearchResults.Columns.Add("Point_Latitude", typeof(string));
            displaySearchResults.Columns.Add("Point_Longitude", typeof(string));
            
            //check to see if we already have msr in cache, else get a new msr
            string MSRKey = HttpContext.Current.Session["MapSearchResultsKey"].ToString();
            if (HttpContext.Current.Cache[MSRKey] == null)
            {
                #region Create New MSR
                
                //temp objects
                List<DataTable> temp_Tables = new List<DataTable>(); //change to dataset?
                DataTable temp_searchResults = new DataTable();

                //holds bounds calculator fields
                double swx = -1;
                double swy = -1;
                double nex = -1;
                double ney = -1;

                //search for all items in each collection (handles multiple aggregationPermissions)
                foreach (string aggregationId in aggregationIds)
                {
                    temp_Tables.Add(SobekCM_Database.Get_All_Items_By_AggregationID(aggregationId, temp_FIDs, Tracer));
                }

                //merge the tables if there are multiple aggregationPermissions
                foreach (DataTable temp_Table in temp_Tables)
                {
                    temp_searchResults.Merge(temp_Table);
                }

                //go through each item from search and it and its metadata to MSR
                foreach (DataRow searchResult in temp_searchResults.Rows)
                {
                    //define holders
                    string a = String.Empty;
                    string b = String.Empty;
                    string c = String.Empty;
                    string d = String.Empty;
                    string e = String.Empty;

                    //get itemID
                    if(searchResult["ItemID"]!=null)
                        a = searchResult["ItemID"].ToString();

                    //get lat/long
                    if (searchResult["MainLatitude"] != null)
                        b = searchResult["MainLatitude"].ToString();
                    if (searchResult["MainLongitude"] != null)
                        c = searchResult["MainLongitude"].ToString();

                    //fallback to spatial kml
                    if (string.IsNullOrEmpty(b))
                    {
                        string[] temp = searchResult["Spatial_KML"].ToString().Split('|');
                        //is this a point?
                        if (temp.Length == 2)
                        {
                            string[] temp2 = temp[1].Split(',');
                            b = temp2[0]; //lat
                            c = temp2[1]; //lng
                        }
                    }

                    //work with bounds calculator
                    if (!string.IsNullOrEmpty(b))
                    {
                        if ((Convert.ToDouble(b) < swx) || (swx == -1))
                            swx = Convert.ToDouble(b);
                        if ((Convert.ToDouble(b) > nex) || (swy == -1))
                            nex = Convert.ToDouble(b);
                        if ((Convert.ToDouble(c) < swy) || (nex == -1))
                            swy = Convert.ToDouble(c);
                        if ((Convert.ToDouble(c) > ney) || (ney == -1))
                            ney = Convert.ToDouble(c);
                    }

                    //handle start datetime
                    if (searchResult["PubDate"] != null)
                        d = searchResult["PubDate"].ToString();
                    else
                        if (searchResult["CreateDate"] != null)
                            d = searchResult["CreateDate"].ToString();

                    //handle end datetime
                    if (searchResult["PubDate"] != null)
                        e = searchResult["PubDate"].ToString();
                    else
                        if (searchResult["CreateDate"] != null)
                            e = searchResult["CreateDate"].ToString();

                    List<string> filterValues = new List<string>();
                    foreach (string filterName in FIDs)
                    {
                        //hande empty filter slots
                        //if (filterName.IndexOf("empty") != -1)
                        if (string.IsNullOrEmpty(filterName))
                            filterValues.Add("");
                        else
                            filterValues.Add(searchResult[filterName.Replace(" ", "_")].ToString());
                    }

                    //add to the DSR (id/lat/lng) only if lat/lng not null
                    if (!string.IsNullOrEmpty(b))
                        displaySearchResults.Rows.Add(a, b, c);

                    //add all to search results (with 8 fids)
                    searchResults.Rows.Add(a, b, c, d, e, filterValues[0], filterValues[1], filterValues[2], filterValues[3], filterValues[4], filterValues[5], filterValues[6], filterValues[7]);

                }

                //add to collection level params to search results
                searchResults.Rows.Add("swBounds", swx.ToString(), swy.ToString(), "", "", "", "", "", "", "", "", "", "");
                searchResults.Rows.Add("neBounds", nex.ToString(), ney.ToString(), "", "", "", "", "", "", "", "", "", "");

                //add to collection level params to display search results
                displaySearchResults.Rows.Add("swBounds", swx.ToString(), swy.ToString());
                displaySearchResults.Rows.Add("neBounds", nex.ToString(), ney.ToString());

                //assign and hold the current search result datatable, from now on we will be using this as the base layer..
                HttpContext.Current.Cache[MSRKey] = searchResults;
                HttpContext.Current.Cache[MSRKey + "_Created"] = DateTime.Now;

                #endregion
            }
            else
            {
                if (HttpContext.Current.Cache[MSRKey + "_Created"] != null)
                {
                    //determine if MSR is more than 30 mins old
                    if ((DateTime.Now.Subtract(Convert.ToDateTime(HttpContext.Current.Cache[MSRKey + "_Created"].ToString())).TotalMinutes) > 30)
                    {
                        #region Create new MSR

                        //temp objects
                        List<DataTable> temp_Tables = new List<DataTable>(); //change to dataset?
                        DataTable temp_searchResults = new DataTable();

                        //holds bounds calculator fields
                        double swx = -1;
                        double swy = -1;
                        double nex = -1;
                        double ney = -1;

                        //search for all items in each collection (handles multiple aggregationPermissions)
                        foreach (string aggregationId in aggregationIds)
                        {
                            temp_Tables.Add(SobekCM_Database.Get_All_Items_By_AggregationID(aggregationId, temp_FIDs, Tracer));
                        }

                        //merge the tables if there are multiple aggregationPermissions
                        foreach (DataTable temp_Table in temp_Tables)
                        {
                            temp_searchResults.Merge(temp_Table);
                        }

                        //go through each item from search and it and its metadata to MSR
                        foreach (DataRow searchResult in temp_searchResults.Rows)
                        {
                            //get itemID
                            string a = searchResult["ItemID"].ToString();

                            //get lat/long
                            string b = searchResult["MainLatitude"].ToString();
                            string c = searchResult["MainLongitude"].ToString();

                            //fallback to spatial kml
                            if (string.IsNullOrEmpty(b))
                            {
                                string[] temp = searchResult["Spatial_KML"].ToString().Split(',');
                                //is this a point?
                                if (temp.Length == 2)
                                {
                                    b = temp[0].Replace("P|", "").Replace("A|", "");
                                    c = temp[1];
                                }
                            }

                            //work with bounds calculator
                            if (!string.IsNullOrEmpty(b))
                            {
                                if ((Convert.ToDouble(b) < swx) || (swx == -1))
                                    swx = Convert.ToDouble(b);
                                if ((Convert.ToDouble(b) > nex) || (swy == -1))
                                    nex = Convert.ToDouble(b);
                                if ((Convert.ToDouble(c) < swy) || (nex == -1))
                                    swy = Convert.ToDouble(c);
                                if ((Convert.ToDouble(c) > ney) || (ney == -1))
                                    ney = Convert.ToDouble(c);
                            }

                            //handle date time
                            string d = searchResult["PubDate"].ToString();
                            if (string.IsNullOrEmpty(d))
                                d = searchResult["CreateDate"].ToString();
                            //d = Convert.ToDateTime(d);
                            string e = searchResult["PubDate"].ToString();
                            if (string.IsNullOrEmpty(e))
                                e = searchResult["CreateDate"].ToString();

                            List<string> filterValues = new List<string>();
                            foreach (string filterName in FIDs)
                            {
                                //hande empty filter slots
                                //if (filterName.IndexOf("empty") != -1)
                                if (string.IsNullOrEmpty(filterName))
                                    filterValues.Add("");
                                else
                                    filterValues.Add(searchResult[filterName.Replace(" ", "_")].ToString());
                            }

                            //add to the DSR (id/lat/lng) only if lat/lng not null
                            if (!string.IsNullOrEmpty(b))
                                displaySearchResults.Rows.Add(a, b, c);

                            //add all to search results (with 8 fids)
                            searchResults.Rows.Add(a, b, c, d, e, filterValues[0], filterValues[1], filterValues[2], filterValues[3], filterValues[4], filterValues[5], filterValues[6], filterValues[7]);

                        }

                        //add to collection level params to search results
                        searchResults.Rows.Add("swBounds", swx.ToString(), swy.ToString(), "", "", "", "", "", "", "", "", "", "");
                        searchResults.Rows.Add("neBounds", nex.ToString(), ney.ToString(), "", "", "", "", "", "", "", "", "", "");

                        //add to collection level params to display search results
                        displaySearchResults.Rows.Add("swBounds", swx.ToString(), swy.ToString());
                        displaySearchResults.Rows.Add("neBounds", nex.ToString(), ney.ToString());

                        //assign and hold the current search result datatable, from now on we will be using this as the base layer..
                        HttpContext.Current.Cache[MSRKey] = searchResults;
                        HttpContext.Current.Cache[MSRKey + "_Created"] = DateTime.Now;

                        #endregion
                    }
                    else
                    {
                        #region Use Existing MSR

                        //assign cached MSR to active MSR
                        searchResults = HttpContext.Current.Cache[MSRKey] as DataTable;

                        //add to the DSR
                        foreach (DataRow searchResult in searchResults.Rows)
                        {
                            //get itemID
                            string a = searchResult["ItemID"].ToString();

                            //get lat/long
                            string b = searchResult["Point_Latitude"].ToString();
                            string c = searchResult["Point_Longitude"].ToString();

                            //add to the DSR (id/lat/lng) only if lat/lng not null
                            if (!string.IsNullOrEmpty(b))
                                displaySearchResults.Rows.Add(a, b, c);
                        }

                        #endregion
                    }
                }
            }
            
            //call json writer with these results
            object DSR = Create_JSON_Search_Results_Object(displaySearchResults);

            //send json obj to page and tell page to read it (via callback results)
            HttpContext.Current.Items["DSR"] = DSR;

            #endregion

        }