namespace FrameworkDAL.Query.Entitlement
{
    public static class FeatureDashboardMapQB
    {
        public const string GET_FEATUREDASHBOARDMAP = @"SELECT
                            M.FEATUREDASHBOARDMAPID AS FeatureDashboardMapId,
                            M.FEATURECODE AS FeatureCode,
                            M.DASHBOARDID AS DashboardId,
                            D.DASHBOARDCODE AS DashboardCode,
                            D.DASHBOARDNAME AS DashboardName
                            FROM MENTITLEMENTFEATUREDASHBOARDMAP M
                            LEFT JOIN MDASHBOARD D ON D.DASHBOARDID = M.DASHBOARDID
                            WHERE M.DASHBOARDID = @dashboardid;
                            ";

        public const string SAVE_FEATUREDASHBOARDMAP = @"INSERT
                            INTO MENTITLEMENTFEATUREDASHBOARDMAP (
                                 FEATUREDASHBOARDMAPID,
                                 FEATURECODE,
                                 DASHBOARDID
                            ) VALUES (
                                 @FeatureDashboardMapId,
                                 @FeatureCode,
                                 @DashboardId
                            );
                            ";

        public const string UPDATE_FEATUREDASHBOARDMAP = @"UPDATE
                            MENTITLEMENTFEATUREDASHBOARDMAP SET
                            FEATURECODE = @FeatureCode,
                            DASHBOARDID = @DashboardId
                            WHERE FEATUREDASHBOARDMAPID = @FeatureDashboardMapId;
                            ";

        public const string DELETE_FEATUREDASHBOARDMAP = @"DELETE
                            FROM MENTITLEMENTFEATUREDASHBOARDMAP
                            WHERE FEATUREDASHBOARDMAPID = @featuredashboardmapid;
                            ";
    }
}