Beispiel #1
0
        /// <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));
 }