// Get all customers
public List <Product> getAll()
{
BangazonConnection conn = new BangazonConnection();
List <Product> list = new List <Product> ();
// Execute the query to retrieve all customers
conn.execute(@"select
IdProduct,
Name,
Description,
Price,
IdProductType
from Product" ,
(SqliteDataReader reader) => {
while (reader.Read())
{
list.Add(new Product {
IdProduct = reader.GetInt32(0),
Name = reader [1].ToString(),
Description = reader [2].ToString(),
Price = reader.GetDouble(3),
IdProductType = reader.GetInt32(4)
});
}
}
);
return(list);
}
// Get a single customer
public Customer get(int IdCustomer)
{
BangazonConnection conn = new BangazonConnection();
Customer c = null;
conn.execute(@"select
IdCustomer,
FirstName,
LastName,
StreetAddress,
City,
StateProvince,
PostalCode,
PhoneNumber
from customers
where IdCustomer = " + IdCustomer, (SqliteDataReader reader) => {
while (reader.Read())
{
c = new Customer {
id = reader.GetInt32(0),
FirstName = reader [1].ToString(),
LastName = reader [2].ToString(),
StreetAddress = reader [3].ToString(),
City = reader [4].ToString(),
StateProvince = reader [5].ToString(),
PostalCode = reader [6].ToString(),
PhoneNumber = reader [7].ToString()
};
}
});
return(c);
}
// Get all customers
public List <Customer> getAll()
{
BangazonConnection conn = new BangazonConnection();
List <Customer> list = new List <Customer> ();
// Execute the query to retrieve all customers
conn.execute(@"select
IdCustomer,
FirstName,
LastName,
StreetAddress,
City,
StateProvince,
PostalCode,
PhoneNumber
from customer" ,
(SqliteDataReader reader) => {
while (reader.Read())
{
list.Add(new Customer {
id = reader.GetInt32(0),
FirstName = reader [1].ToString(),
LastName = reader [2].ToString(),
StreetAddress = reader [3].ToString(),
City = reader [4].ToString(),
StateProvince = reader [5].ToString(),
PostalCode = reader [6].ToString(),
PhoneNumber = reader [7].ToString()
});
}
}
);
return(list);
}