public List <Gerecht> GetAllGerechtenAndRondesFromOrderId(int id) { string sql = "select Gerecht.GerechtID, Gerecht.RestaurantID, Gerecht.Descriptie, Gerecht.Naam, GerechtOrder.Ronde From Gerecht" + " Inner Join GerechtOrder On Gerecht.GerechtID = GerechtOrder.GerechtID Where GerechtOrder.OrderID = @id"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("id", id); List <Gerecht> gerechten = new List <Gerecht>(); DataSet set = GetDataSetSql(sql, parameters); if (set != null && set.Tables[0].Rows.Count >= 1) { for (int x = 0; x < set.Tables[0].Rows.Count; x++) { gerechten.Add(DataSetParser.DataSetToGerechtWithRonde(set, x)); } } else { return(null); } return(gerechten); }
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 List <Account> GetRestaurantAccounts(int RestaurantID) { string sql = "Select * From Account Where RestaurantID = @restaurantid"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("restaurantid", RestaurantID); DataSet results = GetDataSetSql(sql, parameters); List <Account> Accounts = new List <Account>(); if (results != null && results.Tables[0].Rows.Count > 0) { for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Account a = DataSetParser.DataSetToAccount(results, x); Accounts.Add(a); } } else { return(null); } return(Accounts); }
public Gerecht GetGerechtById(int id) { string sql = "select * from Gerecht where GerechtID = @ID"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("ID", id); int x = 0; DataSet ds = GetDataSetSql(sql, parameters); Gerecht g = DataSetParser.DataSetToGerecht(ds, x); return(g); }
public Restaurant GetRestaurantByID(int id) { string sql = "Select * From restaurant where RestaurantID = @id"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("id", id.ToString()); DataSet results = GetDataSetSql(sql, parameters); Restaurant r = null; if (results != null && results.Tables[0].Rows.Count == 1) { r = DataSetParser.DataSetToRestaurant(results, 0); } return(r); }
public Account GetAccountByID(int id) { string sql = "Select * From Account where AccountID= @id"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("id", id.ToString()); DataSet results = GetDataSetSql(sql, parameters); Account a = null; if (results != null && results.Tables[0].Rows.Count > 0) { a = DataSetParser.DataSetToAccount(results, 0); } return(a); }
public Restaurant GetRestaurantByName(string Name) { string sql = "Select * From restaurant where Naam like @name"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("name", Name); DataSet results = GetDataSetSql(sql, parameters); Restaurant r = null; if (results != null && results.Tables[0].Rows.Count == 1) { r = DataSetParser.DataSetToRestaurant(results, 0); } return(r); }
public Gerecht GetGerechtByRondeAndGerechtIdAndOrderId(int ronde, int GerechtId, int OrderId) { string sql = "Select * From Gerecht Where GerechtId = (Select GerechtId From GerechtOrder where Ronde = @ronde And GerechtID = @id and OrderId = @OrderId)"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("ronde", ronde); parameters.Add("id", GerechtId); parameters.Add("OrderId", OrderId); DataSet set = GetDataSetSql(sql, parameters); Gerecht g = null; if (set != null && set.Tables[0].Rows.Count >= 1) { g = DataSetParser.DataSetToGerecht(set, 0); } return(g); }
public List <Restaurant> GetGlobalRestaurants() { string sql = "Select * From restaurant"; Dictionary <object, object> parameters = new Dictionary <object, object>(); DataSet results = GetDataSetSql(sql, parameters); List <Restaurant> restaurants = new List <Restaurant>(); if (results != null && results.Tables[0].Rows.Count > 0) { for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Restaurant r = DataSetParser.DataSetToRestaurant(results, x); restaurants.Add(r); } } return(restaurants); }
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 Account Check(string Email) { string sql = "Select * From Account where Email = @Email"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("Email", Email.ToString()); DataSet results = GetDataSetSql(sql, parameters); Account a = null; if (results != null && results.Tables[0].Rows.Count > 0) { a = DataSetParser.DataSetToAccount(results, 0); } else { return(null); } return(a); }
public List <Gerecht> GetGerechtenUitBestelling(int reserveringID, int ronde) { List <Gerecht> GerechtenUitBestelling = new List <Gerecht>(); string sql = "Select GerechtReservering.GerechtID, Gerecht.Naam, GerechtReservering.Aantal From (GerechtReservering INNER JOIN Gerecht ON GerechtReservering.GerechtID = Gerecht.GerechtID) Where GerechtReservering.ReserveringID = @ReserveringId AND GerechtReservering.Ronde = @ronde "; Dictionary <object, object> Parameters = new Dictionary <object, object>(); Parameters.Add("ReserveringId", reserveringID); Parameters.Add("ronde", ronde); 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++) { GerechtenUitBestelling.Add(DataSetParser.DataSetToMinimalGerecht(Results, x)); } } return(GerechtenUitBestelling); }
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); }
public List <Gerecht> GetAllGerechtenFromRestaurantID(int id) { string sql = "select * from Gerecht where RestaurantID = @Id"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("Id", id); List <Gerecht> gerechten = new List <Gerecht>(); DataSet set = GetDataSetSql(sql, parameters); if (set != null && set.Tables[0].Rows.Count >= 1) { for (int x = 0; x < set.Tables[0].Rows.Count; x++) { gerechten.Add(DataSetParser.DataSetToGerecht(set, x)); } } else { return(null); } return(gerechten); }
public List <Bestelling> GetOpenBestellingen(int ReserveringID) { string sql = "Select GerechtReservering.ReserveringID, GerechtReservering.GerechtID, GerechtReservering.Aantal, GerechtReservering.Ronde, Gerecht.Naam from GerechtReservering inner join Gerecht on GerechtReservering.GerechtID = Gerecht.GerechtID where ReserveringID = @reserveringID and Status = 'Open'"; Dictionary <object, object> parameters = new Dictionary <object, object>(); parameters.Add("reserveringID", ReserveringID); DataSet results = GetDataSetSql(sql, parameters); List <Bestelling> Bestellingen = new List <Bestelling>(); if (results != null && results.Tables[0].Rows.Count > 0) { for (int x = 0; x < results.Tables[0].Rows.Count; x++) { Bestelling b = DataSetParser.DataSetToBestelling(results, x); Bestellingen.Add(b); } } else { return(null); } return(Bestellingen); }