namespace TMSDAL.Query.Promotion
{
    public static class TrainingDomainCodeLookupQB
    {
        public const string GET_CODE_BY_ID = @"
            SELECT DOMAINCODE FROM MTRAININGDOMAIN WHERE TRAININGDOMAINID = @TrainingDomainId AND TENANTID = @TenantId";

        public const string GET_ID_BY_CODE = @"
            SELECT TRAININGDOMAINID FROM MTRAININGDOMAIN WHERE DOMAINCODE = @DomainCode AND TENANTID = @TenantId";
    }
}