public Database.PersonInfo getCurrentPersonInfo() { if (SelectedRows.Count != 1) { return null; } if (SelectedRows[0].Cells[0].Value is DBNull) { return null; } Database.PersonInfo ret = new Database.PersonInfo(); ret.id = Convert.ToUInt64(SelectedRows[0].Cells[0].Value); ret.name = Convert.ToString(SelectedRows[0].Cells[1].Value); return ret; }
public ICollection<IPerson> getPersons() { if (!connect()) return null; ICollection<IPerson> ret = null; NpgsqlCommand command = new NpgsqlCommand("select ID, NAME from PERSON", connection); try { List<IPerson> list = new List<IPerson>(); NpgsqlDataReader rd = command.ExecuteReader(); while (rd.Read()) { UInt64 id = Convert.ToUInt64(rd["ID"]); String name = Convert.ToString(rd["NAME"]); PersonInfo info = new PersonInfo(id, name); list.Add(info); } ret = list; } catch (Exception ex) { HandleException(ex); } finally { disconnect(); } return ret; }