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

namespace FrameworkDAL.Query.Action
{
    public static class ActionQB
    {
        public const string GET_ACTION = @"  SELECT
                                        MA.ACTIONID         AS MActionId,
                                        MA.DESCRIPTION      AS MActionDescription,
                                        MA.EVENTTYPEID      AS EventTypeId,
                                        MA.ACTIONTYPE       AS MActionActionType,
                                        MA.REPLYTO          AS MActionReplyTo,
                                        MA.TEMPLATEID       AS TemplateId,
                                        MA.TODELIVERYTYPE   AS MActionToDeliveryType,
                                        MA.TOCONTENTTYPE    AS MActionToContentType,
                                        MA.SENDTO           AS MActionTo,
                                        MA.SENDTO               AS SendTo,
                                        MA.MAILCCDELIVERYTYPE   AS MActionMailCCDeliveryType,
                                        MA.MAILCCCONTENTTYPE    AS MActionMailCCContentType,
                                        MA.MAILCC               AS MActionMailCC,
                                        MA.MAILBCCDELIVERYTYPE  AS MActionMailBCCDeliveryType,
                                        MA.MAILBCCCONTENTTYPE   AS MActionMailBCCContentType,
                                        MA.MAILBCC              AS MActionMailBCC,
                                        MA.EXPORTFORMAT     AS MActionExportFormat,
                                        MA.REPORTTYPE       AS MActionReportType,
                                        MA.REPORTFORMATID   AS ReportFormatId,
                                        MA.MAILFILEID       AS MailFileId,
                                        MA.JOBID            AS JobId,
                                        MA.WEBSERVICEID     AS WebServiceId,
                                        MA.CRITERIACONFIGID AS CriteriaConfigId,
                                        MA.SORTORDER        AS MActionSortOrder,
                                        MA.SOURCETYPE       AS MActionSourceType,
                                        MA.STATUS           AS MActionStatus,
                                        MA.VERSION          AS MActionVersion,
                                        MA.CREATEDBYID      AS MActionCreatedById,
                                        MA.CREATEDON        AS MActionCreatedOn,
                                        MA.MODIFIEDBYID     AS MActionModifiedById,
                                        MA.MODIFIEDON       AS MActionModifiedOn,
                                        MA.MENUID           AS MenuId,
                                        MA.TYPE             AS Type,
                                        MA.URIPARAMETERVALUE AS MActionUriTemplateValue,
                                        MA.ACTIONFORTYPE    AS MActionActionForType,
                                        MA.REPORTID         AS ReportId,
                                        MA.GROUPBYFIELDS    AS MActionGroupByFields,
                                        MA.REMARKS          AS MActionRemarks,
                                        MA.REPORTVIEWID     AS ReportViewId,
                                        MA.MAILLISTID       AS MailListId,
                                        MA.ISPREVIOUSVERSION AS MActionIsPreviousVersion,
                                        MA.TENANTID         AS TenantId,
                                        MA.ISFILEBASED      AS MActionIsFileBased,
                                        MA.ISENCRYPTIONREQUIRED AS MActionIsEncryptionRequired
                                    FROM
                                        MACTION MA
                                    WHERE
                                        MA.ACTIONID = @mactionid; ";

