public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new NotificationDbHelper(connection, transaction); if (TemplateId.HasValue) { helper.DeleteNotificationTemplate(TemplateId.Value); } else if (DeleteAll) { var templateId = helper.GetNotificationId(Namespace, Name); if (templateId == null) { throw new Exception($"Reference list '{Namespace}.{Name}' not found"); } // delete all if filter is not specified helper.DeleteNotificationTemplates(Namespace, Name); } else { throw new NotSupportedException(); } } }; processor.Process(exp); }
public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new NotificationDbHelper(connection, transaction); var refListId = helper.InsertNotification(Namespace, Name, Description); } }; processor.Process(exp); }
public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new NotificationDbHelper(connection, transaction); var notificationId = helper.GetNotificationId(Namespace, Name); if (notificationId == null) { throw new Exception($"Notification '{Namespace}.{Name}' not found"); } if (!Template.Id.IsSet) { Template.Id.Set(Guid.NewGuid()); } var templateId = Template.Id.Value; helper.InsertNotificationTemplate(notificationId.Value, Template); if (Template.Name.IsSet) { helper.UpdateTemplateName(templateId, Template.Name.Value); } if (Template.Subject.IsSet) { helper.UpdateTemplateSubject(templateId, Template.Subject.Value); } if (Template.Body.IsSet) { helper.UpdateTemplateBody(templateId, Template.Body.Value); } if (Template.BodyFormat.IsSet) { helper.UpdateTemplateBodyFormat(templateId, Template.BodyFormat.Value); } if (Template.SendType.IsSet) { helper.UpdateTemplateSendType(templateId, Template.SendType.Value); } if (Template.IsEnabled.IsSet) { helper.UpdateTemplateIsEnabled(templateId, Template.IsEnabled.Value); } } }; processor.Process(exp); }
public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new NotificationDbHelper(connection, transaction); helper.DeleteNotificationTemplates(Namespace, Name); helper.DeleteNotification(Namespace, Name); } }; processor.Process(exp); }
public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new NotificationDbHelper(connection, transaction); var id = helper.GetNotificationId(Namespace, Name); if (id == null) { return; } if (Description.IsSet) { helper.UpdateNotificationDescription(id, Description.Value); } } }; processor.Process(exp); }
public override void ExecuteWith(IMigrationProcessor processor) { var exp = new PerformDBOperationExpression() { Operation = (connection, transaction) => { var helper = new NotificationDbHelper(connection, transaction); if (Template.Name.IsSet) { helper.UpdateTemplateName(Id, Template.Name.Value); } if (Template.Subject.IsSet) { helper.UpdateTemplateSubject(Id, Template.Subject.Value); } if (Template.Body.IsSet) { helper.UpdateTemplateBody(Id, Template.Body.Value); } if (Template.BodyFormat.IsSet) { helper.UpdateTemplateBodyFormat(Id, Template.BodyFormat.Value); } if (Template.SendType.IsSet) { helper.UpdateTemplateSendType(Id, Template.SendType.Value); } if (Template.IsEnabled.IsSet) { helper.UpdateTemplateIsEnabled(Id, Template.IsEnabled.Value); } } }; processor.Process(exp); }