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

namespace FrameworkDAL.Query.SecurityQuestion
{
    public static class SecurityQuestionQB
    {
        public const string GET_SECURITYQUESTION = @"SELECT 
                                                    SECURITYQUESTIONID     AS SecurityQuestionId,
                                                    SECURITYQUESTION       AS SecurityQuestionQuestion,
                                                    REMARKS                AS SecurityQuestionRemarks,
                                                    SORTORDER              AS SecurityQuestionSortOrder,
                                                    STATUS                 AS SecurityQuestionStatus,
                                                    VERSION                AS SecurityQuestionVersion,
                                                    SOURCETYPE             AS SecurityQuestionSourceType,
                                                    CREATEDBYID            AS SecurityQuestionCreatedById,
                                                    CREATEDON              AS SecurityQuestionCreatedOn,
                                                    MODIFIEDBYID           AS SecurityQuestionModifiedById,
                                                    MODIFIEDON             AS SecurityQuestionModifiedOn
                                                    FROM MSECURITYQUESTION
                                                   WHERE SECURITYQUESTIONID= @securityquestionid;";

        public const string GET_SELECTLIST_SECURITYQUESTION = @"SELECT 
                                                                SECURITYQUESTIONID AS Id,
                                                                SECURITYQUESTION   AS Question
                                                            FROM MSECURITYQUESTION
                                                            WHERE STATUS = 1   -- Only Active Questions
                                                            ORDER BY SORTORDER;
                                                            ";

        public const string SAVE_SECURITYQUESTION = @"INSERT INTO MSECURITYQUESTION 
                                                    (
                                                        SECURITYQUESTIONID,
                                                        SECURITYQUESTION,
                                                        REMARKS,
                                                        SORTORDER,
                                                        STATUS,
                                                        VERSION,
                                                        SOURCETYPE,
                                                        CREATEDBYID,
                                                        CREATEDON,
                                                        MODIFIEDBYID,
                                                        MODIFIEDON
                                                    )
                                                    VALUES 
                                                    (
                                                        @SecurityQuestionId,
                                                        @SecurityQuestionQuestion,
                                                        @SecurityQuestionRemarks,
                                                        @SecurityQuestionSortOrder,
                                                        @SecurityQuestionStatus,
                                                        @SecurityQuestionVersion,
                                                        @SecurityQuestionSourceType,
                                                        @SecurityQuestionCreatedById,
                                                        @SecurityQuestionCreatedOn,
                                                        @SecurityQuestionModifiedById,
                                                        @SecurityQuestionModifiedOn
                                                    );";

        public const string UPDATE_SECURITYQUESTION = @"UPDATE MSECURITYQUESTION
                                                        SET 
                                                            SECURITYQUESTION   = @SecurityQuestionQuestion,
                                                            REMARKS            = @SecurityQuestionRemarks,
                                                            SORTORDER          = @SecurityQuestionSortOrder,
                                                            STATUS             = @SecurityQuestionStatus,
                                                            VERSION            = @SecurityQuestionVersion,
                                                            SOURCETYPE         = @SecurityQuestionSourceType,
                                                            MODIFIEDBYID       = @SecurityQuestionModifiedById,
                                                            MODIFIEDON         = @SecurityQuestionModifiedOn
                                                        WHERE SECURITYQUESTIONID = @SecurityQuestionId;
                                                        ";

        public const string DELETE_SECURITYQUESTION = @"DELETE FROM MSECURITYQUESTION
                                                        WHERE SECURITYQUESTIONID = @securityquestionid;
                                                        ";

    }
}