namespace PartnerDAL.Query.PartnerSync
{
    public static class PartnerSyncQB
    {
        public const string GET_DATASET_ID_BY_CODE = @"
            SELECT ISNULL(DATASETID, 0)
            FROM   MDATASET
            WHERE  DATASETCODE = @DatasetCode
              AND  STATUS      = 1";

        public const string GET_PARTNER_PRODUCT_IDS = @"
            SELECT PARTNERPRODUCTID
            FROM   TPARTNERPRODUCT
            WHERE  PARTNERID = @PartnerId
              AND  STATUS    = 1";

        public const string GET_SYNCJOB_BY_DESCRIPTION = @"
            SELECT TOP 1 SYNCJOBID
            FROM   TDSYNCJOB
            WHERE  DESCRIPTION = @Description";

        public const string SAVE_PARTNER_SYNCJOB = @"
            INSERT INTO TDSYNCJOB (
                SYNCJOBID, DESCRIPTION, SOURCEDBINSTANCEID, TARGETDBINSTANCEID,
                DATASETID, SCHEDULERID, CONFLICTPOLICY, DIRECTION, ISENABLED,
                QUERYCONDITION, LASTINSERTEDTILL, LASTUPDATEDTILL, LASTDELETETILL,
                SORTORDER, STATUS, VERSION, SOURCETYPE,
                CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON
            ) VALUES (
                @SyncJobId, @Description, @SourceDbInstanceId, @TargetDbInstanceId,
                @DatasetId, @SchedulerId, @ConflictPolicy, @Direction, @IsEnabled,
                @QueryCondition, @LastInsertedTill, @LastUpdatedTill, @LastDeleteTill,
                @SortOrder, @Status, @Version, @SourceType,
                @CreatedById, @CreatedOn, @ModifiedById, @ModifiedOn
            )";

        public const string UPDATE_SYNCJOB_PROVISION = @"
            UPDATE TDSYNCJOB
               SET QUERYCONDITION    = @QueryCondition,
                   SOURCEDBINSTANCEID = @SourceDbInstanceId,
                   TARGETDBINSTANCEID = @TargetDbInstanceId,
                   MODIFIEDBYID      = @ModifiedById,
                   MODIFIEDON        = @ModifiedOn
             WHERE SYNCJOBID = @SyncJobId";
    }
}