namespace FrameworkDAL.Query.Dashboard
{
    public static class UserVsDashboardQB
    {
        public const string GET_USERVSDASHBOARD = @"SELECT
                            UVD.USERVSDASHBOARDID AS UserVsDashboardId,
                            UVD.USERID AS UserId,
                            UVD.DASHBOARDID AS DashboardId,
                            D.DASHBOARDCODE AS DashboardCode,
                            D.DASHBOARDNAME AS DashboardName,
                            UVD.SLNO AS SlNo,
                            UVD.ISPINNED AS IsPinned
                            FROM MUSERVSDASHBOARD UVD
                            LEFT JOIN MDASHBOARD D ON UVD.DASHBOARDID = D.DASHBOARDID
                            WHERE UVD.USERID = @userid;
                            ";

        public const string SAVE_USERVSDASHBOARD = @"INSERT
                            INTO MUSERVSDASHBOARD (
                                 USERVSDASHBOARDID,
                                 USERID,
                                 DASHBOARDID,
                                 SLNO,
                                 ISPINNED
                            ) VALUES (
                                 @UserVsDashboardId,
                                 @UserId,
                                 @DashboardId,
                                 @SlNo,
                                 @IsPinned
                            );
                            ";

        public const string UPDATE_USERVSDASHBOARD = @"UPDATE
                            MUSERVSDASHBOARD SET
                            USERID = @UserId,
                            DASHBOARDID = @DashboardId,
                            SLNO = @SlNo,
                            ISPINNED = @IsPinned
                            WHERE USERVSDASHBOARDID = @UserVsDashboardId;
                            ";

        public const string DELETE_USERVSDASHBOARD = @"DELETE
                            FROM MUSERVSDASHBOARD
                            WHERE USERVSDASHBOARDID = @uservsdashboardid;
                            ";

        public const string DELETE_USERVSDASHBOARD_WITH_USER_AND_DASHBOARD = @"DELETE
                            FROM MUSERVSDASHBOARD
                            WHERE USERID = @userid AND DASHBOARDID = @dashboardid;
                            ";
    }
}