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;
}
