Beispiel #1
0
 public List<Credential> GetAll()
 {
     CredentialDAC _credentialComponent = new CredentialDAC();
      IDataReader reader =  _credentialComponent.GetAllCredential().CreateDataReader();
      List<Credential> _credentialList = new List<Credential>();
      while(reader.Read())
      {
      if(_credentialList == null)
          _credentialList = new List<Credential>();
          Credential _credential = new Credential();
          if(reader["BusinessEntityId"] != DBNull.Value)
              _credential.BusinessEntityId = Convert.ToInt32(reader["BusinessEntityId"]);
          if(reader["Username"] != DBNull.Value)
              _credential.Username = Convert.ToString(reader["Username"]);
          if(reader["PasswordHash"] != DBNull.Value)
              _credential.PasswordHash = Convert.ToString(reader["PasswordHash"]);
          if(reader["PasswordSalt"] != DBNull.Value)
              _credential.PasswordSalt = Convert.ToString(reader["PasswordSalt"]);
          if(reader["ActivationCode"] != DBNull.Value)
              _credential.ActivationCode = Convert.ToString(reader["ActivationCode"]);
          if(reader["IsActivated"] != DBNull.Value)
              _credential.IsActivated = Convert.ToBoolean(reader["IsActivated"]);
          if(reader["IsActive"] != DBNull.Value)
              _credential.IsActive = Convert.ToBoolean(reader["IsActive"]);
          if(reader["RowGuid"] != DBNull.Value)
              _credential.RowGuid = new Guid(reader["RowGuid"].ToString());
          if(reader["ModifiedDate"] != DBNull.Value)
              _credential.ModifiedDate = Convert.ToDateTime(reader["ModifiedDate"]);
      _credential.NewRecord = false;
      _credentialList.Add(_credential);
      }             reader.Close();
      return _credentialList;
 }