public List <Bestelling> GetAllFromUser(long Id) { try { string sql = "SELECT Besteldatum, Leverdatum, TotaalPrijs From Bestelling WHERE Accountid = @id"; List <Bestelling> bestellingen = new List <Bestelling>(); List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("Id", Id.ToString()), }; 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++) { Bestelling b = DataSetParser.DataSetToBestelling(result, x); bestellingen.Add(b); } } return(bestellingen); } catch (Exception e) { throw e; } }
public List <Bestelling> GetAll() { List <Bestelling> bestellingList = new List <Bestelling>(); try { string sql = "SELECT Datum, KlantID FROM Bestelling"; 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++) { Bestelling b = DataSetParser.DataSetToBestelling(results, x); bestellingList.Add(b); } return(bestellingList); } catch (Exception e) { throw e; } }
public Bestelling GetById(long id) { try { string sql = "SELECT Datum, KlantID FROM Bestelling WHERE bestellingID = @bestellingID"; List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> > { new KeyValuePair <string, string>("bestellingID", id.ToString()), }; DataSet results = ExecuteSql(sql, parameters); Bestelling b = DataSetParser.DataSetToBestelling(results, 0); return(b); } catch (Exception e) { throw e; } }