public List <Product> GetAllProducts() { var query = "SELECT * FROM Products"; var products = SqliteUtil.Query <Product>(toProduct, query); return(products); }
public List <Product> GetProductsByName(string name) { var query = "SELECT * FROM Products WHERE LOWER(name) LIKE @Name"; SqliteParameter[] parameters = { new SqliteParameter("@Name", $"%{name.ToLower()}%") }; var products = SqliteUtil.Query <Product>(toProduct, query, parameters); return(products); }
public List <ProductOption> GetAllProductOptions(Guid productId) { var query = "SELECT * FROM ProductOptions WHERE productId = @productId collate nocase"; SqliteParameter[] parameters = { new SqliteParameter("@productId", productId) }; var options = SqliteUtil.Query <ProductOption>(toProductOption, query, parameters); return(options); }
public Product GetProductById(Guid id) { var query = "SELECT * FROM Products WHERE id = @id collate nocase"; SqliteParameter[] parameters = { new SqliteParameter("@id", id) }; var products = SqliteUtil.Query <Product>(toProduct, query, parameters); if (products.Count == 1) { return(products[0]); } return(null); }
public bool ProductExists(Guid id) { var query = "SELECT id FROM Products WHERE id = @Id collate nocase"; SqliteParameter[] parameters = { new SqliteParameter("@Id", id) }; var products = SqliteUtil.Query <Product>( (SqliteDataReader reader) => { return(new Product() { Id = Guid.Parse(reader.GetValueOrDefault <string>("Id")) }); }, query, parameters); return(products.Count > 0); }
public ProductOption GetProductOptionById(Guid productId, Guid optionId) { var query = "SELECT * FROM productoptions WHERE productId = @productId collate nocase AND id = @optionId collate nocase"; SqliteParameter[] parameters = { new SqliteParameter("@productId", productId), new SqliteParameter("@optionId", optionId), }; var options = SqliteUtil.Query <ProductOption>(toProductOption, query, parameters); if (options.Count == 1) { return(options[0]); } return(null); }