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

namespace AdminDAL.Query.Reason
{
    public static class ReasonQB
    {
        public const string GET_REASON = @"SELECT
                            R.REASONID AS ReasonId,
                            R.REASONCODE AS ReasonCode,
                            R.REASONNAME AS ReasonName,
                            R.REASONTYPEID AS ReasonTypeId,
                            G.GCMCODE AS ReasonTypeCode,
                            G.GCMNAME AS ReasonTypeName,
                            R.REMARKS AS ReasonRemarks,
                            R.SORTORDER AS ReasonSortOrder,
                            R.STATUS AS ReasonStatus,
                            R.VERSION AS ReasonVersion,
                            R.CREATEDBYID AS ReasonCreatedById,
                            R.CREATEDON AS ReasonCreatedOn,
                            R.MODIFIEDBYID AS ReasonModifiedById,
                            R.MODIFIEDON AS ReasonModifiedOn,
                            R.SOURCETYPE AS ReasonSourceType,
                            R.TENANTID AS ReasonTenantId,
                            R.CATEGORY AS ReasonCategory,
                            R.ISPRODUCTIVE AS ReasonIsProductive
                            FROM MREASON R
                            LEFT JOIN MGCM G ON R.REASONTYPEID = G.GCMID
                            WHERE R.REASONID = @reasonid;
                            ";

        public const string GET_SELECTLIST_REASON = @"SELECT
                            REASONID AS Id,
                            REASONCODE AS Code,
                            REASONNAME AS Name
                            FROM MREASON
                            ";

        public const string SAVE_REASON = @"INSERT 
                            INTO MREASON (
                                 REASONID,
                                 REASONCODE,
                                 REASONNAME,
                                 REASONTYPEID,
                                 REMARKS,
                                 SORTORDER,
                                 STATUS,
                                 VERSION,
                                 CREATEDBYID,
                                 CREATEDON,
                                 MODIFIEDBYID,
                                 MODIFIEDON,
                                 SOURCETYPE,
                                 TENANTID,
                                 CATEGORY,
                                 ISPRODUCTIVE
                            ) VALUES (
                                 @ReasonId,
                                 @ReasonCode,
                                 @ReasonName,
                                 @ReasonTypeId,
                                 @ReasonRemarks,
                                 @ReasonSortOrder,
                                 @ReasonStatus,
                                 @ReasonVersion,
                                 @ReasonCreatedById,
                                 @ReasonCreatedOn,
                                 @ReasonModifiedById,
                                 @ReasonModifiedOn,
                                 @ReasonSourceType,
                                 @ReasonTenantId,
                                 @ReasonCategory,
                                 @ReasonIsProductive  
                            );
                            ";

        public const string UPDATE_REASON = @"UPDATE 
                            MREASON SET
                            REASONCODE = @ReasonCode,
                            REASONNAME = @ReasonName,
                            REASONTYPEID = @ReasonTypeId,
                            REMARKS = @ReasonRemarks,
                            SORTORDER = @ReasonSortOrder,
                            STATUS = @ReasonStatus,
                            VERSION = @ReasonVersion,
                            MODIFIEDBYID = @ReasonModifiedById,
                            MODIFIEDON = @ReasonModifiedOn,
                            SOURCETYPE = @ReasonSourceType,
                            TENANTID = @ReasonTenantId,
                            CATEGORY = @ReasonCategory,
                            ISPRODUCTIVE = @ReasonIsProductive
                            WHERE REASONID = @ReasonId;
                            ";

        public const string DELETE_REASON = @"DELETE 
                            FROM MREASON
                            WHERE REASONID = @reasonid;
                            ";
    }
}