private void addButton_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(MenuNameTextBox.Text))
{
if (!string.IsNullOrEmpty(TypeComboBox.SelectedIndex.ToString()))
{
if (!string.IsNullOrEmpty(priceTextBox.Text))
{
int result = ms.AddMenu(MenuNameTextBox.Text, Convert.ToInt32(priceTextBox.Text), Convert.ToInt32(QuantityTextBox.Text), TypeComboBox.SelectedItem.ToString());
if (result == 1)
{
MessageBox.Show("Item successfully added to menu!");
mda = new MenuDataAccess();
dataGridView1.DataSource = mda.GetMenuData();
MenuNameTextBox.Clear();
priceTextBox.Clear();
QuantityTextBox.Clear();
TypeComboBox.SelectedItem = null;
}
}
else
{
MessageBox.Show("Please Enter a price!");
}
}
else
{
MessageBox.Show("Please Enter quantity!");
}
}
else
{
MessageBox.Show("Please Enter name!");
}
}
public Manager_Menu()
{
InitializeComponent();
mda = new MenuDataAccess();
ms = new MenuService();
dataGridView1.DataSource = mda.GetMenuData();
}
public ActionResult EditDataMenu(MenuViewModel paramEditMenu)
{
if (ModelState.IsValid)
{
//update data manual createby and createdate
paramEditMenu.updateBy = "Tian";
paramEditMenu.updateDate = DateTime.Now;
int?numberV = MenuDataAccess.NameValidation(paramEditMenu.code);
if (numberV <= 1)
{
if (MenuDataAccess.UpdateMenu(paramEditMenu))
{
return(Json(new { success = true, message = MenuDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = MenuDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Menu number " + paramEditMenu.code + " is exist !" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Wajib menginputkan semua kotak bertanda bintang" }, JsonRequestBehavior.AllowGet));
}
}
//EDIT Menu
public ActionResult EditMenu(int paramId)
{
//String dummyPrefix = string.Empty;
//ViewBag.MenuParentName = new SelectList(MenuDataAccess.SearchMenuStringParent(dummyPrefix), "parentId", "parentName");
return(PartialView(MenuDataAccess.GetDetailMenuById(paramId)));
}
public string RenderMenuWebMVC(string userID)
{
StringBuilder sb = new StringBuilder();
List <Getmenu> lstMenu = new List <Getmenu>();
lstMenu = new MenuDataAccess(DALInfo).RenderMenu(userID);
if (lstMenu.Count > 0)
{
var parentMenu = (from m in lstMenu
where m.ParentID.Equals(0)
select m
).AsParallel().ToList();
foreach (Getmenu mp in parentMenu)
{
string iconClass = string.Empty;
switch (mp.MenuText)
{
case "Master":
iconClass = "fa-sitemap";
break;
case "Transaction":
iconClass = "fa-newspaper-o";
break;
case "Content":
iconClass = "fa-newspaper-o";
break;
default:
iconClass = "fa-home";
break;
}
sb.AppendLine("<li>");
sb.AppendLine("<a><i class=\"fa " + iconClass + "\"></i> " + mp.MenuText + " <span class=\"fa fa-chevron-down\"></span></a>");
var childMenu = (from m in lstMenu
where m.ParentID.Equals(mp.MenuID)
select m
).AsParallel().ToList();
if (childMenu.Count > 0)
{
sb.AppendLine("<ul class=\"nav child_menu\">");
foreach (Getmenu mc in childMenu)
{
sb.AppendLine(" <li><a href=\"" + mc.PageName + "\">" + mc.MenuText + "</a></li>");
}
sb.AppendLine("</ul>");
}
sb.AppendLine("</li>");
}
}
return(sb.ToString());
}
/// <summary>
/// Obtener un registro de Menu por su ID
/// </summary>
/// <param name="strID"></param>
/// <returns></returns>
public static Menu ObtenerMenuPorID(string strID)
{
//1. Obtener el objeto Menu y complementar el GrupoMenu
Menu oMenu = MenuDataAccess.ObtenerMenuPorID(strID);
oMenu.RGrupoMenu = GrupoMenuBusiness.ObtenerGrupoMenuPorID(oMenu.GrupoMenu);
//2. Regresar el objeto
return(oMenu);
}
private void saveButton_Click(object sender, EventArgs e)
{
int result = ms.EditMenu(id, MenuNameTextBox.Text, Convert.ToInt32(priceTextBox.Text), Convert.ToInt32(QuantityTextBox.Text), TypeComboBox.SelectedItem.ToString());
mda = new MenuDataAccess();
dataGridView1.DataSource = mda.GetMenuData();
MessageBox.Show("Item details successfully saved!");
MenuNameTextBox.Clear();
priceTextBox.Clear();
QuantityTextBox.Clear();
TypeComboBox.SelectedItem = null;
}
private void deleteButton_Click(object sender, EventArgs e)
{
int result = ms.DeleteMenu(Convert.ToInt32(deleteTextBox.Text));
if (result == 1)
{
MessageBox.Show("Item is deleted from Menu successfully!");
mda = new MenuDataAccess();
dataGridView1.DataSource = mda.GetMenuData();
deleteTextBox.Clear();
}
}
/// <summary>
/// Obtener un registro de Menu por su GrupoMenu
/// </summary>
/// <param name="strGrupoMenu"></param>
/// <returns></returns>
public static List <Menu> ObtenerMenuPorGrupoMenu(string strGrupoMenu)
{
//1. Obtener los objetos Menu que corresponden al GrupoMenu
List <Menu> lMenu = MenuDataAccess.ObtenerMenuPorGrupoMenu(strGrupoMenu);
//2. Por cada elemento de la lista complementar con un objeto GrupoMenu
foreach (Menu sd in lMenu)
{
sd.RGrupoMenu = GrupoMenuBusiness.ObtenerGrupoMenuPorID(sd.GrupoMenu);
}
return(lMenu);
}
public JsonResult DeleteDataMenu(int paramId)
{
string latestCode = MenuDataAccess.DeleteMenu(paramId);
if (latestCode != "")
{
return(Json(new { success = true, latestCode, message = MenuDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = MenuDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Método que obtiene todos los regsitros de Menus
/// </summary>
/// <returns></returns>
public static List <Menu> ObtenerMenus()
{
//1. Obtener la lista de los grupo menu
List <Menu> lMenu = MenuDataAccess.ObtenerMenus();
//2. Por cada elemento de la lista complementar con un objeto GrupoMenu
foreach (Menu sd in lMenu)
{
sd.RGrupoMenu = GrupoMenuBusiness.ObtenerGrupoMenuPorID(sd.GrupoMenu);
}
return(lMenu);
}
public int AddFood(string foodname, string price, string status, string categoryName)
{
int categoryId = this.menuDataAccess.GetCategoryId(categoryName);
Menu1 menu = new Menu1()
{
FoodName = foodname,
Price = Convert.ToDouble(price),
Status = status,
CategoryId = categoryId
};
menuDataAccess = new MenuDataAccess();
return(this.menuDataAccess.InsertFood(menu));
}
public JsonResult Del(string id)
{
Result r = new Result();
try
{
MenuDataAccess.DelMenu(id);
r.Set(ResultCode.Success, "作業成功");
}
catch (Exception e)
{
r.Set(ResultCode.Error, e.Message);
}
return(Json(r, JsonRequestBehavior.AllowGet));
}
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 List()
{
try
{
//初始化物件
var m = new MenuListViewModel();
m.Authority = Tool.GetPageAuthority();
//所有選單資料
var dtMenu = MenuDataAccess.GetAllMenuList(null);
m.List = Util.ToList <ListItem>(dtMenu);
return(View(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"));
}
}
static void SendMenu(NetworkStream networkStream)
{
IMenuDataAccess menuDA = new MenuDataAccess();
IMenuService menuService = new MenuService(menuDA);
IFrameHandler frameHandler = new FrameHandler(networkStream);
var items = menuService.GetMenuItems();
string menu = "";
int count = 1;
foreach (var item in items)
{
menu += count + ") " + item + "\n";
count++;
}
byte[] data = Encoding.UTF8.GetBytes(menu);
frameHandler.SendMessageAsync(data);
}
public ActionResult CreateDataMenu(MenuViewModel paramAddMenu)
{
if (ModelState.IsValid)
{
//is delete default value
paramAddMenu.isDelete = false;
//update data manual createby and createdate
paramAddMenu.createBy = "Zack";
paramAddMenu.createDate = DateTime.Now;
int?numberV = MenuDataAccess.NameValidation(paramAddMenu.code);
if (numberV == 0)
{
string latestCode = MenuDataAccess.CreateMenu(paramAddMenu);
if (latestCode != "")
{
return(Json(new { success = true, latestCode, message = MenuDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = MenuDataAccess.Message }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Menu name " + paramAddMenu.name + " is exist !" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { success = false, message = "Wajib menginputkan semua kotak bertanda bintang" }, JsonRequestBehavior.AllowGet));
}
}
public IEnumerable <CategoriaMenu> listaMenu()
{
var tkn = ActionContext.Request.Headers.GetValues("Token").First();
return(MenuDataAccess.ListarCategorias(tkn));
}
/// <summary>
/// Método que actualiza un nuevo registro a la tabla de Menus
/// </summary>
/// <param name="uMenu"></param>
/// <returns></returns>
public static int Actualizar(Menu uMenu)
{
return(MenuDataAccess.Actualizar(uMenu));
}
public ActionResult TopMenu()
{
var model = new MenuDataAccess().ListByGroupId(2);
return(PartialView(model));
}
public DataSet GetSubMenuByParentMenuId(int parentID)
{
MenuDataAccess dataAccess = new MenuDataAccess();
return(dataAccess.GetSubMenuByParentMenuId(parentID));
}
public MenuService()
{
this.menuDataAccess = new MenuDataAccess();
}
public JsonResult Login(LoginViewModel m)
{
var r = new Result();
//基本驗証
if (string.IsNullOrEmpty(m.Account) || string.IsNullOrEmpty(m.Password))
{
r.Code = ResultCode.Error;
r.Msg = "帳號密碼請勿空白";
return(Json(r, JsonRequestBehavior.AllowGet));
}
//判斷是否為模擬使用者，並取得使用者資訊
var pwd = (TempData["Simulate"] == null ? Util.MD5(m.Password, 32) : null);
var dt = UserDataAccess.GetUserList(null, m.Account, pwd, null, null, new Pages());
if (dt.Rows.Count > 0)
{
//判斷帳戶是否鎖定
DataRow rowUser = dt.Rows[0];
if (!Convert.ToBoolean(rowUser["IsLock"]))
{
//將使用者資訊記錄Session
var u = Util.ToList <User>(dt)[0];
Definition.UserInfo = u;
//將使用者頁面權限記錄Session
var dtAuth = UserDataAccess.GetUserAuthority(u.Account);
Definition.UserAuthority = Util.ToList <Auth>(dtAuth);
#region 人化選單資料
var menuList = new List <Menu>();
//取得全部的選單
var dtMenu = MenuDataAccess.GetAllMenuList(true);
var listMenu = Util.ToList <Menu>(dtMenu);
foreach (var menu in listMenu) //逐筆讀取選單資料
{
if (Tool.CheckMenuAuthority(menu.MenuNo)) //驗証權限
{
menuList.Add(menu); //增加選單
}
}
Definition.MenuList = menuList;
#endregion
//取得登錄者電腦IP
m.IP = Util.GetClientIP();
//更新使用者登入時間
UserDataAccess.SetUserLoginDate(m);
r.Set(ResultCode.Success, "登入成功");
}
else
{
r.Set(ResultCode.Error, "帳戶已鎖定");
}
}
else
{
r.Set(ResultCode.Error, "登入失敗");
}
return(Json(r, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Método que borrar algun Menu por su ID
/// </summary>
/// <param name="dID"></param>
public static int Borrar(string dID)
{
return(MenuDataAccess.Borrar(dID));
}
public DataSet GetParentMenu()
{
MenuDataAccess dataAccess = new MenuDataAccess();
return(dataAccess.GetParentMenu());
}
public DataTable GetAll()
{
MenuDataAccess dataAccess = new MenuDataAccess();
return(dataAccess.GetAll());
}
//public DataTable GetAllByUserGroupID(int userGroupID)
//{
// MenuDataAccess dataAccess = new MenuDataAccess();
// return dataAccess.GetAllByUserGroupID(userGroupID);
//}
public DataTable GetAllByUserGroupID(String userID)
{
MenuDataAccess dataAccess = new MenuDataAccess();
return(dataAccess.GetAllByUserGroupID(userID));
}
public MenuBusinessLogic()
{
menuDataAccess = new MenuDataAccess();
}
/// <summary>
/// Método que inserta un nuevo registro a la tabla de Menus
/// </summary>
/// <param name="iMenu"></param>
public static string Insertar(Menu iMenu)
{
return(MenuDataAccess.Insertar(iMenu));
}
