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 Add(TagCategoryDetailDTO entity)
{
MealTagCategory tag = new MealTagCategory();
tag.Name = entity.Name;
dao.Add(tag);
}
public void Update(TagCategoryDetailDTO entity)
{
MealTagCategory tag = new MealTagCategory();
tag.Name = entity.Name;
tag.ID = entity.ID;
dao.Update(tag);
}
public List <TagCategoryDetailDTO> GetTags(string text)
{
var list = db.MealTagCategories.Where(x => x.Name.Contains(text)).ToList();
List <TagCategoryDetailDTO> dtoList = new List <TagCategoryDetailDTO>();
foreach (var item in list)
{
TagCategoryDetailDTO dto = new TagCategoryDetailDTO();
dto.ID = item.ID;
dto.Name = item.Name;
dtoList.Add(dto);
}
return(dtoList);
}
public List <TagCategoryDetailDTO> GetTags()
{
var list = db.MealTagCategories.ToList();
List <TagCategoryDetailDTO> dtoList = new List <TagCategoryDetailDTO>();
foreach (var item in list)
{
TagCategoryDetailDTO dto = new TagCategoryDetailDTO();
dto.ID = item.ID;
dto.Name = item.Name;
dtoList.Add(dto);
}
return(dtoList);
}
public List <TagCategoryDetailDTO> GetTagsWithMealID(int ID)
{
var list = db.MealTags.Where(x => x.MealOptionID == ID);
List <TagCategoryDetailDTO> dtoList = new List <TagCategoryDetailDTO>();
foreach (var item in list)
{
TagCategoryDetailDTO dto = new TagCategoryDetailDTO();
dto.ID = item.MealTagCategoriesID;
dto.Name = item.MealTagCategory.Name;
dtoList.Add(dto);
}
return(dtoList);
}
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 btnAdd_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("請輸入欲新增標籤名稱");
}
else if (bll.IsTagExist(textBox1.Text))
{
MessageBox.Show("該標籤已經存在");
}
else
{
TagCategoryDetailDTO detail = new TagCategoryDetailDTO();
detail.Name = textBox1.Text;
bll.Add(detail);
MessageBox.Show("已新增標籤");
RefreshPage();
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtName.Text == "" || txtCalories.Text == "")
{
MessageBox.Show("請輸入所有欄位");
}
else
{
byte[] bytes;
System.IO.MemoryStream ms = new System.IO.MemoryStream();
this.pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
bytes = ms.GetBuffer();
detail.Image = bytes;
detail.Name = txtName.Text;
detail.Calories = Convert.ToInt32(txtCalories.Text);
ndto.Fat = float.Parse(txtFat.Text);
ndto.Protein = float.Parse(txtProtein.Text);
ndto.Carbs = float.Parse(txtCarbs.Text);
ndto.Sugar = float.Parse(txtSugar.Text);
ndto.VitA = float.Parse(txtVitA.Text);
ndto.VitB = float.Parse(txtVitB.Text);
ndto.VitC = float.Parse(txtVitC.Text);
ndto.VitD = float.Parse(txtVitD.Text);
ndto.VitE = float.Parse(txtVitE.Text);
ndto.Na = float.Parse(txtNa.Text);
ndto.K = float.Parse(txtK.Text);
if (IsUpdate)
{
int mealID = detail.ID;
for (int i = 0; i < clbTag.Items.Count; i++)
{
TagCategoryDetailDTO dto = clbTag.Items[i] as TagCategoryDetailDTO;
int categoryID = dto.ID;
if (clbTag.GetItemChecked(i)) // Checked.
{
if (!bll.HasTag(mealID, categoryID)) // Had not been checked.
{
bll.AddTag(mealID, categoryID); // Check it!
}
}
else // Not checked.
{
if (bll.HasTag(mealID, categoryID)) // But it WAS checked.
{
bll.RemoveTag(mealID, categoryID); // Uncheck it.
}
}
}
//detail.Tags = bll.GetTagsWithMealID(mealID);
bll.Update(detail);
MessageBox.Show("已更新餐點資訊");
this.Close();
}
else
{
if (bll.IsMealExist(detail.Name))
{
MessageBox.Show("餐點名稱已存在");
}
else
{
detail.NutrientID = nbll.Add(ndto);
detail.Image = bytes;
detail.Fat = ndto.Fat;
detail.Protein = ndto.Protein;
detail.Sugar = ndto.Sugar;
detail.Carbs = ndto.Carbs;
detail.VitA = ndto.VitA;
detail.VitB = ndto.VitB;
detail.VitC = ndto.VitC;
detail.VitD = ndto.VitD;
detail.VitE = ndto.VitE;
detail.Na = ndto.Na;
detail.K = ndto.K;
int mealID = bll.Add(detail);
for (int i = 0; i < clbTag.Items.Count; i++)
{
TagCategoryDetailDTO dto = clbTag.Items[i] as TagCategoryDetailDTO;
int categoryID = dto.ID;
if (clbTag.GetItemChecked(i)) // Checked.
{
if (!bll.HasTag(mealID, categoryID)) // Had not been checked.
{
bll.AddTag(mealID, categoryID); // Check it!
}
}
}
MessageBox.Show("已新增餐點");
this.Close();
}
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtName.Text == "" || txtCalories.Text == "")
{
MessageBox.Show("請輸入所有欄位");
}
else
{
detail.Name = txtName.Text;
detail.Calories = Convert.ToInt32(txtCalories.Text);
if (IsUpdate)
{
int mealID = detail.ID;
for (int i = 0; i < clbTag.Items.Count; i++)
{
TagCategoryDetailDTO dto = clbTag.Items[i] as TagCategoryDetailDTO;
int categoryID = dto.ID;
if (clbTag.GetItemChecked(i)) // Checked.
{
if (!bll.HasTag(mealID, categoryID)) // Had not been checked.
{
bll.AddTag(mealID, categoryID); // Check it!
}
}
else // Not checked.
{
if (bll.HasTag(mealID, categoryID)) // But it WAS checked.
{
bll.RemoveTag(mealID, categoryID); // Uncheck it.
}
}
}
//detail.Tags = bll.GetTagsWithMealID(mealID);
bll.Update(detail);
MessageBox.Show("已更新餐點資訊");
this.Close();
}
else
{
if (bll.IsMealExist(detail.Name))
{
MessageBox.Show("餐點名稱已存在");
}
else
{
int mealID = bll.Add(detail);
for (int i = 0; i < clbTag.Items.Count; i++)
{
TagCategoryDetailDTO dto = clbTag.Items[i] as TagCategoryDetailDTO;
int categoryID = dto.ID;
if (clbTag.GetItemChecked(i)) // Checked.
{
if (!bll.HasTag(mealID, categoryID)) // Had not been checked.
{
bll.AddTag(mealID, categoryID); // Check it!
}
}
}
MessageBox.Show("已新增餐點");
this.Close();
}
}
}
}
