/// <summary>
/// Removes a trigger from the rule and updates it.
/// </summary>
/// <param name="trigger"></param>
/// <returns></returns>
public string RemoveTrigger(Trigger trigger)
{
var triggerToBeRemoved = Triggers.FirstOrDefault(t => t.Id == trigger.Id);
if (triggerToBeRemoved == null)
{
return($"{trigger} was not found.");
}
Triggers.Remove(triggerToBeRemoved);
return(Update());
}
/// <summary>
/// Removes job from the databound collection
/// </summary>
/// <param name="jobName"></param>
public void RemoveJobFromTheDataSource(string jobName)
{
try
{
var trigger = Triggers.FirstOrDefault(t => t.JobName == jobName);
Triggers.Remove(trigger);
}
catch (Exception ex)
{
log.Error(ex.Message, ex);
}
}
public DatabaseObjectInfo RemoveObjectById(string id)
{
var tres = Tables.FirstOrDefault(o => o.ObjectId == id);
if (tres != null)
{
Tables.Remove(tres);
return(tres);
}
var vres = Views.FirstOrDefault(o => o.ObjectId == id);
if (vres != null)
{
Views.Remove(vres);
return(vres);
}
var pres = StoredProcedures.FirstOrDefault(o => o.ObjectId == id);
if (pres != null)
{
StoredProcedures.Remove(pres);
return(pres);
}
var fres = Functions.FirstOrDefault(o => o.ObjectId == id);
if (fres != null)
{
Functions.Remove(fres);
return(fres);
}
var rres = Triggers.FirstOrDefault(o => o.ObjectId == id);
if (rres != null)
{
Triggers.Remove(rres);
return(rres);
}
return(null);
}
//public ColumnInfo FindColumn(string table, string column)
//{
// var tbl = FindTable(table);
// if (tbl == null) return null;
// return tbl.Columns.FirstOrDefault(c => String.Compare(c.Name, column, true) == 0);
//}
public DatabaseObjectInfo FindObjectById(string id)
{
DatabaseObjectInfo res;
res = Tables.FirstOrDefault(o => o.ObjectId == id);
if (res != null)
{
return(res);
}
res = Views.FirstOrDefault(o => o.ObjectId == id);
if (res != null)
{
return(res);
}
res = StoredProcedures.FirstOrDefault(o => o.ObjectId == id);
if (res != null)
{
return(res);
}
res = Functions.FirstOrDefault(o => o.ObjectId == id);
if (res != null)
{
return(res);
}
res = Triggers.FirstOrDefault(o => o.ObjectId == id);
if (res != null)
{
return(res);
}
return(null);
}
public TriggerInfo FindTrigger(NameWithSchema fullName)
{
return(Triggers.FirstOrDefault(x => x.FullName == fullName));
}
public ITrigger FindTriggerByName(string name)
{
return(Triggers.FirstOrDefault(trigger => string.Equals(trigger.Name, name, StringComparison.CurrentCultureIgnoreCase)));
}
public ITrigger FindTriggerById(Guid triggerId)
{
return(Triggers.FirstOrDefault(trigger => trigger.TriggerId == triggerId));
}
