private void ActualizeMetaData(UserConnection userConnection, MetaDataInfo metaDataInfo, bool isParentActualize = false) { var entityId = isParentActualize ? metaDataInfo.ParentId : metaDataInfo.EntityId; var entitySchemaName = isParentActualize ? metaDataInfo.ParentSchemaName : metaDataInfo.EntitySchemaName; var syncAction = isParentActualize ? SyncAction.Update : metaDataInfo.SyncAction; if (syncAction == SyncAction.Create && !IsDetailSchemaName(entitySchemaName)) { return; } var actualizeMetaData = new Update(userConnection, "SysSyncMetaData") .Set("Version", Column.Parameter(metaDataInfo.ModifiedOn)) .Set("ModifiedOn", Column.Parameter(metaDataInfo.ModifiedOn)) .Set("ModifiedInStoreId", Column.Parameter(ExchangeConsts.LocalStoreId)) .Set("LocalState", Column.Parameter(syncAction)) .Where("LocalId").IsEqual(Column.Parameter(entityId)) .And("RemoteStoreId").IsEqual(Column.Parameter(StoreId)) .And("SyncSchemaName").IsEqual(Column.Parameter(entitySchemaName)); if (syncAction != SyncAction.Delete) { actualizeMetaData = actualizeMetaData .And("CreatedById").IsEqual(Column.Parameter(metaDataInfo.UserContactId)) as Update; } actualizeMetaData.Execute(); }
private void AddResetChangedStateConditions(Update tranlationsResetQuery, IEnumerable <ISysCultureInfo> sysCulturesInfo) { tranlationsResetQuery.Where(TranslationErrorColumnName).IsEqual(Column.Parameter(string.Empty)); var changedLanguagesCondition = GetLanguageConditions(sysCulturesInfo); if (changedLanguagesCondition != null) { tranlationsResetQuery.And(changedLanguagesCondition); } }
/// <summary> /// Returns base query for <see cref="SequenceFlowElement"/> /// </summary> /// <param name="sourceRefUId">Unique identifier of the sequence's source element.</param> /// <param name="targetRefUId">Unique identifier of the sequence's target element.</param> /// <returns>Query with base logic of <see cref="SequenceFlowElement"/>.</returns> protected virtual Update GetSequenceFlowBaseUpdate(Guid sourceRefUId, Guid targetRefUId) { var result = new Update(UserConnection, CampaignParticipantTable) .Set("CampaignItemId", Column.Parameter(targetRefUId)) .Set("StepModifiedOn", Column.Parameter(DateTime.UtcNow)) .Set("StepCompletedOn", Column.Parameter(null, "DateTime")) .Set("StepCompleted", Column.Parameter(false)) .Where("StatusId").IsEqual(Column.Parameter(CampaignConstants.CampaignParticipantParticipatingStatusId)) .And("CampaignItemId") .IsEqual(Column.Parameter(sourceRefUId)) as Update; if (!SessionId.Equals(default(Guid))) { result.And(CampaignParticipantTable, "SessionId").IsEqual(Column.Parameter(SessionId)); } result.WithHints(new RowLockHint()); return(result); }