public List <Reservering> GetOpenReserveringenByRestaurantId(int id) { List <Reservering> reserveringen = new List <Reservering>(); string sql = "Select R.ReserveringID, R.Datum, R.Status, R.RestaurantID, R.AccountID, A.Voornaam, A.Achternaam From Reservering R inner join Account A on R.AccountID = A.AccountID where R.RestaurantID = @id And Status = 'Open'"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("id", id); DataSet results = GetDataSetSql(sql, parameters); if (results != null && results.Tables[0].Rows.Count > 0) { for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Reservering r = DataSetParser.DataSetToRestaurantReservering(results, x); reserveringen.Add(r); } } else { return(null); } return(reserveringen); }
public Reservering GetReserveringById(int id) { string sql = "Select * From Reservering Where ReserveringID = @reserveringID"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("reserveringID", id); Reservering r = new Reservering(); DataSet results = GetDataSetSql(sql, parameters); if (results != null && results.Tables[0].Rows.Count > 0) { r = DataSetParser.DataSetToReservering(results, 0); } else { return(null); } return(r); }
public List <Reservering> GetOpenBestellingenFromReservering(int reserveringID) { string sql = "Select * From GerechtReservering Where ReserveringID = @id and Status = 'Open'"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("id", reserveringID); DataSet results = GetDataSetSql(sql, parameters); List <Reservering> reserveringen = new List <Reservering>(); if (results != null && results.Tables[0].Rows.Count > 0) { for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Reservering r = DataSetParser.DataSetToReserveringBestellingen(results, x); reserveringen.Add(r); } } return(reserveringen); }
public Reservering GetReserveringByAccountAndRestaurantAndDate(int accountID, int restaurantID, string dtp) { string sql = "select * from Reservering Where AccountID = @AccountID and RestaurantID = @RestaurantID and Datum = @datum + ':00.000' "; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("RestaurantID", restaurantID); parameters.Add("AccountID", accountID); parameters.Add("datum", dtp); DataSet results = GetDataSetSql(sql, parameters); Reservering r = new Reservering(); if (results != null && results.Tables[0].Rows.Count == 1) { r = DataSetParser.DataSetToReservering(results, 0); } else { return(null); } return(r); }