public ActionResult Mypurchases() { using (var db = new ShoppingCartDbContext()) { string sessionId = (string)Session["SessionId"]; //select purchases based on customer id and session id from DB var mypurchases = (from cp in db.CustomerPurchase join customer in db.Customer on cp.CustomerId equals customer.Id join product in db.Product on cp.ProductId equals product.Id where customer.SessionId == sessionId select new { cp.ActivationCode, cp.DatePurchased, product.Name, product.Description, product.Img }); List <MyPurchaseModel> PmList = new List <MyPurchaseModel>(); foreach (var purchase in mypurchases) { MyPurchaseModel pm = new MyPurchaseModel(); pm.ActivationCode = purchase.ActivationCode; pm.DateOfPurchase = purchase.DatePurchased; pm.Name = purchase.Name; pm.Description = purchase.Description; pm.Image = purchase.Img; PmList.Add(pm); } // add List to MypurchaseModel ViewData["mypurchases"] = PmList;; return(View()); } }
// GET: ViewPurchase public ActionResult MyPurchase(string SessionId) { //Check for session. if does not exist,redirect back to login screen if (!Util.SessionExist(SessionId)) { return(RedirectToAction("Login", "Login")); } List <MyPurchaseModel> listofpurchase = new List <MyPurchaseModel>(); using (var db = new ShoppingCartDbContext()) { var purchases = (from customerpurchase in db.CustomerPurchase join customer in db.Customer on customerpurchase.CustomerId equals customer.Id join product in db.Product on customerpurchase.ProductId equals product.Id where customer.SessionId == SessionId orderby customerpurchase.DatePurchased descending, product.Name ascending select new { product.ImageUrl, product.Name, product.Description, customerpurchase.DatePurchased, customerpurchase.ActivationCode }).ToList(); foreach (var purchase in purchases) { MyPurchaseModel p = new MyPurchaseModel(); p.ImageUrl = purchase.ImageUrl; p.Name = purchase.Name; p.Description = purchase.Description; p.DatePurchased = purchase.DatePurchased; p.ActivationCode = purchase.ActivationCode; listofpurchase.Add(p); } } ViewData["CustomerPurchase"] = listofpurchase; ViewData["SessionId"] = SessionId; return(View()); }