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