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

namespace FrameworkDAL.Query.MessageHub
{
    public static class MessageHubQB
    {
        public const string GET_MESSAGEHUB = @"
            SELECT 
                MESSAGEHUBID       AS MessageHubId,
                MODE               AS Mode,
                RECIPIENT          AS Recipient,
                MESSAGETEXT        AS MessageText,
                AUTHTOKEN          AS AuthToken,
                PHONENUMBERID      AS PhoneNumberId,
                WEBHOOKURL         AS WebhookUrl,
                SORTORDER          AS SortOrder,
                STATUS             AS Status,
                VERSION            AS Version,
                SOURCETYPE         AS SourceType,
                CREATEDBYID        AS CreatedById,
                CREATEDON          AS CreatedOn,
                MODIFIEDBYID       AS ModifiedById,
                MODIFIEDON         AS ModifiedOn,
                TENANTID           AS TenantId
            FROM TMESSAGEHUB
            WHERE MESSAGEHUBID = @MessageHubId
        ";

        public const string INSERT_MESSAGEHUB = @"
            INSERT INTO TMESSAGEHUB
            (
                MODE,
                RECIPIENT,
                MESSAGETEXT,
                AUTHTOKEN,
                PHONENUMBERID,
                WEBHOOKURL,
                SORTORDER,
                STATUS,
                VERSION,
                SOURCETYPE,
                CREATEDBYID,
                MODIFIEDBYID,
                TENANTID
            )
            VALUES
            (
                @Mode,
                @Recipient,
                @MessageText,
                @AuthToken,
                @PhoneNumberId,
                @WebhookUrl,
                @SortOrder,
                @Status,
                @Version,
                @SourceType,
                @CreatedById,
                @ModifiedById,
                @TenantId
            );

            SELECT SCOPE_IDENTITY();
        ";

        public const string UPDATE_MESSAGEHUB = @"
            UPDATE TMESSAGEHUB
            SET
                MODE          = @Mode,
                RECIPIENT     = @Recipient,
                MESSAGETEXT   = @MessageText,
                AUTHTOKEN     = @AuthToken,
                PHONENUMBERID = @PhoneNumberId,
                WEBHOOKURL    = @WebhookUrl,
                MODIFIEDBYID  = @ModifiedById,
                MODIFIEDON    = GETDATE()
            WHERE MESSAGEHUBID = @MessageHubId
              AND TENANTID     = @TenantId
        ";

        // 🔹 Soft delete
        public const string DELETE_MESSAGEHUB = @"
            UPDATE TMESSAGEHUB
            SET 
                STATUS = 0,
                MODIFIEDBYID = @ModifiedById,
                MODIFIEDON = GETDATE()
            WHERE MESSAGEHUBID = @MessageHubId
        ";

        public const string SAVE_MESSAGEHUB_LOG = @"
            INSERT INTO TMESSAGEHUBLOG
            (
                MODE,
                RECIPIENT,
                MESSAGETEXT,
                AUTHTOKEN,
                PHONENUMBERID,
                WEBHOOKURL,
                RESPONSEDATA,
                CREATEDBYID,
                CREATEDON
            )
            VALUES
            (
                @Mode,
                @Recipient,
                @MessageText,
                @AuthToken,
                @PhoneNumberId,
                @WebhookUrl,
                @ResponseData,
                @CreatedById,
                GETDATE()
            )
        ";

        public const string GET_SELECTLIST_MESSAGEHUB = @"SELECT
    MT.MAILTEMPLATEID     AS MailTemplateId,
    MT.MAILTEMPLATECODE   AS MailTemplateCode,
    MT.MAILTEMPLATENAME   AS MailTemplateName,
    MT.MAILTEMPLATETYPE   AS MailTemplateType,
    MT.SUBJECT            AS Subject,
    MT.BODY               AS Body
FROM MMAILTEMPLATE MT
";


        public const string GET_MESSAGEHUB_TEMPLATE = @"SELECT
    MT.MAILTEMPLATEID     AS MailTemplateId,
    MT.MAILTEMPLATECODE   AS MailTemplateCode,
    MT.MAILTEMPLATENAME   AS MailTemplateName,
    MT.MAILTEMPLATETYPE   AS MailTemplateType,
    MT.ATTACHMENTFILEID   AS AttachmentFileId,
    MT.BODYFILEID         AS BodyFileId,
    MT.EVENTTYPEID        AS EventTypeId,
    MT.SUBJECT            AS Subject,
    MT.BODY               AS Body,
    MT.REMARKS            AS Remarks,
    MT.SORTORDER          AS SortOrder,
    MT.STATUS             AS Status,
    MT.VERSION            AS Version,
    MT.SOURCETYPE         AS SourceType,
    MT.CREATEDBYID        AS CreatedById,
    MT.CREATEDON          AS CreatedOn,
    MT.MODIFIEDBYID       AS ModifiedById,
    MT.MODIFIEDON         AS ModifiedOn
FROM MMAILTEMPLATE MT
Where MT.MAILTEMPLATEID = @mailtemplateid
";
    }
}