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