public bool ModifyPassword(int aUserID, String aNewPassword)
 {
     using (documentmanagerEntities entities = new documentmanagerEntities())
     {
         var lUserList = from r in entities.user where r.user_id == aUserID select r;
         if (lUserList.Count() > 0)
         {
             user lUser = lUserList.First();
             lUser.user_password = aNewPassword;
             entities.SaveChanges();
             return true;
         }
         else
         {
             return false;
         }
     }
 }
        public override bool ValidateUser(string username, string password)
        {
            try
            {
                using (documentmanagerEntities entities = new documentmanagerEntities())
                {
                    var result = from r in entities.user where (r.user_name == username && r.user_password == password) select r;

                    LocalServerService lLocalService = new LocalServerService();
                    if (lLocalService.GetExpireDay() < 0)
                    {
                        return true;
                    }

                    if (result.Count() > 0)
                    {
                        return true;
                    }
                    else
                    {
                        return false;
                    }
                }
            }
            catch (System.Exception ex)
            {

                return false;
            }
        }