public static int GetUserCount()
 {
     var db = new DAO.MainDataClassDataContext();
     return db.users.Count();
 }
        public ActionResult Register(Models.RegisterViewModel user)
        {
            if (ModelState.IsValid)
            {
                DAO.user newUser = new DAO.user();
                newUser.email = user.UserName;
                newUser.full_name = user.FullName;
                newUser.hash_password = SHA1.Encode(user.Password);
                newUser.tel = user.Tel;
                newUser.role_name = "none";

                DAO.MainDataClassDataContext db = new DAO.MainDataClassDataContext();
                db.users.InsertOnSubmit(newUser);

                db.SubmitChanges();

                TempData["message"] = "Welcome! you can post question now";
                Session["User"] = newUser;
                LoggedInCount++;

                return RedirectToAction("Index", "Rooms");
            }

            return View(user);
        }