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

namespace FrameworkDAL.Query.WebServiceCriteria
{
    public static class WebServiceCriteriaQB
    {
        public const string GET_WEBSERVICE_CRITERIA = @"SELECT
                        A.WEBSERVICECRITERIAID AS WebServiceCriteriaId,

                        A.WEBSERVICEID AS WebServiceId,
                        B.WEBSERVICENAME AS WebServiceName,

                        A.SLNO AS WebServiceCriteriaSlNo,

                        A.CRITERIAATTRIBUTEID AS CriteriaAttributeId,
                        C.CRITERIAATTRIBUTENAME AS CriteriaAttributeName,
                        C.APPLICABLEOPERATION AS CriteriaAttributeApplicableOperation,
                        C.VARIABLEFIELD AS CriteriaAttributeVariableField,
                        C.CRITERIAATTRIBUTETYPE AS CriteriaAttributeType,
                        C.APPLICABLEVALUES AS CriteriaAttributeApplicableValues,

                        A.ISCOMPULSORY AS WebServiceCriteriaIsCompulsory,
                        A.ISHEADER AS WebServiceCriteriaIsHeader,
                        A.DISPLAYNAME AS WebServiceCriteriaDisplayName,
                        A.FIELDNAME AS WebServiceCriteriaFieldName,
                        A.PICKLISTFIELDNAME AS WebServiceCriteriaPicklistFieldName,
                        A.QUERYCRITERIAFIELDNAME AS WebServiceCriteriaQueryCriteriaFieldName,
                        A.SLNO AS WebServiceCriteriaDisplaySlNo,
                        A.DEPENDPICKLISTNAME AS WebServiceCriteriaDependPicklistName,
                        A.DEPENDFIELDNAME AS WebServiceCriteriaDependFieldName,

                        A.CREATEDBYID AS WebServiceCriteriaCreatedById,
                        A.CREATEDON AS WebServiceCriteriaCreatedOn,
                        A.MODIFIEDBYID AS WebServiceCriteriaModifiedById,
                        A.MODIFIEDON AS WebServiceCriteriaModifiedOn,

                        A.SORTORDER AS WebServiceCriteriaSortOrder,
                        A.STATUS AS WebServiceCriteriaStatus,
                        A.VERSION AS WebServiceCriteriaVersion,
                        A.SOURCETYPE AS WebServiceCriteriaSourceType
                    FROM MWEBSERVICECRITERIA A
                    LEFT JOIN MWEBSERVICE B ON A.WEBSERVICEID = B.WEBSERVICEID
                    LEFT JOIN MCRITERIAATTRIBUTE C ON A.CRITERIAATTRIBUTEID = C.CRITERIAATTRIBUTEID
                    WHERE
                    A.WEBSERVICEID = @webserviceid;";

    }
}