public static void Dodaj(Ucionica a) { SqliteCommand c = DB.con.CreateCommand(); c.CommandText = String.Format(@"INSERT INTO Ucionica (naziv, kapacitet, komentar, polje_IDpredavaca) VALUES ('{0}', '{1}', '{2}', '{3}')", a.naziv, a.kapacitet, a.komentar, a.polje_IDpredavaci); c.ExecuteNonQuery(); c.Dispose(); }
public ZauzmiTerminWindow(Predavac _predavac, Ucionica _ucionica) : base(Gtk.WindowType.Toplevel) { this.Build(); this._predavac = _predavac; this._ucionica = _ucionica; provjera_polja_predavac_ucionice(); for (int i = 0; i < 15; ++i) { for (int j = 0; j < 5; ++j) { pomocno_polje[i, j] = false; } } } // Konstruktor
public static Ucionica Dohvati_Ucionicu(string naziv) { SqliteCommand c = DB.con.CreateCommand(); c.CommandText = String.Format(@"SELECT ID, naziv, kapacitet, komentar, polje_IDpredavaca FROM Ucionica WHERE naziv = '{0}';", naziv); SqliteDataReader reader = c.ExecuteReader(); while (reader.Read()) { Ucionica temp = new Ucionica(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4)); c.Dispose(); return(temp); } c.Dispose(); return(null); }
public static List <Ucionica> DohvatiSve_Ucionice() { var lista = new List <Ucionica>(); SqliteCommand c = DB.con.CreateCommand(); c.CommandText = String.Format(@"SELECT ID, naziv, kapacitet, komentar, polje_IDpredavaca FROM Ucionica;"); SqliteDataReader reader = c.ExecuteReader(); while (reader.Read()) { Ucionica temp = new Ucionica(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4)); // Dodati za unos u polje lista.Add(temp); } c.Dispose(); return(lista); }
} // Dodajemo predavaca u listu public static void dodaj_ucionicu(Ucionica a) { ucionice_lista.Add(a); } // Dodajemo ucionicu u listu
public UcionicaNode(Ucionica a) { naziv = a.naziv; kapacitet = a.kapacitet; komentar = a.komentar; } // Konstruktor koji sprema iz ucionice a u nodove
public void Add(Ucionica a) { this.AddNode(new UcionicaNode(a)); } // Dodajemo ucionicu