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