public ActionResult LogIn(UsserAccount user, string url)
        { //check if password and username are in db
            var usr = db.accounts_table.SingleOrDefault(u => u.UserName == user.UserName && u.Password == user.Password);

            if (usr != null)
            {
                Session["UsedId"]   = usr.UsedId;
                Session["UserName"] = usr.UserName.ToString();
                Session["IsAdmin"]  = usr.IsAdmin;

                if (url == null)
                {
                    return(RedirectToAction("LoggedIn"));
                }
                else
                {
                    Redirect(url);
                }
            }
            else
            {
                ModelState.AddModelError("", "User name or password wrong ");
            }
            return(View());
        }// view for successfull login
 public ActionResult SetCC(string url)
 {
     if (!(Session["UsedId"] == null))
     {
         int          id  = (int)Session["UsedId"];
         UsserAccount usr = db.accounts_table.SingleOrDefault(u => u.UsedId == id);
         if (usr.cardId == null)
         {
             return(View());
         }
     }
     return(Content("not logged on or credit card information already set"));
 }
        protected bool IsUnique(UsserAccount user)// method to check for username, email uniqueness
        {
            var username = db.accounts_table.SingleOrDefault(a => a.UserName == user.UserName);
            var email    = db.accounts_table.SingleOrDefault(a => a.Email == user.Email);

            if (username == null && email == null)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
 public ActionResult Register(UsserAccount account)
 {
     if (ModelState.IsValid)    // checks for form errors
     {
         if (IsUnique(account)) // check database for username -- username needs to be uniqie
         {
             db.accounts_table.Add(account);
             db.SaveChanges();
             TempData["Confirmation"] = account.FirstName + " " + account.LastName + " registration was successful";
             //Confirmation message
             return(RedirectToAction("LogIn"));
         }
         else
         {
             ViewBag.message = "username or password is already in use, please use another.";
         }
     }
     return(View());
 }
        public ActionResult SetCC(CreditCard card, string url)
        {
            if (ModelState.IsValid)
            {
                db.card_table.Add(card);
                db.SaveChanges();
                var          carid = db.card_table.SingleOrDefault(u => u.CCNum == card.CCNum).Id;
                int          id    = (int)Session["UsedId"];
                UsserAccount user  = db.accounts_table.SingleOrDefault(u => u.UsedId == id);
                user.cardId          = carid;
                db.Entry(user).State = System.Data.Entity.EntityState.Modified;
                db.SaveChanges();
                if (url == null)
                {
                    return(RedirectToAction("Customer_index", "bks"));
                }
                else
                {
                    return(Redirect(url));
                }
            }

            return(View());
        }