public IList<Core.Business.Role> GetAllRole() { IList<Core.Business.Role> rolelist = new List<Core.Business.Role>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllRole); if (reader != null) { while (reader.Read()) { Core.Business.Role role = new Core.Business.Role(); if (!reader.IsDBNull(0)) role.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) role.Status = reader.GetInt32(1); if (!reader.IsDBNull(2)) role.AddDate = reader.GetDateTime(2); if (!reader.IsDBNull(3)) role.Name = reader.GetString(3); if (!reader.IsDBNull(4)) role.Description = reader.GetString(4); role.MarkOld(); rolelist.Add(role); } reader.Close(); } return rolelist; }
public Role Find(string name) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Name", SqlDbType.NVarChar, name); SqlDataReader reader = sql.ExecuteSqlReader(SqlFind); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Role role = new Core.Business.Role(); if (!reader.IsDBNull(0)) role.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) role.Status = reader.GetInt32(1); if (!reader.IsDBNull(2)) role.AddDate = reader.GetDateTime(2); if (!reader.IsDBNull(3)) role.Name = reader.GetString(3); if (!reader.IsDBNull(4)) role.Description = reader.GetString(4); reader.Close(); return role; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public Core.Business.Role Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@RoleId", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectRole"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Role role = new Core.Business.Role(); if (!reader.IsDBNull(0)) role.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) role.Description = reader.GetString(1); if (!reader.IsDBNull(2)) role.UserCode = reader.GetGuid(2); reader.Close(); return role; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public ICollection<Role> Find(Account account) { IList<Core.Business.Role> roles = new List<Core.Business.Role>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@accountid", SqlDbType.Int, account.Id); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllRoleByAccount); if (reader != null) { while (reader.Read()) { Core.Business.Role role = new Core.Business.Role(); if (!reader.IsDBNull(0)) role.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) role.Status = reader.GetInt32(1); if (!reader.IsDBNull(2)) role.AddDate = reader.GetDateTime(2); if (!reader.IsDBNull(3)) role.Name = reader.GetString(3); if (!reader.IsDBNull(4)) role.Description = reader.GetString(4); role.MarkOld(); roles.Add(role); } reader.Close(); } return roles; }
public IList<Core.Business.Role> GetAllRole() { IList<Core.Business.Role> rolelist = new List<Core.Business.Role>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectRolesAll"); if(reader != null) { while(reader.Read()) { Core.Business.Role role = new Core.Business.Role(); if (!reader.IsDBNull(0)) role.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) role.Description = reader.GetString(1); if (!reader.IsDBNull(2)) role.UserCode = reader.GetGuid(2); role.MarkOld(); rolelist.Add(role); } reader.Close(); } return rolelist; }