Exemplo n.º 1
0
        public async Task GetGeoReport(bool isAjax, string keyword, DateTime? start, DateTime? end)
		{
            this.SetFilters(isAjax, keyword, String.Empty, start, end);

			/*
			 * Note:  the OpenFDA API has a bug/limitation that it will not support a count on distribution_pattern.exact 
			 * which would return complete distribution_pattern strings and allow more accurate parsing.  Just counting
			 * distribution_pattern splits on individual words, so there is no reliable way to distinguish between e.g.
			 * IN for Indiana and the preposition "in". It will also fail to count two-word state names such as "South
			 * Dakota" because the words wil be split. Due to the time constraints on this prototype, this view model 
			 * will accept this limitation of the API and return demonstrative but inaccurate results.
			 * 
			 */

			// create state count list with all states and zero counts
			int cnt = 0;
			this.data = new List<StateCount> ();
			foreach (KeyValuePair<string, string> kvp in StateNames.stateNames) 
			{
				cnt++;
				StateCount stateCount = new StateCount (cnt, kvp.Key, kvp.Value);
				this.data.Add (stateCount);
			}

			OpenFDAQuery query = new OpenFDAQuery ();
			query.source = OpenFDAQuery.FDAReportSource.food;
			query.type = OpenFDAQuery.FDAReportType.enforcement;
			query.queryCount = "distribution_pattern";

			var searchQuery = new List<string>();

			if (!string.IsNullOrWhiteSpace (keyword))
				searchQuery.Add ( HttpUtility.UrlEncode(keyword));
			
			if (start != null && end != null)
				searchQuery.Add (string.Format ("recall_initiation_date:[{0:yyyyMMdd}+TO+{1:yyyyMMdd}]", start.Value, end.Value));

			if (searchQuery.Count > 0)
				query.querySearch = string.Join ("+AND+", searchQuery);

			bool success = await query.RunQueryAsync();

			if (!success)
				this.ErrorMsg = "An error occurred executing the query.  Please try again.";
			else 
            {
				this.ErrorMsg = String.Empty;

				foreach (OpenFDAResult result in query.response.results) 
                {
					var statecount = this.data.Where (s => s.StateAbbr.ToLower().Equals (result.term) || s.StateName.ToLower().Equals (result.term)).FirstOrDefault ();
					if (statecount != null)
					{
						int c = 0;
						Int32.TryParse(result.count, out c);
						statecount.Count += c;
					}
				}
			}
		}
Exemplo n.º 2
0
 public async Task GetReportDetails(string id, string eventid)
 {
     OpenFDAQuery query = new OpenFDAQuery ();
     query.source = OpenFDAQuery.FDAReportSource.food;
     query.type = OpenFDAQuery.FDAReportType.enforcement;
     query.querySearch = String.Format("event_id:{0}", HttpUtility.HtmlEncode(eventid));
     query.queryLimit = 100;
     bool result = await query.RunQueryAsync();
     if (result) {
         this.Result = query.response.results.Where (r => r.id.Equals(id)).FirstOrDefault ();
     }
 }
Exemplo n.º 3
0
        public async Task GetFinancialReport(bool isAjax, string keyword, string state)
        {
            this.data = new List<RecallCount>();
            this.SetFilters(isAjax, keyword, state, null, null);
            this.ErrorMsg = String.Empty;

            int loopStart = 2008;
            int loopEnd = DateTime.Today.Year;
            for (int yr = loopStart; yr <= loopEnd; yr++)
            {
                OpenFDAQuery query = new OpenFDAQuery();
                query.source = OpenFDAQuery.FDAReportSource.food;
                query.type = OpenFDAQuery.FDAReportType.enforcement;

                var searchQuery = new List<string>();

                if (!String.IsNullOrWhiteSpace(keyword))
                    searchQuery.Add(HttpUtility.UrlEncode(keyword));

                if (!String.IsNullOrWhiteSpace(state))
                    searchQuery.Add(String.Format("state:{0}", HttpUtility.UrlEncode(state)));

                searchQuery.Add(String.Format("recall_initiation_date:[{0}0101+TO+{1}0101]", yr, yr + 1));

                if (searchQuery.Count > 0)
                    query.querySearch = string.Join("+AND+", searchQuery);

                bool success = await query.RunQueryAsync();

                int cnt = 0;
                if (success && (query.response != null))
                    cnt = query.response.meta.results.total;

                this.data.Add(new RecallCount(yr, cnt));
            }
        }
