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); }