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