public Accommodation GetPrices(Accommodation a)
{
try
{
string sql = "SELECT * FROM [AccommodationPrices] WHERE [AccommodationId] = @ac";
List <KeyValuePair <string, string> > parameters = new List <KeyValuePair <string, string> >()
{
new KeyValuePair <string, string>("@ac", a.Id.ToString())
};
DataSet results = ExecuteSql(sql, parameters);
for (int x = 0; x < results.Tables[0].Rows.Count; x++)
{
a.DatePrices.Add(DataSetParser.DataSetToAccommodationPrices(results, x));
}
return(a);
}
catch
{
throw;
}
}