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

namespace WiDAL.Query.Wi
{
    public class WiStepExecutionQB
    {
        public const string GET_WISTEPEXECUTION_BYID = @"SELECT
                                                            WISTEPEXECUTIONID   AS WiStepExecutionId,
                                                            WIEXECUTIONID       AS WiExecutionId,
                                                            WISTEPID            AS WiStepId,
                                                            SLNO                AS SlNo,
                                                            STEPSTATUS          AS StepStatus,
                                                            STARTEDON           AS StartedOn,
                                                            COMPLETEDON         AS CompletedOn,
                                                            ACTUALDURATIONSECS  AS ActualDurationSecs,
                                                            STDDURATIONSECS     AS StdDurationSecs,
                                                            ADVANCETRIGGER      AS AdvanceTrigger,
                                                            BARCODESCANNED      AS BarcodeScanned,
                                                            SKIPPEDREASON       AS SkippedReason,
                                                            REMARKS             AS Remarks
                                                        FROM WI.TWISTEPEXECUTION
                                                        WHERE
                                                            WISTEPEXECUTIONID = @wistepexecution;";

        public const string SAVE_WISTEPECXECUTION = @"INSERT INTO WI.TWISTEPEXECUTION
                                                    (
                                                        WISTEPEXECUTIONID,
                                                        WIEXECUTIONID,
                                                        WISTEPID,
                                                        SLNO,
                                                        STEPSTATUS,
                                                        STARTEDON,
                                                        COMPLETEDON,
                                                        ACTUALDURATIONSECS,
                                                        STDDURATIONSECS,
                                                        ADVANCETRIGGER,
                                                        BARCODESCANNED,
                                                        SKIPPEDREASON,
                                                        REMARKS
                                                    )
                                                    VALUES
                                                    (
                                                        @WiStepExecutionId,
                                                        @WiExecutionId,
                                                        @WiStepId,
                                                        @SlNo,
                                                        @StepStatus,
                                                        @StartedOn,
                                                        @CompletedOn,
                                                        @ActualDurationSecs,
                                                        @StdDurationSecs,
                                                        @AdvanceTrigger,
                                                        @BarcodeScanned,
                                                        @SkippedReason,
                                                        @Remarks
                                                    );";

        public const string UPDATE_WISTEPEXECUTION = @"UPDATE WI.TWISTEPEXECUTION
                                                        SET
                                                            WIEXECUTIONID       = @WiExecutionId,
                                                            WISTEPID            = @WiStepId,
                                                            SLNO                = @SlNo,
                                                            STEPSTATUS          = @StepStatus,
                                                            STARTEDON           = @StartedOn,
                                                            COMPLETEDON         = @CompletedOn,
                                                            ACTUALDURATIONSECS  = @ActualDurationSecs,
                                                            STDDURATIONSECS     = @StdDurationSecs,
                                                            ADVANCETRIGGER      = @AdvanceTrigger,
                                                            BARCODESCANNED      = @BarcodeScanned,
                                                            SKIPPEDREASON       = @SkippedReason,
                                                            REMARKS             = @Remarks
                                                        WHERE
                                                            WISTEPEXECUTIONID = @WiStepExecutionId;";

        public const string DELETE_WISTEPEXECUTION = @"DELETE FROM WI.TWISTEPEXECUTION
                                                        WHERE WISTEPEXECUTIONID=@wistepexecution;";

        public const string GET_SELECTLIST_WISTEPXECUTION = @"";

    }
}