public void InsertTestData()
        {
            Helper helper = new Helper();
            User dil = new User();
            dil.UserName = "******";
            dil.Password = helper.EncryptPassword(dil.UserName+"123");
            dil.Role = "Admin";
            String v1 = helper.GenerageVerificationCode(4);
            dil.VerificationCode = v1;

            User laxman = new User();
            laxman.UserName = "******";
            laxman.Password = helper.EncryptPassword(laxman.UserName+"123");
            laxman.Role = "Staff";
            String v2 = helper.GenerageVerificationCode(4);
            laxman.VerificationCode = v2;

            List<User> users = new List<User>();
            users.Add(dil);
            users.Add(laxman);
            using (var db = new GPAEntities())
            {
                db.Users.AddRange(users);
                db.SaveChanges();
            }
        }
        public String GetUserVerificationCode(int userId)
        {
            string verification = "";
            using (var db = new GPAEntities())
            {
                verification = db.Users.Where(r => r.UserID == userId).Select(s => s.VerificationCode).Single();

            }

            return verification;
        }
        public Boolean IsUserRegistered(User user)
        {
            Boolean flag = false;
            using (var db = new GPAEntities())
            {
                var userRegistraion = db.Registrations.Where(r => r.UserID == user.UserID).SingleOrDefault();
                if (userRegistraion != null)
                {
                    flag = true;
                }
                else

                    flag = false;

            }
            return flag;
        }
        public void RegisterUser(RegisterViewModel model,int userId)
        {
            using (var db = new GPAEntities())
            {
                Registration user = new Registration();
                user.FName = model.RegisterUserViewModel.FName;
                user.LName = model.RegisterUserViewModel.LName;
                user.Email = model.RegisterUserViewModel.Email;
                user.Address = model.RegisterUserViewModel.Address;
                user.City = model.RegisterUserViewModel.City;
                user.Zip = model.RegisterUserViewModel.Zip;
                user.LandNumber = model.RegisterUserViewModel.LandNumber;
                user.MobileNumber = model.RegisterUserViewModel.MobileNumber;
                user.UserID = userId;
                db.Registrations.Add(user);
                db.SaveChanges();

            }
        }
        public bool ValidateUser(LoginViewModel model, out User user)
        {
            //LoginViewModel
            String userName = model.UserName;
            String password = model.Password;
            Helper helper = new Helper();
            user = null;
            String epassword = helper.EncryptPassword(password);
            using (var db = new GPAEntities())
            {
                var _user = db.Users.Where(r => r.UserName == userName && r.Password == epassword).SingleOrDefault();

                if (_user!= null)
                {
                    user = _user;
                    return true;
                }
                else
                {
                    return false;
                }

            }
        }