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