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

namespace MMDAL.Query.Fabric
{
    public static class FabricQB
    {
        public const string GET_SELECTLIST_FABRIC = @"SELECT
                            FABRICID AS FabricPicklistId,
                            FABRICNAME AS FabricPicklistName
                            FROM MFABRIC
                            WHERE TENANTID IN (-1, @TenantId)
                            AND (@Name IS NULL OR FABRICNAME LIKE CONCAT('%', @Name, '%'))
                            AND (@PartyId IS NULL OR @PartyId <= 0 OR PARTYID = @PartyId)
                            AND (@MerchandiserId IS NULL OR @MerchandiserId <= 0 OR MERCHANDISERID = @MerchandiserId)
                            AND (@DesignerId IS NULL OR @DesignerId <= 0 OR DESIGNERID = @DesignerId)
                            AND (@Status IS NULL OR @Status <= 0 OR STATUS = @Status)
                            AND (@IsOnlyforCosting IS NULL OR ISONLYFORCOSTING = @IsOnlyforCosting)
                            AND (@UserPartyId IS NULL OR @UserPartyId <= 0 OR PARTYID = @UserPartyId)
                            ORDER BY FABRICNAME;
                            ";
    }
}