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

namespace AdminDAL.Query.AllocationPortFolio
{
    public static class AllocationPortFolioQB
    {
        public const string GET_SELECTLIST_ALLOCATION_PORTFOLIO = @"
            SELECT 
                apf.Id,
                apf.Name,
                apf.Description,
                apf.IsActive,
                apf.CreatedBy,
                apf.CreatedDate,
                apf.UpdatedBy,
                apf.UpdatedDate
            FROM 
                AllocationPortFolio AS apf
            WHERE 
                (@Name IS NULL OR apf.Name LIKE '%' + @Name + '%')
                AND (@IsActive IS NULL OR apf.IsActive = @IsActive)
            ORDER BY 
                apf.Name";
    }
}