public IList<Core.Business.AccountRole> GetAllAccountRole() { IList<Core.Business.AccountRole> accountRolelist = new List<Core.Business.AccountRole>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllAccountRole); if (reader != null) { while (reader.Read()) { Core.Business.AccountRole accountRole = new Core.Business.AccountRole(); accountRole.Id = new Core.Business.AccountRoleKey(); if (!reader.IsDBNull(0)) accountRole.Id.RoleId = reader.GetInt32(0); if (!reader.IsDBNull(1)) accountRole.Id.AccountId = reader.GetInt32(1); if (!reader.IsDBNull(2)) accountRole.Status = reader.GetInt32(2); if (!reader.IsDBNull(3)) accountRole.AddDate = reader.GetDateTime(3); accountRole.MarkOld(); accountRolelist.Add(accountRole); } reader.Close(); } return accountRolelist; }
public Core.Business.AccountRole Select(AccountRoleKey id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@RoleId", SqlDbType.Int, id.RoleId); sql.AddParameter("@AccountId", SqlDbType.Int, id.AccountId); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectAccountRole); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.AccountRole accountRole = new Core.Business.AccountRole(); accountRole.Id = new Core.Business.AccountRoleKey(); if (!reader.IsDBNull(0)) accountRole.Id.RoleId = reader.GetInt32(0); if (!reader.IsDBNull(1)) accountRole.Id.AccountId = reader.GetInt32(1); if (!reader.IsDBNull(2)) accountRole.Status = reader.GetInt32(2); if (!reader.IsDBNull(3)) accountRole.AddDate = reader.GetDateTime(3); reader.Close(); return accountRole; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }