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