public IEnumerable <Angajat> FindAll() { IDbConnection con = DBUtils.getConnection(props); IList <Angajat> angajati = new List <Angajat>(); using (var comm = con.CreateCommand()) { comm.CommandText = "select * from Angajati"; using (var dataR = comm.ExecuteReader()) { while (dataR.Read()) { String id = dataR.GetString(0); String pass = dataR.GetString(1); Angajat angajat = new Angajat(id, pass); angajati.Add(angajat); } } } return(angajati); }
public Zbor FindOneByDestinatieAndDateTime(String destinatie, String DataTimp) { IDbConnection con = DBUtils.getConnection(props); using (var comm = con.CreateCommand()) { comm.CommandText = "select * from Zboruri where Destinatia=@destinatia and Plecare=@plecare"; IDbDataParameter paramDestinatie = comm.CreateParameter(); paramDestinatie.ParameterName = "@destinatia"; paramDestinatie.Value = destinatie; comm.Parameters.Add(paramDestinatie); IDbDataParameter paramPlecare = comm.CreateParameter(); paramPlecare.ParameterName = "@plecare"; paramPlecare.Value = DataTimp; comm.Parameters.Add(paramPlecare); using (var dataR = comm.ExecuteReader()) { if (dataR.Read()) { int IdZ = dataR.GetInt32(0); String Destinatie = dataR.GetString(1); String PlecareS = dataR.GetString(2); DateTime Plecare = DateTime.Parse(PlecareS); String Aeroport = dataR.GetString(3); int Locuri = dataR.GetInt32(4); Zbor z = new Zbor(IdZ, Destinatie, Plecare, Aeroport, Locuri); log.InfoFormat("Exiting findOne with value {0}", z); return(z); } } } log.InfoFormat("Exiting findOne with value {0}", null); return(null); }
public IEnumerable <Client> findAll() { IDbConnection con = DBUtils.getConnection(props); IList <Client> clientR = new List <Client>(); using (var comm = con.CreateCommand()) { comm.CommandText = "select * from Clienti"; using (var dataR = comm.ExecuteReader()) { while (dataR.Read()) { int IdC = dataR.GetInt32(0); String Nume = dataR.GetString(1); String Adresa = dataR.GetString(2); Client client = new Client(IdC, Nume, Adresa); clientR.Add(client); } } } return(clientR); }