public IEnumerable <VerbindingDto> VerbindingenVanLandOpvragen(string land)
{
string query = "_AlleVerbindingenVanLand";
List <VerbindingDto> resultaat = new List <VerbindingDto>();
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@land", MySqlDbType.String).Value = land;
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
VerbindingDto verbinding = new VerbindingDto(dataReader.GetString(0), dataReader.GetString(1), dataReader.GetInt32(2));
resultaat.Add(verbinding);
}
dataReader.Close();
}
catch (Exception ex)
{
resultaat = null;
throw new Exception(ex.Message);
}
this.CloseConnection();
}
return(resultaat);
}
public void VerbindingVerwijderenUitDatabase(VerbindingDto verbinding)
{
string query = "";
if (this.OpenConnection())
{
try
{
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@inkomendLand", MySqlDbType.String).Value = verbinding.aankomstLand;
cmd.Parameters.Add("@uitgaandLand", MySqlDbType.String).Value = verbinding.vertrekLand;
cmd.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
this.CloseConnection();
}
}
