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);
}
