private void lbox_varosok_SelectedIndexChanged(object sender, EventArgs e)
{
lbox_varoslatvanyossagai.Items.Clear();
Varos v = (Varos)lbox_varosok.SelectedItem;
int id = getId(v);
string sql = @"
SELECT nev, leiras, ar, varos_id
FROM latvanyossagok
WHERE varos_id=@id
";
var comm = this.conn.CreateCommand();
comm.CommandText = sql;
comm.Parameters.AddWithValue("@id", id);
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
string nev = reader.GetString("nev");
string leairas = reader.GetString("leiras");
int ar = reader.GetInt32("ar");
int varosid = reader.GetInt32("varos_id");
Latvanyossag l = new Latvanyossag(nev, leairas, ar, varosid);
lbox_varoslatvanyossagai.Items.Add(l);
}
}
string tboxbanev = v.Nev;
txtbx_varosneve.Text = Convert.ToString(tboxbanev);
int tboxbalakossag = v.Lakossag;
numupd_varoslakossag.Value = tboxbalakossag;
}
private void btn_latvanyossaghozzaad_Click(object sender, EventArgs e)
{
if (txtbx_latvanyossagneve.Text.Length > 0 && rtbox_latvanyossagleiras.Text.Length > 0 && numupd_latvanyossagara.Value > 0 && lbox_varosok.SelectedIndex > -1)
{
string nev = txtbx_latvanyossagneve.Text;
string leiras = rtbox_latvanyossagleiras.Text;
int ar = Convert.ToInt32(numupd_latvanyossagara.Value);
Varos v = (Varos)lbox_varosok.SelectedItem;
int varosid = getId(v);
var insertComm = conn.CreateCommand();
insertComm.CommandText = @"
INSERT INTO latvanyossagok (nev,leiras,ar,varos_id)
VALUES(@nev,@leiras,@ar,@varos_id)
";
insertComm.Parameters.AddWithValue("@nev", nev);
insertComm.Parameters.AddWithValue("@leiras", leiras);
insertComm.Parameters.AddWithValue("@ar", ar);
insertComm.Parameters.AddWithValue("@varos_id", varosid);
insertComm.ExecuteNonQuery();
Latvanyossag l = new Latvanyossag(nev, leiras, ar, varosid);
v.setLavanyossagok(l);
}
else
{
MessageBox.Show("Hiba! Nem megfelelő értékek", "Hiba!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
