public virtual KitCart UpdateKitCart(KitCart entity)
{
if (entity.IsTransient())
{
return(entity);
}
KitCart other = GetKitCart(entity.KitCartRecId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update KitCart set [CustomerID]=@CustomerID
, [ShoppingCartRecID]=@ShoppingCartRecID
, [ProductID]=@ProductID
, [VariantID]=@VariantID
, [KitGroupID]=@KitGroupID
, [KitGroupTypeID]=@KitGroupTypeID
, [KitItemID]=@KitItemID
, [Quantity]=@Quantity
, [CartType]=@CartType
, [OriginalRecurringOrderNumber]=@OriginalRecurringOrderNumber
, [TextOption]=@TextOption
, [InventoryVariantID]=@InventoryVariantID
, [InventoryVariantColor]=@InventoryVariantColor
, [InventoryVariantSize]=@InventoryVariantSize
, [ExtensionData]=@ExtensionData
, [CreatedOn]=@CreatedOn
where KitCartRecID=@KitCartRecID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@KitCartRecID", entity.KitCartRecId)
, new SqlParameter("@CustomerID", entity.CustomerId)
, new SqlParameter("@ShoppingCartRecID", entity.ShoppingCartRecId)
, new SqlParameter("@ProductID", entity.ProductId)
, new SqlParameter("@VariantID", entity.VariantId)
, new SqlParameter("@KitGroupID", entity.KitGroupId)
, new SqlParameter("@KitGroupTypeID", entity.KitGroupTypeId)
, new SqlParameter("@KitItemID", entity.KitItemId)
, new SqlParameter("@Quantity", entity.Quantity)
, new SqlParameter("@CartType", entity.CartType)
, new SqlParameter("@OriginalRecurringOrderNumber", entity.OriginalRecurringOrderNumber ?? (object)DBNull.Value)
, new SqlParameter("@TextOption", entity.TextOption ?? (object)DBNull.Value)
, new SqlParameter("@InventoryVariantID", entity.InventoryVariantId ?? (object)DBNull.Value)
, new SqlParameter("@InventoryVariantColor", entity.InventoryVariantColor ?? (object)DBNull.Value)
, new SqlParameter("@InventoryVariantSize", entity.InventoryVariantSize ?? (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(GetKitCart(entity.KitCartRecId));
}
