public List <TemporaryCart> GetItems(int userId)
{
List <TemporaryCart> list = new List <TemporaryCart>();
string sql = "SELECT * FROM TemporaryCart WHERE UserId=" + userId;
DataSet ds = SqlHelper.ExecuteDataset(this.connection, CommandType.Text, sql);
if (ds.Tables.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow row in dt.Rows)
{
TemporaryCart item = new TemporaryCart();
item.Id = Convert.ToInt32(row["Id"]);
item.Book = new BookService().GetBookById(Convert.ToInt32(row["BookId"]));
item.User = new UserService().GetUserById(Convert.ToInt32(row["UserId"]));
item.CreateTime = Convert.ToDateTime(row["CreateTime"]);
list.Add(item);
}
}
return(list);
}
public void AddSnackToTempCart(SnacksType snacks)
{
TemporaryCart.Add(new Snack(snacks));
}
public void AddBeveragesToTempCart(BeverageType beverage, Size beverageSize)
{
TemporaryCart.Add(new Beverage(beverage, beverageSize));
}
