public ActionResult Edit(User user)
 {
     if (ModelState.IsValid)
     {
         db.Entry(user).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     return View(user);
 }
        public ActionResult Login(User u)
        {
            AppIdentityDBContext db = new AppIdentityDBContext();
            var count = db.Users.Where(x => x.Username == u.Username && x.Password == u.Password).Count();
            var checkuser = db.Users.Where(x => x.Username == u.Username && x.Password == u.Password && x.Role=="p").Count();
            if (count == 0)
            {
                ViewBag.Msg = "Invalid User!";
                return View();
            }

            else if (checkuser != 0)
            {
                ViewBag.Mssg = "Your account is waiting for approval!";
                return View();
            }

            else
            {
                FormsAuthentication.SetAuthCookie(u.Username, false);
                return RedirectToAction("Index", "Home");
            }
        }
 public ActionResult Register(User u)
 {
     if (ModelState.IsValid)
     {
         var checkUser = db.Users.Where(x => x.Username == u.Username).Count();
         if (checkUser == 0)
         {
             using (AppIdentityDBContext db = new AppIdentityDBContext())
             {
                 u.Role = "p";
                 u.Approved = "pending";
                 db.Users.Add(u);
                 db.SaveChanges();
                 ModelState.Clear();
                 u = null;
                 ViewBag.Msg = "Successfully registered.";
             }
         }
         else
         {
             ViewBag.Msg = "That username is already taken, try another one.";
             return View(u);
         }
     }
     return View(u);
 }