public List <Customer> GetAllCustomers()
{
_customerTable.Clear();
_db.Query($"SELECT CustomerId, FirstName, LastName FROM Customer;",
(SqliteDataReader reader) =>
{
while (reader.Read())
{
{
Customer customer = new Customer()
{
CustomerId = reader.GetInt32(0),
FirstName = reader[1].ToString(),
LastName = reader[2].ToString()
};
_customerTable.Add(customer);
};
}
});
return(_customerTable);
}
public List <Product> GetAllProducts(Customer activeCustomer)
{
_db.Query($"SELECT * FROM Product WHERE CustomerId != {activeCustomer.CustomerId} and Quantity != 0;",
(SqliteDataReader reader) =>
{
products.Clear();
while (reader.Read())
{
products.Add(new Product()
{
ProductId = reader.GetInt32(0),
Title = reader[1].ToString(),
Description = reader[2].ToString(),
Price = reader.GetDouble(3),
Quantity = reader.GetInt32(4),
Category = reader.GetInt32(5),
CustomerId = reader.GetInt32(6),
DateCreated = reader.GetDateTime(7)
});
}
}
);
return(products);
}
