private void UpdateSQL()
{
queryBuilder = new CreateTriggerQueryBuilder(TriggerName)
.IfNotExists(IsIfNotExists)
.On(selectedTarget)
.ForEachRow(IsForEachRow)
.When(whenExpression)
.Do(triggerActions);
SetEntryPoint();
SetEvent();
Sql = queryBuilder.Build();
}
private void SetEntryPoint()
{
if (string.IsNullOrEmpty(selectedTriggerEntryPoint))
{
return;
}
if (SelectedTriggerEntryPoint.Equals("BEFORE"))
{
queryBuilder = queryBuilder.Before();
}
else if (SelectedTriggerEntryPoint.Equals("INSTEAD OF"))
{
queryBuilder = queryBuilder.InsteadOf();
}
else
{
queryBuilder = queryBuilder.After();
}
}
private void SetEvent()
{
if (string.IsNullOrEmpty(selectedTriggerEvent))
{
return;
}
if (selectedTriggerEvent.Equals("INSERT"))
{
queryBuilder = queryBuilder.Insert();
}
else if (selectedTriggerEvent.Equals("UPDATE"))
{
queryBuilder = queryBuilder.Update();
}
else if (selectedTriggerEvent.Equals("UPDATE OF"))
{
queryBuilder = queryBuilder.Update(Columns.Where(x => x.IsSelected).Select(x => x.ColumnName).ToList());
}
else
{
queryBuilder = queryBuilder.Delete();
}
}
