コード例 #1
0
        private SearchSummary ExecuteSearchCounts(OpenFdaApiEndPoints endPointType,
                                                  FdaFilterTypes filterType,
                                                  List <string> filterList,
                                                  int maxresultsize,
                                                  string state,
                                                  string cntField)
        {
            var apiUrl = string.Empty;
            var tmpRecallResultList = new List <ResultRecall>();

            var searchSummary = new SearchSummary()
            {
                Keyword = filterList[0],
                State   = state
            };
            var searchResults = "";

            //Limit first query to a 1 year window
            var beginDate = string.Format("{0:yyyyMMdd}", DateTime.Now.AddDays(1));
            var endDate   = string.Format("{0:yyyyMMdd}", DateTime.Now.AddYears(-1));

            _fda.ResetSearch();
            _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, new List <string>(new[]
            {
                state
            }), FilterCompairType.And);
            _fda.AddSearchFilter(endPointType, filterType, filterList, FilterCompairType.And);
            _fda.AddSearchFilter(endPointType, FdaFilterTypes.Date, new List <string>(new[]
            {
                beginDate,
                endDate
            }), FilterCompairType.And);

            _fda.AddCountField(string.Format("{0}.exact", cntField.ToLower()));
            apiUrl = _fda.BuildUrl(endPointType);

            searchResults = _fda.Execute(apiUrl);

            // If there was not data in the 1 yr window the get all results.
            // Check a 2 yr window for results.
            if (string.IsNullOrEmpty(searchResults))
            {
                endDate = string.Format("{0:yyyyMMdd}", DateTime.Now.AddYears(-2));

                _fda.ResetSearch();
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, new List <string>(new[]
                {
                    state
                }), FilterCompairType.And);
                _fda.AddSearchFilter(endPointType, filterType, filterList, FilterCompairType.And);
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.Date, new List <string>(new[]
                {
                    beginDate,
                    endDate
                }), FilterCompairType.And);

                _fda.AddCountField(string.Format("{0}.exact", cntField.ToLower()));
                apiUrl = _fda.BuildUrl(endPointType);

                searchResults = _fda.Execute(apiUrl);
            }

            // If there was not data in the 2 yr window the get all results.
            if (string.IsNullOrEmpty(searchResults))
            {
                _fda.ResetSearch();
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, new List <string>(new[]
                {
                    state
                }), FilterCompairType.And);
                _fda.AddSearchFilter(endPointType, filterType, filterList, FilterCompairType.And);

                _fda.AddCountField(string.Format("{0}.exact", cntField.ToLower()));
                apiUrl = _fda.BuildUrl(endPointType);

                searchResults = _fda.Execute(apiUrl);
            }

            if (!string.IsNullOrEmpty(searchResults))
            {
                var jo           = JObject.Parse(searchResults);
                var countResults = (JArray)(jo["results"]);

                var termCountFound = false;
                var termCount      = 0;

                foreach (var itm in countResults)
                {
                    termCount = (int)itm["count"];

                    var termClassification = (itm["term"]).ToString();

                    switch (termClassification)
                    {
                    case "Class I":

                        searchSummary.ClassICount = termCount;
                        termCountFound            = true;
                        break;

                    case "Class II":

                        searchSummary.ClassIICount = termCount;
                        termCountFound             = true;
                        break;

                    case "Class III":
                        searchSummary.ClassIIICount = termCount;
                        termCountFound = true;
                        break;
                    }
                }

                if (!termCountFound)
                {
                    searchSummary = null;
                }
            }

            return(searchSummary);
        }
