public IEnumerable <IMapSpawnTable> Execute(MapID id) { var ret = new List <IMapSpawnTable>(); using (var r = ExecuteReader(id)) { while (r.Read()) { var values = new MapSpawnTable(); values.ReadValues(r); ret.Add(values); } } return(ret); }
public IMapSpawnTable Execute(MapSpawnValuesID id) { MapSpawnTable ret; using (var r = ExecuteReader(id)) { if (!r.Read()) { return(null); } ret = new MapSpawnTable(); ret.ReadValues(r); } return(ret); }
/// <summary> /// Handles the Click event of the <see cref="btnNew"/> control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> void btnNew_Click(object sender, EventArgs e) { var map = Map; if (map == null) { return; } // Create new spawn var charID = CharacterTemplateManager.Instance.First().TemplateTable.ID; var value = new MapSpawnTable { MapID = map.ID, Amount = 1, CharacterTemplateID = charID }; var q = DbControllerBase.GetInstance().GetQuery <InsertMapSpawnQuery>(); q.Execute(value); // Update list lstSpawns.ReloadSpawns(); }