private List<short_entity> GetShortEntities(string query)
{
List<short_entity> list_entities = new List<short_entity>();
if (OpenConnection())
{
using (MySqlCommand cmd = new MySqlCommand(query, connection))
{
MySqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
short_entity e = new short_entity()
{
uid = dataReader.GetUInt32(0),
name = dataReader.IsDBNull(1) ? null : dataReader.GetString(1),
description = dataReader.IsDBNull(2) ? null : dataReader.GetString(2)
};
list_entities.Add(e);
}
}
dataReader.Close();
}
this.CloseConnection();
}
return list_entities;
}
private short_entity GetShortEntity(string query)
{
var new_short_entity = new short_entity();
if (OpenConnection())
{
using (MySqlCommand cmd = new MySqlCommand(query, connection))
{
MySqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
new_short_entity = new short_entity()
{
uid = dataReader.GetUInt32(0),
name = dataReader.IsDBNull(1) ? null : dataReader.GetString(1),
description = dataReader.IsDBNull(2) ? null : dataReader.GetString(2)
};
}
}
dataReader.Close();
}
this.CloseConnection();
}
return new_short_entity;
}