// selectez toate informatiile din inventar_sala public DataTable SelectInventar() { Connection db = new Connection(); string sqlQuery = "SELECT * FROM Inventar_Sala"; return db.Select(sqlQuery, false); }
// selectez o sala dupa id public DataRow SelectSalaById() { Connection db = new Connection(); Dictionary<string, string> parameters2 = new Dictionary<string, string>(); parameters2.Add("@ID_S", sv.getID_SALA().ToString()); return db.Select("SelID_S", true, parameters2).AsEnumerable().First(); }
// selectez toti utilizatorii public DataTable SelectU() { Connection db = new Connection(); string sqlQuery = "SELECT * FROM Users "; return db.Select(sqlQuery, false); }
// selectez dupa id o intrare din tabela inventar_sala public DataRow SelectInventarId() { Connection db = new Connection(); Dictionary<string, string> parameters2 = new Dictionary<string, string>(); parameters2.Add("@ID_S", inv.getID().ToString()); return db.Select("SelInvID", true, parameters2).AsEnumerable().First(); }