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