public List <Drink> GetAll() { var drinkList = new List <Drink>(); SqlCommand cmd = new SqlCommand("Select * from Drinks"); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Drink drink = new Drink { DrinkId = Convert.ToInt32(reader[0]), Name = reader[1].ToString(), perPackage = double.Parse(reader[2].ToString()), UnitPrice = decimal.Parse(reader[3].ToString()) }; drinkList.Add(drink); } return(drinkList); }
public Drink Get(int id) { SqlCommand cmd = new SqlCommand("Select * from Drinks where DrinkId=@DrinkId"); cmd.Parameters.AddWithValue("DrinkId", id); SqlDataReader reader = VTYS.SqlExecuteReader(cmd); while (reader.Read()) { Drink drink = new Drink { DrinkId = Convert.ToInt32(reader[0]), Name = reader[1].ToString(), perPackage = double.Parse(reader[2].ToString()), UnitPrice = decimal.Parse(reader[3].ToString()) }; return(drink); } return(null); }