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