//飲料編輯的ViewModel public static DrinkDetails GetEditDrinkDetail_UseSizePID(int SizePID) { NewDrinkDB db = new NewDrinkDB(); SizeTable query = db.SizeTables.Find(SizePID); //取出飲料種類.名稱 MenuDrink drinkNameT = db.MenuDrinks.Find(query.DrinkID); //分別取出尺寸,甜度,冰度,加料 var size = ManagerModels.mySize(query.MenuID); var sweet = ManagerModels.AllreadyMySweet(SizePID); var ice = ManagerModels.AllreadyMyIce(SizePID); var additem = ManagerModels.AllreadyMyAddItem(SizePID); DrinkDetails result = new DrinkDetails() { ID = SizePID, DrinkType = drinkNameT.DrinkType, DrinkName = drinkNameT.DrinkName, DrinkPrice = query.Price, SizeType = size, SizeTypeM = query.SizeID.ToString(), Sweet = sweet, IceHot = ice, AddItem = additem }; db.Dispose(); return(result); }
//取出已勾選的飲料冰度的ViewModel(checkbox) public static IList <SelectListItem> AllreadyMyIce(int SizePID) { NewDrinkDB db = new NewDrinkDB(); SizeTable Sizequery = db.SizeTables.Find(SizePID); //先從店家冰度表取IceID var query = db.MenuIces.Where(m => m.MenuID == Sizequery.MenuID); //查看勾選了哪些項目 var iceTable = db.IceTables.Where(m => m.SizePID == SizePID); var result = new List <SelectListItem>(); foreach (var item in query) { //從iceTable將已勾選的項目勾選 var query2 = db.IceTypes.Find(item.IceID); bool AreCheck = false; foreach (var checkIce in iceTable) { if (checkIce.IceID == item.IceID) { AreCheck = true; } } if (AreCheck) { result.Add( new SelectListItem { Text = item.IceName, Value = item.IceID.ToString(), Selected = true } ); } else { result.Add( new SelectListItem { Text = query2.IceName, Value = item.IceID.ToString(), Selected = false } ); } } db.Dispose(); return(result); }
//取出已勾選的飲料加料價的ViewModel(checkbox) public static IList <SelectListItem> AllreadyMyAddItem(int SizePID) { NewDrinkDB db = new NewDrinkDB(); SizeTable Sizequery = db.SizeTables.Find(SizePID); //先從店家加料價表取AdditemID var query = db.AddItemTypePrices.Where(m => m.MenuID == Sizequery.MenuID); //查看勾選了哪些項目 var additemTable = db.AddItemTables.Where(m => m.SizePID == SizePID); var result = new List <SelectListItem>(); foreach (var item in query) { //從additemTable將已勾選的項目勾選 string Size = ""; if (item.SizeNumber == 0) { Size = "大"; } if (item.SizeNumber == 1) { Size = "中"; } if (item.SizeNumber == 2) { Size = "小"; } var query2 = db.AddItemTypes.Find(item.ItemID); bool AreCheck = false; foreach (var checkadd in additemTable) { if (checkadd.ItemIDPriceID == item.ID) { AreCheck = true; } } if (AreCheck) { result.Add( new SelectListItem { Text = query2.ItemName + "(" + Size + ") $" + item.ItemPrice, Value = item.ID.ToString(), Selected = true } ); } else { result.Add( new SelectListItem { Text = query2.ItemName + "(" + Size + ") $" + item.ItemPrice, Value = item.ID.ToString(), Selected = false } ); } } db.Dispose(); return(result); }