/// <summary>
/// Adatok feltöltése litából vagy adatbázisból
/// </summary>
/// <returns></returns>
public List <Megrendelo2> getOrdersFromDatabaseTable()
{
List <Megrendelo2> orders = new List <Megrendelo2>();
MySqlConnection connection = new MySqlConnection(connectionString);
try
{
connection.Open();
string query = Megrendelo2.getSQLCommandGetAllRecord();
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
string name = dr["name"].ToString();
string address = dr["address"].ToString();
bool goodResult = false;
int id = -1;
goodResult = int.TryParse(dr["id"].ToString(), out id);
if (goodResult)
{
int price = -1;
goodResult = int.TryParse(dr["price"].ToString(), out price);
if (goodResult)
{
Megrendelo2 m = new Megrendelo2(id, name, address, price);
orders.Add(m);
}
}
}
connection.Close();
}
catch (Exception e)
{
connection.Close();
Debug.WriteLine(e.Message);
throw new RepositoryException("Megrendelők beolvasása az adatbázisból nem sikerült!");
}
return(orders);
}
