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 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 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(int BusinessEntityId, string Username, string PasswordHash, string PasswordSalt, string ActivationCode, bool IsActivated, bool IsActive, Guid RowGuid, DateTime ModifiedDate) { CredentialDAC credentialComponent = new CredentialDAC(); return(credentialComponent.InsertNewCredential(BusinessEntityId, Username, PasswordHash, PasswordSalt, ActivationCode, IsActivated, IsActive, RowGuid, ModifiedDate)); }
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)); }
public int UpdateDataset(System.Data.DataSet dataset) { CredentialDAC credentialcomponent = new CredentialDAC(); return(credentialcomponent.UpdateDataset(dataset)); }
public void Delete(int Original_BusinessEntityId) { CredentialDAC credentialComponent = new CredentialDAC(); credentialComponent.DeleteCredential(Original_BusinessEntityId); }