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

namespace FrameworkDAL.Query.Page
{
    public static class PageQB
    {
        public const string GET_PAGE = @"SELECT
                            P.PAGEID AS PageId,
                            P.PAGECODE AS PageCode,
                            P.PAGENAME AS PageName,
                            P.REMARKS AS PageRemarks,
                            P.PAGELAYOUT AS PageLayOut,
                            P.PAGETYPE AS PageType,
                            P.DEFAULTCRITERIACONFIGID AS DefaultCriteriaConfigId,
                            P.OVERRIDEDASHBOARDCRITERIA AS OverrideDashboardCriteria,
                            P.MODULEID AS ModuleId,
                            M.MODULECODE AS ModuleCode,
                            M.MODULENAME AS ModuleName,
                            P.SORTORDER AS PageSortOrder,
                            P.STATUS AS PageStatus,
                            P.VERSION AS PageVersion,
                            P.SOURCETYPE AS PageSourceType,
                            P.CREATEDBYID AS PageCreatedById,
                            P.CREATEDON AS PageCreatedOn,
                            P.MODIFIEDBYID AS PageModifiedById,
                            P.MODIFIEDON AS PageModifiedOn,
                            P.IMAGEID AS ImageId,
                            I.IMAGENAME AS ImageName,
                            I.IMAGELINKURL AS ImageLinkURL
                            FROM MPAGE P
                            LEFT JOIN MMODULE M ON P.MODULEID = M.MODULEID
                            LEFT JOIN MIMAGE I ON P.IMAGEID = I.IMAGEID
                            WHERE P.PAGEID = @pageid;
                            ";

        public const string SAVE_PAGE = @"INSERT 
                            INTO MPAGE (
                                 PAGEID,
                                 PAGECODE,
                                 PAGENAME,
                                 REMARKS,
                                 PAGELAYOUT,
                                 PAGETYPE,
                                 DEFAULTCRITERIACONFIGID,
                                 OVERRIDEDASHBOARDCRITERIA,
                                 MODULEID,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 SOURCETYPE,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 IMAGEID
                            ) VALUES (
                                 @PageId,
                                 @PageCode,
                                 @PageName,
                                 @PageRemarks,
                                 @PageLayOut,
                                 @PageType,
                                 @DefaultCriteriaConfigId,
                                 @OverrideDashboardCriteria,
                                 @ModuleId,
                                 @PageSortOrder,
                                 @PageStatus,
                                 @PageVersion,
                                 @PageSourceType,
                                 @PageCreatedById,
                                 @PageCreatedOn,
                                 @PageModifiedById,
                                 @PageModifiedOn,
                                 @ImageId 
                            );
                            ";

        public const string UPDATE_PAGE = @"UPDATE 
                            MPAGE SET
                            PAGECODE = @PageCode,
                            PAGENAME = @PageName,
                            REMARKS = @PageRemarks,
                            PAGELAYOUT = @PageLayOut,
                            PAGETYPE = @PageType,
                            DEFAULTCRITERIACONFIGID = @DefaultCriteriaConfigId,
                            OVERRIDEDASHBOARDCRITERIA = @OverrideDashboardCriteria,
                            MODULEID = @ModuleId,
                            SORTORDER = @PageSortOrder,
                            STATUS = @PageStatus,
                            VERSION = @PageVersion,
                            SOURCETYPE = @PageSourceType,
                            MODIFIEDBYID = @PageModifiedById,
                            MODIFIEDON = @PageModifiedOn,
                            IMAGEID = @ImageId
                            WHERE PAGEID = @PageId;
                            ";

        public const string DELETE_PAGE = @"DELETE 
                            FROM MPAGE
                            WHERE PAGEID = @pageid;
                            ";

        public const string GET_SELECTLIST_PAGE = @"SELECT
                            PAGEID AS Id,
                            PAGECODE AS Code,
                            PAGENAME AS Name
                            FROM MPAGE
                            ";
    }
}