public void AddOrUpdate(StateDrugUtilization sdu, string ndc)
{
Guid ndcId, drugId;
if (NdcToDrug.TryGetValue(ndc, out drugId) && NdcToPackage.TryGetValue(ndc, out ndcId))
{
sdu.PackageId = ndcId;
sdu.DrugId = drugId;
sdu.Id = Guid.NewGuid();
SDUs.Enqueue(sdu);
}
}
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, "sdu.csv")))
// {
// await (msg.Content.CopyToAsync(sw.BaseStream));
// sw.Flush();
// }
//}
using (StreamReader sr = new StreamReader(Path.Combine(workDir, "sdu.csv")))
{
var csv = new CsvReader(sr);
csv.Configuration.RegisterClassMap <SduMap>();
csv.Configuration.Delimiter = ",";
var records = csv.GetRecords <SduObject>();
foreach (var rec in records)
{
StateDrugUtilization sdu = new StateDrugUtilization
{
UtilizationType = rec.UtilizationType,
State = rec.State,
ReportDate = YearQtrToEndDate(Convert.ToInt32(rec.Year), Convert.ToInt32(rec.Quarter)),
SuppressionUsed = rec.SuppressionUsed,
UnitsReimbursed = rec.UnitsReimbursed,
NumberOfScripts = rec.NumberOfScripts,
TotalAmountReimbursed = rec.TotalAmountReimbursed,
MedicaidAmountReimbursed = rec.MedicaidAmountReimbursed,
NonMedicaidAmountReimbursed = rec.NonMedicaidAmountReimbursed,
Latitude = rec.Latitude,
Longitude = rec.Longitude
};
string ndc = $"{rec.NdcPart1.PadLeft(5, '0')}-{rec.NdcPart2.PadLeft(4, '0')}-{rec.NdcPart3.PadLeft(2, '0')}";
ImporterCache.Instance.AddOrUpdate(sdu, ndc);
}
}
return(0);
}
