private object DfsMarkerData(MapSearch map) { List <IMapIndexData> dfs = iDfsService.GetDfsData(); List <DfsData> vals = CollectionHelpers.CollectionHelper <DfsData> .GetProperList(dfs); string cql = ""; var hasFilters = Infrastructure.FilterChecker.FilterChecker.HasFilters(map); //checklistDfsData = vals; List <IMapIndexData> maWoutCompanies = new List <IMapIndexData>(); SideFilterOptions sideFilters = new SideFilterOptions(); List <string> autoComplete = new List <string>(); if (map.Plays.Count > 0 || map.Regions.Count > 0 || map.Companies.Count > 0 || map.Entities.Count > 0 || !string.IsNullOrEmpty(map.TimeRange) || !string.IsNullOrEmpty(map.Keyword)) { List <IMapIndexData> filteredList = iDfsService.GetFilteredData(dfs, map); vals = CollectionHelpers.CollectionHelper <DfsData> .GetProperList(filteredList); List <DfsData> withoutCompaniesSet = CollectionHelpers.CollectionHelper <DfsData> .GetProperList(dfs); if (!string.IsNullOrEmpty(map.Keyword) || map.Companies.Count > 0) { maWoutCompanies = iDfsService.GetDataBeforeCompanies(withoutCompaniesSet, map); } else { maWoutCompanies = iDfsService.GetDataBeforeCompanies(vals, map); } sideFilters = iDfsService.GetSideFiltersDfs(maWoutCompanies, map); dfs = filteredList; autoComplete = iDfsService.GetKeywordAutoComplete(dfs, map); } else { sideFilters = iDfsService.GetSideFiltersDfs(dfs, map); autoComplete = iDfsService.GetKeywordAutoComplete(dfs, map); } List <DfsData> dfsResult = CollectionHelpers.CollectionHelper <DfsData> .GetProperList(dfs); if (hasFilters && !string.IsNullOrEmpty(map.Keyword)) { cql = iDfsService.GeoserverCqlFilter(dfs); } else if (hasFilters) { cql = GeoserverHelpers.GeoserverCqlFilter.CreateDFSCql(dfsResult, map); } #region MyRegion //if (map.ListingIds.Count > 0) //{ // checklistDfsData = vals2.Where(s => map.ListingIds.Contains(s.id)).ToList(); //} //else //{ // checklistDfsData = vals2; //} #endregion string companiesHtml = ""; string cacheKey = ConfigurationFactory.Instance.Configuration().CacheKeyCompanyHtml + "_" + map.WhichDb; if (map.Plays.Count > 0) { cacheKey += "_" + "PLAYS" + string.Join(",", map.Plays); } if (map.Regions.Count > 0) { cacheKey += "_" + "REGIONS" + string.Join(",", map.Regions); } if (map.Entities.Count > 0) { cacheKey += "_" + "DEALTYPES" + string.Join(",", map.Entities); } if (!string.IsNullOrEmpty(map.TimeRange)) { cacheKey += "_" + "TIMERANGE" + map.TimeRange; } if (!string.IsNullOrEmpty(map.Keyword)) { cacheKey += "_" + "KEYWORD" + map.Keyword; } string cacheKeyTable = "DFSLISTTABLE"; if (map.Plays.Count > 0) { cacheKeyTable += "_" + "PLAYS" + string.Join(",", map.Plays); } if (map.Regions.Count > 0) { cacheKeyTable += "_" + "REGIONS" + string.Join(",", map.Regions); } if (map.Companies.Count > 0) { cacheKeyTable += "_" + "COMPANIES" + string.Join(",", map.Companies); } if (map.Entities.Count > 0) { cacheKeyTable += "_" + "DEALTYPES" + string.Join(",", map.Entities); } if (!string.IsNullOrEmpty(map.TimeRange)) { cacheKeyTable += "_" + "TIMERANGE" + map.TimeRange; } if (!string.IsNullOrEmpty(map.Keyword)) { cacheKeyTable += "_" + "KEYWORD" + map.Keyword; } companiesHtml = iMaDataGeoService.GenerateCompanyHtml(sideFilters.Companies, cacheKey, ConfigurationFactory.Instance.Configuration().CacheKeyPortfolioCompaniesPath, map); Infrastructure.ExportHelpers.IExportData export = iDfsExport.GetChecklistTable(dfsResult.ToList <Infrastructure.ExportHelpers.IExportData>(), map); Models.ExportData.ExportDataSet exportSet = ((Models.ExportData.ExportDataSet)export); var result = new { Result = iLeafService.GetMarkerData(new List <MaData>(), dfsResult, new List <Models.EP.ViewModel.EpViewModel>(), map, "", false), SideFilters = sideFilters, CqlFilter = cql, CheckSideListData = exportSet.ExportSet, TableData = dfsResult, ExportTableSet = exportSet.ExportSet, ExportHeaders = exportSet.ExportHeaders, CompanyHtml = companiesHtml, AutoCompleteSource = autoComplete, TableSource = iDfsViewService.GenerateDataSetHtml(dfsResult, cacheKeyTable, "~/Views/Templates/DfsTableList.cshtml", map) }; return(result); }
private object MaMarkerData(MapSearch map) { List <IMapIndexData> ma = iService.GetMaData(); List <MaData> vals = CollectionHelpers.CollectionHelper <MaData> .GetProperList(ma); var hasFilters = Infrastructure.FilterChecker.FilterChecker.HasFilters(map); List <IMapIndexData> maWoutCompanies = new List <IMapIndexData>(); SideFilterOptions sideFilters = new SideFilterOptions(); List <string> autoComplete = new List <string>(); if (map.Plays.Count > 0 || map.Regions.Count > 0 || map.Companies.Count > 0 || map.Entities.Count > 0 || !string.IsNullOrEmpty(map.TimeRange) || !string.IsNullOrEmpty(map.Keyword)) { List <IMapIndexData> filteredList = iService.GetFilteredData(ma, map); vals = CollectionHelpers.CollectionHelper <MaData> .GetProperList(filteredList); List <MaData> withoutCompaniesSet = CollectionHelpers.CollectionHelper <MaData> .GetProperList(ma); if (!string.IsNullOrEmpty(map.Keyword) || map.Companies.Count > 0) { maWoutCompanies = iService.GetDataBeforeCompanies(withoutCompaniesSet, map); } else { maWoutCompanies = iService.GetDataBeforeCompanies(vals, map); } sideFilters = iService.GetSideFiltersMa(maWoutCompanies, map); //ma = iService.GetFilteredData(maWoutCompanies, map); ma = filteredList; autoComplete = iService.GetKeywordAutoComplete(ma, map); } else { sideFilters = iService.GetSideFiltersMa(ma, map); autoComplete = iService.GetKeywordAutoComplete(ma, map); } List <MaData> maResult = CollectionHelpers.CollectionHelper <MaData> .GetProperList(ma); ChartingData.IChartOutput charts = iMaChart.GetChartOutput(maResult, map); Models.Charting.ChartOptions chartOptions = ((Models.Charting.ChartOptions)charts); string companiesHtml = ""; if ((map.ReloadCompanies || map.InitialLoad)) { string cacheKey = ConfigurationFactory.Instance.Configuration().CacheKeyCompanyHtml + "_" + map.WhichDb; if (map.Plays.Count > 0) { cacheKey += "_" + "PLAYS" + string.Join(",", map.Plays); } if (map.Regions.Count > 0) { cacheKey += "_" + "REGIONS" + string.Join(",", map.Regions); } if (map.Entities.Count > 0) { cacheKey += "_" + "DEALTYPES" + string.Join(",", map.Entities); } if (!string.IsNullOrEmpty(map.TimeRange)) { cacheKey += "_" + "TIMERANGE" + map.TimeRange; } if (!string.IsNullOrEmpty(map.Keyword)) { cacheKey += "_" + "KEYWORD" + map.Keyword; } companiesHtml = iMaDataGeoService.GenerateCompanyHtml(sideFilters.Companies, cacheKey, ConfigurationFactory.Instance.Configuration().CacheKeyPortfolioCompaniesPath, map); } #region MyRegion //if (map.MaDealIds.Count > 0) //{ // checkListMaData = checkListMaData.Where(s => map.MaDealIds.Contains(s.id)).ToList(); //} //else //{ // checkListMaData = vals2; //} #endregion if (map.Companies.Count > 0) { } Infrastructure.ExportHelpers.IExportData export = iExport.GetChecklistTable(maResult.ToList <Infrastructure.ExportHelpers.IExportData>(), map); Models.ExportData.ExportDataSet exportSet = ((Models.ExportData.ExportDataSet)export); #region MyRegion //List<MaExport> exportSetzz = new List<MaExport>(); //foreach (var item in checkListMaData) //{ // macheckList.MaTable.Add(new MaCheckListTable(new List<string> { "Legend", "Announced", "Buyers", "Sellers", "Link", "GeoId" }, new List<string> { item.HexColor, item.Date_Announced.Value.ToString("MM-dd-yy"), item.Buyers, item.Sellers, item.id, item.theId }, new List<string> { "checkbox", "date", "text", "text", "link", "primarykey" })); // exportSet.Add(new MaExport(item.id, item.Buyers, item.Sellers, item.Date_Announced, item.Value___MM_, item.__Acre, item.__Daily_BOE, item.Hydrocarbon, item.Headline, item.US_Region, item.US_Play, item.Lat, item.Long, item.DealType)); //} //List<string> exportHeaders = new List<string>(); //exportHeaders.Add("Record ID"); //exportHeaders.Add("Buyers"); //exportHeaders.Add("Sellers"); //exportHeaders.Add("Date Announced"); //exportHeaders.Add("Value ($MM)"); //exportHeaders.Add("$/Acre"); //exportHeaders.Add("$/Daily_BOE"); //exportHeaders.Add("Hydrocarbon"); //exportHeaders.Add("Headline"); //exportHeaders.Add("US Region"); //exportHeaders.Add("US Play"); //exportHeaders.Add("Lat"); //exportHeaders.Add("Long"); //exportHeaders.Add("Deal Type"); #endregion string cql = ""; if (hasFilters && !string.IsNullOrEmpty(map.Keyword)) { cql = iService.GeoserverCqlFilter(ma); } else if (hasFilters) { cql = GeoserverHelpers.GeoserverCqlFilter.CreateMACql(maResult, map); } string cacheKeyTable = "MALISTTABLE"; if (map.Plays.Count > 0) { cacheKeyTable += "_" + "PLAYS" + string.Join(",", map.Plays); } if (map.Regions.Count > 0) { cacheKeyTable += "_" + "REGIONS" + string.Join(",", map.Regions); } if (map.Companies.Count > 0) { cacheKeyTable += "_" + "COMPANIES" + string.Join(",", map.Companies); } if (map.Entities.Count > 0) { cacheKeyTable += "_" + "DEALTYPES" + string.Join(",", map.Entities); } if (!string.IsNullOrEmpty(map.TimeRange)) { cacheKeyTable += "_" + "TIMERANGE" + map.TimeRange; } if (!string.IsNullOrEmpty(map.Keyword)) { cacheKeyTable += "_" + "KEYWORD" + map.Keyword; } var result = new { Result = iLeafService.GetMarkerData(maResult, new List <DfsData>(), new List <Models.EP.ViewModel.EpViewModel>(), map, "", false), SideFilters = sideFilters, //PortData = "", CheckSideListData = exportSet.ExportSet, TableData = maResult, CqlFilter = cql, ExportTableSet = exportSet.ExportSet, ExportHeaders = exportSet.ExportHeaders, ChartSeries = "", ChartX = chartOptions.ChartXCategories, ChartDataSeries = chartOptions.ChartSeries, CompanyHtml = companiesHtml, AutoCompleteSource = autoComplete, TableSource = iMaViewService.GenerateDataSetHtml(maResult, cacheKeyTable, "~/Views/Templates/MaTableList.cshtml", map) //DfsTableData = "" }; return(result); }
private object PortfolioMarkerData(MapSearch map) { List <IMapIndexData> port = iPortfolioService.GetData(); List <Data.IMapIndexData> ep = iEpService.GetData(); List <EpViewModel> epResults = CollectionHelpers.CollectionHelper <EpViewModel> .GetProperList(ep); List <PortfolioData> vals = CollectionHelpers.CollectionHelper <PortfolioData> .GetProperList(port); var hasFilters = Infrastructure.FilterChecker.FilterChecker.HasFilters(map); //if (hasFilters) //{ // port = iPortfolioService.GetFilteredData(port, map); //} // port list before company List <IMapIndexData> maWoutCompanies = new List <IMapIndexData>(); SideFilterOptions sideFilters = new SideFilterOptions(); List <string> autoComplete = new List <string>(); if (map.Plays.Count > 0 || map.Regions.Count > 0 || map.Entities.Count > 0 || !string.IsNullOrEmpty(map.Keyword) || map.Companies.Count > 0) { List <IMapIndexData> filteredList = iPortfolioService.GetFilteredData(port, map); vals = CollectionHelpers.CollectionHelper <PortfolioData> .GetProperList(filteredList); List <PortfolioData> withoutCompaniesSet = CollectionHelpers.CollectionHelper <PortfolioData> .GetProperList(port); if (!string.IsNullOrEmpty(map.Keyword) || map.Companies.Count > 0) { maWoutCompanies = iPortfolioService.GetDataBeforeCompanies(withoutCompaniesSet, map); } else { maWoutCompanies = iPortfolioService.GetDataBeforeCompanies(vals, map); } sideFilters = iPortfolioService.GetSideFilters(maWoutCompanies, map); if (map.Regions.Count > 0) { epResults = epResults.Where(s => s.RegionId != null).Where(s => map.Regions.Contains(s.RegionId)).ToList(); } port = filteredList; autoComplete = iPortfolioService.GetKeywordAutoComplete(port, map); } else { sideFilters = iPortfolioService.GetSideFilters(port, map); autoComplete = iPortfolioService.GetKeywordAutoComplete(port, map); } List <PortfolioData> portResult = CollectionHelpers.CollectionHelper <PortfolioData> .GetProperList(port); //portResult = portResult.OrderBy(s => s.CompanyName).ToList(); string companiesHtml = ""; //if ((map.ReloadCompanies || map.InitialLoad)) //{ // string cacheKey = ConfigurationFactory.Instance.Configuration().CacheKeyCompanyHtml + "_" + "PORTFOLIO"; // if (map.Plays.Count > 0) // { // cacheKey += "_" + "PLAYS" + string.Join(",", map.Plays); // } // if (map.Regions.Count > 0) // { // cacheKey += "_" + "REGIONS" + string.Join(",", map.Regions); // } // if (!string.IsNullOrEmpty(map.TimeRange)) // { // cacheKey += "_" + "TIMERANGE" + map.TimeRange; // } // if (!string.IsNullOrEmpty(map.Keyword)) // { // cacheKey += "_" + "KEYWORD" + map.Keyword; // } // companiesHtml = iMaDataGeoService.GenerateCompanyHtml(sideFilters.Companies, cacheKey, ConfigurationFactory.Instance.Configuration().CacheKeyPortfolioCompaniesPath); //} string cacheKey = ConfigurationFactory.Instance.Configuration().CacheKeyCompanyHtml + "_" + map.WhichDb; if (map.Plays.Count > 0) { cacheKey += "_" + "PLAYS" + string.Join(",", map.Plays); } if (map.Regions.Count > 0) { cacheKey += "_" + "REGIONS" + string.Join(",", map.Regions); } if (!string.IsNullOrEmpty(map.TimeRange)) { cacheKey += "_" + "TIMERANGE" + map.TimeRange; } if (!string.IsNullOrEmpty(map.Keyword)) { cacheKey += "_" + "KEYWORD" + map.Keyword; } companiesHtml = iMaDataGeoService.GenerateCompanyHtml(sideFilters.Companies, cacheKey, ConfigurationFactory.Instance.Configuration().CacheKeyPortfolioCompaniesPath, map); Infrastructure.ExportHelpers.IExportData export = iPortExport.GetChecklistTable(portResult.ToList <Infrastructure.ExportHelpers.IExportData>(), map); Models.ExportData.ExportDataSet exportSet = ((Models.ExportData.ExportDataSet)export); string cacheKeyTable = "PORTLISTTABLE"; if (map.Plays.Count > 0) { cacheKeyTable += "_" + "PLAYS" + string.Join(",", map.Plays); } if (map.Regions.Count > 0) { cacheKeyTable += "_" + "REGIONS" + string.Join(",", map.Regions); } if (map.Companies.Count > 0) { cacheKeyTable += "_" + "COMPANIES" + string.Join(",", map.Companies); } if (map.Entities.Count > 0) { cacheKeyTable += "_" + "DEALTYPES" + string.Join(",", map.Entities); } if (!string.IsNullOrEmpty(map.TimeRange)) { cacheKeyTable += "_" + "TIMERANGE" + map.TimeRange; } if (!string.IsNullOrEmpty(map.Keyword)) { cacheKeyTable += "_" + "KEYWORD" + map.Keyword; } string cql = GeoserverHelpers.GeoserverCqlFilter.CreatePortfolioCql(portResult, map); PortfolioData p = new PortfolioData(); string popup = ""; if (map.Companies.Count > 0) { try { p = portResult.Where(s => map.Companies.Last() == s.CompanyId).FirstOrDefault(); popup = GeoserverHelpers.GeoserverPopupHelper.GeneratePopupPortfolio(p); } catch (Exception ex) { } } if (p == null) { p = new PortfolioData(); p.Latitude = ""; p.Longitude = ""; } if (popup == null) { popup = ""; } var result = new { Result = iLeafService.GetMarkerData(new List <MaData>(), new List <DfsData>(), epResults.Take(500).ToList(), map, System.DateTime.Now.Date.ToString(), false), SideFilters = sideFilters, //PortData = "", CheckSideListData = exportSet.ExportSet, TableData = portResult, CqlFilter = cql, ExportTableSet = exportSet.ExportSet, ExportHeaders = exportSet.ExportHeaders, Popup = popup, Lat = p.Latitude, Long = p.Longitude, CompanyHtml = companiesHtml, AutoCompleteSource = autoComplete, TableSource = iPortViewService.GenerateDataSetHtml(portResult, cacheKeyTable, "~/Views/Templates/PortfolioTableList.cshtml", map) //DfsTableData = "" }; return(result); }