public List <Drink> GetDrinkUnderPrice(double price)
{
using (SqlConnection connection = new SqlConnection(_connString.ConnectionStringBuilder()))
{
List <Drink> drinks = new List <Drink>();
using (SqlCommand command = new SqlCommand())
{
try
{
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "[dbo].[DrinkUnderPrice]";
command.Parameters.AddWithValue("@price", price);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
drinks.Add(new Drink
{
Id = Convert.ToString(reader[0]),
DrinkName = Convert.ToString(reader[1]),
Price = Convert.ToString(reader[2]),
BarName = Convert.ToString(reader[3]),
Category = Convert.ToString(reader[4])
});
}
}
connection.Close();
return(drinks);
}
catch (Exception e)
{
throw e;
}
}
}
}
public List <Bar> GetBars()
{
using (SqlConnection connection = new SqlConnection(_connString.ConnectionStringBuilder()))
{
List <Bar> bars = new List <Bar>();
using (SqlCommand command = new SqlCommand())
{
try
{
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "[dbo].[SelectBars]";
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
bars.Add(new Bar {
Id = Convert.ToString(reader[0]),
Name = (string)reader[1],
Location = (string)reader[2],
Phone = (string)reader[3]
});
}
}
connection.Close();
return(bars);
}
catch (Exception e)
{
throw e;
}
}
}
}
public List <Special> GetSpecials()
{
using (SqlConnection connection = new SqlConnection(_connString.ConnectionStringBuilder()))
{
List <Special> specials = new List <Special>();
using (SqlCommand command = new SqlCommand())
{
try
{
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "[dbo].[GetSpecials]";
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
specials.Add(new Special
{
Id = Convert.ToString(reader[0]),
Day = Convert.ToString(reader[1]),
BarName = Convert.ToString(reader[2]),
CategoryName = Convert.ToString(reader[3]),
Price = Convert.ToString(reader[4]),
});;
}
}
connection.Close();
return(specials);
}
catch (Exception e)
{
throw e;
}
}
}
}
