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 }