public static List<UserAccess> GetAll() { List<UserAccess> userAccessList = new List<UserAccess>(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetUserAccessCommand objectCommand = new GetUserAccessCommand(objectConnection)) { objectConnection.Open(); using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader()) { if (!sqlDataReader.HasRows) { return userAccessList; } using (UserAccessSqlDataReader objectSqlDataReader = new UserAccessSqlDataReader(sqlDataReader)) { while (objectSqlDataReader.Read()) { UserAccess userAccess = objectSqlDataReader.UserAccess; userAccessList.Add(userAccess); } } } } } return userAccessList; }
public static UserAccess GetByUserName(string userName) { UserAccess userAccess = new UserAccess(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetUserAccessByUserNameCommand objectCommand = new GetUserAccessByUserNameCommand(objectConnection)) { objectCommand.UserName = userName; objectConnection.Open(); using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader()) { if (!sqlDataReader.HasRows) { return null; } using (UserAccessSqlDataReader objectSqlDataReader = new UserAccessSqlDataReader(sqlDataReader)) { while (objectSqlDataReader.Read()) { userAccess = objectSqlDataReader.UserAccess; } } } } } return userAccess; }