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

namespace WiDAL.Query.Wi
{
    public class WiStepQB
    {
        public const string GET_BY_ID = @"SELECT
                                        WISTEPID        AS WiStepId,
                                        WIID            AS WiId,
                                        WISECTIONID     AS WiSectionId,
                                        SLNO            AS WiStepSlNo,
                                        STEPDISPLAYNO   AS StepDisplayNo,
                                        STEPTITLE       AS StepTitle,
                                        WARNINGLEVEL    AS WarningLevel,
                                        STDDURATIONSECS AS StdDurationSecs,
                                        TOOLSREQUIRED   AS ToolsRequired,
                                        ISOPTIONAL      AS IsOptional,
                                        REQUIRESIGNOFF  AS RequireSignOff,
                                        AUTOADVANCESECS AS AutoAdvanceSecs,
                                        ISACTIVE        AS IsActive,
                                        CONTENTID       AS ContentId
                                    FROM WI.MWISTEP
                                    WHERE WISTEPID = @wiStepId;";

        public const string INSERT = @"INSERT INTO WI.MWISTEP
                                        (
                                            WISTEPID,
                                            WIID,
                                            WISECTIONID,
                                            SLNO,
                                            STEPDISPLAYNO,
                                            STEPTITLE,
                                            WARNINGLEVEL,
                                            STDDURATIONSECS,
                                            TOOLSREQUIRED,
                                            ISOPTIONAL,
                                            REQUIRESIGNOFF,
                                            AUTOADVANCESECS,
                                            ISACTIVE,
                                            CONTENTID
                                        )
                                        VALUES
                                        (
                                            @WiStepId,
                                            @WiId,
                                            @WiSectionId,
                                            @WiStepSlNo,
                                            @StepDisplayNo,
                                            @StepTitle,
                                            @WarningLevel,
                                            @StdDurationSecs,
                                            @ToolsRequired,
                                            @IsOptional,
                                            @RequireSignOff,
                                            @AutoAdvanceSecs,
                                            @IsActive,
                                            @ContentId
                                        );";

        public const string UPDATE = @"UPDATE WI.MWISTEP
                                        SET
                                            WIID            = @WiId,
                                            WISECTIONID     = @WiSectionId,
                                            SLNO            = @WiStepSlNo,
                                            STEPDISPLAYNO   = @StepDisplayNo,
                                            STEPTITLE       = @StepTitle,
                                            WARNINGLEVEL    = @WarningLevel,
                                            STDDURATIONSECS = @StdDurationSecs,
                                            TOOLSREQUIRED   = @ToolsRequired,
                                            ISOPTIONAL      = @IsOptional,
                                            REQUIRESIGNOFF  = @RequireSignOff,
                                            AUTOADVANCESECS = @AutoAdvanceSecs,
                                            ISACTIVE        = @IsActive,
                                            CONTENTID       = @ContentId
                                        WHERE
                                            WISTEPID = @WiStepId;";

        public const string GET_SELECTLIST_WISTEP = @"SELECT 
                                                        WISTEPID AS Id,
                                                        STEPTITLE AS Name,
                                                        WARNINGLEVEL AS WarningLevel,
                                                        STDDURATIONSECS AS StdDuration
                                                    FROM WI.MWISTEP
                                                    ORDER BY STEPTITLE;";

        public const string DELETE_WISTEP = @"DELETE FROM WI.MWISTEP
                                                  WHERE WISTEPID =@wiStepId;";
    }
}