public void SaveNutritionsTable()
{
log.InfoFormat("[SaveNutritionsTable]");
using (Restaurants restaurantsDb = new Restaurants())
{
MongoEntityRepositoryBase<NutritionType> basicData =
new MongoEntityRepositoryBase<NutritionType>(restaurantsDb.DB);
using (usda_nutritionEntities context = new usda_nutritionEntities())
{
var nutrtition = context.NUTR_DEF.ToList();
List<NutritionType> nutList = new List<NutritionType>();
foreach (var item in nutrtition)
{
log.InfoFormat("[SaveNutritionsTable] Loop: Nutr_No={0}, NutrDesc={1}.", item.Nutr_No, item.NutrDesc);
Spontaneous.DataModel.Foods.NutritionType tempNutrition = new Spontaneous.DataModel.Foods.NutritionType()
{
USDA_Nutr_No = int.Parse(item.Nutr_No),
Units = item.Units,
Tagname = item.Tagname != null ? item.Tagname : "",
NutrDesc = item.NutrDesc,
Num_Dec = item.Num_Dec
//SR_Order = int.Parse(item.SR_Order.ToString()),
};
nutList.Add(tempNutrition);
basicData.Add(tempNutrition);
}
Console.Write("After NutritionType copy loop.\n");
}
}
}
public void SaveFoodTable()
{
log.InfoFormat("[SaveFoodTable].");
try
{
using (Restaurants restaurantsDb = new Restaurants())
{
MongoEntityRepositoryBase<Ingredient> basicData =
new MongoEntityRepositoryBase<Ingredient>(restaurantsDb.DB);
using (usda_nutritionEntities context = new usda_nutritionEntities())
{
var food_groups = context.FD_GROUP.ToList();
var weigts = context.WEIGHT.ToList();
var foods = context.FOOD_DES.ToList();
foreach (var item in foods)
{
Spontaneous.DataModel.Ingredient ingredient = FoodDesToIngredient(item, food_groups);
if(ingredient != null) basicData.Add(ingredient);
}
Console.Write("After Food copy loop.\n");
}
}
}
catch (Exception e)
{
log.ErrorFormat("[SaveFoodTable] Exception={0}.", e);
}
}