/// <summary> /// Gets a shopping cart by customer session GUID /// </summary> /// <param name="ShoppingCartType">Shopping cart type</param> /// <param name="CustomerSessionGUID">The customer session identifier</param> /// <returns>Cart</returns> public static ShoppingCart GetShoppingCartByCustomerSessionGUID(ShoppingCartTypeEnum ShoppingCartType, Guid CustomerSessionGUID) { DBShoppingCart dbCollection = DBProviderManager <DBShoppingCartProvider> .Provider.GetShoppingCartByCustomerSessionGUID((int)ShoppingCartType, CustomerSessionGUID); ShoppingCart shoppingCart = DBMapping(dbCollection); return(shoppingCart); }
private static ShoppingCart DBMapping(DBShoppingCart dbCollection) { if (dbCollection == null) { return(null); } ShoppingCart collection = new ShoppingCart(); foreach (DBShoppingCartItem dbItem in dbCollection) { ShoppingCartItem item = DBMapping(dbItem); collection.Add(item); } return(collection); }
/// <summary> /// Gets a shopping cart by customer session GUID /// </summary> /// <param name="ShoppingCartTypeID">Shopping cart type identifier</param> /// <param name="CustomerSessionGUID">The customer session identifier</param> /// <returns>Cart</returns> public override DBShoppingCart GetShoppingCartByCustomerSessionGUID(int ShoppingCartTypeID, Guid CustomerSessionGUID) { DBShoppingCart Cart = new DBShoppingCart(); Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString); DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShoppingCartItemLoadByCustomerSessionGUID"); db.AddInParameter(dbCommand, "ShoppingCartTypeID", DbType.Int32, ShoppingCartTypeID); db.AddInParameter(dbCommand, "CustomerSessionGUID", DbType.Guid, CustomerSessionGUID); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { DBShoppingCartItem shoppingCartItem = GetShoppingCartItemFromReader(dataReader); Cart.Add(shoppingCartItem); } } return(Cart); }