//public ActionResult Return_Url(string id)
        //{
        //    var order = db.Orders.Find(id);

        //    ViewBag.Order = order;
        //    ViewBag.Account = customer_Service.GetCustomer(order.Email);
        //    ViewBag.Address = address_Service.GetOrderAddresses().Find(x => x.Order_ID == order.Order_ID);
        //    ViewBag.Items = order_Service.GetOrderItems(order.Order_ID);
        //    ViewBag.Total = order_Service.GetOrderTotal(order.Order_ID);
        //    return View();
        //}
        public ActionResult Payment_Successfull(string id)
        {
            try
            {
                var order = _orderRepository.GetById(id);
                var items = _orderItemRepository.Find(predicate: x => x.Order_ID == order.OrderNo).ToList();
                foreach (var tem in items)
                {
                    cart_Service.UpdateQuantity(tem.Item.ItemCode, tem.ItemCode);
                }
                cart_Service.AddPayment(order);
                OrderDetailConFirm odcf = new OrderDetailConFirm();
                Order orderT            = _orderRepository.GetById(id);
                odcf.order = orderT;
                //odcf.address = context.OrderAddresses.ToList().Find(x => x.OrderNo == _orderRepository.GetById(id).OrderNo);
                //ViewBag.Items = context.OrderItems.ToList().FindAll(x => x.Order_ID == orderT.OrderNo).ToList();
                //Order_Business.EstimateDeliveryDateReport(order);
                //if (affiliate_Service.GetAffiliateJoiners().FirstOrDefault(x => x.New_Customer_Email == order.Email) != null)
                //{ /* deposit benefits */
                //    affiliate_Service.PayAffiliates(order.Email, (decimal)order_Service.GetOrderTotal(order.Order_ID));
                //}
            }
            catch (Exception ex) { }
            return(View());
        }
        public ActionResult Payment(int id)
        {
            DataContext context = new DataContext();
            //var order = _orderRepository.GetById(id); //db.Orders.Find(id);
            //ViewBag.Order = order;

            //ViewBag.Account = context.Users.Find(order.Email);   //db.Customers.Find(order.custId);
            //ViewBag.name = order.FirstName;
            //ViewBag.lname = order.LastName;
            //ViewBag.Address = context.OrderAddresses.ToList().Find(x => x.OrderNo == order.OrderNo);
            //ViewBag.Items = context.OrderItems.ToList().FindAll(x => x.Order_ID == order.OrderNo);
            //ViewBag.Total = order.TotalPrice;
            OrderDetailConFirm odcf = new OrderDetailConFirm();
            Order orderT            = _orderRepository.GetById(id);

            odcf.order    = orderT;
            odcf.address  = context.OrderAddresses.ToList().Find(x => x.OrderNo == _orderRepository.GetById(id).OrderNo);
            ViewBag.Items = context.OrderItems.ToList().FindAll(x => x.Order_ID == orderT.OrderNo).ToList();


            // context.OrderItems.Include(c => c.Item).Where(x => x.Order_ID == _orderRepository.GetById(id).OrderNo).ToList();


            #region email
            //try
            //{
            //    string url = "<a href=" + "/Shopping/Payment/" + id + " >  here" + "</a>";
            //    string table = "<br/>" +
            //                   "Items in this order<br/>" +
            //                   "<table>";
            //    table += "<tr>" +
            //             "<th>Item</th>"
            //             +
            //             "<th>Quantity</th>"
            //             +
            //             "<th>Price</th>" +
            //             "</tr>";
            //    foreach (var item in (List<OrderItem>)ViewBag.Items)
            //    {
            //        string itemsinoder = "<tr> " +
            //                             "<td>" + item.Item.Name + " </td>" +
            //                             "<td>" + item.quantity + " </td>" +
            //                             "<td>R " + item.price + " </td>" +
            //                             "<tr/>";
            //        table += itemsinoder;
            //    }

            //    table += "<tr>" +
            //             "<th></th>"
            //             +
            //             "<th></th>"
            //             +
            //             "<th>" + order.TotalPrice.ToString("R0.00") + "</th>" +
            //             "</tr>";
            //    table += "</table>";

            //    //var client = new SendGridClient("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");
            //    //var from = new EmailAddress("*****@*****.**", "Company");
            //    var subject = "Order " + id + " | Awaiting Payment";
            //    //var to = new EmailAddress(((Customer)ViewBag.Account).Email, ((Customer)ViewBag.Account).FirstName + " " + ((Customer)ViewBag.Account).LastName);
            //    var htmlContent = "Hi " + order.FirstName + ", Your order was placed, you can securely pay your order from " + url + table;
            //    //var msg = MailHelper.CreateSingleEmail(from, to, subject, null, htmlContent);
            //    //var response = client.SendEmailAsync(msg);
            //}
            //catch (Exception ex)
            //{

            //}
            #endregion
            //return View();
            return(View(odcf));
        }