public override int InsertMember(int version_id, string name, bool is_todo, bool is_missing, bool is_niex, bool is_fixed, string fixed_in, string comment)
{
IDbConnection cnc = GetConnection ();
try {
IDbCommand cmd = cnc.CreateCommand ();
cmd.Transaction = transaction;
cmd.CommandText = "insert_member";
cmd.CommandType = CommandType.StoredProcedure;
AddParameter (cmd, "version_id", version_id);
AddParameter (cmd, "name", name);
AddParameter (cmd, "is_todo", is_todo);
AddParameter (cmd, "is_missing", is_missing);
AddParameter (cmd, "is_niex", is_niex);
AddParameter (cmd, "is_fixed", is_fixed);
AddParameter (cmd, "fixed_in_version", fixed_in);
AddParameter (cmd, "todo_comment", comment);
IDataParameter p = AddOutputParameter (cmd, "id");
if (cmd.ExecuteNonQuery () != 1)
throw new ApplicationException ("Error inserting new member");
return Convert.ToInt32 (p.Value);
} finally {
if (transaction == null)
cnc.Close ();
}
}