Cześć gdy próbuje dodać do bazy zamowienie to przy zapisie zamowienia do bazu wyskakuje taki błąd
SqlException: Invalid column name 'ApplicationUser_Id'.
System.Data.Entity.Infrastructure.DbUpdateException: „An error occurred while updating the entries. See the inner exception for details.”
using Sklep.Models;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using System.Web;
namespace Sklep.Infrastructure
{
public class OrderManager
{
private ISessionManager session;
private ApplicationDbContext db = new ApplicationDbContext();
public OrderManager(ISessionManager session)
{
this.session = session;
}
public const string sessionKey = "BasketKey";
public List<OrderItems> GetBasket()
{
List<OrderItems> basket;
if (session.Get<List<OrderItems>>(sessionKey) == null)
{
basket = new List<OrderItems>();
}
else
{
basket = session.Get<List<OrderItems>>(sessionKey) as List<OrderItems>;
}
return basket;
}
public void AddToBasket(int productId)
{
var basket = GetBasket();
var basketItem = basket.Find(x => x.ProductId == productId);
if (basketItem != null)
{
basketItem.Quantity++;
}
else
{
var product = db.Products.Find(productId);
if (product != null)
{
var newBasketItems = new OrderItems
{
Product = product,
ProductId = productId,
Quantity = 1,
Price = product.Price
};
basket.Add(newBasketItems);
}
}
session.Set<List<OrderItems>>(sessionKey, basket);
}
public int DeleteFromBasket(int productId)
{
var basket = GetBasket();
var basketItem = basket.Find(x => x.ProductId == productId);
if (basketItem != null)
{
basketItem.Quantity--;
return basketItem.Quantity;
}
else
{
basket.Remove(basketItem);
}
return 0;
}
public decimal GetTotalValue()
{
var basket = GetBasket();
return basket.Sum(x => (x.Product.Price * x.Quantity));
}
public int GetAmountBasketItems()
{
var basket = GetBasket();
return basket.Sum(x => x.Quantity);
}
public Order CreateOrder(Order newOrder, string userId)
{
var basket = GetBasket();
newOrder.DateOfAddition = DateTime.UtcNow;
newOrder.UserId = userId;
db.Orders.Add(newOrder);
if (newOrder.OrderItems == null)
newOrder.OrderItems = new List<OrderItems>();
decimal basketValue = 0;
foreach (var item in basket)
{
var newOrderItems = new OrderItems()
{
ProductId = item.ProductId,
Quantity = item.Quantity,
Price = item.Price,
};
basketValue += (item.Price * item.Quantity);
newOrder.OrderItems.Add(newOrderItems);
}
newOrder.TotalValue = basketValue;
db.SaveChanges();
return newOrder;
}
public void EmptyBasket()
{
session.Abandom();
}
}
}
Wiecie może jak to naprawić Z góry dziękuje za pomoc :)