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