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

namespace FrameworkDAL.Query.AddOnField
{
    public static class AddOnFieldQB
    {
        public const string GET_ADDONFIELD = @"
SELECT
    AF.ADDONFIELDID AS AddOnFieldId,
    AF.ENTITYID AS EntityId,
    AF.SLNO AS AddOnFieldSlNo,
    AF.FIELDNAME AS AddOnFieldFieldName,
    AF.DATATYPE AS AddOnFieldDataType,
    AF.DATASIZE AS AddOnFieldDataSize,
    AF.TYPEOFINFO AS AddOnFieldTypeOfInfo,
    AF.LOVTYPEID AS LovTypeId,
    AF.REMARKS AS AddOnFieldRemarks,
    AF.SORTORDER AS AddOnFieldSortOrder,
    AF.STATUS AS AddOnFieldStatus,
    AF.VERSION AS AddOnFieldVersion,
    AF.SOURCETYPE AS AddOnFieldSourceType,
    AF.CREATEDBYID AS AddOnFieldCreatedById,
    AF.CREATEDON AS AddOnFieldCreatedOn,
    AF.MODIFIEDBYID AS AddOnFieldModifiedById,
    AF.MODIFIEDON AS AddOnFieldModifiedOn,
    AF.FIELDDESCRIPTION AS AddOnFieldFieldDescription,
    AF.CRITERIAATTRIBUTEID AS CriteriaAttributeId,
    AF.ISMANDATORY AS AddOnFieldIsMandatory,
    AF.ISMULTISELECT AS AddOnFieldIsMultiselect
FROM
    MADDONFIELDS AF
WHERE
    AF.ADDONFIELDID = @addonfieldid;
";

        public const string GET_ADDONFIELD_BY_ENTITYID = @"
SELECT
    AF.ADDONFIELDID AS AddOnFieldId,
    AF.ENTITYID AS EntityId,
    AF.SLNO AS AddOnFieldSlNo,
    AF.FIELDNAME AS AddOnFieldFieldName,
    AF.DATATYPE AS AddOnFieldDataType,
    AF.DATASIZE AS AddOnFieldDataSize,
    AF.TYPEOFINFO AS AddOnFieldTypeOfInfo,
    AF.LOVTYPEID AS LovTypeId,
    AF.REMARKS AS AddOnFieldRemarks,
    AF.SORTORDER AS AddOnFieldSortOrder,
    AF.STATUS AS AddOnFieldStatus,
    AF.VERSION AS AddOnFieldVersion,
    AF.SOURCETYPE AS AddOnFieldSourceType,
    AF.CREATEDBYID AS AddOnFieldCreatedById,
    AF.CREATEDON AS AddOnFieldCreatedOn,
    AF.MODIFIEDBYID AS AddOnFieldModifiedById,
    AF.MODIFIEDON AS AddOnFieldModifiedOn,
    AF.FIELDDESCRIPTION AS AddOnFieldFieldDescription,
    AF.CRITERIAATTRIBUTEID AS CriteriaAttributeId,
    AF.ISMANDATORY AS AddOnFieldIsMandatory,
    AF.ISMULTISELECT AS AddOnFieldIsMultiselect
FROM
    MADDONFIELDS AF
WHERE
    AF.ENTITYID = @entityid;
";
    }
}