public List <Product> GetAll() { try { string sql = "SELECT P.Id, P.Naam, P.Prijs, P.Grootte, P.Kleur, P.Beschrijving, P.Voorraad, C.Naam, P.CategorieId, P.Actief FROM Product as P INNER JOIN Categorie as C ON P.CategorieId = C.Id"; List <Product> producten = new List <Product>(); List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> > { }; ExecuteSql(sql, parameters); DataSet result = ExecuteSql(sql, parameters); if (result != null && result.Tables[0].Rows.Count > 0) { for (int x = 0; x < result.Tables[0].Rows.Count; x++) { Product p = DataSetParser.DataSetToProduct(result, x); producten.Add(p); } } return(producten); } catch (Exception e) { throw e; } }
public List <Product> Zoeken(string Zoekterm) { List <Product> productList = new List <Product>(); try { string sql = "SELECT P.Id, P.Naam, P.Prijs, P.Grootte, P.Kleur, P.Beschrijving, P.Voorraad, C.Naam, P.CategorieId, P.Actief FROM Product as P INNER JOIN Categorie as C ON P.CategorieId = C.Id WHERE CHARINDEX(@zoekterm, P.Naam) > 0 ORDER BY P.Naam"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("zoekterm", Zoekterm), }; DataSet results = ExecuteSql(sql, parameters); for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Product p = DataSetParser.DataSetToProduct(results, x); productList.Add(p); } return(productList); } catch (Exception e) { throw e; } }
public List <Product> GetAllGames() { List <Product> productList = new List <Product>(); try { string sql = "select Product.ProductID , Product.CategorieId, Product.Omschrijving,Product.naam,Product.Aantal, Product.Prijs, Product.Soort,Product.Actief,Product.Tweedehands,Product.Naam, Product.ImagePath from Product where CategorieId <= 9"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> > { }; DataSet results = ExecuteSql(sql, parameters); for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Product p = DataSetParser.DataSetToProduct(results, x); productList.Add(p); } return(productList); } catch (Exception e) { throw e; } }
public List <Product> Zoeken(string zoekterm) { List <Product> productList = new List <Product>(); try { string sql = "SELECT Product.ProductID , Product.CategorieId, Product.Omschrijving, Product.naam, Product.Aantal, Product.Prijs, Product.Soort, Product.Actief, Product.Tweedehands, Categorie.Naam, Product.ImagePath FROM Product INNER JOIN Categorie ON Product.CategorieID = Categorie.CategorieID WHERE CHARINDEX(@zoekterm, Product.Naam) > 0 ORDER BY Product.Naam"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("Zoekterm", zoekterm), }; DataSet results = ExecuteSql(sql, parameters); for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Product p = DataSetParser.DataSetToProduct(results, x); productList.Add(p); } return(productList); } catch (Exception e) { throw e; } }
public Product GetById(long id) { try { string sql = "SELECT P.Id, P.Naam, P.Prijs, P.Grootte, P.Kleur, P.Beschrijving, P.Voorraad, C.Naam, P.CategorieId, P.Actief FROM Product as P INNER JOIN Categorie as C ON P.CategorieId = C.Id WHERE P.Id = @Id"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("Id", id.ToString()), }; DataSet results = ExecuteSql(sql, parameters); Product p = DataSetParser.DataSetToProduct(results, 0); return(p); } catch (Exception e) { throw e; } }
public Product GetById(long id) { try { string sql = "SELECT Product.ProductID , Product.CategorieId, Product.Omschrijving,Product.naam,Product.Aantal, Product.Prijs, Product.Soort,Product.Actief,Product.Tweedehands,Categorie.Naam, Product.ImagePath FROM Product INNER JOIN Categorie ON Product.CategorieID = Categorie.CategorieID WHERE ProductID = @productID"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("productID", id.ToString()), }; DataSet results = ExecuteSql(sql, parameters); Product p = DataSetParser.DataSetToProduct(results, 0); return(p); } catch (Exception e) { throw e; } }