public static List <User> createListOfUsersFromReader(SqlDataReader reader, List <Role> roles, List <Application> applications) { List <User> list = new List <User>(); while (reader.Read()) { int id = reader.GetInt32(0); String login = reader.GetString(1), password = reader.GetString(2); Boolean activeFlag = reader.GetBoolean(3); DateTime createdDate = reader.GetDateTime(4); int createdBy = reader.GetInt32(5); int lastModifiedBy = reader.GetInt32(6); DateTime lastModifiedDate = reader.GetDateTime(7); List <int> supportedAppId = ApplicationDAO.getAppIdForThisUser(id); List <int> userRole = RoleDAO.getRoleIdForThisUser(id); List <Role> role = getRoleFromList(roles, userRole); User user = new User(id, login, password, supportedAppId, role, activeFlag, createdDate, lastModifiedDate, createdBy, lastModifiedBy); list.Add(user); } return(list); }
private static List <User> makeUsersOutOfReader(SqlDataReader reader) { List <User> user = new List <User>(); while (reader.Read()) { int id = reader.GetInt32(0); String login = reader.GetString(1), password = reader.GetString(2); Boolean activeFlag = reader.GetByte(3) == 1; DateTime createdDate = reader.GetDateTime(4); int createdBy = reader.GetInt32(5); int lastModifiedBy = reader.GetInt32(6); DateTime lastModifiedDate = reader.GetDateTime(7); List <int> supportedAppId = ApplicationDAO.getAppIdForThisUser(id); List <Role> role = RoleDAO.getAllRolesForThisUser(id); user.Add(new User(id, login, password, supportedAppId, role, activeFlag, createdDate, lastModifiedDate, createdBy, lastModifiedBy)); } return(user); }