public ActionResult TransactionSummary() { if (null == Session["UserId"]) { return(RedirectToAction("../CustomerAccount/Login")); } List <TransactionSummary> transactionSummaries = new List <TransactionSummary>(); int UserId = Convert.ToInt32(Session["UserId"]); List <Reservation> reservations = db.Reservations.Where(u => u.ID == UserId).ToList(); Transaction.TrxnWebServiceClient transaction = new Transaction.TrxnWebServiceClient(); foreach (Reservation res in reservations) { string summary = transaction.getTransaction(res.ReservationNumber); TransactionSummary transactionSummary = new TransactionSummary(); String[] transactionArray = summary.Split(','); transactionSummary.TransactionID = Convert.ToInt32(transactionArray[0]); transactionSummary.NameOnCard = transactionArray[1]; transactionSummary.CardNumber = transactionArray[2]; transactionSummary.CardType = transactionArray[3]; transactionSummary.qty = Convert.ToInt32(transactionArray[4]); transactionSummary.Price = Convert.ToDouble(transactionArray[5]); transactionSummary.TotalPrice = Convert.ToDouble(transactionArray[6]); transactionSummaries.Add(transactionSummary); } return(View(transactionSummaries)); }