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