public void NutDataToNutritionDataTest_ShouldConvertAllProperties()
{
//arrange
NUT_DATA NutData1 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "203",
Nutr_Val = 101,
Num_Data_Pts = 1,
Std_Error = 1,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 1,
Min = 101,
Max = 201,
DF = 1,
Low_EB = 1,
Up_EB = 1,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
NUT_DATA NutData2 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "205",
Nutr_Val = 102,
Num_Data_Pts = 2,
Std_Error = 2,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 2,
Min = 102,
Max = 202,
DF = 2,
Low_EB = 2,
Up_EB = 2,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
NUT_DATA NutData3 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "210",
Nutr_Val = 103,
Num_Data_Pts = 3,
Std_Error = 3,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 3,
Min = 103,
Max = 203,
DF = 3,
Low_EB = 3,
Up_EB = 3,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
//act
//usda_nutritionEntities context = new usda_nutritionEntities();
//var food_groups = context.FD_GROUP.ToList();
//var weigts = context.WEIGHT.ToList();
USDAImport usdaImport = new USDAImport();
NutritionData nut1 = usdaImport.NutDataToNutritionData(NutData1);
NutritionData nut2 = usdaImport.NutDataToNutritionData(NutData2);
NutritionData nut3 = usdaImport.NutDataToNutritionData(NutData3);
//assert
Assert.IsNotNull(nut1);
Assert.IsNotNull(nut2);
Assert.IsNotNull(nut3);
Assert.IsNotNull(nut1);
Assert.AreEqual(nut1.Nutr_No, int.Parse(NutData1.Nutr_No));
Assert.AreEqual(nut1.Std_Error, (double)NutData1.Std_Error);
Assert.AreEqual(nut1.Min, (double)NutData1.Min);
Assert.AreEqual(nut1.Max, (double)NutData1.Max);
Assert.AreEqual(nut1.DF, (double)NutData1.DF);
Assert.AreEqual(nut1.Low_EB, (double)NutData1.Low_EB);
Assert.AreEqual(nut1.Up_EB, (double)NutData1.Up_EB);
Assert.AreEqual(nut1.AddMod_Date, DateTime.Parse(NutData1.AddMod_Date));
}
public void FoodDesToIngredientTest_ShouldConvertFOOD_DES_objectToIngreadientObjectWithAllParameters()
{
//arrange
USDADataImport.FOOD_DES food1 = new USDADataImport.FOOD_DES
{
NDB_No = "1",
FdGrp_Cd = "0100", //Dairy and Egg Products
Long_Desc = "Long_Desc",
Shrt_Desc = "Shrt_Desc",
ComName = "ComName",
ManufacName = "ManufacName",
Ref_Desc = "Ref_Desc",
Refuse = 0,
SciName = "SciName",
N_Factor = 0,
Pro_Factor = 0,
Fat_Factor = 0,
CHO_Factor = 0,
NUT_DATA = new List<NUT_DATA>(),
WEIGHT = new List<WEIGHT>(),
LANGDESC = new List<LANGDESC>()
};
NUT_DATA NutData1 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "203",
Nutr_Val = 101,
Num_Data_Pts = 1,
Std_Error = 1,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 1,
Min = 101,
Max = 201,
DF = 1,
Low_EB = 1,
Up_EB = 1,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
NUT_DATA NutData2 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "205",
Nutr_Val = 102,
Num_Data_Pts = 2,
Std_Error = 2,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 2,
Min = 102,
Max = 202,
DF = 2,
Low_EB = 2,
Up_EB = 2,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
NUT_DATA NutData3 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "210",
Nutr_Val = 103,
Num_Data_Pts = 3,
Std_Error = 3,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 3,
Min = 103,
Max = 203,
DF = 3,
Low_EB = 3,
Up_EB = 3,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
food1.NUT_DATA.Add(NutData1);
food1.NUT_DATA.Add(NutData2);
food1.NUT_DATA.Add(NutData3);
WEIGHT weight1 = new WEIGHT
{
NDB_No = "1",
Seq = "1",
Amount = 1,
Msre_Desc = "stick",
Gm_Wgt = 21
};
WEIGHT weight2 = new WEIGHT
{
NDB_No = "1",
Seq = "2",
Amount = 2,
Msre_Desc = "serving 5 sticks",
Gm_Wgt = 107
};
food1.WEIGHT.Add(weight1);
food1.WEIGHT.Add(weight2);
List<FD_GROUP> food_groups = new List<FD_GROUP>();
food_groups.Add(new FD_GROUP { FdGrp_CD = "0100", FdGrp_Desc = "Dairy and Egg Products" });
food_groups.Add(new FD_GROUP { FdGrp_CD = "0200", FdGrp_Desc = "Spices and Herbs" });
food_groups.Add(new FD_GROUP { FdGrp_CD = "0300", FdGrp_Desc = "Baby Foods" });
//act
USDAImport usdaImport = new USDAImport();
Ingredient ingredient = usdaImport.FoodDesToIngredient(food1, food_groups);
//assert
Assert.IsNotNull(ingredient);
Assert.IsNotNull(ingredient.NutritionFacts);
Assert.IsNotNull(ingredient.NutritionFacts.FullNutrisionList);
Assert.AreEqual(ingredient.NutritionFacts.FullNutrisionList.Count, 3);
Assert.IsNotNull(ingredient.Weigts);
Assert.AreEqual(ingredient.Weigts.Count, 2);
Assert.AreEqual((int)ingredient.FoodGrp, 0100);
}
public void NutDataListToNutritionFactsTest_ShouldReseiveListOfNut_DATA_AndConvertToNutritionFactsObject()
{
//arrange
NUT_DATA NutData1 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "203",
Nutr_Val = 101,
Num_Data_Pts = 1,
Std_Error = 1,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 1,
Min = 101,
Max = 201,
DF = 1,
Low_EB = 1,
Up_EB = 1,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
NUT_DATA NutData2 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "205",
Nutr_Val = 102,
Num_Data_Pts = 2,
Std_Error = 2,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 2,
Min = 102,
Max = 202,
DF = 2,
Low_EB = 2,
Up_EB = 2,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
NUT_DATA NutData3 = new NUT_DATA
{
NDB_No = "1",
Nutr_No = "210",
Nutr_Val = 103,
Num_Data_Pts = 3,
Std_Error = 3,
Src_Cd = "Src_Cd",
Deriv_Cd = "Deriv_Cd",
Ref_NDB_No = "Ref_NDB_No",
Add_Nutr_Mark = "Add_Nutr_Mark",
Num_Studies = 3,
Min = 103,
Max = 203,
DF = 3,
Low_EB = 3,
Up_EB = 3,
Stat_Cmt = "Stat_Cmt",
AddMod_Date = "12/2013",
};
List<NUT_DATA> nutList = new List<NUT_DATA>() { NutData1, NutData2, NutData3 };
//act
USDAImport usdaImport = new USDAImport();
NutritionFacts nutFacts = usdaImport.NutDataListToNutritionFacts(nutList);
//assert
Assert.IsNotNull(nutFacts);
Assert.AreEqual(nutFacts.FullNutrisionList.Count, 3);
Assert.AreEqual(nutFacts.Protein, 101);
Assert.AreEqual(nutFacts.TotalCarbohydrate, 102);
Assert.IsNotNull(nutFacts.FullNutrisionList.Exists(c => c.Nutr_No == 210));
}
public NutritionData NutDataToNutritionData(NUT_DATA nutData)
{
log.InfoFormat("[NutDataToNutritionData] NUT_DATA.Nutr_No={0}, NUT_DATA.NDB_No={1}, NUT_DATA.Nutr_Val{2}.", nutData.Nutr_No, nutData.NDB_No, nutData.Nutr_Val);
try
{
Spontaneous.DataModel.Foods.NutritionData tempNutData = new Spontaneous.DataModel.Foods.NutritionData()
{
Nutr_No = int.Parse(nutData.Nutr_No),
Nutr_Val = double.Parse(nutData.Nutr_Val.ToString()),
};
if (nutData.Std_Error != null && nutData.Std_Error.HasValue) tempNutData.Std_Error = nutData.Std_Error.Value;
if (nutData.Min != null && nutData.Min.HasValue) tempNutData.Min = nutData.Min.Value;
if (nutData.Max != null && nutData.Max.HasValue) tempNutData.Max = nutData.Max.Value;
if (nutData.DF != null && nutData.DF.HasValue) tempNutData.DF = nutData.DF.Value;
if (nutData.Low_EB != null && nutData.Low_EB.HasValue) tempNutData.Low_EB = nutData.Low_EB.Value;
if (nutData.Up_EB != null && nutData.Up_EB.HasValue) tempNutData.Up_EB = nutData.Up_EB.Value;
if (nutData.AddMod_Date != null) tempNutData.AddMod_Date = DateTime.Parse(nutData.AddMod_Date);
NutritionType nutType = GetNutritionTypeByNo(tempNutData.Nutr_No);
if (nutType != null) tempNutData.Type = nutType;
return tempNutData;
}
catch(Exception e)
{
log.ErrorFormat("[NutDataToNutritionData] Exception={0}", e);
return null;
}
}
