namespace FrameworkDAL.Query.Validation
{
    /// <summary>
    /// Required indexes: IX_MVALIDATIONCRITERIA_TENANTID on (TENANTID)
    /// </summary>
    public static class ValidationCriteriaQB
    {
        public const string GET_VALIDATIONCRITERIA = @"
SELECT  vc.VALIDATIONCRITERIAID AS ValidationCriteriaId,
        vc.VALIDATIONTYPE       AS ValidationType,
        vc.TARGETID             AS TargetId,
        vc.MINSCOREPCT          AS MinScorePct,
        vc.MINLEVEL             AS MinLevel,
        vc.VALIDITYDAYS         AS ValidityDays,
        vc.DESCRIPTION          AS Description,
        vc.ISACTIVE             AS IsActive,
        vc.VERSION              AS Version,
        vc.STATUS               AS Status,
        vc.SORTORDER            AS SortOrder,
        vc.SOURCETYPE           AS SourceType,
        vc.TENANTID             AS TenantId,
        vc.CREATEDBYID          AS CreatedById,
        vc.CREATEDON            AS CreatedOn,
        vc.MODIFIEDBYID         AS ModifiedById,
        vc.MODIFIEDON           AS ModifiedOn
FROM    DBO.MVALIDATIONCRITERIA vc
WHERE   vc.VALIDATIONCRITERIAID = @ValidationCriteriaId
AND    (vc.TENANTID = @TenantId OR vc.TENANTID = -1)";


        public const string GET_SELECTLIST_VALIDATIONCRITERIA = @"
SELECT  vc.VALIDATIONCRITERIAID AS Id,
        vc.DESCRIPTION          AS Name
FROM    DBO.MVALIDATIONCRITERIA vc
WHERE  (vc.TENANTID = @TenantId OR vc.TENANTID = -1)
AND     vc.ISACTIVE = 1
ORDER BY vc.SORTORDER, vc.DESCRIPTION";


        public const string SAVE_VALIDATIONCRITERIA = @"
INSERT INTO DBO.MVALIDATIONCRITERIA
(
    VALIDATIONCRITERIAID, VALIDATIONTYPE, TARGETID, MINSCOREPCT, MINLEVEL, VALIDITYDAYS, DESCRIPTION,
    ISACTIVE, VERSION, STATUS, SORTORDER, SOURCETYPE, TENANTID,
    CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON
)
VALUES
(
    @ValidationCriteriaId, @ValidationType, @TargetId, @MinScorePct, @MinLevel, @ValidityDays, @Description,
    @IsActive, @Version, @Status, @SortOrder, @SourceType, @TenantId,
    @CreatedById, @CreatedOn, @ModifiedById, @ModifiedOn
)";


        public const string UPDATE_VALIDATIONCRITERIA = @"
UPDATE  DBO.MVALIDATIONCRITERIA
SET     VALIDATIONTYPE = @ValidationType,
        TARGETID        = @TargetId,
        MINSCOREPCT     = @MinScorePct,
        MINLEVEL        = @MinLevel,
        VALIDITYDAYS    = @ValidityDays,
        DESCRIPTION     = @Description,
        ISACTIVE        = @IsActive,
        VERSION         = @Version,
        STATUS          = @Status,
        SORTORDER       = @SortOrder,
        MODIFIEDBYID    = @ModifiedById,
        MODIFIEDON      = @ModifiedOn
WHERE   VALIDATIONCRITERIAID = @ValidationCriteriaId
AND    (TENANTID = @TenantId OR TENANTID = -1)";


        public const string DELETE_VALIDATIONCRITERIA = @"
DELETE FROM DBO.MVALIDATIONCRITERIA
WHERE   VALIDATIONCRITERIAID = @ValidationCriteriaId
AND     TENANTID              = @TenantId";
    }
}