public ActionResult Bill_To(Models.Bill_To u)
        {
            using (var context = new Shopping_DBEntities4())
            {
                var student = (from d in context.Bill_To
                               where d.UserID == SessionManager.User.UserID
                               select d).ToList();
                var total  = 0;
                var total1 = student.ToList();
                foreach (var x in total1)
                {
                    total = (Int32)x.Total;
                }
                ViewBag.total     = total;
                ViewData["total"] = total;
                foreach (var no in total1)
                {
                    if (no != null)
                    {
                        no.Display_Name     = u.Display_Name;
                        no.User_Name        = u.User_Name;
                        no.Password         = u.Password;
                        no.confirm_password = u.confirm_password;
                        no.Company_Name     = u.Company_Name;
                        no.Email            = u.Email;
                        no.Title            = u.Title;
                        no.First_Name       = u.First_Name;
                        no.Middle_Name      = u.Middle_Name;
                        no.Last_Name        = u.Last_Name;
                        no.Address_1        = u.Address_1;
                        no.Address_2        = u.Address_2;
                        no.Zip      = u.Zip;
                        no.Country  = u.Country;
                        no.State    = u.State;
                        no.Phone1   = u.Phone1;
                        no.Phone2   = u.Phone2;
                        no.Fax      = u.Mobile_Phone;
                        no.Email    = u.Fax;
                        no.message  = u.message;
                        no.Shipping = u.Shipping;
                        context.SaveChanges();
                        var data = new
                        {
                            success = true
                        };
                        return(Content("<script>alert('checkout successful!!!'); var data = new{success = true; document.location='NormalUser'</script>"));
                    }
                    else
                    {
                        return(View());
                    }
                }

                return(View());
            }
        }
        public ActionResult Bill_To()
        {
            using (var context = new Shopping_DBEntities4())
            {
                var student = (from d in context.Bill_To
                               where d.UserID == SessionManager.User.UserID
                               select d).Single();
                var total = 0;
                total = (Int32)student.Total;
            }
            Models.Bill_To u = new Models.Bill_To();
            u.Company_Name = Request["Company_Name"];
            u.Email        = Request["Email"];
            u.Title        = Request["Title"];
            u.First_Name   = Request["First_Name"];
            u.Middle_Name  = Request["Middle_Name"];
            u.Last_Name    = Request["Last_Name"];
            u.Address_1    = Request["Address_1"];
            u.Address_2    = Request["Address_2"];
            u.Zip          = Request["Zip"];
            u.Country      = Request["Country"];
            u.State        = Request["State"];
            u.Phone1       = Request["Confirm_password"];
            u.Phone2       = Request["Phone"];
            u.Fax          = Request["Mobile_Phone"];
            u.Email        = Request["Fax"];
            u.message      = Request["message"];
            u.Shipping     = Request["Shipping"];
            var obj = BAL.Bill_To.Save(u);

            if (obj > 0)
            {
                return(Content("<script>alert('checkout successful!!!');document.location='NormalUser'</script>"));
            }
            else
            {
                return(View());
            }
        }