// GET: MenuDetails/Create
public ActionResult Create()
{
//ViewBag.FoodId = new SelectList(db.Foods, "Id", "Name");
ViewBag.MenuId = new SelectList(db.Menus, "Id", "Name");
var model = new MenuDetailViewModel();
model.FoodItems = GetMenuDetail(1);
return(View(model));
}
private IEnumerable <MenuDetail> GetToSave(MenuDetailViewModel model)
{
var foodToSave = model.FoodItems.Where(s => s.Selected == true);
return(foodToSave.Select(s => new MenuDetail()
{
FoodId = s.Id,
MenuId = model.MenuId
}));
}
public MenuDetailViewModel GetMenuDetailViewModel(int menuID)
{
var model = new MenuDetailViewModel();
var menu = Get(menuID);
model.Menu = menu;
model.MenuID = menu.Id;
model.Functions = GetFunctionAccessibilities(menuID);
return(model);
}
/// <summary>儲存選單資料</summary>
public static bool SaveMenuInfo(MenuDetailViewModel m)
{
string action = "";
//有無選單編號，若無則視為新增
if (string.IsNullOrEmpty(m.MenuNo))
{
action = "Add";
//判斷是否為空值
m.ParentMenuNo = string.IsNullOrWhiteSpace(m.ParentMenuNo) ? "" : m.ParentMenuNo;
//設定新選單編號
string strMaxMenuNo = MenuDataAccess.GetMaxMenuNo(m.ParentMenuNo, m.ParentMenuNo.Length + 2);
m.MenuNo = Util.GetPadLeftString(strMaxMenuNo, 1);
}
//開啟資料庫存取物件
using (var db = new DataBase.DataBase(Definition.Conn))
{
//資料庫參數
var param = new DataBase.SqlParams();
param.Add("MenuNo", m.MenuNo);
param.Add("MenuName", m.MenuName);
param.Add("MenuLink", m.MenuLink);
param.Add("Type", m.Type);
param.Add("MenuDesc", m.MenuDesc);
param.Add("OrderID", m.OrderID);
param.Add("Enabled", m.Enabled);
param.Add("MenuIco", m.MenuIco);
db.SqlParams = param;
if (action == "Add")
{
//新增資料
db.StrSQL = @"--設定排序值--
SET @OrderID = (SELECT MAX(OrderID) + 1 FROM Menu WHERE LEN(MenuNo) = LEN(@MenuNo));
INSERT Menu(MenuNo, MenuName, MenuLink, Type, MenuDesc, OrderID, Enabled, MenuIco) VALUES(@MenuNo, @MenuName, @MenuLink, @Type, @MenuDesc, @OrderID, @Enabled, @MenuIco)";
}
else
{
db.StrSQL = "UPDATE Menu SET MenuName=@MenuName, MenuLink=@MenuLink, Type=@Type, MenuDesc=@MenuDesc, OrderID=@OrderID, Enabled=@Enabled, MenuIco=@MenuIco WHERE MenuNo=@MenuNo";
}
int iResult = db.ExecuteSQL();
return(iResult > 0);
}
}
public JsonResult Save(MenuDetailViewModel m)
{
Result r = new Result();
try
{
MenuDataAccess.SaveMenuInfo(m);
r.Set(ResultCode.Success, "作業成功");
}
catch (Exception e)
{
r.Set(ResultCode.Error, e.Message);
}
return(Json(r, JsonRequestBehavior.AllowGet));
}
public ActionResult Add(string id = "")
{
try
{
//初始化物件
var m = new MenuDetailViewModel();
m.ParentMenuNo = id;
m.Type = "";
m.Enabled = true;
return(View("Detail", m));
}
catch
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Edit(string id)
{
try
{
//初始化物件
var m = new MenuDetailViewModel();
//取出資料
var dt = MenuDataAccess.GetMenuList(null, id, null, null);
var list = Util.ToList <MenuDetailViewModel>(dt);
m = list[0];
return(View("Detail", m));
}
catch
{
return(RedirectToAction("Error", "Home"));
}
}
public ActionResult Create(MenuDetailViewModel model)//[Bind(Include = "Id,MenuId,FoodId")] MenuDetail menuDetail)
{
var menuId = model.MenuId;
DeleteMenuDetails(menuId);
var toSave = GetToSave(model).ToList();
if (ModelState.IsValid)
{
toSave.ForEach(s =>
{
db.MenuDetails.Add(s);
});
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.FoodId = new SelectList(db.Foods, "Id", "Name", menuDetail.FoodId);
ViewBag.MenuId = new SelectList(db.Menus, "Id", "Name", menuId);
return(View(model));
}
public IActionResult Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var menu = _menuManager.GetMenu(id.Value);
if (menu == null)
{
return(NotFound());
}
MenuDetailViewModel vm = new MenuDetailViewModel
{
ID = menu.ID,
Email = menu.Owner.Email,
Naam = menu.Naam,
menuItems = _menuItemManager.GetMenuItems(menu.ID)
};
return(View(vm));
}
public MenuDetail()
{
InitializeComponent();
MenuDetailViewModel = new MenuDetailViewModel();
LoadPhoto();
}
