public static void SeedAutocomplete(IZippyDatabase context)
{
if (!context.Autocomplete.Any())
{
RestClient client = new RestClient("http://rxnav.nlm.nih.gov/REST");
var result = client.Get(new RestRequest("displaynames.json"));
var rxData = JsonConvert.DeserializeObject <RxNormData>(result.Content);
HashSet <string> terms = new HashSet <string>();
foreach (var term in rxData.displayTermsList.term)
{
// Only use the first alphabetic word in each list
var oneWord = Regex.Match(term, @"^[a-zA-Z][^\s\,]*");
if (oneWord.Success)
{
var normalizedTerm = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(oneWord.Value.ToLower());
if (normalizedTerm.Length <= 80 && !terms.Contains(normalizedTerm))
{
context.Add(new Autocomplete()
{
Term = normalizedTerm
});
terms.Add(normalizedTerm);
}
}
}
context.Commit();
}
}
/// <summary>
/// Constructs an instance of TermController with a database context instance
/// </summary>
/// <param name="dbContext">Database context instance</param>
public TermController(IZippyDatabase dbContext)
{
this.dbContext = dbContext;
}
/// <summary>
/// Constructs an instance of MedicationController with a database context instance
/// </summary>
/// <param name="dbContext">Database context instance</param>
public MedicationController(IZippyDatabase dbContext)
{
this.dbContext = dbContext;
}
/// <summary>
/// Constructs an instance of MedicationController with a database context instance
/// </summary>
/// <param name="dbContext">Database context instance</param>
public MedicationController(IZippyDatabase dbContext)
{
this.dbContext = dbContext;
}
/// <summary>
/// Constructs an instance of CabinetController with a database context instance
/// </summary>
/// <param name="dbContext">Database context instance</param>
public CabinetController(IZippyDatabase dbContext)
{
this.dbContext = dbContext;
}
public HomeController(IZippyDatabase dbContext)
{
this.dbContext = dbContext;
}
/// <summary>
/// Constructs an instance of CabinetController with a database context instance
/// </summary>
/// <param name="dbContext">Database context instance</param>
public CabinetController(IZippyDatabase dbContext)
{
this.dbContext = dbContext;
}