コード例 #2
0
        private IEnumerable <ResultRecall> GetRecallInfo(string keyWord, string state)
        {
            _fda = new OpenFda(_restClient);

            OpenFdaApiHits = 0;

            var resultList   = new List <ResultRecall>();
            var endPointList = new List <OpenFdaApiEndPoints>(new[]
            {
                OpenFdaApiEndPoints.FoodRecall,
                OpenFdaApiEndPoints.DrugRecall,
                OpenFdaApiEndPoints.DeviceRecall
            });

            foreach (var endPointType in endPointList)
            {
                var filterList = new List <string>(new[]
                {
                    state
                });

                //Limit first query to a 1 year window
                var beginDate = string.Format("{0:yyyyMMdd}", DateTime.Now.AddDays(1));
                var endDate   = string.Format("{0:yyyyMMdd}", DateTime.Now.AddYears(-1));

                _fda.ResetSearch();
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, filterList, FilterCompairType.And);
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.RecallReason, new List <string>(new[]
                {
                    keyWord
                }), FilterCompairType.And);
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.Date, new List <string>(new[]
                {
                    beginDate,
                    endDate
                }), FilterCompairType.And);

                var apiUrl = _fda.BuildUrl(endPointType, MaxResultSetSize);

                var searchResults = _fda.Execute(apiUrl);
                OpenFdaApiHits++;

                var dataSetSize = _fda.GetMetaResults().
                                  Total;

                // If there was not data in the 1 yr window the get all results.
                // Check a 2 yr window for results.
                if (dataSetSize == 0)
                {
                    endDate = string.Format("{0:yyyyMMdd}", DateTime.Now.AddYears(-2));

                    _fda.ResetSearch();
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, filterList, FilterCompairType.And);
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.RecallReason, new List <string>(new[]
                    {
                        keyWord
                    }), FilterCompairType.And);
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.Date, new List <string>(new[]
                    {
                        beginDate,
                        endDate
                    }), FilterCompairType.And);

                    apiUrl = _fda.BuildUrl(endPointType, MaxResultSetSize);

                    searchResults = _fda.Execute(apiUrl);
                    OpenFdaApiHits++;

                    dataSetSize = _fda.GetMetaResults().
                                  Total;
                }

                // If there was not data in the 2 yr window the get all results.
                if (dataSetSize == 0)
                {
                    _fda.ResetSearch();
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, filterList, FilterCompairType.And);
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.RecallReason, new List <string>(new[]
                    {
                        keyWord
                    }), FilterCompairType.And);

                    apiUrl = _fda.BuildUrl(endPointType, MaxResultSetSize);

                    searchResults = _fda.Execute(apiUrl);
                    OpenFdaApiHits++;

                    dataSetSize = _fda.GetMetaResults().
                                  Total;
                }

                // if total records int the Search request exceeds the max of 100 records per request
                // then page through the data
                // LIMIT the number of page request to a MAX of 5
                var pageLimit = (int)(decimal.Ceiling((decimal)((double)dataSetSize / 100)));
                if (pageLimit > 5)
                {
                    pageLimit = 5;
                }

                var skipValue = 0;
                if (dataSetSize > 0)
                {
                    do
                    {
                        pageLimit--;

                        if (!string.IsNullOrEmpty(searchResults))
                        {
                            var result = ResultRecall.CnvJsonDataToList(searchResults);
                            resultList.AddRange(result);
                        }

                        if (pageLimit > 0)
                        {
                            skipValue += 100;
                            var newApiUrl = apiUrl.Replace("&limit=100", string.Format("&limit=100&skip={0}", skipValue));
                            searchResults = _fda.Execute(apiUrl);
                            OpenFdaApiHits++;
                        }
                    }while (!(pageLimit == 0));
                }
            }

            var sortedResultList = ((from el in resultList
                                     select el).OrderByDescending(el => el.Recall_Initiation_Date)).ToList();

            return(sortedResultList);

            //Return resultList
        }
