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);
}
