public async Task <NutritionFact> AddNutritionFact(NutritionFact nutritionFact)
{
await _context.NutritionFacts.AddAsync(nutritionFact);
await _context.SaveChangesAsync();
return(nutritionFact);
}
private void UpdateIngredientNutritionalInformation(UpdateObject update, ref UpdateResults results)
{
// need to get the xmlimportitem
var xmlimport = GetXmlIngredientByGuid(update.xmlingredientguid.ToString());
if (xmlimport == null)
{
throw new ApplicationException("XmlImportIngredient not found");
}
//need to blow out the previous facts
GetDataBase().Execute(" update NutritionFacts set active = 0 where ingredientid =@0", update.ingredientid);
//translate field to nutrition type
foreach (var facttype in GetDataBase().Fetch <NutritionFactType>(" select * from NutritionFactTypes"))
{
try
{
var fact = GetNutritionFact(update.ingredientid, facttype.nutritionfacttypeid);
if (fact == null)
{
fact = new NutritionFact();
fact.ingredientid = update.ingredientid;
fact.nutritionfacttypeid = facttype.nutritionfacttypeid;
fact.ServiceObjectId = new Guid();
fact.DataObjectId = new Guid();
}
fact.active = true;
fact.value = GetFactValueFromImport(xmlimport, facttype.nutritionfacttypeid);
if (fact.IsNew())
{
fact.Insert();
}
else
{
fact.Update();
}
results.NutrionalFactsUpdates++;
}
catch (Exception e)
{
results.Errors.Add("NutrionalFact:" + facttype.name + " for Ingredient:" + update.ingredientid, e.Message);
}
}
}
private void UpdateIngredientNutritionalInformation(UpdateObject update, ref UpdateResults results)
{
// need to get the xmlimportitem
var xmlimport = GetXmlIngredientByGuid(update.xmlingredientguid.ToString());
if ( xmlimport == null)
throw new ApplicationException("XmlImportIngredient not found");
//need to blow out the previous facts
GetDataBase().Execute(" update NutritionFacts set active = 0 where ingredientid =@0", update.ingredientid);
//translate field to nutrition type
foreach (var facttype in GetDataBase().Fetch<NutritionFactType>(" select * from NutritionFactTypes"))
{
try
{
var fact = GetNutritionFact(update.ingredientid, facttype.nutritionfacttypeid);
if (fact == null)
{
fact = new NutritionFact();
fact.ingredientid = update.ingredientid;
fact.nutritionfacttypeid = facttype.nutritionfacttypeid;
fact.ServiceObjectId = new Guid();
fact.DataObjectId = new Guid();
}
fact.active = true;
fact.value = GetFactValueFromImport(xmlimport, facttype.nutritionfacttypeid);
if (fact.IsNew())
fact.Insert();
else
fact.Update();
results.NutrionalFactsUpdates++;
}
catch (Exception e)
{
results.Errors.Add("NutrionalFact:" + facttype.name + " for Ingredient:" + update.ingredientid, e.Message);
}
}
}