public List <Reservering> GetReserveringenById(int id) { List <Reservering> reserveringen = new List <Reservering>(); string sql = "select * from Reservering where AccountID = @id"; 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.DataSetToReservering(results, x); reserveringen.Add(r); } } else { MessageBox.Show("Reserveringen Not Found in Database!"); } return(reserveringen); }
public Reservering GetReserveringById(string text) { string sql = "Select * From Reservering Where ReserveringID = @reserveringID"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("reserveringID", text); 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 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 { MessageBox.Show("Too many/few data found."); } return(r); }