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

namespace WiDAL.Query.Wi
{
    public class WiStepContentQB
    {
        public const string GET_BY_ID = @"SELECT
                                        WC.WISTEPCONTENTID      AS WiStepContentId,
                                        WC.WISTEPID             AS WiStepId,
                                        WC.SLNO                 AS WiStepContentSlNo,
                                        WC.CONTENTTYPE          AS ContentType,
                                        WC.CONTENTSOURCE        AS ContentSource,
                                        WC.CONTENTREF           AS ContentRef,
                                        WC.MEDIACAPTION         AS MediaCaption,
                                        WC.DISPLAYDURATIONSECS  AS DisplayDurationSecs,
                                        WC.LOOPMEDIA            AS LoopMedia,
                                        WC.ZOOMREGION           AS ZoomRegion,
                                        WC.APPLICABLEMODELIDS   AS ApplicableModelIds,
                                        WC.ISACTIVE             AS IsActive,
                                        ISNULL(WC.CONTAINERID, 0)             AS ContainerId,
                                        ISNULL(WC.CONTAINERTYPE, 0)           AS ContainerType,
                                        WC.CONTAINERLABEL                     AS ContainerLabel,
                                        ISNULL(WC.ZONENAME, 'main')           AS ZoneName,
                                        ISNULL(WC.BLOCKINCONTAINERPOS, 1)     AS BlockInContainerPos
                                    FROM WI.MWISTEPCONTENT WC
                                    WHERE WC.WISTEPCONTENTID = @wiStepContentId";

        public const string INSERT= @"INSERT INTO WI.MWISTEPCONTENT
                                    (
                                        WISTEPCONTENTID,
                                        WISTEPID,
                                        SLNO,
                                        CONTENTTYPE,
                                        CONTENTSOURCE,
                                        CONTENTREF,
                                        MEDIACAPTION,
                                        DISPLAYDURATIONSECS,
                                        LOOPMEDIA,
                                        ZOOMREGION,
                                        APPLICABLEMODELIDS,
                                        ISACTIVE,
                                        CONTAINERID,
                                        CONTAINERTYPE,
                                        CONTAINERLABEL,
                                        ZONENAME,
                                        BLOCKINCONTAINERPOS
                                    )
                                    VALUES
                                    (
                                        @WiStepContentId,
                                        @WiStepId,
                                        @WiStepContentSlNo,
                                        @ContentType,
                                        @ContentSource,
                                        @ContentRef,
                                        @MediaCaption,
                                        @DisplayDurationSecs,
                                        @LoopMedia,
                                        @ZoomRegion,
                                        @ApplicableModelIds,
                                        @IsActive,
                                        @ContainerId,
                                        @ContainerType,
                                        @ContainerLabel,
                                        @ZoneName,
                                        @BlockInContainerPos
                                    )";

        public const string UPDATE = @"UPDATE WI.MWISTEPCONTENT
                                        SET
                                            WISTEPID            = @WiStepId,
                                            SLNO                = @WiStepContentSlNo,
                                            CONTENTTYPE         = @ContentType,
                                            CONTENTSOURCE       = @ContentSource,
                                            CONTENTREF          = @ContentRef,
                                            MEDIACAPTION        = @MediaCaption,
                                            DISPLAYDURATIONSECS = @DisplayDurationSecs,
                                            LOOPMEDIA           = @LoopMedia,
                                            ZOOMREGION          = @ZoomRegion,
                                            APPLICABLEMODELIDS  = @ApplicableModelIds,
                                            ISACTIVE            = @IsActive,
                                            CONTAINERID         = @ContainerId,
                                            CONTAINERTYPE       = @ContainerType,
                                            CONTAINERLABEL      = @ContainerLabel,
                                            ZONENAME            = @ZoneName,
                                            BLOCKINCONTAINERPOS = @BlockInContainerPos
                                        WHERE WISTEPCONTENTID   = @WiStepContentId";

        public const string DELETE_WISTEPCONTENT = @"DELETE FROM WI.MWISTEPCONTENT
                                                    WHERE WISTEPCONTENTID = @wiStepContentId";

        public const string GET_SELECTLIST_WISTEPCONTENT = @"SELECT 
                                                        WISTEPCONTENTID AS Id,
                                                        MEDIACAPTION AS Name
                                                    FROM WI.MWISTEPCONTENT
                                                    ORDER BY MEDIACAPTION;";


        public const string DELETE_BY_STEPID = @"DELETE FROM WI.MWISTEPCONTENT 
                                                 WHERE WISTEPID = @wiStepId;";
    }
}