/// <summary>
/// Updates the shopping cart item
/// </summary>
/// <param name="shoppingCartItemId">The shopping cart item identifier</param>
/// <param name="shoppingCartTypeId">The shopping cart type identifier</param>
/// <param name="customerSessionGuid">The customer session identifier</param>
/// <param name="productVariantId">The product variant identifier</param>
/// <param name="attributesXml">The product variant attributes</param>
/// <param name="customerEnteredPrice">The price enter by a customer</param>
/// <param name="quantity">The quantity</param>
/// <param name="createdOn">The date and time of instance creation</param>
/// <param name="updatedOn">The date and time of instance update</param>
/// <returns>Shopping cart item</returns>
public override DBShoppingCartItem UpdateShoppingCartItem(int shoppingCartItemId,
int shoppingCartTypeId, Guid customerSessionGuid,
int productVariantId, string attributesXml,
decimal customerEnteredPrice, int quantity, DateTime createdOn, DateTime updatedOn)
{
DBShoppingCartItem item = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShoppingCartItemUpdate");
db.AddInParameter(dbCommand, "ShoppingCartItemID", DbType.Int32, shoppingCartItemId);
db.AddInParameter(dbCommand, "ShoppingCartTypeID", DbType.Int32, shoppingCartTypeId);
db.AddInParameter(dbCommand, "CustomerSessionGUID", DbType.Guid, customerSessionGuid);
db.AddInParameter(dbCommand, "ProductVariantID", DbType.Int32, productVariantId);
db.AddInParameter(dbCommand, "AttributesXML", DbType.Xml, attributesXml);
db.AddInParameter(dbCommand, "CustomerEnteredPrice", DbType.Decimal, customerEnteredPrice);
db.AddInParameter(dbCommand, "Quantity", DbType.Int32, quantity);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, createdOn);
db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, updatedOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetShoppingCartItemById(shoppingCartItemId);
}
return(item);
}
private DBShoppingCartItem GetShoppingCartItemFromReader(IDataReader dataReader)
{
DBShoppingCartItem shoppingCartItem = new DBShoppingCartItem();
shoppingCartItem.ShoppingCartItemID = NopSqlDataHelper.GetInt(dataReader, "ShoppingCartItemID");
shoppingCartItem.ShoppingCartTypeID = NopSqlDataHelper.GetInt(dataReader, "ShoppingCartTypeID");
shoppingCartItem.CustomerSessionGUID = NopSqlDataHelper.GetGuid(dataReader, "CustomerSessionGUID");
shoppingCartItem.ProductVariantID = NopSqlDataHelper.GetInt(dataReader, "ProductVariantID");
shoppingCartItem.AttributesXML = NopSqlDataHelper.GetString(dataReader, "AttributesXML");
shoppingCartItem.Quantity = NopSqlDataHelper.GetInt(dataReader, "Quantity");
shoppingCartItem.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
shoppingCartItem.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn");
return(shoppingCartItem);
}
private DBShoppingCartItem GetShoppingCartItemFromReader(IDataReader dataReader)
{
var item = new DBShoppingCartItem();
item.ShoppingCartItemId = NopSqlDataHelper.GetInt(dataReader, "ShoppingCartItemID");
item.ShoppingCartTypeId = NopSqlDataHelper.GetInt(dataReader, "ShoppingCartTypeID");
item.CustomerSessionGuid = NopSqlDataHelper.GetGuid(dataReader, "CustomerSessionGUID");
item.ProductVariantId = NopSqlDataHelper.GetInt(dataReader, "ProductVariantID");
item.AttributesXml = NopSqlDataHelper.GetString(dataReader, "AttributesXML");
item.CustomerEnteredPrice = NopSqlDataHelper.GetDecimal(dataReader, "CustomerEnteredPrice");
item.Quantity = NopSqlDataHelper.GetInt(dataReader, "Quantity");
item.CreatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "CreatedOn");
item.UpdatedOn = NopSqlDataHelper.GetUtcDateTime(dataReader, "UpdatedOn");
return(item);
}
/// <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);
}
/// <summary>
/// Gets a shopping cart item
/// </summary>
/// <param name="ShoppingCartItemID">The shopping cart item identifier</param>
/// <returns>Shopping cart item</returns>
public override DBShoppingCartItem GetShoppingCartItemByID(int ShoppingCartItemID)
{
DBShoppingCartItem shoppingCartItem = null;
if (ShoppingCartItemID == 0)
{
return(shoppingCartItem);
}
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShoppingCartItemLoadByPrimaryKey");
db.AddInParameter(dbCommand, "ShoppingCartItemID", DbType.Int32, ShoppingCartItemID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
shoppingCartItem = GetShoppingCartItemFromReader(dataReader);
}
}
return(shoppingCartItem);
}
/// <summary>
/// Inserts a shopping cart item
/// </summary>
/// <param name="ShoppingCartTypeID">The shopping cart type identifier</param>
/// <param name="CustomerSessionGUID">The customer session identifier</param>
/// <param name="ProductVariantID">The product variant identifier</param>
/// <param name="AttributesXML">The product variant attributes</param>
/// <param name="Quantity">The quantity</param>
/// <param name="CreatedOn">The date and time of instance creation</param>
/// <param name="UpdatedOn">The date and time of instance update</param>
/// <returns>Shopping cart item</returns>
public override DBShoppingCartItem InsertShoppingCartItem(int ShoppingCartTypeID, Guid CustomerSessionGUID,
int ProductVariantID, string AttributesXML, int Quantity,
DateTime CreatedOn, DateTime UpdatedOn)
{
DBShoppingCartItem shoppingCartItem = null;
Database db = NopSqlDataHelper.CreateConnection(_sqlConnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("Nop_ShoppingCartItemInsert");
db.AddOutParameter(dbCommand, "ShoppingCartItemID", DbType.Int32, 0);
db.AddInParameter(dbCommand, "ShoppingCartTypeID", DbType.Int32, ShoppingCartTypeID);
db.AddInParameter(dbCommand, "CustomerSessionGUID", DbType.Guid, CustomerSessionGUID);
db.AddInParameter(dbCommand, "ProductVariantID", DbType.Int32, ProductVariantID);
db.AddInParameter(dbCommand, "AttributesXML", DbType.Xml, AttributesXML);
db.AddInParameter(dbCommand, "Quantity", DbType.Int32, Quantity);
db.AddInParameter(dbCommand, "CreatedOn", DbType.DateTime, CreatedOn);
db.AddInParameter(dbCommand, "UpdatedOn", DbType.DateTime, UpdatedOn);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
int ShoppingCartItemID = Convert.ToInt32(db.GetParameterValue(dbCommand, "@ShoppingCartItemID"));
shoppingCartItem = GetShoppingCartItemByID(ShoppingCartItemID);
}
return(shoppingCartItem);
}
