private void varosTorles_Click(object sender, EventArgs e)
{
if (listBoxfelvettVarosok.SelectedIndex == -1)
{
MessageBox.Show("Nincs város kiválasztva!");
return;
}
listBoxLatvanyossagok.Items.Clear();
var cmd = conn.CreateCommand();
cmd.CommandText = "DELETE FROM varosok where id = @id and (SELECT varos_id FROM latvanyossagok where varos_id = varosok.id)";
var varos = (varosok)listBoxfelvettVarosok.SelectedItem;
cmd.Parameters.AddWithValue("@id", varos.Id);
var cmd2 = conn.CreateCommand();
cmd2.CommandText = "SELECT id, nev, lakossag FROM varosok ORDER BY nev";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = reader.GetInt32("id");
var nev = reader.GetString("nev");
var lakossag = reader.GetInt32("lakossag");
var varoska = new varosok(id, nev, lakossag);
listBoxfelvettVarosok.Items.Add(varoska);
listBoxLatvanyossagok.Items.Add(varoska);
}
//if (varos.Id == )
}
cmd.ExecuteNonQuery();
varosokKilistazasa();
}
void varosokKilistazasa()
{
listBoxfelvettVarosok.Items.Clear();
var cmd = conn.CreateCommand();
cmd.CommandText = "SELECT id, nev, lakossag FROM varosok ORDER BY nev";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = reader.GetInt32("id");
var nev = reader.GetString("nev");
var lakossag = reader.GetInt32("lakossag");
var varoska = new varosok(id, nev, lakossag);
listBoxfelvettVarosok.Items.Add(varoska);
listBoxLatvanyossagok.Items.Add(varoska);
}
}
}
void varosListaz()
{
listVaros.Items.Clear();
var command = conn.CreateCommand();
if (listVaros.SelectedIndex == 0)
{
}
command.CommandText = @"SELECT id,nev,lakossag FROM varosok ORDER BY nev";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = reader.GetInt32("id");
var nev = reader.GetString("nev");
var lakossag = reader.GetInt32("lakossag");
var varos = new varosok(id, nev, lakossag);
listVaros.Items.Add(varos);
}
}
}
