public NutrientDTO GetNutrient(int ID)
{
MealOption meal = db.MealOptions.First(x => x.ID == ID);
NutrientDTO dto = new NutrientDTO();
int nutrientID = (int)meal.NutrientID;
Nutrient nutrient = db.Nutrients.First(x => x.ID == nutrientID);
dto.ID = nutrient.ID;
//把資料庫資料匯入清單
dto.Fat = (float)nutrient.Fat;
dto.Protein = (float)nutrient.Protein;
dto.Carbs = (float)nutrient.Carbs;
dto.Sugar = (float)nutrient.Sugar;
dto.VitA = (float)nutrient.VitA;
dto.VitB = (float)nutrient.VitB;
dto.VitC = (float)nutrient.VitC;
dto.VitD = (float)nutrient.VitD;
dto.VitE = (float)nutrient.VitE;
dto.Na = (float)nutrient.Na;
dto.K = (float)nutrient.Potassium;
return(dto);
}
public void ShowNutrient()
{
NutrientDTO Nutdto = new NutrientDTO();
MealDTO dto = new MealDTO();
MealDetailDTO MDdto = new MealDetailDTO();
//dto = mbll.GetMeals();
if (isSearch)
{
dto = mbll.GetMeals(keyword);
}
else
{
dto = mbll.GetMeals();
}
dataGridView1.DataSource = dto.Meals;
dataGridView1.Columns["ID"].HeaderText = "餐點編號";
dataGridView1.Columns["Name"].HeaderText = "食物名稱";
dataGridView1.Columns["Calories"].HeaderText = "卡路里";
dataGridView1.Columns["Nutrient"].Visible = false;
dataGridView1.Columns["Image"].Visible = false;
dataGridView1.Columns["NutrientID"].HeaderText = "營養編號";
dataGridView1.Columns["Fat"].HeaderText = "脂肪";
dataGridView1.Columns["Protein"].HeaderText = "蛋白質";
dataGridView1.Columns["Carbs"].HeaderText = "碳水化合物";
dataGridView1.Columns["Sugar"].HeaderText = "醣";
dataGridView1.Columns["VitA"].HeaderText = "維生素A";
dataGridView1.Columns["VitB"].HeaderText = "維生素B";
dataGridView1.Columns["VitC"].HeaderText = "維生素C";
dataGridView1.Columns["VitD"].HeaderText = "維生素D";
dataGridView1.Columns["VitE"].HeaderText = "維生素E";
dataGridView1.Columns["Na"].HeaderText = "鈉";
dataGridView1.Columns["K"].HeaderText = "鉀";
}
public int Add(NutrientDTO entity)
{
Nutrient nutrient = new Nutrient();
nutrient.Fat = entity.Fat;
nutrient.Protein = entity.Protein;
nutrient.Carbs = entity.Carbs;
nutrient.Sugar = entity.Sugar;
nutrient.VitA = entity.VitA;
nutrient.VitB = entity.VitB;
nutrient.VitC = entity.VitC;
nutrient.VitD = entity.VitD;
nutrient.VitE = entity.VitE;
nutrient.Na = entity.Na;
nutrient.Potassium = entity.K;
return(dao.Add(nutrient));
}
//public NutrientDTO GetNutrientLastID()
//{
// NutrientDTO dto = new NutrientDTO();
// return dto.ID.ToString().Last();
//}
public void Update(NutrientDTO entity)
{
NutrientDAO dao = new NutrientDAO();
Nutrient nutrient = new Nutrient();
nutrient.ID = entity.ID;
nutrient.Fat = entity.Fat;
nutrient.Protein = entity.Protein;
nutrient.Carbs = entity.Carbs;
nutrient.Sugar = entity.Sugar;
nutrient.VitA = entity.VitA;
nutrient.VitB = entity.VitB;
nutrient.VitC = entity.VitC;
nutrient.VitD = entity.VitD;
nutrient.VitE = entity.VitE;
nutrient.Na = entity.Na;
nutrient.Potassium = entity.K;
dao.Update(nutrient);
}
