namespace FrameworkDAL.Query.Dashboard
{
    public static class DashboardPageQB
    {
        public const string GET_DASHBOARDPAGE = @"SELECT
                            DP.DASHBOARDPAGEID AS DashboardPageId,
                            DP.DASHBOARDID AS DashboardId,
                            DP.SLNO AS SlNo,
                            DP.PAGEID AS PageId,
                            P.PAGECODE AS PageCode,
                            P.PAGENAME AS PageName,
                            DP.ISDEFAULTTAB AS IsDefaultTab,
                            DP.ISVISIBLE AS IsVisible
                            FROM MDASHBOARDPAGE DP
                            LEFT JOIN MPAGE P ON P.PAGEID = DP.PAGEID
                            WHERE DP.DASHBOARDID = @dashboardid
                            ORDER BY DP.SLNO;
                            ";

        public const string SAVE_DASHBOARDPAGE = @"INSERT
                            INTO MDASHBOARDPAGE (
                                 DASHBOARDPAGEID,
                                 DASHBOARDID,
                                 SLNO,
                                 PAGEID,
                                 ISDEFAULTTAB,
                                 ISVISIBLE
                            ) VALUES (
                                 @DashboardPageId,
                                 @DashboardId,
                                 @SlNo,
                                 @PageId,
                                 @IsDefaultTab,
                                 @IsVisible
                            );
                            ";

        public const string UPDATE_DASHBOARDPAGE = @"UPDATE
                            MDASHBOARDPAGE SET
                            SLNO = @SlNo,
                            PAGEID = @PageId,
                            ISDEFAULTTAB = @IsDefaultTab,
                            ISVISIBLE = @IsVisible
                            WHERE DASHBOARDPAGEID = @DashboardPageId;
                            ";

        public const string DELETE_DASHBOARDPAGE = @"DELETE
                            FROM MDASHBOARDPAGE
                            WHERE DASHBOARDPAGEID = @dashboardpageid;
                            ";

        public const string DELETE_DASHBOARDPAGE_WITH_DASHBOARD_AND_PAGE = @"DELETE
                            FROM MDASHBOARDPAGE
                            WHERE DASHBOARDID = @dashboardid AND PAGEID = @pageid;
                            ";
    }
}