// 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();
}