using System;

namespace FrameworkDAL.Query.EIPConversation
{
    public static class EIPConceptQB
    {
        /* =========================================================
           SELECT CONVERSATION
           ========================================================= */
        public const string GET_CONVERSATION = @"
SELECT
    CONVERSATIONID        AS ConversationId,
    CLIENTID              AS ClientId,
    PLATFORMTYPEID        AS PlatformTypeId,
    SESSIONTOKEN          AS SessionId,
    STATUS                AS StatusId,
    LASTACTIVITYON        AS LastActivityOn,
    CREATEDBYID           AS CreatedById,
    CREATEDON             AS CreatedOn,
    MODIFIEDBYID          AS ModifiedById,
    MODIFIEDON            AS ModifiedOn,
    SOURCETYPE            AS SourceType,
    TENANTID              AS TenantId
FROM TEIPCONVERSATION
WHERE CLIENTID = @ClientId
  AND SESSIONTOKEN = @SessionId
  AND STATUS = 1
  AND TENANTID = @TenantId;
";

        /* =========================================================
           INSERT CONVERSATION
           ========================================================= */
        public const string INSERT_CONVERSATION = @"INSERT INTO TEIPCONVERSATION
(
    CLIENTID,
    PLATFORMTYPEID,
    SESSIONTOKEN,
    STATUS,
    LASTACTIVITYON,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON,
    SOURCETYPE,
    TENANTID
)
VALUES
(
    @ClientId,
    @PlatformTypeId,
    @SessionId,
    @Status,
    @LastActivityOn,
    @CreatedById,
    @CreatedOn,
    @ModifiedById,
    @ModifiedOn,
    5,
    @TenantId
);

SELECT CAST(SCOPE_IDENTITY() AS BIGINT);

";

        /* =========================================================
           UPDATE STATUS + LAST ACTIVITY
           ========================================================= */
        public const string UPDATE_STATUS_AND_ACTIVITY = @"
UPDATE TEIPCONVERSATION
SET
    STATUS = @Status,
    LASTACTIVITYON = @LastActivityOn,
    MODIFIEDBYID = @ModifiedById,
    MODIFIEDON = @ModifiedOn
WHERE CLIENTID = @ClientId
  AND SESSIONTOKEN = @SessionId
  AND TENANTID = @TenantId;
";

        /* =========================================================
           UPDATE LAST ACTIVITY ONLY
           ========================================================= */
        public const string UPDATE_LAST_ACTIVITY_ONLY = @"
UPDATE TEIPCONVERSATION
SET
    LASTACTIVITYON = @LastActivityOn,
    MODIFIEDBYID = @ModifiedById,
    MODIFIEDON = @ModifiedOn
WHERE CLIENTID = @ClientId
  AND SESSIONTOKEN = @SessionId
  AND TENANTID = @TenantId;
";

        /* =========================================================
           CLOSE CONVERSATION
           ========================================================= */
        public const string CLOSE_CONVERSATION = @"
UPDATE TEIPCONVERSATION
SET
    STATUS = 2,  -- Closed
    MODIFIEDBYID = @ModifiedById,
    MODIFIEDON = @ModifiedOn
WHERE CLIENTID = @ClientId
  AND SESSIONTOKEN = @SessionId
  AND TENANTID = @TenantId;
";

        /* =========================================================
           INSERT CONVERSATION DETAIL
           ========================================================= */
        public const string INSERT_CONVERSATION_DETAIL = @"
INSERT INTO TEIPCONVERSATIONDETAIL
(
    CONVERSATIONID,
    DIRECTION,
    MESSAGE,
    PROVIDERMESSAGEID,
    STATUS,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON,
    TENANTID
)
VALUES
(
    @ConversationId,
    @Direction,
    @Message,
    @ProviderMessageId,
    @Status,
    @CreatedById,
    @CreatedOn,
    @ModifiedById,
    @ModifiedOn,
    @TenantId
);

SELECT CAST(SCOPE_IDENTITY() AS BIGINT);
";

        /* =========================================================
           INSERT CONVERSATION OTP
           ========================================================= */
        public const string INSERT_CONVERSATION_OTP = @"
INSERT INTO TCONVERSATIONOTP
(
    CONVERSATIONID,
    OTP,
    EXPIRESON,
    STATUS,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON,
    TENANTID
)
VALUES
(
    @ConversationId,
    @OTP,
    @ExpiresOn,
    @Status,
    @CreatedById,
    @CreatedOn,
    @ModifiedById,
    @ModifiedOn,
    @TenantId
);

SELECT CAST(SCOPE_IDENTITY() AS BIGINT);
";

        /* =========================================================
   INSERT SUPPORT REQUEST
   ========================================================= */
        public const string INSERT_SUPPORT_REQUEST = @"
INSERT INTO TMESSAGEHUBSUPPORTREQUEST
(
    CLIENTID,
    SESSIONID,
    PHONENUMBER,
    REMARKS,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON
)
VALUES
(
    @ClientId,
    @SessionId,
    @PhoneNumber,
    @Remarks,
    @CreatedById,
    @CreatedOn,
    @ModifiedById,
    @ModifiedOn
);
";

        /* =========================================================
           GET CONTACT BY MOBILE
           ========================================================= */
        public const string GET_CONTACT_BY_MOBILE = @"
SELECT TOP 1 *
FROM MCONTACT
WHERE TENANTID = @TenantId
  AND CLIENTID = @ClientId
  AND MOBILENO = @MobileNo
  AND STATUS = 1;
";

        /* =========================================================
           INSERT CONTACT
           ========================================================= */
        public const string INSERT_CONTACT = @"
INSERT INTO MCONTACT
(
    TENANTID,
    CLIENTID,
    NAME,
    MOBILENO,
    EMAIL,
    STATUS,
    CREATEDBYID,
    CREATEDON,
    MODIFIEDBYID,
    MODIFIEDON
)
VALUES
(
    @TenantId,
    @ClientId,
    @Name,
    @MobileNo,
    @Email,
    @Status,
    @CreatedById,
    @CreatedOn,
    @ModifiedById,
    @ModifiedOn
);

SELECT CAST(SCOPE_IDENTITY() AS INT);
";

        /* =========================================================
           GET PARTY PRODUCTS
           ========================================================= */
        public const string GET_PARTY_PRODUCTS = @"
SELECT *
FROM MPARTYPRODUCT
WHERE TENANTID = @TenantId
  AND CLIENTID = @ClientId
  AND PARTYID = @PartyId
  AND STATUS = 1;
";

        /* =========================================================
           INSERT PARTY PRODUCT
           ========================================================= */
        public const string INSERT_PARTYPRODUCT = @"
INSERT INTO MPARTYPRODUCT
(
    OUID,
    PARTYID,
    PARTYBRANCHID,
    ITEMNAME,
    QUANTITY,
    PARTICULARS,
    CREATEDBYID,
    CREATEDON
)
VALUES
(
    @OUID,
    @PartyId,
    @PartyBranchId,
    @ItemName,
    @Quantity,
    @Particulars,
    @CreatedById,
    @CreatedOn
);

SELECT CAST(SCOPE_IDENTITY() AS INT);
";

    }
}