using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace FrameworkDAL.Query.PortletVsMenu
{
    public static class PortletVsMenuQB
    {
        public const string GET_PORTLETVSMENU = @"SELECT
                            PM.PORTLETVSMENUID AS PortletVsMenuId,
                            PM.PORTLETID AS PortletId,
                            P.PORTLETCODE AS PortletCode,
                            P.PORTLETNAME AS PortletName,
                            PM.SLNO AS PortletVsMenuSlNo,
                            PM.MENUID AS MenuId,
                            M.MENUCODE AS MenuCode,
                            M.MENUNAME AS MenuName
                            FROM MPORTLETVSMENU PM
                            LEFT JOIN MPORTLET P ON PM.PORTLETID = P.PORTLETID
                            LEFT JOIN MMENU M ON PM.MENUID = M.MENUID
                            WHERE PM.PORTLETID = @portletid;
                            ";

        public const string SAVE_PORTLETVSMENU = @"INSERT 
                            INTO MPORTLETVSMENU (
                                 PORTLETVSMENUID,
                                 PORTLETID,
                                 SLNO,
                                 MENUID
                            ) VALUES (
                                 @PortletVsMenuId,
                                 @PortletId,
                                 @PortletVsMenuSlNo,
                                 @MenuId  
                            );
                            ";

        public const string UPDATE_PORTLETVSMENU = @"UPDATE 
                            MPORTLETVSMENU SET
                            PORTLETID = @PortletId,
                            SLNO = @PortletVsMenuSlNo,
                            MENUID = @MenuId
                            WHERE PORTLETVSMENUID = @PortletVsMenuId;
                            ";

        public const string DELETE_PORTLETVSMENU = @"DELETE 
                            FROM MPORTLETVSMENU
                            WHERE PORTLETID = @portletid;
                            ";
    }
}