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