Umer Waqar

Umer Waqar

  • NA
  • 5
  • 612

Show products related to previous purchased products MVC ASP

Nov 27 2015 10:25 AM

'm basically trying to build an E-commerce application on MVC and I just want this feature of recommendation. I've registered users and want to recommend new products related to their previous purchased. I've their previous purchase records in database.

I've 5 tables

Products: PId, ProductName, Price, Quantity, CategoryId(fk)  Category: CId, CategoryName  Users: UserId, FName, LName, Email, Password, City  Orders: OrderId, FullName, Address, City, Total, UserId(fk)  OrderDetails: OdId, OrderId(fk), ProductId(fk)

I've some data in Orders and OrderDetails table of Customers who has made some purchasing.

Now I want, If the same user visits again I want to show him/her some products of same category that he/she has purchased.

Sorry for my english, I just need some Ideas or example. Do I have to do "join" between tables ?