//飲料編輯的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);
}
