public ActionResult Order(List <OrderProductDTO> productsList, int?Total, int?Id)
        {
            var user   = Session["User"] as User;
            var UserId = user.UserId;



            var manager = new DBManager("ValuesTest");
            var DTOList = new List <ProductPurchaseDTO>();

            foreach (var item in productsList)
            {
                DTOList.Add(new ProductPurchaseDTO()
                {
                    quantity = item.quantity, product_id = item.product_id
                });
            }


            var success = manager.PurchaseProducts(UserId, DTOList, Total ?? 0);

            if (success != -1)
            {
                var orderDetails = manager.GetOrderById(success);

                MailManager.InformUser(user, orderDetails);
            }
            return(Content(success.ToString()));
        }