/// <summary>
/// delete script by script id
/// </summary>
/// <remarks>
/// 1. get script steps id
/// 2. for each step id delete actions from action table
/// 3. for each step id delete conditions from condition table
/// 4. delete script steps from step table
/// 5. delete script
/// </remarks>
/// <param name="id"></param>
public void DeleteScript(int id)
{
var step_ids = from ids in DB.step
where ids.script_id == id
select ids.id;
foreach (var sid in step_ids)
{
queries.DeleteStepActionsById(sid);
queries.DeleteStepConditionsById(sid);
}
queries.DeleteStepsByScriptId(id);
queries.DeleteScriptById(id);
SaveChanges("action", "condition", "step", "script");
Reload();
}
