public virtual CustomCart UpdateCustomCart(CustomCart entity)
{
if (entity.IsTransient())
{
return(entity);
}
CustomCart other = GetCustomCart(entity.CustomCartRecId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update CustomCart set [CustomerID]=@CustomerID
, [PackID]=@PackID
, [ShoppingCartRecID]=@ShoppingCartRecID
, [ProductSKU]=@ProductSKU
, [ProductWeight]=@ProductWeight
, [ProductID]=@ProductID
, [VariantID]=@VariantID
, [Quantity]=@Quantity
, [ChosenColor]=@ChosenColor
, [ChosenColorSKUModifier]=@ChosenColorSKUModifier
, [ChosenSize]=@ChosenSize
, [ChosenSizeSKUModifier]=@ChosenSizeSKUModifier
, [CartType]=@CartType
, [OriginalRecurringOrderNumber]=@OriginalRecurringOrderNumber
, [ExtensionData]=@ExtensionData
, [CreatedOn]=@CreatedOn
where CustomCartRecID=@CustomCartRecID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@CustomCartRecID", entity.CustomCartRecId)
, new SqlParameter("@CustomerID", entity.CustomerId)
, new SqlParameter("@PackID", entity.PackId)
, new SqlParameter("@ShoppingCartRecID", entity.ShoppingCartRecId)
, new SqlParameter("@ProductSKU", entity.ProductSku ?? (object)DBNull.Value)
, new SqlParameter("@ProductWeight", entity.ProductWeight)
, new SqlParameter("@ProductID", entity.ProductId)
, new SqlParameter("@VariantID", entity.VariantId)
, new SqlParameter("@Quantity", entity.Quantity)
, new SqlParameter("@ChosenColor", entity.ChosenColor ?? (object)DBNull.Value)
, new SqlParameter("@ChosenColorSKUModifier", entity.ChosenColorSkuModifier ?? (object)DBNull.Value)
, new SqlParameter("@ChosenSize", entity.ChosenSize ?? (object)DBNull.Value)
, new SqlParameter("@ChosenSizeSKUModifier", entity.ChosenSizeSkuModifier ?? (object)DBNull.Value)
, new SqlParameter("@CartType", entity.CartType)
, new SqlParameter("@OriginalRecurringOrderNumber", entity.OriginalRecurringOrderNumber ?? (object)DBNull.Value)
, new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetCustomCart(entity.CustomCartRecId));
}
public virtual CustomCart InsertCustomCart(CustomCart entity)
{
CustomCart other = new CustomCart();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into CustomCart ( [CustomerID]
,[PackID]
,[ShoppingCartRecID]
,[ProductSKU]
,[ProductWeight]
,[ProductID]
,[VariantID]
,[Quantity]
,[ChosenColor]
,[ChosenColorSKUModifier]
,[ChosenSize]
,[ChosenSizeSKUModifier]
,[CartType]
,[OriginalRecurringOrderNumber]
,[ExtensionData]
,[CreatedOn] )
Values
( @CustomerID
, @PackID
, @ShoppingCartRecID
, @ProductSKU
, @ProductWeight
, @ProductID
, @VariantID
, @Quantity
, @ChosenColor
, @ChosenColorSKUModifier
, @ChosenSize
, @ChosenSizeSKUModifier
, @CartType
, @OriginalRecurringOrderNumber
, @ExtensionData
, @CreatedOn );
Select scope_identity()" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@CustomCartRecID", entity.CustomCartRecId)
, new SqlParameter("@CustomerID", entity.CustomerId)
, new SqlParameter("@PackID", entity.PackId)
, new SqlParameter("@ShoppingCartRecID", entity.ShoppingCartRecId)
, new SqlParameter("@ProductSKU", entity.ProductSku ?? (object)DBNull.Value)
, new SqlParameter("@ProductWeight", entity.ProductWeight)
, new SqlParameter("@ProductID", entity.ProductId)
, new SqlParameter("@VariantID", entity.VariantId)
, new SqlParameter("@Quantity", entity.Quantity)
, new SqlParameter("@ChosenColor", entity.ChosenColor ?? (object)DBNull.Value)
, new SqlParameter("@ChosenColorSKUModifier", entity.ChosenColorSkuModifier ?? (object)DBNull.Value)
, new SqlParameter("@ChosenSize", entity.ChosenSize ?? (object)DBNull.Value)
, new SqlParameter("@ChosenSizeSKUModifier", entity.ChosenSizeSkuModifier ?? (object)DBNull.Value)
, new SqlParameter("@CartType", entity.CartType)
, new SqlParameter("@OriginalRecurringOrderNumber", entity.OriginalRecurringOrderNumber ?? (object)DBNull.Value)
, new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
};
var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray);
if (identity == DBNull.Value)
{
throw new DataException("Identity column was null as a result of the insert operation.");
}
return(GetCustomCart(Convert.ToInt32(identity)));
}
return(entity);
}
