public IEnumerable <Cursa> findAll() { // log.Info("Found all races"); List <Cursa> curse = new List <Cursa>(); SQLiteConnection connection = sqliteConnection.getConnection(); string select = "select * from Cursa"; /*DataSet data = new DataSet(); * var dataAdapter = new SQLiteDataAdapter(select, connection); * dataAdapter.Fill(data); */ SQLiteCommand sQLiteCommand = new SQLiteCommand(select, connection); SQLiteDataReader reader = sQLiteCommand.ExecuteReader(); while (reader.Read()) { int idCursa = Convert.ToInt32(reader["idCursa"]); string capCilindrica = Convert.ToString(reader["capCilindrica"]); int numarParticipanti = Convert.ToInt32(reader["numarParticipanti"]); Cursa cursa = new Cursa(capCilindrica, idCursa, numarParticipanti); curse.Add(cursa); } return(curse); }
public IEnumerable <Participant> findAll() { string findAllQuerry = "select * from Participanti"; List <Participant> participanti = new List <Participant>(); SQLiteConnection connection = sqliteConnection.getConnection(); SQLiteCommand command = new SQLiteCommand(findAllQuerry, connection); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { Participant p; if (reader["idEchipa"] != DBNull.Value) { p = new Participant(Convert.ToInt32(reader["idCursa"]), Convert.ToInt32(reader["idEchipa"]), Convert.ToString(reader["nume"])); } else { p = new Participant(Convert.ToInt32(reader["idCursa"]), null, Convert.ToString(reader["nume"])); } participanti.Add(p); } return(participanti); }
public User findUser(string username, string password) { SQLiteConnection connection = sqliteConnection.getConnection(); SQLiteCommand command = new SQLiteCommand("select * from User u where u.name=@name and u.password=@pass", connection); command.Parameters.AddWithValue("@name", username); command.Parameters.AddWithValue("@pass", password); SQLiteDataReader reader = command.ExecuteReader(); bool isOk = reader.Read(); if (isOk) { return(new User(username, password)); } return(null); }
public IEnumerable <Echipa> findAll() { //log.Info("Found all teams!"); List <Echipa> echipe = new List <Echipa>(); SQLiteConnection connection = sqliteConnection.getConnection(); string select = "select * from Echipa"; /*DataSet data = new DataSet(); * var dataAdapter = new SQLiteDataAdapter(select, connection); * dataAdapter.Fill(data); */ SQLiteCommand sQLiteCommand = new SQLiteCommand(select, connection); SQLiteDataReader reader = sQLiteCommand.ExecuteReader(); while (reader.Read()) { int idEchipa = Convert.ToInt32(reader["idEchipa"]); string numeEchipa = Convert.ToString(reader["numeEchipa"]); Echipa echipa = new Echipa(idEchipa, numeEchipa); echipe.Add(echipa); } return(echipe); }