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
