//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();
}
}
