[SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ShoppingCart_Inventory". The conflict occurred in database "mydrinkstore_com_db", table "dbo.Inventory", column 'InventoryID'.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2586154
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6039978
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +59
System.Data.SqlClient.SqlDataReader.get_MetaData() +91
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +446
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2698
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +1611
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +65
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +251
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +43
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +12
System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) +224
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +271
[UpdateException: An error occurred while updating the entries. See the inner exception for details.]
System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) +482
System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) +147
System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) +597
NordicPaintball.WebApplication.MyShoppingCart.AddItem(String cartID, Int32 productID, Int32 inventoryID, Int32 quantity) in C:\Nordic Paintball AS\NordicPaintball Code\NordicPaintball.WebApplication\Classes\MyShoppingCart.cs:54
[Exception: ERROR: Unable to Add Item to Cart - An error occurred while updating the entries. See the inner exception for details.]
NordicPaintball.WebApplication.MyShoppingCart.AddItem(String cartID, Int32 productID, Int32 inventoryID, Int32 quantity) in C:\Nordic Paintball AS\NordicPaintball Code\NordicPaintball.WebApplication\Classes\MyShoppingCart.cs:65
NordicPaintball.WebApplication.AddToCart.Page_Load(Object sender, EventArgs e) in C:\Nordic Paintball AS\NordicPaintball Code\NordicPaintball.WebApplication\AddToCart.aspx.cs:42
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
System.Web.UI.Control.OnLoad(EventArgs e) +97
System.Web.UI.Control.LoadRecursive() +61
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693
|