// Runs check for a piece of existing data
public static void Initialize(DatabaseInterface db)
{
bool checkForData = false;
db.Query($"select customerid from customer",
(SqliteDataReader reader) => {
while (reader.Read())
{
checkForData = true;
}
// If no data returns from the simple test, then inserts the following into the created tables
if (checkForData == false)
{
db.SeedData($@"
insert into customer values(null, 'Nigel Thornberry', '2002/06/18', '123 Nickel Dr', 'Long Island', 'NY', '01234', '2222222222');
insert into customer values(null, 'Kevin Spacey', '2002/6/18', '1900 Penn Ave', 'Washington', 'DC', '23445', '3333333333');
insert into customer values(null, 'Pekka Rinne', '2002/6/18', '1511 Broadway', 'Nashville', 'TN', '37201', '4444444444');
insert into [order] values (null, 1, null, '2015/06/18', null);
insert into [order] values (null, 2, null, '2016/06/18', null);
insert into [order] values (null, 3, null, '2017/09/18', null);
insert into [order] values (null, 1, 6, '2017/08/18', null);
insert into [order] values (null, 2, 7, '2017/07/18', null);
insert into [order] values (null, 3, 8, '2017/06/18', null);
insert into orderProduct values (null, 1, 2);
insert into orderProduct values (null, 1, 6);
insert into orderProduct values (null, 1, 3);
insert into orderProduct values (null, 2, 4);
insert into orderProduct values (null, 2, 2);
insert into orderProduct values (null, 3, 4);
insert into orderProduct values (null, 4, 2);
insert into orderProduct values (null, 4, 1);
insert into orderProduct values (null, 4, 2);
insert into orderProduct values (null, 5, 3);
insert into orderProduct values (null, 5, 4);
insert into orderProduct values (null, 5, 4);
insert into orderProduct values (null, 6, 4);
insert into orderProduct values (null, 6, 5);
insert into orderProduct values (null, 6, 6);
insert into paymentType values (null, 1, 'Visa', '987987987987');
insert into paymentType values (null, 2, 'Mastercard', '876876876876');
insert into paymentType values (null, 3, 'Amex', '765765765765');
insert into producttype values (null, 'Home Goods');
insert into producttype values (null, 'Accessories');
insert into producttype values (null, 'Electronics');
insert into product values (null, 1, 1, 'Lamp', 42, 'Lights stuff up', 22.98, '2017/06/18');
insert into product values (null, 2, 2, 'Watch', 16, 'Tells time', 33.45, '2012/06/18');
insert into product values (null, 3, 3, 'Headphones', 32, 'Plays music', 50.01, '2013/06/18');
insert into product values (null, 1, 3, 'Table', 77, 'Corner or coffee', 5.51, '2017/06/18');
insert into product values (null, 2, 1, 'Hat', 362, 'Looks great', 7.90, '2017/07/18');
insert into product values (null, 3, 2, 'Laptop', 55, 'Runs programs', 890.01, '2017/08/01');
"
);
}
});
}
public List <PaymentType> GetCustomerPaymentTypes(int customerId)
{
_db.Query($"select * FROM paymenttype WHERE customerID = {customerId}",
(SqliteDataReader reader) => {
_paymentTypes.Clear();
while (reader.Read())
{
_paymentTypes.Add(new PaymentType(
reader.GetInt32(0),
reader.GetInt32(1),
reader[2].ToString(),
reader[3].ToString()));
}
});
return(_paymentTypes);
}