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; } }