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