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));
        }