public void AddOrUpdate(FederalUpperLimit ful, string ndc)
        {
            Guid ndcId, drugId;

            if (NdcToDrug.TryGetValue(ndc, out drugId) && NdcToPackage.TryGetValue(ndc, out ndcId))
            {
                ful.Id        = Guid.NewGuid();
                ful.PackageId = ndcId;
                ful.DrugId    = drugId;
                Fuls.Add(ful);
            }
        }
        public static async Task <int> Import(string baseDir, SiteConfig config)
        {
            string workDir = Path.Combine(baseDir, config.ShortName);

            Directory.CreateDirectory(workDir);

            //using (HttpClient httpClient = new HttpClient())
            //{
            //    HttpResponseMessage msg = await httpClient.GetAsync(new Uri(config.DownloadFiles[0]));
            //    using (StreamWriter sw = new StreamWriter(Path.Combine(workDir, "acaful.csv")))
            //    {
            //        await (msg.Content.CopyToAsync(sw.BaseStream));
            //        sw.Flush();
            //    }
            //}

            using (StreamReader sr = new StreamReader(Path.Combine(workDir, "acaful.csv")))
            {
                var csv = new CsvReader(sr);
                csv.Configuration.RegisterClassMap <AcaFulMap>();
                csv.Configuration.Delimiter = ",";
                var records = csv.GetRecords <AcaFulObject>();

                foreach (var rec in records)
                {
                    FederalUpperLimit ful = new FederalUpperLimit
                    {
                        AvgMfgPrice   = rec.WeightedAverageAmps,
                        Ful           = rec.AcaFedUpperLimit,
                        PackageSize   = rec.PackageSize,
                        ReportingDate = new DateTime(rec.Year, rec.Month, 1),
                        UnitType      = rec.MdrUnitType,
                        Ndc           = rec.Ndc
                    };

                    ImporterCache.Instance.AddOrUpdate(ful, rec.Ndc);
                }
            }

            return(0);
        }