/// <summary> /// Returns update query for capmaign participants synchronization. /// </summary> /// <param name="userConnection">An instance of <see cref="UserConnection"/>.</param> /// <returns>Update query for capmaign participants synchronization.</returns> protected virtual UpdateSelect GetUpdateInProgressParticipantsQuery(UserConnection userConnection) { var update = new UpdateSelect(userConnection, CampaignParticipantTableName, "cp") .Set("CampaignItemId", Column.SourceColumn(CampaignParticipantOpTableName, "CampaignItemId")) .Set("StatusId", Column.SourceColumn(CampaignParticipantOpTableName, "StatusId")) .Set("StepCompleted", Column.SourceColumn(CampaignParticipantOpTableName, "StepCompleted")) .Set("StepModifiedOn", Column.SourceColumn(CampaignParticipantOpTableName, "StepModifiedOn")) .Set("StepCompletedOn", Column.SourceColumn(CampaignParticipantOpTableName, "StepCompletedOn")) .From(CampaignParticipantOpTableName, null) .Where(ParticipantsToSyncSelect.Condition) .And("cp", "Id").IsEqual(CampaignParticipantOpTableName, "CampaignParticipantId") .And("cp", "CampaignItemId").IsEqual(CampaignParticipantOpTableName, "InitialCampaignItemId") .And("cp", "StatusId").IsEqual( Column.Parameter(CoreCampaignConsts.CampaignParticipantInProgressStatusId)) as UpdateSelect; update.WithHints(new RowLockHint()); update.SpecifyNoLockHints(); return(update); }
//Pasa productos insertados a la ventana ImportacionToProductWindow private void EventoImportacion() { UpdateSelect?.Invoke(this, EventArgs.Empty); }