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

namespace FrameworkDAL.Query.UserVsPortlet
{
    public static class UserVsPortletQB
    {
        public const string GET_USERVSPORTLET = @"SELECT
                            UP.USERVSPORTLETID AS UserVsPortletId,
                            UP.USERID AS UserId,
                            U.USERCODE AS UserCode,
                            U.USERNAME AS UserName,
                            UP.PAGEID AS PageId,
                            PA.PAGECODE AS PageCode,
                            PA.PAGENAME AS PageName,
                            UP.PORTLETID AS PortletId,
                            P.PORTLETCODE AS PortletCode,
                            P.PORTLETNAME AS PortletName,
                            UP.CRITERIACONFIGID AS CriteriaConfigId,
                            C.CRITERIACONFIGNAME AS CriteriaConfigName,
                            UP.HEIGHT AS UserVsPortletHeight,
                            UP.WIDTH AS UserVsPortletWidth,
                            UP.SLNO AS UserVsPortletSlNo,
                            UP.PORTLETROW AS UserVsPortletPortletRow,
                            UP.PORTLETCOLUMN AS UserVsPortletPortletColumn
                            FROM MUSERVSPORTLET UP
                            LEFT JOIN MUSER U ON UP.USERID = U.USERID
                            LEFT JOIN MPORTLET P ON UP.PORTLETID = P.PORTLETID
                            LEFT JOIN MPAGE PA ON UP.PAGEID = PA.PAGEID
                            LEFT JOIN TCRITERIACONFIG C ON UP.CRITERIACONFIGID = C.CRITERIACONFIGID
                            WHERE UP.USERID = @userid AND UP.PAGEID = @pageid;
                            ";

        public const string SAVE_USERVSPORTLET = @"INSERT 
                            INTO MUSERVSPORTLET (
                                 USERVSPORTLETID,
                                 USERID,
                                 PAGEID,
                                 PORTLETID,
                                 CRITERIACONFIGID,
                                 HEIGHT,
                                 WIDTH,
                                 SLNO,
                                 PORTLETROW,
                                 PORTLETCOLUMN
                            ) VALUES (
                                 @UserVsPortletId,
                                 @UserId,
                                 @PageId,
                                 @PortletId,
                                 @CriteriaConfigId,
                                 @UserVsPortletHeight,
                                 @UserVsPortletWidth,
                                 @UserVsPortletSlNo,
                                 @UserVsPortletPortletRow,
                                 @UserVsPortletPortletColumn
                            );
                            ";

        public const string UPDATE_USERVSPORTLET = @"UPDATE 
                            MUSERVSPORTLET SET
                            USERID = @UserId,
                            PAGEID = @PageId,
                            PORTLETID = @PortletId,
                            CRITERIACONFIGID = @CriteriaConfigId,
                            HEIGHT = @UserVsPortletHeight,
                            WIDTH = @UserVsPortletWidth,
                            SLNO = @UserVsPortletSlNo,
                            PORTLETROW = @UserVsPortletPortletRow,
                            PORTLETCOLUMN = @UserVsPortletPortletColumn
                            WHERE USERVSPORTLETID = @UserVsPortletId;
                            ";

        public const string DELETE_USERVSPORTLET = @"DELETE 
                            FROM MUSERVSPORTLET
                            WHERE USERVSPORTLETID = @uservsportletid;
                            ";

        public const string DELETE_USERVSPORTLETWITHUSERIDANDPAGEID = @"DELETE 
                            FROM MUSERVSPORTLET
                            WHERE USERID = @userid AND PAGEID = @pageid;
                            ";

        public const string UPDATE_CRITERIACONFIG_IN_USERVSPORTLET = @"UPDATE 
                            MUSERVSPORTLET SET
                            CRITERIACONFIGID = @criteriaconfigid
                            WHERE PAGEID = @pageid AND PORTLETID = @portletid AND USERID = @userid;
                            ";
    }
}