private void AddDataFromColumns(XmlRomInformation source, IProgramRomInformationBuilder programInformationBuilder)
{
foreach (var column in source.RomInfoDatabaseColumns)
{
try
{
switch (column.Name.ToXmlRomInformationDatabaseColumnName())
{
case XmlRomInformationDatabaseColumnName.title:
programInformationBuilder.WithTitle(StringConverter.Instance.Convert(column.Value));
programInformationBuilder.WithLongName(StringConverter.Instance.Convert(column.Value, 60));
break;
case XmlRomInformationDatabaseColumnName.vendor:
programInformationBuilder.WithVendor(StringConverter.Instance.Convert(column.Value));
break;
case XmlRomInformationDatabaseColumnName.release_date:
programInformationBuilder.WithYear(StringToMetadataDateTimeConverter.Instance.Convert(column.Value).Date.Year);
break;
case XmlRomInformationDatabaseColumnName.short_name:
programInformationBuilder.WithShortName(StringConverter.Instance.Convert(column.Value, 18));
break;
case XmlRomInformationDatabaseColumnName.name:
programInformationBuilder.WithVariantName(StringConverter.Instance.Convert(column.Value));
break;
case XmlRomInformationDatabaseColumnName.platform: // enum('Intellivision')
// Throw if it's not Intellivision?
break;
case XmlRomInformationDatabaseColumnName.variant: // this is variant number of the ROM, not the name of the variant
case XmlRomInformationDatabaseColumnName.origin: // set('INTV Funhouse','Intellivision Lives','manual entry','e-mail','intvname','ROM','CFG','LUIGI','Catalog','other') NOT NULL COMMENT '',
case XmlRomInformationDatabaseColumnName.box_variant:
case XmlRomInformationDatabaseColumnName.screenshot:
case XmlRomInformationDatabaseColumnName.preview:
case XmlRomInformationDatabaseColumnName.get_rom:
break;
default:
break;
}
}
catch (FormatException)
{
}
catch (ArgumentException)
{
}
}
}
private void AddBasicData(IProgramRomInformationBuilder programInformationBuilder, string title, string vendor, string yearString, string shortName)
{
try
{
programInformationBuilder.WithTitle(title);
}
catch (InvalidOperationException)
{
}
programInformationBuilder.WithVendor(vendor);
int year;
if (int.TryParse(yearString, out year))
{
programInformationBuilder.WithYear(year);
}
if (!string.IsNullOrEmpty(shortName))
{
programInformationBuilder.WithShortName(shortName);
}
}