コード例 #3
0
        private IEnumerable<ResultRecall> GetRecallInfo(string keyWord, string state)
        {
            _fda = new OpenFda(_restClient);

            OpenFdaApiHits = 0;

            var resultList = new List<ResultRecall>();
            var endPointList = new List<OpenFdaApiEndPoints>(new[]
                                                             {
                                                                 OpenFdaApiEndPoints.FoodRecall,
                                                                 OpenFdaApiEndPoints.DrugRecall,
                                                                 OpenFdaApiEndPoints.DeviceRecall
                                                             });

            foreach (var endPointType in endPointList)
            {
                var filterList = new List<string>(new[]
                                                  {
                                                      state
                                                  });

                //Limit first query to a 1 year window
                var beginDate = string.Format("{0:yyyyMMdd}", DateTime.Now.AddDays(1));
                var endDate = string.Format("{0:yyyyMMdd}", DateTime.Now.AddYears(-1));

                _fda.ResetSearch();
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, filterList, FilterCompairType.And);
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.RecallReason, new List<string>(new[]
                                                                                                 {
                                                                                                     keyWord
                                                                                                 }), FilterCompairType.And);
                _fda.AddSearchFilter(endPointType, FdaFilterTypes.Date, new List<string>(new[]
                                                                                         {
                                                                                             beginDate,
                                                                                             endDate
                                                                                         }), FilterCompairType.And);

                var apiUrl = _fda.BuildUrl(endPointType, MaxResultSetSize);

                var searchResults = _fda.Execute(apiUrl);
                OpenFdaApiHits++;

                var dataSetSize = _fda.GetMetaResults().
                                       Total;

                // If there was not data in the 1 yr window the get all results.
                // Check a 2 yr window for results.
                if (dataSetSize == 0)
                {
                    endDate = string.Format("{0:yyyyMMdd}", DateTime.Now.AddYears(-2));

                    _fda.ResetSearch();
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, filterList, FilterCompairType.And);
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.RecallReason, new List<string>(new[]
                                                                                                     {
                                                                                                         keyWord
                                                                                                     }), FilterCompairType.And);
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.Date, new List<string>(new[]
                                                                                             {
                                                                                                 beginDate,
                                                                                                 endDate
                                                                                             }), FilterCompairType.And);

                    apiUrl = _fda.BuildUrl(endPointType, MaxResultSetSize);

                    searchResults = _fda.Execute(apiUrl);
                    OpenFdaApiHits++;

                    dataSetSize = _fda.GetMetaResults().
                                       Total;
                }

                // If there was not data in the 2 yr window the get all results.
                if (dataSetSize == 0)
                {
                    _fda.ResetSearch();
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.Region, filterList, FilterCompairType.And);
                    _fda.AddSearchFilter(endPointType, FdaFilterTypes.RecallReason, new List<string>(new[]
                                                                                                     {
                                                                                                         keyWord
                                                                                                     }), FilterCompairType.And);

                    apiUrl = _fda.BuildUrl(endPointType, MaxResultSetSize);

                    searchResults = _fda.Execute(apiUrl);
                    OpenFdaApiHits++;

                    dataSetSize = _fda.GetMetaResults().
                                       Total;
                }

                // if total records int the Search request exceeds the max of 100 records per request
                // then page through the data
                // LIMIT the number of page request to a MAX of 5
                var pageLimit = (int) (decimal.Ceiling((decimal) ((double) dataSetSize/100)));
                if (pageLimit > 5)
                {
                    pageLimit = 5;
                }

                var skipValue = 0;
                if (dataSetSize > 0)
                {
                    do
                    {
                        pageLimit--;

                        if (!string.IsNullOrEmpty(searchResults))
                        {
                            var result = ResultRecall.CnvJsonDataToList(searchResults);
                            resultList.AddRange(result);
                        }

                        if (pageLimit > 0)
                        {
                            skipValue += 100;
                            var newApiUrl = apiUrl.Replace("&limit=100", string.Format("&limit=100&skip={0}", skipValue));
                            searchResults = _fda.Execute(apiUrl);
                            OpenFdaApiHits++;
                        }
                    }
                    while (!(pageLimit == 0));
                }
            }

            var sortedResultList = ((from el in resultList
                                     select el).OrderByDescending(el => el.Recall_Initiation_Date)).ToList();

            return sortedResultList;

            //Return resultList
        }