/// <summary> /// Adds the menu. /// </summary> /// <param name="objComMenu">The object COM menu.</param> /// <param name="entryMode">The entry mode.</param> /// <param name="menuId">The menu identifier.</param> public int AddMenu(ComMenu objComMenu, int entryMode, int menuId) { int i = 0; if (entryMode == 0)//to insert menu item { DbCommand cmd = null; cmd = db.GetStoredProcCommand("pkg_module.insertmenuitem"); db.AddInParameter(cmd, "v_menu_nep_name", DbType.String, objComMenu.menuNepaliName); db.AddInParameter(cmd, "v_menu_eng_name", DbType.String, objComMenu.menuEnglishName); db.AddInParameter(cmd, "v_menu_parent_id", DbType.Int16, objComMenu.menuParentId); db.AddInParameter(cmd, "v_menu_type_id", DbType.Int16, objComMenu.menuTypeId); db.AddInParameter(cmd, "v_menu_node_level", DbType.Int16, objComMenu.menuLevel); db.AddInParameter(cmd, "v_menu_path", DbType.String, objComMenu.menuPath); i = db.ExecuteNonQuery(cmd); } else // to update menu item { DbCommand cmd = null; cmd = db.GetStoredProcCommand("pkg_module.updatemenuitem"); db.AddInParameter(cmd, "v_menu_nep_name", DbType.String, objComMenu.menuNepaliName); db.AddInParameter(cmd, "v_menu_eng_name", DbType.String, objComMenu.menuEnglishName); db.AddInParameter(cmd, "v_menu_parent_id", DbType.Int16, objComMenu.menuParentId); db.AddInParameter(cmd, "v_menu_type_id", DbType.Int16, objComMenu.menuTypeId); db.AddInParameter(cmd, "v_menu_node_level", DbType.Int16, objComMenu.menuLevel); db.AddInParameter(cmd, "v_menu_id", DbType.Int16, menuId); db.AddInParameter(cmd, "v_menu_path", DbType.String, objComMenu.menuPath); i = db.ExecuteNonQuery(cmd); } return(i); }
public int AddMenu(ComMenu objComMenu, int entryMode, int menuId) { return(objMenuDal.AddMenu(objComMenu, entryMode, menuId)); }