        public const string SAVE_ACTION = @"INSERT INTO MACTION(
                                                    ACTIONID,
                                                    DESCRIPTION,
                                                    EVENTTYPEID,
                                                    ACTIONTYPE,
                                                    REPLYTO,
                                                    TEMPLATEID,
                                                    TODELIVERYTYPE,
                                                    TOCONTENTTYPE,
                                                    SENDTO,
                                                    MAILCCDELIVERYTYPE,
                                                    MAILCCCONTENTTYPE,
                                                    MAILCC,
                                                    MAILBCCDELIVERYTYPE,
                                                    MAILBCCCONTENTTYPE,
                                                    MAILBCC,
                                                    EXPORTFORMAT,
                                                    REPORTTYPE,
                                                    REPORTFORMATID,
                                                    MAILFILEID,
                                                    JOBID,
                                                    WEBSERVICEID,
                                                    CRITERIACONFIGID,
                                                    SORTORDER,
                                                    SOURCETYPE,
                                                    STATUS,
                                                    VERSION,
                                                    CREATEDBYID,
                                                    CREATEDON,
                                                    MODIFIEDBYID,
                                                    MODIFIEDON,
                                                    MENUID,
                                                    TYPE,
                                                    URIPARAMETERVALUE,
                                                    ACTIONFORTYPE,
                                                    REPORTID,
                                                    GROUPBYFIELDS,
                                                    REMARKS,
                                                    REPORTVIEWID,
                                                    MAILLISTID,
                                                    ISPREVIOUSVERSION,
                                                    TENANTID,
                                                    ISFILEBASED,
                                                    ISENCRYPTIONREQUIRED
                                                )
                                                VALUES (
                                                    @MActionId,
                                                    @MActionDescription,
                                                    @EventTypeId,
                                                    @MActionActionType,
                                                    @MActionReplyTo,
                                                    @TemplateId,
                                                    @MActionToDeliveryType,
                                                    @MActionToContentType,
                                                    @MActionTo,
                                                    @MActionMailCCDeliveryType,
                                                    @MActionMailCCContentType,
                                                    @MActionMailCC,
                                                    @MActionMailBCCDeliveryType,
                                                    @MActionMailBCCContentType,
                                                    @MActionMailBCC,
                                                    @MActionExportFormat,
                                                    @MActionReportType,
                                                    @ReportFormatId,
                                                    @MailFileId,
                                                    @JobDefineId,
                                                    @WebServiceId,
                                                    @CriteriaConfigId,
                                                    @MActionSortOrder,
                                                    @MActionSourceType,
                                                    @MActionStatus,
                                                    @MActionVersion,
                                                    @MActionCreatedById,
                                                    @MActionCreatedOn,
                                                    @MActionModifiedById,
                                                    @MActionModifiedOn,
                                                    @MenuId,
                                                    @Type,
                                                    @MActionUriTemplateValue,
                                                    @MActionActionForType,
                                                    @ReportId,
                                                    @MActionGroupByFields,
                                                    @MActionRemarks,
                                                    @ReportViewId,
                                                    @MailListId,
                                                    @MActionIsPreviousVersion,
                                                    @TenantId,
                                                    @MActionIsFileBased,
                                                    @MActionIsEncryptionRequired    
                                                );";


        public const string UPDATE_ACTION = @"UPDATE MACTION
                                            SET
                                                DESCRIPTION                 = @MActionDescription,
                                                EVENTTYPEID                 = @EventTypeId,
                                                ACTIONTYPE                  = @MActionActionType,
                                                REPLYTO                     = @MActionReplyTo,
                                                TEMPLATEID                  = @TemplateId,
                                                TODELIVERYTYPE              = @MActionToDeliveryType,
                                                TOCONTENTTYPE               = @MActionToContentType,
                                                SENDTO                      = @MActionTo,
                                                MAILCCDELIVERYTYPE          = @MActionMailCCDeliveryType,
                                                MAILCCCONTENTTYPE           = @MActionMailCCContentType,
                                                MAILCC                      = @MActionMailCC,
                                                MAILBCCDELIVERYTYPE         = @MActionMailBCCDeliveryType,
                                                MAILBCCCONTENTTYPE          = @MActionMailBCCContentType,
                                                MAILBCC                     = @MActionMailBCC,
                                                EXPORTFORMAT                = @MActionExportFormat,
                                                REPORTTYPE                  = @MActionReportType,
                                                REPORTFORMATID              = @ReportFormatId,
                                                MAILFILEID                  = @MailFileId,
                                                JOBID                       = @JobDefineId,
                                                WEBSERVICEID                = @WebServiceId,
                                                CRITERIACONFIGID            = @CriteriaConfigId,
                                                SORTORDER                   = @MActionSortOrder,
                                                SOURCETYPE                  = @MActionSourceType,
                                                STATUS                      = @MActionStatus,
                                                VERSION                     = @MActionVersion,
                                                MODIFIEDBYID                = @MActionModifiedById,
                                                MODIFIEDON                  = @MActionModifiedOn,
                                                MENUID                      = @MenuId,
                                                TYPE                        = @Type,
                                                URIPARAMETERVALUE           = @MActionUriTemplateValue,
                                                ACTIONFORTYPE               = @MActionActionForType,
                                                REPORTID                    = @ReportId,
                                                GROUPBYFIELDS               = @MActionGroupByFields,
                                                REMARKS                     = @MActionRemarks,
                                                REPORTVIEWID                = @ReportViewId,
                                                MAILLISTID                  = @MailListId,
                                                ISPREVIOUSVERSION           = @MActionIsPreviousVersion,
                                                TENANTID                    = @TenantId,
                                                ISFILEBASED                 = @MActionIsFileBased,
                                                ISENCRYPTIONREQUIRED        = @MActionIsEncryptionRequired
                                            WHERE
                                                ACTIONID = @MActionId;";

        public const string DELETE_ACTION = @"DELETE FROM MACTION
                                            WHERE ACTIONID = @mactionid;";
    }
}