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)); }
public virtual KitCart InsertKitCart(KitCart entity) { KitCart other = new KitCart(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into KitCart ( [CustomerID] ,[ShoppingCartRecID] ,[ProductID] ,[VariantID] ,[KitGroupID] ,[KitGroupTypeID] ,[KitItemID] ,[Quantity] ,[CartType] ,[OriginalRecurringOrderNumber] ,[TextOption] ,[InventoryVariantID] ,[InventoryVariantColor] ,[InventoryVariantSize] ,[ExtensionData] ,[CreatedOn] ) Values ( @CustomerID , @ShoppingCartRecID , @ProductID , @VariantID , @KitGroupID , @KitGroupTypeID , @KitItemID , @Quantity , @CartType , @OriginalRecurringOrderNumber , @TextOption , @InventoryVariantID , @InventoryVariantColor , @InventoryVariantSize , @ExtensionData , @CreatedOn ); Select scope_identity()" ; 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) }; 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(GetKitCart(Convert.ToInt32(identity))); } return(entity); }