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

namespace FrameworkDAL.Query.ServiceRequest
{
    public class ServiceRequestQB
    {
        public const string GET_SERVICEREQUEST = @"SELECT
                                               TSR. SERVICEREQUESTID AS ServiceRequestId,
                                               TSR. SERVICEREQUESTTYPEID AS ServiceRequestTypeId,
                                               TSR. OUID AS OUId,
                                               TSR. BIZTRANSACTIONTYPEID AS BizTransactionTypeId,
                                               TSR. TITLE AS Title,
                                               TSR. SERVICEREQUESTNUMBER AS ServiceRequestNumber,
                                               TSR. SERVICEREQUESTDATE AS ServiceRequestDate,
                                               TSR. REFERENCENUMBER AS ReferenceNumber,
                                               TSR. REFERENCEDATE AS ReferenceDate,
                                               TSR. DESCRIPTION AS Description,
                                               TSR. REQUESTEDBYID AS RequestedById,
                                               TSR. ASSIGNEDTOID AS AssignedToId,
                                               TSR. PRIORITY AS Priority,
                                               TSR. CRITICALITY AS Criticality,
                                               TSR. REQUESTSTATUS AS RequestStatus,
                                               TSR. CUSTOMDATA AS CustomData,
                                               TSR. SLARESPONSEDUE AS SlaResponseDue,
                                               TSR. SLARESOLUTIONDUE AS SlaResolutionDue,
                                               TSR. FIRSTRESPONSEAT AS FirstResponseAt,
                                               TSR. RESOLVEDAT AS ResolvedAt,
                                               TSR. CLOSEDAT AS ClosedAt,
                                               TSR. CREATEDBYID AS ServiceRequestCreatedById,
                                               TSR. CREATEDON AS ServiceRequestCreatedOn,
                                               TSR. MODIFIEDBYID AS ServiceRequestModifiedById,
                                               TSR. MODIFIEDON AS ServiceRequestModifiedOn,
                                               TSR. SORTORDER AS ServiceRequestSortOrder,
                                               TSR. STATUS AS ServiceRequestStatus,
                                               TSR. VERSION AS ServiceRequestVersion,
                                               TSR. SOURCETYPE AS ServiceRequestSourceType,
                                               TSR. TENANTID AS ServiceRequestTenantId
                                            FROM TSERVICEREQUEST TSR
                                            WHERE SERVICEREQUESTID = @servicerequestid;";

        public const string GET_SELECTLIST_SERVICEREQUEST = @"SELECT ";

        public const string SAVE_SERVICEREQUEST = @"INSERT INTO TSERVICEREQUEST (
                                                    SERVICEREQUESTTYPEID,
                                                    OUID,
                                                    BIZTRANSACTIONTYPEID,
                                                    TITLE,
                                                    SERVICEREQUESTNUMBER,
                                                    SERVICEREQUESTDATE,
                                                    REFERENCENUMBER,
                                                    REFERENCEDATE,
                                                    DESCRIPTION,
                                                    REQUESTEDBYID,
                                                    ASSIGNEDTOID,
                                                    PRIORITY,
                                                    CRITICALITY,
                                                    REQUESTSTATUS,
                                                    CUSTOMDATA,
                                                    SLARESPONSEDUE,
                                                    SLARESOLUTIONDUE,
                                                    FIRSTRESPONSEAT,
                                                    RESOLVEDAT,
                                                    CLOSEDAT,
                                                    CREATEDBYID,
                                                    CREATEDON,
                                                    MODIFIEDBYID,
                                                    MODIFIEDON,
                                                    SORTORDER,
                                                    STATUS,
                                                    VERSION,
                                                    SOURCETYPE,
                                                    TENANTID
                                                )
                                                VALUES (
                                                    @ServiceRequestTypeId,
                                                    @OUId,
                                                    @BizTransactionTypeId,
                                                    @Title,
                                                    @ServiceRequestNumber,
                                                    @ServiceRequestDate,
                                                    @ReferenceNumber,
                                                    @ReferenceDate,
                                                    @Description,
                                                    @RequestedById,
                                                    @AssignedToId,
                                                    @Priority,
                                                    @Criticality,
                                                    @RequestStatus,
                                                    @CustomData,
                                                    @SlaResponseDue,
                                                    @SlaResolutionDue,
                                                    @FirstResponseAt,
                                                    @ResolvedAt,
                                                    @ClosedAt,
                                                    @ServiceRequestCreatedById,
                                                    @ServiceRequestCreatedOn,
                                                    @ServiceRequestModifiedById,
                                                    @ServiceRequestModifiedOn,
                                                    @ServiceRequestSortOrder,
                                                    @ServiceRequestStatus,
                                                    @ServiceRequestVersion,
                                                    @ServiceRequestSourceType,
                                                    @ServiceRequestTenantId);";

        public const string UPDATE_SERVICEREQUEST = @"UPDATE TSERVICEREQUEST
                                                    SET 
                                                        SERVICEREQUESTTYPEID = @ServiceRequestTypeId,
                                                        OUID = @OUId,
                                                        BIZTRANSACTIONTYPEID = @BizTransactionTypeId,
                                                        TITLE = @Title,
                                                        SERVICEREQUESTNUMBER = @ServiceRequestNumber,
                                                        SERVICEREQUESTDATE = @ServiceRequestDate,
                                                        REFERENCENUMBER = @ReferenceNumber,
                                                        REFERENCEDATE = @ReferenceDate,
                                                        DESCRIPTION = @Description,
                                                        REQUESTEDBYID = @RequestedById,
                                                        ASSIGNEDTOID = @AssignedToId,
                                                        PRIORITY = @Priority,
                                                        CRITICALITY = @Criticality,
                                                        REQUESTSTATUS = @RequestStatus,
                                                        CUSTOMDATA = @CustomData,
                                                        SLARESPONSEDUE = @SlaResponseDue,
                                                        SLARESOLUTIONDUE = @SlaResolutionDue,
                                                        FIRSTRESPONSEAT = @FirstResponseAt,
                                                        RESOLVEDAT = @ResolvedAt,
                                                        CLOSEDAT = @ClosedAt,
                                                        CREATEDBYID = @ServiceRequestCreatedById,  
                                                        CREATEDON = @ServiceRequestCreatedOn,
                                                        MODIFIEDBYID = @ServiceRequestModifiedById,
                                                        MODIFIEDON = @ServiceRequestModifiedOn,
                                                        SORTORDER = @ServiceRequestSortOrder,
                                                        STATUS = @ServiceRequestStatus,
                                                        VERSION = @ServiceRequestVersion,
                                                        SOURCETYPE = @ServiceRequestSourceType,
                                                        TENANTID = @ServiceRequestTenantId
                                                    WHERE SERVICEREQUESTID = @ServiceRequestId";

        public const string DELETE_SERVICEREQUEST = @"DELETE FROM TSERVICEREQUEST
                                                    WHERE SERVICEREQUESTID = @servicerequestid;";


    }
}