//button za dodati termin klik protected void OnButton225Clicked(object sender, EventArgs e) { if (comboboxNP.ActiveText == null || spinbutton1.Text == "0" || spinbutton3.Text == "0" || spinbutton2.Text == "0") { ZaVoditeljeDialog2 win1 = new ZaVoditeljeDialog2(); win1.Show(); } else { DateTime x; x = calendar1.Date; string y; y = x.ToString("dd.MM.yyyy."); string z; z = comboboxNP.ActiveText; int u = Convert.ToInt32(spinbutton2.Text); string connectionString = "URI=file:bazapodataka.db"; SqliteConnection con = new SqliteConnection(connectionString); con.Open(); SqliteCommand dbInsertCmd = con.CreateCommand(); dbInsertCmd.CommandText = String.Format(@"INSERT INTO Termini (Nacionalnipark, Datum, Cijena_djeca, Cijena_odrasli, Kapacitet) VALUES('{0}', '{1}', '{2}', '{3}', {4})" , comboboxNP.ActiveText, y, spinbutton1.Text, spinbutton3.Text, u); dbInsertCmd.ExecuteNonQuery(); dbInsertCmd.Dispose(); con.Close(); ZaVoditeljeDialog3 win1 = new ZaVoditeljeDialog3(); win1.Show(); } }
//spremanje novog termina protected void OnButton225Clicked(object sender, EventArgs e) { if (comboboxNP.ActiveText == null || spinbutton1.Text == "0" || spinbutton3.Text == "0" || spinbutton2.Text == "0") { ZaVoditeljeDialog2 win1 = new ZaVoditeljeDialog2(); win1.Show(); } else { DateTime x; x = calendar1.Date; string y; y = x.ToString("dd.MM.yyyy."); string z; z = comboboxNP.ActiveText; int u = Convert.ToInt32(spinbutton2.Text); string connectionString = "URI=file:bazapodataka.db"; SqliteConnection con = new SqliteConnection(connectionString); con.Open(); SqliteCommand dbInsertCmd = con.CreateCommand(); dbInsertCmd.CommandText = String.Format(@"INSERT INTO Termini (Nacionalnipark, Datum, Cijena_djeca, Cijena_odrasli, Kapacitet) VALUES('{0}', '{1}', '{2}', '{3}', {4})" , comboboxNP.ActiveText, y, spinbutton1.Text, spinbutton3.Text, u); dbInsertCmd.ExecuteNonQuery(); dbInsertCmd.Dispose(); con.Close(); ZaVoditeljeDialog3 win1 = new ZaVoditeljeDialog3(); win1.Show(); //dio za refresh termini.Clear(); buttonIzbrisi.Sensitive = false; string connectionStringg = "URI=file:bazapodataka.db"; SqliteConnection conn = new SqliteConnection(connectionStringg); conn.Open(); SqliteCommand cc = conn.CreateCommand(); cc.CommandText = string.Format(@"SELECT Nacionalnipark, Datum FROM Termini WHERE Nacionalnipark = '{0}'", comboboxNP.ActiveText); SqliteDataReader reader = cc.ExecuteReader(); while (reader.Read()) { Termin a = new Termin(); a.Nacionalnipark = (string)reader["Nacionalnipark"]; a.Datum = (string)reader["Datum"]; termini.Add(a); } int b = 0; int q = 0; while (q < 20) { comboboxTermini.RemoveText(q); q++; } q = 0; while (q < 20) { comboboxTermini.RemoveText(u); q++; } comboboxTermini.RemoveText(0); foreach (var i in termini) { comboboxTermini.InsertText(b, i.Datum); b++; } cc.Dispose(); conn.Close(); } }