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