public ActionResult ShowPDF(int?id)
        {
            List <Basket_ProductSize> bapp = new List <Basket_ProductSize>();

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            var orders_pr = db.Basket_ProductSize.Select(o => o).Where(o => o.BasketID == id);

            ViewBag.ID = id;
            Basket_ProductSize bap = null;

            foreach (var item in orders_pr)
            {
                bap = item;
                // ViewBag.Price2 = TotalPrice;
                bapp.Add(bap);
            }


            DateTime date = DateTime.Now;

            ViewBag.Date2 = date;

            //pobieranie danych o uzytkowniku
            foreach (var item in bapp)
            {
                ViewBag.UserName2 = item.Basket.Profile.UserName;
                ViewBag.Name2     = item.Basket.Profile.FirstName;
                ViewBag.SurName2  = item.Basket.Profile.SurName;
                ViewBag.City2     = item.Basket.Profile.City;
                ViewBag.Street2   = item.Basket.Profile.Street;
                ViewBag.Number2   = item.Basket.Profile.Number;
            }

            //pobieranie danych o kwocie ktora user musi zaplacic

            var basket = db.Baskets.Select(o => o).Where(o => o.ID == id);

            foreach (var item in basket)
            {
                ViewBag.TotalPrice    = item.AllPrice;
                ViewBag.DeliveryPrice = item.DeliveryPrice;
            }
            return(View(bapp));
        }
        public ActionResult Done()
        {
            if (DeliveryPrice == '-')
            {
                ViewBag.Text = "Wybierz opcje dostawy!";
                RedirectToAction("Index");
            }

            if (listProductsSize.Count == 0)
            {
                return(View(listProductsSize));
            }

            //pobieranie ceny przesylki



            foreach (var item in deliversOptions)
            {
                //poprawic
                Price += item.KindOfDelivery.PriceForDelivery;
            }

            //pobieranie zalogowanego użytkownika

            var     pf      = db.Profiles.Select(u => u).Where(u => u.UserName == User.Identity.Name);
            Profile profile = null;

            foreach (var item in pf)
            {
                profile = item;
            }

            //pobranie odpowiedniego statusu

            var st = db.Status.Select(s => s).Where(s => s.Name == "Expectant");

            Status status = null;

            foreach (var item in st)
            {
                status = item;
            }

            //tworzenie zamowienia

            Basket basket = new Basket {
                Price = Price, Profile = profile, DateOrder = DateTime.Now, Status = status, DeliveryPrice = DeliveryPrice, AllPrice = Price
            };

            db.Baskets.Add(basket);
            db.SaveChanges();



            //tworzenie basket_products
            //pobieranie produktu ktore nalezy do zamowienia
            ProductSize prod = null;

            foreach (var item in listProductsSize)
            {
                var product = db.ProductSize.Select(p => p).Where(p => p.ID == item.ID);
                foreach (var item2 in product)
                {
                    prod = item2;
                }

                Basket_ProductSize bp = new Basket_ProductSize {
                    Basket = basket, ProductSize = prod
                };
                db.Basket_ProductSize.Add(bp);
                db.SaveChanges();
            }
            //wyzerowanie wartosci w koszyku
            listProductsSize.Clear();
            deliversOptions.Clear();
            Price = 0;

            var apikey = "efIWNWVx6pDzBF1oeNti8XBv0mjAoeykjY2RYWv4";

            var address = "https://api.smsapi.pl/sms.do?access_token=";
            var id1     = basket.Profile;

            var numer = "48" + profile.PhoneNumber;
            var email = profile.UserName;

            var message = "Thank you for your order :) ~ JUVENUS REGEM";


            var url = address + apikey + "&to=" + numer + "&message=" + message + "&sender=" + "&fast=1&format=json";

            HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url);

            HttpWebResponse resp    = (HttpWebResponse)req.GetResponse();
            StreamReader    sr      = new StreamReader(resp.GetResponseStream());
            string          results = sr.ReadToEnd();

            Debug.WriteLine(results);
            sr.Close();

            return(View("Done", listProductsSize));
        }