MonkeyWrench.DB.DeleteWork C# (CSharp) Method

		public void DeleteWork (int lane_id, int revision_id, int host_id)
		{
			using (IDbCommand cmd = CreateCommand ()) {
				//				cmd.CommandText = "DELETE FROM Work WHERE lane_id = @lane_id AND revision_id = @revision_id AND host_id = @host_id;";
				cmd.CommandText = @"
DELETE FROM Work 
WHERE Work.revisionwork_id = 
	(SELECT id 
	 FROM RevisionWork 
	 WHERE		lane_id = @lane_id 
			AND revision_id = @revision_id 
			AND host_id = @host_id
	);
UPDATE RevisionWork SET state = 10 WHERE lane_id = @lane_id AND host_id = @host_id AND revision_id = @revision_id;";
				DB.CreateParameter (cmd, "lane_id", lane_id);
				DB.CreateParameter (cmd, "revision_id", revision_id);
				DB.CreateParameter (cmd, "host_id", host_id);
				cmd.ExecuteNonQuery ();
			}
			//TODO: Directory.Delete(Configuration.GetDataRevisionDir(lane, revision), true);
		}