Exemplo n.º 4
0
        public async Task GetFinancialReport(bool isAjax, string keyword, string state, DateTime? start, DateTime? end)
		{
			this.data = new List<CompanyCount> ();
            this.SetFilters(isAjax, keyword, state, start, end);

			OpenFDAQuery query = new OpenFDAQuery ();
			query.source = OpenFDAQuery.FDAReportSource.food;
			query.type = OpenFDAQuery.FDAReportType.enforcement;
			query.queryCount = "recalling_firm.exact";

            var searchQuery = new List<string>();

            if (!String.IsNullOrWhiteSpace (keyword))
                searchQuery.Add ( HttpUtility.UrlEncode(keyword));

            if (!String.IsNullOrWhiteSpace(state))
                searchQuery.Add(String.Format("state:{0}", HttpUtility.UrlEncode(state)));

            if ((start != null) && (end != null))
                searchQuery.Add (String.Format ("recall_initiation_date:[{0:yyyyMMdd}+TO+{1:yyyyMMdd}]", start.Value, end.Value));
            else 
                searchQuery.Add (String.Format ("recall_initiation_date:[20080101+TO+{0}0101]", DateTime.Today.Year+1));
			
            if (searchQuery.Count > 0)
                query.querySearch = string.Join ("+AND+", searchQuery);

            bool success = await query.RunQueryAsync();

			if (!success)
				this.ErrorMsg = "An error occurred executing the query.  Please try again.";
			else 
            {
				this.ErrorMsg = String.Empty;

				// build top company list
                int resultLimit = 0;
                foreach (OpenFDAResult result in query.response.results)
                {

                    string name = result.term;

                    /*
					 * TODO:  FDA API contains a known issue which does not permit string text search queries 
                     * containing single-quote whether or not it is URL-encoded properly.  For demonstration 
                     * purposes, names with single-quote/apostrophes will be excluded from the top-ten list.
                     * Actual fix for this issue may involve making broader queries and string matching to find 
                     * the desired company within the result set.
					 * 
					 */
                    if (!name.Contains("'"))
                    {
                        resultLimit++;
                        if (resultLimit > 10)
                            break;

                        this.data.Add(new CompanyCount(name, 0));
                    }
                }

                // build company counts per year
                int loopStart = 2008;
                int loopEnd = DateTime.Today.Year;
                if ((start != null) && (end != null))
                {
                    loopStart = ((DateTime)start).Year;
                    loopEnd = ((DateTime)end).Year;
                }

                bool yearHasHadData = false;
                for (int yr = loopStart; yr <= loopEnd; yr++)
                {
                    bool yearHasData = false;
                    OpenFDAQuery subquery = new OpenFDAQuery();
                    subquery.source = OpenFDAQuery.FDAReportSource.food;
                    subquery.type = OpenFDAQuery.FDAReportType.enforcement;
                    subquery.queryCount = "recalling_firm.exact";
                    subquery.querySearch = String.Format("recall_initiation_date:[{0}0101+TO+{1}0101]", yr, yr + 1);
                    subquery.queryLimit = 1000;
                    success = await subquery.RunQueryAsync();

                    foreach (CompanyCount company in this.data)
                    {
                        int cnt = 0;
                        if ((success) && (subquery.response != null) && (subquery.response.results.Count > 0))
                        {
                            var result = subquery.response.results.Where(r => r.term.Equals(company.Name)).FirstOrDefault();
                            if (result != null)
                            {
                                cnt = result.countNumeric;
                                yearHasData = true;
                                yearHasHadData = true;
                            }
                        }
                        company.YearlyCounts.Add(yr.ToString(), cnt);
                    }

                    if (!yearHasData && !yearHasHadData)
                    {
                        // remove year from all company dictionaries if year (and no previous year) contains data
                        foreach (CompanyCount company in this.data)
                        {
                            company.YearlyCounts.Remove(yr.ToString());
                        }
                    }
                }

            }
		}
Exemplo n.º 5
0
		public async void QueryTest()
		{

			OpenFDAQuery query = new OpenFDAQuery ();
			query.baseUrl = "https://api.fda.gov";
			query.apiKey = "iECPoOgnA6LVBZ5X3PHyx5Slpj1smHE6u4FuzlHl";
			query.source = OpenFDAQuery.FDAReportSource.food;
			query.type = OpenFDAQuery.FDAReportType.enforcement;
			bool result = await query.RunQueryAsync();

			Assert.IsTrue (result);

            /*
             * Note: mocked request TestWebRequest does not support async calls
			// test against a mock WebRequest
			WebRequest.RegisterPrefix ("test", new TestWebRequestCreate ());
			TestWebRequest request = TestWebRequestCreate.CreateTestRequest (json_response);

			OpenFDAQuery query = new OpenFDAQuery ();
			query.baseUrl = "test://testUrl";
			query.apiKey = "iECPoOgnA6LVBZ5X3PHyx5Slpj1smHE6u4FuzlHl";
			query.source = OpenFDAQuery.FDAReportSource.food;
			query.type = OpenFDAQuery.FDAReportType.enforcement;
			bool result = await query.RunQueryAsync();

			Assert.IsTrue (result);
			Assert.AreEqual ("F-0924-2013", query.response.results [1].recall_number);
			Assert.AreEqual ("US", query.response.results [0].country);
            */
		}