public void AddTagType(string typename)
{
using (SQLiteCommand cmd = new SQLiteCommand(conn))
{
cmd.CommandText = "insert into types(name) values(@Name);";
cmd.Prepare();
cmd.Parameters.AddWithValue("@Name", typename);
cmd.ExecuteNonQuery();
TagType t = new TagType(Tags) { Typeguid = (int)conn.LastInsertRowId, Typename = typename };
Types.Add(t);
}
}
public void AddTag2Type(string tagname, TagType tagtype)
{
using (SQLiteCommand cmd = new SQLiteCommand(conn))
{
cmd.CommandText = "insert into tags(name,type) values(@Name,@Type);";
cmd.Prepare();
cmd.Parameters.AddWithValue("@Name", tagname);
cmd.Parameters.AddWithValue("@Type", tagtype.Typeguid);
cmd.ExecuteNonQuery();
Tag t = new Tag() { Tagname = tagname, Tagoffset = (int)conn.LastInsertRowId, Typeguid = tagtype.Typeguid };
Tags.Add(t);
tagtype.Tags.Add(t);
}
}
