public List <Izposoja> GetRents()
{
List <Izposoja> list = new List <Izposoja>();
conn.Open();
using (SQLiteCommand com = new SQLiteCommand(conn))
{
com.CommandText = "SELECT * FROM rents ORDER BY id;";
SQLiteDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Izposoja a = new Izposoja();
a.id = reader.GetInt32(0);
a.id_clana = reader.GetInt32(1);
a.id_knjige = reader.GetInt32(2);
a.stanje = reader.GetInt32(3);
a.datum_izposoje = reader.GetString(4);
list.Add(a);
}
com.Dispose();
}
conn.Close();
return(list);
}
public List <Izposoja> GetAllIzposojaForUser(int clan_id)
{
List <Izposoja> list = new List <Izposoja>();
conn.Open();
using (SQLiteCommand com = new SQLiteCommand(conn))
{
com.CommandText = "SELECT * FROM rents WHERE user_id = " + clan_id + " AND state = 1;";
SQLiteDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Izposoja a = new Izposoja();
a.id = reader.GetInt32(0);
a.id_clana = reader.GetInt32(1);
a.id_knjige = reader.GetInt32(2);
a.stanje = reader.GetInt32(3);
a.datum_izposoje = reader.GetString(4);
list.Add(a);
}
com.Dispose();
}
conn.Close();
return(list);
}
