/// <summary>
/// Retrieves a list of person items from the database.
/// </summary>
/// <param name="reader">The reader to be used to retrieve the data records.</param>
/// <param name="baseTableName">The base table name of the person item.</param>
/// <param name="baseTableID">The base table id of the person item.</param>
/// <param name="targetTableName">The target table name of the person item.</param>
/// <param name="order">The order in which the data records are to be sorted.</param>
/// <returns>The list of cast person items.</returns>
/// <exception cref="ArgumentNullException">Thrown when the given reader, base table name, base table id, target table name or order is null.</exception>
public static new List <CastPersonItem> RetrieveList(DBReader reader, string baseTableName, string baseTableID, string targetTableName, string order = "ID")
{
if (reader == null)
{
throw new ArgumentNullException(nameof(reader));
}
if (String.IsNullOrEmpty(baseTableName))
{
throw new ArgumentNullException(nameof(baseTableName));
}
if (String.IsNullOrEmpty(baseTableID))
{
throw new ArgumentNullException(nameof(baseTableID));
}
if (String.IsNullOrEmpty(targetTableName))
{
throw new ArgumentNullException(nameof(targetTableName));
}
if (String.IsNullOrEmpty(order))
{
throw new ArgumentNullException(nameof(order));
}
// Liste laden
reader.Query = $"SELECT ID " +
$"FROM {baseTableName}_{targetTableName} " +
$"WHERE {baseTableName}ID=\"{baseTableID}\"" +
$"ORDER BY {order}";
List <CastPersonItem> list = new List <CastPersonItem>();
if (reader.Retrieve(true) > 0)
{
list.Capacity = reader.Table.Rows.Count;
foreach (DataRow row in reader.Table.Rows)
{
CastPersonItem item = new CastPersonItem();
item.BaseTableName = baseTableName;
item.TargetTableName = targetTableName;
item.ID = row["ID"].ToString();
item.Retrieve(false);
list.Add(item);
}
}
return(list);
}
