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

namespace FrameworkDAL.Query.ServiceRequestField
{
    public class ServiceRequestFieldQB
    {
        public const string GET_SERVICEREQUESTFIELD = @"SELECT 
                                                    SERVICEREQUESTFIELDID      AS ServiceRequestFieldId,
                                                    SERVICEREQUESTID           AS ServiceRequestId,
                                                    FIELDNAME                  AS FieldName,
                                                    FIELDDATATYPE              AS FieldDataType,
                                                    FIELDDATE                  AS FieldDate,
                                                    FIELDTEXT                  AS FieldText,
                                                    FIELDVALUE                 AS FieldValue,
                                                    FIELDID                    AS FieldId,
                                                    CREATEDBYID                AS ServiceRequestCreatedById,
                                                    CREATEDON                  AS ServiceRequestCreatedOn,
                                                    MODIFIEDBYID               AS ServiceRequestModifiedById,
                                                    MODIFIEDON                 AS ServiceRequestModifiedOn,
                                                    SORTORDER                  AS ServiceRequestSortOrder,
                                                    STATUS                     AS ServiceRequestStatus,
                                                    VERSION                    AS ServiceRequestVersion,
                                                    SOURCETYPE                 AS ServiceRequestSourceType,
                                                    TENANTID                   AS ServiceRequestTenantId
                                                FROM TSERVICEREQUESTFIELD
                                                WHERE SERVICEREQUESTFIELDID = @ServiceRequestFieldId;";

        public const string GET_SELECTLIST_SERVICEREQUESTFIELD = @"SELECT";


        public const string SAVE_SERVICEREQUESTFIELD = @"INSERT INTO TSERVICEREQUESTFIELD (
                                                        SERVICEREQUESTID,
                                                        FIELDNAME,
                                                        FIELDDATATYPE,
                                                        FIELDDATE,
                                                        FIELDTEXT,
                                                        FIELDVALUE,
                                                        FIELDID,
                                                        CREATEDBYID,
                                                        CREATEDON,
                                                        MODIFIEDBYID,
                                                        MODIFIEDON,
                                                        SORTORDER,
                                                        STATUS,
                                                        VERSION,
                                                        SOURCETYPE,
                                                        TENANTID
                                                    ) VALUES (
                                                        @ServiceRequestId,
                                                        @FieldName,
                                                        @FieldDataType,
                                                        @FieldDate,
                                                        @FieldText,
                                                        @FieldValue,
                                                        @FieldId,
                                                        @ServiceRequestCreatedById,
                                                        @ServiceRequestCreatedOn,
                                                        @ServiceRequestModifiedById,    
                                                        @ServiceRequestModifiedOn,  
                                                        @ServiceRequestSortOrder,
                                                        @ServiceRequestStatus,
                                                        @ServiceRequestVersion,
                                                        @ServiceRequestSourceType,
                                                        @ServiceRequestTenantId
                                                    );";
        public const string UPDATE_SERVICEREQUESTFIELD = @"UPDATE TSERVICEREQUESTFIELD
                                                            SET 
                                                                SERVICEREQUESTID    = @ServiceRequestId,
                                                                FIELDNAME           = @FieldName,
                                                                FIELDDATATYPE       = @FieldDataType,
                                                                FIELDDATE           = @FieldDate,
                                                                FIELDTEXT           = @FieldText,
                                                                FIELDVALUE          = @FieldValue,
                                                                FIELDID             = @FieldId,
                                                                MODIFIEDBYID        = @ServiceRequestModifiedById,
                                                                MODIFIEDON          = @ServiceRequestModifiedOn,
                                                                SORTORDER           = @ServiceRequestSortOrder,
                                                                STATUS              = @ServiceRequestStatus,
                                                                VERSION             = @ServiceRequestVersion,
                                                                SOURCETYPE          = @ServiceRequestSourceType,
                                                                TENANTID            = @ServiceRequestTenantId
                                                            WHERE SERVICEREQUESTFIELDID = @ServiceRequestFieldId;";

        public const string DELETE_SERVICEREQUESTFIELD = @" DELETE FROM TSERVICEREQUESTFIELD
                                                         WHERE SERVICEREQUESTFIELDID = @ServiceRequestFieldId;";
    
    }
}