public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new ReferenceListDbHelper(connection, transaction); var id = helper.GetReferenceListId(Namespace, Name); if (id == null) { return; } if (Description.IsSet) { helper.UpdateReferenceListDescription(id, Description.Value); } if (NoSelectionValue.IsSet) { helper.UpdateReferenceListNoSelectionValue(id, NoSelectionValue.Value); } } }; processor.Process(exp); }
public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new ReferenceListDbHelper(connection, transaction); var refListId = helper.GetReferenceListId(Namespace, Name); if (refListId == null) { throw new Exception($"Reference list '{Namespace}.{Name}' not found"); } if (DeleteAll) { // delete all if filter is not specified helper.DeleteReferenceListItems(Namespace, Name); } else if (ItemValue.HasValue) { helper.DeleteReferenceListItem(Namespace, Name, ItemValue.Value); } } }; processor.Process(exp); }
public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new ReferenceListDbHelper(connection, transaction); var refListId = helper.GetReferenceListId(Namespace, Name); if (refListId == null) { throw new Exception($"Reference list '{Namespace}.{Name}' not found"); } helper.InsertReferenceListItem(refListId.Value, Item); } }; processor.Process(exp); }
public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new ReferenceListDbHelper(connection, transaction); var listId = helper.GetReferenceListId(Namespace, Name); if (listId == null) { throw new Exception($"ReferenceList '{Namespace}.{Name}' not found"); } var itemId = helper.GetReferenceListItemId(listId.Value, ItemValue); if (itemId == null) { throw new Exception($"Item {ItemValue} not found in the ReferenceList '{Namespace}.{Name}'"); } if (ItemText.IsSet) { helper.UpdateReferenceListItemText(itemId, ItemText.Value); } if (Description.IsSet) { helper.UpdateReferenceListItemDescription(itemId, Description.Value); } if (OrderIndex.IsSet) { helper.UpdateReferenceListItemOrderIndex(itemId, OrderIndex.Value); } } }; processor.Process(exp); }