public Credential GetByID(int _businessEntityId)
{
CredentialDAC _credentialComponent = new CredentialDAC();
IDataReader reader = _credentialComponent.GetByIDCredential(_businessEntityId);
Credential _credential = null;
while(reader.Read())
{
_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; } reader.Close();
return _credential;
}
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;
}
public bool Update(Credential credential ,int old_businessEntityId)
{
CredentialDAC credentialComponent = new CredentialDAC();
return credentialComponent.UpdateCredential( credential.BusinessEntityId, credential.Username, credential.PasswordHash, credential.PasswordSalt, credential.ActivationCode, credential.IsActivated, credential.IsActive, credential.RowGuid, credential.ModifiedDate, old_businessEntityId);
}
public bool Insert(Credential credential)
{
CredentialDAC credentialComponent = new CredentialDAC();
return credentialComponent.InsertNewCredential( credential.BusinessEntityId, credential.Username, credential.PasswordHash, credential.PasswordSalt, credential.ActivationCode, credential.IsActivated, credential.IsActive, credential.RowGuid, credential.ModifiedDate);
}