private void btn_varos_edit_Click(object sender, EventArgs e)
{
Varosok v = (Varosok)lbox_varosok.SelectedItem;
int id = v.Id;
int lakossag = Convert.ToInt32(numeric_lakossag.Value);
List <Latvanyossagok> lista = new List <Latvanyossagok>();
List <string> varosnevek = new List <string>();
for (int i = 0; i < lbox_varosok.Items.Count; i++)
{
Varosok va = (Varosok)lbox_varosok.Items[i];
varosnevek.Add(va.Nev);
}
if (varosnevek.Contains(text_nev.Text))
{
MessageBox.Show("ilyen város név már létezik!");
text_nev.Text = v.Nev;
}
else
{
Varosok v2 = new Varosok(id, text_nev.Text, lakossag, lista);
lbox_varosok.Items[lbox_varosok.SelectedIndex] = v2;
var editComm = conn.CreateCommand();
editComm.CommandText = @"
UPDATE varosok SET nev = @nev, lakossag = @lakossag WHERE varosok.id = @id;
";
editComm.Parameters.AddWithValue("@id", id);
editComm.Parameters.AddWithValue("@nev", text_nev.Text);
editComm.Parameters.AddWithValue("@lakossag", lakossag);
int erintettSorok = editComm.ExecuteNonQuery();
}
}
internal VarosModositas(Varosok v)
{
selectedVaros = v;
conn = new MySqlConnection("Server=localhost;Port=3307;Database=latvanyossagokdb;Uid=root;");
conn.Open();
InitializeComponent();
}
void varosadatBetoltes()
{
string sql = @"
SELECT id, nev, lakossag
FROM `varosok`
ORDER BY ID
";
var comm = this.conn.CreateCommand();
comm.CommandText = sql;
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
int id = reader.GetInt32("id");
string nev = reader.GetString("nev");
int lakossag = reader.GetInt32("lakossag");
List <Latvanyossagok> lista = new List <Latvanyossagok>();
//string uzlet;
//try
//{
// uzlet = reader.GetString("uzlet");
//}
//catch (SqlNullValueException ex)
//{
// uzlet = null;
//}
var varos = new Varosok(id, nev, lakossag, lista);
lbox_varosok.Items.Add(varos);
}
}
}
public void VarosokListaz()
{
lib_varosok.Items.Clear();
var command = conn.CreateCommand();
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 varosok = new Varosok(id, nev, lakossag);
lib_varosok.Items.Add(varosok);
}
}
}
private void latvanyossagujratolt()
{
lbox_varos_latvanyossagok.Items.Clear();
Varosok v = (Varosok)lbox_varosok.SelectedItem;
string sql = @"
SELECT `id`, `nev`, `leiras`, `ar`, `varos_id`
FROM `latvanyossagok`
WHERE varos_id = @kivalasztott_varosid";
int vid = lbox_varosok.SelectedIndex + 1;
var comm = this.conn.CreateCommand();
comm.CommandText = sql;
comm.Parameters.AddWithValue("@kivalasztott_varosid", vid);
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
int id = reader.GetInt32("id");
string nev = reader.GetString("nev");
string leiras = reader.GetString("leiras");
int ar = reader.GetInt32("ar");
int varos_id = reader.GetInt32("varos_id");
v.Latvanyossagok.Add(new Latvanyossagok(id, nev, leiras, ar, varos_id));
var latvany = new Latvanyossagok(id, nev, leiras, ar, varos_id);
lbox_varos_latvanyossagok.Items.Add(latvany);
}
}
}
private void btn_varos_delete_Click(object sender, EventArgs e)
{
int latvanyossagdb = latvanyossagokszama();
if (latvanyossagdb == 0)
{
var deleteComm = conn.CreateCommand();
deleteComm.CommandText = @"
DELETE FROM `varosok` WHERE varosok.id = @id;
";
var foreigncheckonComm = conn.CreateCommand();
foreigncheckonComm.CommandText = @"SET FOREIGN_KEY_CHECKS=0;";
foreigncheckonComm.ExecuteNonQuery();
Varosok v = (Varosok)lbox_varosok.SelectedItem;
int id = v.Id;
deleteComm.Parameters.AddWithValue("@id", id);
int erintettSorok = deleteComm.ExecuteNonQuery();
lbox_varosok.Items.RemoveAt(lbox_varosok.SelectedIndex);
var foreigncheckoffComm = @"SET FOREIGN_KEY_CHECKS=0;";
foreigncheckonComm.ExecuteNonQuery();
btn_varos_delete.Visible = false;
btn_varos_edit.Visible = false;
}
else
{
MessageBox.Show("Ennek a városnak van látványossága nem lehet törölni!");
}
}
private void VarosokListBox_SelectedIndexChanged(object sender, EventArgs e)
{
if (VarosokListBox.SelectedIndex > -1)
{
Varosok v = (Varosok)VarosokListBox.SelectedItem;
nevtb.Text = v.Nev;
numLakossag.Value = v.Lakossag;
}
}
private void lbox_varosok_SelectedIndexChanged(object sender, EventArgs e)
{
btn_varos_delete.Visible = true;
btn_varos_edit.Visible = true;
lbox_varos_latvanyossagok.Items.Clear();
Varosok v = (Varosok)lbox_varosok.SelectedItem;
if (lbox_varosok.SelectedItem == null)
{
text_nev.Text = " ";
numeric_lakossag.Value = 0;
}
else
{
//nup_test.Value = v.Id;
text_nev.Text = v.Nev;
numeric_lakossag.Value = v.Lakossag;
}
//nup_test.Value = lbox_varosok.SelectedIndex+1;
string sql = @"
SELECT `id`, `nev`, `leiras`, `ar`, `varos_id`
FROM `latvanyossagok`
WHERE varos_id = @kivalasztott_varosid";
int vid = lbox_varosok.SelectedIndex + 1;
var comm = this.conn.CreateCommand();
comm.CommandText = sql;
comm.Parameters.AddWithValue("@kivalasztott_varosid", vid);
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
int id = reader.GetInt32("id");
string nev = reader.GetString("nev");
string leiras = reader.GetString("leiras");
int ar = reader.GetInt32("ar");
int varos_id = reader.GetInt32("varos_id");
v.Latvanyossagok.Add(new Latvanyossagok(id, nev, leiras, ar, varos_id));
var latvany = new Latvanyossagok(id, nev, leiras, ar, varos_id);
lbox_varos_latvanyossagok.Items.Add(latvany);
}
}
}
public void VarosListazas()
{
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 varosok = new Varosok(id, nev, lakossag);
}
}
}
void comboboxfeltoltes()
{
cbox_varos.Items.Clear();
List <string> varosnevek = new List <string>();
for (int i = 0; i < lbox_varosok.Items.Count; i++)
{
Varosok va = (Varosok)lbox_varosok.Items[i];
varosnevek.Add(va.Nev);
}
for (int i = 0; i < varosnevek.Count; i++)
{
cbox_varos.Items.Add(varosnevek[i]);
}
}
private void btnModositL_Click(object sender, EventArgs e)
{
string nev = LatNevText.Text;
string leiras = LeirasText.Text;
int ar = Convert.ToInt32(numAr.Value);
Varosok v = (Varosok)VarosokListBox.SelectedItem;
var comm = this.conn.CreateCommand();
comm.Parameters.AddWithValue("@nev", nev);
string sql = "";
sql = @"SELECT id
FROM latvanyossagok
WHERE nev=@nev";
comm.CommandText = sql;
int id = 0;
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
id = Convert.ToInt32(reader.GetString(0));
}
}
sql = @"UPDATE latvanyossagok
SET id=@id, nev=@nev,leiras=@leiras,ar=@ar,varos_id=@varosid
WHERE id=@id";
comm.CommandText = sql;
comm.Parameters.AddWithValue("@id", id);
comm.Parameters.AddWithValue("@leiras", leiras);
comm.Parameters.AddWithValue("@ar", ar);
if (VarosokListBox.SelectedIndex < 0)
{
MessageBox.Show("A várost mindenképp választani kell");
}
else
{
comm.Parameters.AddWithValue("@varosid", v.Id);
comm.ExecuteNonQuery();
LatvanyossagList.Items.RemoveAt(LatvanyossagList.SelectedIndex);
LatvanyossagList.Items.Add(new Latvanyossag(id, nev, leiras, ar, v.Id));
LatvanyossagList.SelectedIndex = -1;
}
}
void VarosListazas()
{
Varosok_ListBox.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 varosok = new Varosok(id, nev, lakossag);
Varosok_ListBox.Items.Add(varosok);
}
}
comboBoxElemek();
}
private int latvanyossagokszama()
{
Varosok v = (Varosok)lbox_varosok.SelectedItem;
if (lbox_varosok.SelectedItem == null)
{
text_nev.Text = " ";
numeric_lakossag.Value = 0;
}
else
{
//nup_test.Value = v.Id;
text_nev.Text = v.Nev;
numeric_lakossag.Value = v.Lakossag;
}
string sql = @"
SELECT `id`, `nev`, `leiras`, `ar`, `varos_id`
FROM `latvanyossagok`
WHERE varos_id = @kivalasztott_varosid";
int vid = lbox_varosok.SelectedIndex + 1;
var comm = this.conn.CreateCommand();
comm.CommandText = sql;
comm.Parameters.AddWithValue("@kivalasztott_varosid", vid);
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
int id = reader.GetInt32("id");
string nev = reader.GetString("nev");
string leiras = reader.GetString("leiras");
int ar = reader.GetInt32("ar");
int varos_id = reader.GetInt32("varos_id");
v.Latvanyossagok.Add(new Latvanyossagok(id, nev, leiras, ar, varos_id));
}
}
return(v.Latvanyossagok.Count);
}
private void LatvanyossagSubmit_Click(object sender, EventArgs e)
{
string nev = LatNevText.Text;
string leiras = LeirasText.Text;
int ar = Convert.ToInt32(numAr.Value);
Varosok v = (Varosok)VarosokListBox.SelectedItem;
if (nev == "" && leiras == "" && VarosokListBox.SelectedIndex < 0)
{
MessageBox.Show("Hiányzó adat");
}
else
{
string sql = @"INSERT INTO latvanyossagok(nev,leiras,ar,varos_id)
VALUES (@nev,@leiras,@ar,@varos_id)";
var comm = conn.CreateCommand();
comm.CommandText = sql;
comm.Parameters.AddWithValue("@nev", nev);
comm.Parameters.AddWithValue("@leiras", leiras);
comm.Parameters.AddWithValue("@ar", ar);
comm.Parameters.AddWithValue("@varos_id", v.Id);
comm.ExecuteNonQuery();
sql = @"SELECT id
FROM latvanyossagok
WHERE nev=@nev";
comm.CommandText = sql;
int id = 0;
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
id = Convert.ToInt32(reader.GetString(0));
}
}
Latvanyossag lv = new Latvanyossag(id, nev, leiras, ar, v.Id);
LatvanyossagList.Items.Add(lv);
}
}
private void adatbetoltes()
{
LatvanyossagList.Items.Clear();
string sql = @"SELECT `id`, `nev`, `lakossag`
FROM `varosok`";
var comm = conn.CreateCommand();
comm.CommandText = sql;
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
int id = Convert.ToInt32(reader.GetString(0));
string nev = reader.GetString(1);
int lakossag = Convert.ToInt32(reader.GetString(2));
Varosok v = new Varosok(id, nev, lakossag);
VarosokListBox.Items.Add(v);
}
}
sql = @"SELECT *
FROM latvanyossagok";
comm = conn.CreateCommand();
comm.CommandText = sql;
using (var reader = comm.ExecuteReader())
{
while (reader.Read())
{
int id = Convert.ToInt32(reader.GetString(0));
string nev = reader.GetString(1);
string leiras = reader.GetString(2);
int ar = Convert.ToInt32(reader.GetString(3));
int varos_id = Convert.ToInt32(reader.GetString(4));
Latvanyossag lv = new Latvanyossag(id, nev, leiras, ar, varos_id);
LatvanyossagList.Items.Add(lv);
}
}
}
private void varosTorles()
{
Varosok v = (Varosok)VarosokListBox.SelectedItem;
if (VarosokListBox.SelectedIndex > -1)
{
List <Latvanyossag> lv = new List <Latvanyossag>();
foreach (var item in LatvanyossagList.Items)
{
lv.Add((Latvanyossag)item);
}
int db = 0;
foreach (var item in lv)
{
if (item.Varos_id == v.Id)
{
db++;
}
}
if (db == 0)
{
string sql = @"DELETE FROM varosok
WHERE id=@id";
var comm = conn.CreateCommand();
comm.CommandText = sql;
comm.Parameters.AddWithValue("@id", v.Id);
comm.ExecuteNonQuery();
VarosokListBox.Items.RemoveAt(VarosokListBox.SelectedIndex);
VarosokListBox.SelectedIndex = -1;
}
else
{
MessageBox.Show("Nem törölhető mert tartozik hozzá látványosság");
}
}
}
private void btn_add_Click(object sender, System.EventArgs e)
{
int id = 0;
for (int i = 0; i < lbox_varosok.Items.Count; i++)
{
Varosok v = (Varosok)lbox_varosok.Items[i];
id = v.Id;
id++;
}
string nev = text_nev.Text;
int lakossag = (int)numeric_lakossag.Value;
bool letezik = false;
List <Latvanyossagok> lista = new List <Latvanyossagok>();
var varos = new Varosok(id, nev, lakossag, lista);
//ellenőrzések
List <string> varosnevek = new List <string>();
for (int i = 0; i < lbox_varosok.Items.Count; i++)
{
Varosok va = (Varosok)lbox_varosok.Items[i];
varosnevek.Add(va.Nev);
}
if (varosnevek.Contains(nev))
{
MessageBox.Show("ilyen név már létezik");
letezik = true;
}
if (nev.Length == 0)
{
MessageBox.Show("nem lehet üres a név mező!");
}
if (lakossag == 0)
{
MessageBox.Show("nem lehet 0 a lakosság!");
}
if (lakossag != 0 && nev.Length != 0 && letezik == false)
{
var insertComm = conn.CreateCommand();
insertComm.CommandText = @"
INSERT INTO varosok (id, nev, lakossag)
VALUES (@id, @nev, @lakossag);
";
insertComm.Parameters.AddWithValue("@id", null);
insertComm.Parameters.AddWithValue("@nev", nev);
insertComm.Parameters.AddWithValue("@lakossag", lakossag);
int erintettSorok = insertComm.ExecuteNonQuery();
lbox_varosok.Items.Add(varos);
comboboxfeltoltes();
}
}