public List <MealDetailDTO> GetMealsWithTagID(int tagID) { var list = (from m in db.MealOptions from t in m.MealTags join c in db.MealTagCategories on t.MealTagCategoriesID equals c.ID where c.ID == tagID select new { Name = m.Name, ID = m.ID, Calories = m.Calories }).ToList(); List <MealDetailDTO> dtoList = new List <MealDetailDTO>(); foreach (var item in list) { MealDetailDTO dto = new MealDetailDTO(); dto.Name = item.Name; dto.ID = item.ID; dto.Calories = item.Calories; dtoList.Add(dto); } return(dtoList); }
public NutrientDTO GetNutrient(int ID) { MealDetailDTO dto = new MealDetailDTO(); dto.Nutrient = dao.GetNutrient(ID); return(dto.Nutrient); }
public List <MealDetailDTO> GetMeals(string text) { var list = db.MealOptions.Where(x => x.Name.Contains(text)).ToList(); List <MealDetailDTO> dtoList = new List <MealDetailDTO>(); foreach (var item in list) { MealDetailDTO dto = new MealDetailDTO(); dto.ID = item.ID; dto.Name = item.Name; dto.Calories = item.Calories; dto.Image = item.Image; List <TagCategoryDetailDTO> tagDetailList = new List <TagCategoryDetailDTO>(); var tagList = db.MealTags.Where(x => x.MealOptionID == item.ID).ToList(); foreach (var tag in tagList) { TagCategoryDetailDTO tagDTO = new TagCategoryDetailDTO(); tagDTO.ID = tag.ID; tagDTO.Name = tag.MealTagCategory.Name; tagDetailList.Add(tagDTO); } dto.Tags = tagDetailList; dtoList.Add(dto); } return(dtoList); }
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(MealDetailDTO entity) { MealOption meal = new MealOption(); meal.Name = entity.Name; meal.Calories = entity.Calories; return(dao.Add(meal)); }
public void Update(MealDetailDTO entity) { MealOption meal = new MealOption(); meal.ID = entity.ID; meal.Name = entity.Name; meal.Calories = entity.Calories; dao.Update(meal); }
//采馨加的 public MealDetailDTO GetMeal(int ID) { MealDetailDTO theMeal = new MealDetailDTO(); MealOption mOpt = dao.GetMeal(ID); theMeal.ID = mOpt.ID; theMeal.Name = mOpt.Name; theMeal.Calories = (int)mOpt.Calories; theMeal.Image = mOpt.Image; return(theMeal); }
public List <MealDetailDTO> GetMeals() { var list = db.MealOptions.ToList(); List <MealDetailDTO> dtoList = new List <MealDetailDTO>(); foreach (var item in list) { NutrientBLL nutrientBLL = new NutrientBLL(); MealDetailDTO dto = new MealDetailDTO(); dto.ID = item.ID; dto.Name = item.Name; dto.Calories = Convert.ToInt32(item.Calories); dto.Image = item.Image; dto.Nutrient = nutrientBLL.GetNutrient(dto.ID); dto.NutrientID = dto.Nutrient.ID; dto.Fat = dto.Nutrient.Fat; dto.Protein = dto.Nutrient.Protein; dto.Carbs = dto.Nutrient.Carbs; dto.Sugar = dto.Nutrient.Sugar; dto.VitA = dto.Nutrient.VitA; dto.VitB = dto.Nutrient.VitB; dto.VitC = dto.Nutrient.VitC; dto.VitD = dto.Nutrient.VitD; dto.VitE = dto.Nutrient.VitE; dto.Na = dto.Nutrient.Na; dto.K = dto.Nutrient.K; List <TagCategoryDetailDTO> tagDetailList = new List <TagCategoryDetailDTO>(); var tagList = db.MealTags.Where(x => x.MealOptionID == item.ID).ToList(); foreach (var tag in tagList) { TagCategoryDetailDTO tagDTO = new TagCategoryDetailDTO(); tagDTO.ID = tag.ID; tagDTO.Name = tag.MealTagCategory.Name; tagDetailList.Add(tagDTO); } dto.Tags = tagDetailList; dtoList.Add(dto); } return(dtoList); }
private void listBoxMeals_SelectedIndexChanged(object sender, EventArgs e) { if (this.listBoxMeals.Items.Count == 0 || this.listBoxMeals.DataSource == null) { return; } theMeal = (sender as ListBox).SelectedItem as MealDetailDTO; this.LabelMealTitle.Text = theMeal.Name; //==================================== if (theMeal.Image != null) { byte[] bytes = theMeal.Image; System.IO.MemoryStream ms = new System.IO.MemoryStream(bytes); this.pBoxMeal.Image = Image.FromStream(ms); } else { this.pBoxMeal.Image = this.pBoxMeal.InitialImage; } //==================================== this.tBoxCal.Text = theMeal.Calories.ToString(); }