public IEnumerable <Domain.Entities.Client> Ask(EmptyCriterion criterion) { string databaseName = @"C:\Users\User\Documents\Visual Studio 2015\Projects\TadosJuniorTest\src\WebApp\bin\database.db"; List <Domain.Entities.Client> clients = new List <Domain.Entities.Client>(); using (SQLiteConnection conn = new SQLiteConnection(string.Format(@"Data Source={0};", databaseName))) { conn.Open(); SQLiteCommand command = new SQLiteCommand( string.Format( @"SELECT * FROM Clients"), conn); SQLiteDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { Domain.Entities.Client client = new Domain.Entities.Client( dataReader.GetInt32(0), dataReader.GetString(1), dataReader.GetString(2)); clients.Add(client); } } return(clients); }
public IEnumerable <Domain.Entities.Bill> Ask(EmptyCriterion criterion) { string databaseName = @"C:\Users\User\Documents\Visual Studio 2015\Projects\TadosJuniorTest\src\WebApp\bin\database.db"; List <Domain.Entities.Bill> bills = new List <Domain.Entities.Bill>(); using (SQLiteConnection conn = new SQLiteConnection(string.Format(@"Data Source={0};", databaseName))) { conn.Open(); SQLiteCommand command = new SQLiteCommand( string.Format( @"SELECT * FROM Bills"), conn); SQLiteDataReader dataReader = command.ExecuteReader(); while (dataReader.Read()) { Domain.Entities.Bill bill = new Domain.Entities.Bill( dataReader.GetInt32(0), dataReader.GetDecimal(1), dataReader.GetInt32(3), dataReader.GetInt32(2), _billService.StringToDateTime(dataReader.GetString(4))); if (!dataReader.IsDBNull(5)) { DateTime payedAt = _billService.StringToDateTime(dataReader.GetString(5)); bill.Pay(payedAt); } bills.Add(bill); } } return(bills); }
public IEnumerable <Bike> Ask(EmptyCriterion criterion) { return(_bikeRepository.All()); }
public IEnumerable <RentPoint> Ask(EmptyCriterion criterion) { return(_repository.All()); }