MonkeyWrench.DB.CreateParameter C# (CSharp) Method

		public static void CreateParameter (IDbCommand cmd, string name, object value)
		{
			DBRecord.CreateParameter (cmd, name, value);
		}

        public void ClearWork(int lane_id, int revision_id, int host_id)
        {
            using (IDbCommand cmd = CreateCommand()) {
                cmd.CommandText = @"
UPDATE 
	Work SET state = DEFAULT, summary = DEFAULT, starttime = DEFAULT, endtime = DEFAULT, duration = DEFAULT, logfile = DEFAULT, host_id = DEFAULT
WHERE
	Work.revisionwork_id = 
		(SELECT	RevisionWork.id 
			FROM RevisionWork
			WHERE RevisionWork.host_id = @host_id AND RevisionWork.lane_id = @lane_id AND RevisionWork.revision_id = @revision_id);

UPDATE 
	RevisionWork SET state = DEFAULT, lock_expires = DEFAULT, completed = DEFAULT, workhost_id = DEFAULT,
	createdtime = DEFAULT, assignedtime = DEFAULT, startedtime = DEFAULT, endtime = DEFAULT
WHERE 
		lane_id = @lane_id
	AND revision_id = @revision_id 
	AND host_id = @host_id;
";
                DB.CreateParameter(cmd, "lane_id", lane_id);
                DB.CreateParameter(cmd, "revision_id", revision_id);
                DB.CreateParameter(cmd, "host_id", host_id);
                cmd.ExecuteNonQuery();
            }
        }