/// <summary>
/// Visszadja a adatbázisban lévő Kuldeseket
/// </summary>
/// <returns>Visszatér a Kuldesek adatokal</returns>
public List <Kuldes> getKuldesFromDatabaseTable()
{
List <Kuldes> kuldesek = new List <Kuldes>();
MySqlConnection connection = new MySqlConnection(connectionString);
try
{
connection.Open();
string query = Kuldes.getSQLCommandGetAllRecord();
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
string kikuldes = dr["Kikuldes"].ToString();
string visszaerkezes = dr["Viszaerkezes"].ToString();
bool goodResult = false;
int sid = -1;
goodResult = int.TryParse(dr["sid"].ToString(), out sid);
if (goodResult)
{
int kid = -1;
goodResult = int.TryParse(dr["kid"].ToString(), out kid);
if (goodResult)
{
int heid = -1;
goodResult = int.TryParse(dr["heid"].ToString(), out heid);
if (goodResult)
{
int teid = -1;
goodResult = int.TryParse(dr["teid"].ToString(), out teid);
if (goodResult)
{
int did = -1;
goodResult = int.TryParse(dr["did"].ToString(), out did);
if (goodResult)
{
Kuldes ku = new Kuldes(sid, kid, heid, teid, did, kikuldes, visszaerkezes);
kuldesek.Add(ku);
}
}
}
}
}
}
connection.Close();
}
catch (Exception e)
{
connection.Close();
Debug.WriteLine(e.Message);
throw new RepositoryException("kuldes beolvasása az adatbázisból nem sikerült!");
}
return(kuldesek);
}
/// <summary>
/// Teszt adatok törlése
/// </summary>
public void deleteDataFromTermekTable()
{
MySqlConnection connection = new MySqlConnection(connectionString);
try
{
connection.Open();
string query = Kuldes.getSQLCommandDeleteAllRecord();
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
connection.Close();
Debug.WriteLine(e.Message);
throw new RepositoryException("Tesztadatok törlése sikertelen.");
}
}
