public static List <ABCPitalica> getAll()
{
List <ABCPitalica> pitanja = new List <ABCPitalica>();
using (SQLiteConnection connection = DB.GetConnection())
{
connection.Open();
string select = @"select * from ABC";
SQLiteCommand command = new SQLiteCommand(select, connection);
SQLiteDataReader row = command.ExecuteReader();
while (row.Read())
{
int id = Int32.Parse(row["Id"].ToString());
string pitanje = row["pitanje"].ToString();
string tocan = row["tocan"].ToString();
string drugi = row["drugi"].ToString();
string treci = row["treci"].ToString();
ABCPitalica nova = new ABCPitalica(id, pitanje, tocan, drugi, treci);
pitanja.Add(nova);
}
return(pitanja);
}
}
private void spremi_Click(object sender, EventArgs e)
{
if (pitanje.Text.Length > 0 && tocan.Text.Length > 0 && drugi.Text.Length > 0 && treci.Text.Length > 0)
{
ABCPitalica nova = new ABCPitalica(pitanje.Text, tocan.Text, drugi.Text, treci.Text);
ABCPitalicaAccess.AddABCPitalica(nova);
pitanje.Text = "";
tocan.Text = "";
drugi.Text = "";
treci.Text = "";
}
else
{
MessageBox.Show("Popunite sva polja");
}
}
public static string AddABCPitalica(ABCPitalica abc)
{
using (SQLiteConnection connection = DB.GetConnection())
{
try
{
connection.Open();
string insertABC = @"insert into ABC(pitanje, tocan, drugi, treci)
values ('" + abc.Pitanje + "', '" + abc.Tocan + "', '" + abc.Drugi + "', '" + abc.Treci + "')";
SQLiteCommand command = new SQLiteCommand(insertABC, connection);
command.ExecuteNonQuery();
}
catch (Exception)
{
return("Error: insert to table ABC");
}
return(null);
}
}
private void postaviPitanje()
{
a_odgovor.Enabled = true;
b_odgovor.Enabled = true;
c_odgovor.Enabled = true;
updateBodovi();
Random rand = new Random();
ABCPitalica prva = svaPitanja[rand.Next(0, svaPitanja.Count)];
svaPitanja.Remove(prva);
string[] odgovori = new[] { prva.Tocan, prva.Drugi, prva.Treci };
trenutniTocan = prva.Tocan;
Random rnd = new Random();
pitanje.Text = prva.Pitanje;
int a = rnd.Next(0, 3);
a_odgovor.Text = odgovori[a];
int b = rnd.Next(0, 3);
while (b == a)
{
b = rnd.Next(0, 3);
}
b_odgovor.Text = odgovori[b];
int c = rnd.Next(0, 3);
while (c == a || c == b)
{
c = rnd.Next(0, 3);
}
c_odgovor.Text = odgovori[c];
//spremiti id iskorištenog pitanja
}
