private void GetDayparts(OleDbConnection connection)
{
try
{
_dayparts.Clear();
var dataTable = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
foreach (DataRow row in dataTable.Rows)
{
var daypart = new NameCodePair();
daypart.Name = row["TABLE_NAME"]?.ToString().Replace("$", "").Replace('"'.ToString(), "'").Replace("'", "") ?? String.Empty;
if (!new[]
{
"Headers-Positioning Point",
"Length",
"Dayparts",
"Stations",
"Client Type",
"Date",
"Custom Demos",
"Sources",
"File-Status",
"Toggle Defaults"
}.Contains(daypart.Name.Trim()))
{
_dayparts.Add(daypart);
}
}
}
catch
{
}
}
public static T GetDataTypeComponent <T>(string name, Dictionary <string, string> ncDict, Dictionary <NameCodePair, T> ncPairComponentDict)
{
ncDict.TryGetValue(name, out string code);
var ncPair = new NameCodePair(name, code);
ncPairComponentDict.TryGetValue(ncPair, out T result);
return(result);
}
private static bool GetNationAndSpecInfo(
char nationChar,
char specChar,
out NameCodePair nationInfo,
out NameCodePair specInfo
)
{
nationInfo = new NameCodePair();
specInfo = new NameCodePair();
var coalitionCodes = new[] { 'W', 'X', 's', 't' };
if (!coalitionCodes.Contains(nationChar))
{
nationInfo = GetNationInfo(nationChar);
var specIndex = specChar - 'I';
specInfo = GetSpecInfo(specIndex);
return(true);
}
if (nationChar == 'W')
{
if (GetIndex(specChar) >= GetIndex('A') && GetIndex(specChar) <= GetIndex('H'))
{
nationInfo = new NameCodePair("Eurocorps", "eu");
var specIndex = GetIndex(specChar) - GetIndex('A');
specInfo = GetSpecInfo(specIndex);
return(true);
}
if (GetIndex(specChar) >= GetIndex('I') && GetIndex(specChar) <= GetIndex('P'))
{
nationInfo = new NameCodePair("Scandinavia", "scandi");
var specIndex = GetIndex(specChar) - GetIndex('I');
specInfo = GetSpecInfo(specIndex);
return(true);
}
if (GetIndex(specChar) >= GetIndex('Q') && GetIndex(specChar) <= GetIndex('X'))
{
nationInfo = new NameCodePair("Commonwealth", "cw");
var specIndex = GetIndex(specChar) - GetIndex('Q');
specInfo = GetSpecInfo(specIndex);
return(true);
}
if (GetIndex(specChar) >= GetIndex('Y') && GetIndex(specChar) <= GetIndex('f'))
{
nationInfo = new NameCodePair("Blue Dragons", "bd");
var specIndex = GetIndex(specChar) - GetIndex('Y');
specInfo = GetSpecInfo(specIndex);
return(true);
}
}
if (nationChar == 'X')
{
if (GetIndex(specChar) >= GetIndex('A') && GetIndex(specChar) <= GetIndex('H'))
{
nationInfo = new NameCodePair("Norad", "norad");
var specIndex = GetIndex(specChar) - GetIndex('A');
specInfo = GetSpecInfo(specIndex);
return(true);
}
if (GetIndex(specChar) >= GetIndex('I') && GetIndex(specChar) <= GetIndex('P'))
{
nationInfo = new NameCodePair("Bluefor", "bluefor");
var specIndex = GetIndex(specChar) - GetIndex('I');
specInfo = GetSpecInfo(specIndex);
return(true);
}
}
if (nationChar == 's')
{
if (GetIndex(specChar) >= GetIndex('g') && GetIndex(specChar) <= GetIndex('n'))
{
nationInfo = new NameCodePair("Red Dragons", "rd");
var specIndex = GetIndex(specChar) - GetIndex('g');
specInfo = GetSpecInfo(specIndex);
return(true);
}
if (GetIndex(specChar) >= GetIndex('o') && GetIndex(specChar) <= GetIndex('v'))
{
nationInfo = new NameCodePair("NSWP", "nswp");
var specIndex = GetIndex(specChar) - GetIndex('o');
specInfo = GetSpecInfo(specIndex);
return(true);
}
if (GetIndex(specChar) >= GetIndex('5') && GetIndex(specChar) <= GetIndex('/'))
{
nationInfo = new NameCodePair("SovKor", "sovkor");
var specIndex = GetIndex(specChar) - GetIndex('5');
specInfo = GetSpecInfo(specIndex);
return(true);
}
}
if (nationChar == 't')
{
if (GetIndex(specChar) >= GetIndex('I') && GetIndex(specChar) <= GetIndex('P'))
{
nationInfo = new NameCodePair("Redfor", "redfor");
var specIndex = GetIndex(specChar) - GetIndex('I');
specInfo = GetSpecInfo(specIndex);
return(true);
}
}
return(false);
}
private static bool GetNationAndSpecInfo(
char nationChar,
char specChar,
out NameCodePair nationInfo,
out NameCodePair specInfo
)
{
nationInfo = new NameCodePair();
specInfo = new NameCodePair();
var coalitionCodes = new[] { 'W', 'X', 's', 't' };
if (!coalitionCodes.Contains(nationChar)){
nationInfo = GetNationInfo(nationChar);
var specIndex = specChar - 'I';
specInfo = GetSpecInfo(specIndex);
return true;
}
if (nationChar == 'W')
{
if (GetIndex(specChar) >= GetIndex('A') && GetIndex(specChar) <= GetIndex('H'))
{
nationInfo = new NameCodePair("Eurocorps", "eu");
var specIndex = GetIndex(specChar) - GetIndex('A');
specInfo = GetSpecInfo(specIndex);
return true;
}
if (GetIndex(specChar) >= GetIndex('I') && GetIndex(specChar) <= GetIndex('P'))
{
nationInfo = new NameCodePair("Scandinavia", "scandi");
var specIndex = GetIndex(specChar) - GetIndex('I');
specInfo = GetSpecInfo(specIndex);
return true;
}
if (GetIndex(specChar) >= GetIndex('Q') && GetIndex(specChar) <= GetIndex('X'))
{
nationInfo = new NameCodePair("Commonwealth", "cw");
var specIndex = GetIndex(specChar) - GetIndex('Q');
specInfo = GetSpecInfo(specIndex);
return true;
}
if (GetIndex(specChar) >= GetIndex('Y') && GetIndex(specChar) <= GetIndex('f'))
{
nationInfo = new NameCodePair("Blue Dragons", "bd");
var specIndex = GetIndex(specChar) - GetIndex('Y');
specInfo = GetSpecInfo(specIndex);
return true;
}
}
if (nationChar == 'X')
{
if (GetIndex(specChar) >= GetIndex('A') && GetIndex(specChar) <= GetIndex('H'))
{
nationInfo = new NameCodePair("Norad", "norad");
var specIndex = GetIndex(specChar) - GetIndex('A');
specInfo = GetSpecInfo(specIndex);
return true;
}
if (GetIndex(specChar) >= GetIndex('I') && GetIndex(specChar) <= GetIndex('P'))
{
nationInfo = new NameCodePair("Bluefor", "bluefor");
var specIndex = GetIndex(specChar) - GetIndex('I');
specInfo = GetSpecInfo(specIndex);
return true;
}
}
if (nationChar == 's')
{
if (GetIndex(specChar) >= GetIndex('g') && GetIndex(specChar) <= GetIndex('n'))
{
nationInfo = new NameCodePair("Red Dragons", "rd");
var specIndex = GetIndex(specChar) - GetIndex('g');
specInfo = GetSpecInfo(specIndex);
return true;
}
if (GetIndex(specChar) >= GetIndex('o') && GetIndex(specChar) <= GetIndex('v'))
{
nationInfo = new NameCodePair("NSWP", "nswp");
var specIndex = GetIndex(specChar) - GetIndex('o');
specInfo = GetSpecInfo(specIndex);
return true;
}
if (GetIndex(specChar) >= GetIndex('5') && GetIndex(specChar) <= GetIndex('/'))
{
nationInfo = new NameCodePair("SovKor", "sovkor");
var specIndex = GetIndex(specChar) - GetIndex('5');
specInfo = GetSpecInfo(specIndex);
return true;
}
}
if (nationChar == 't')
{
if (GetIndex(specChar) >= GetIndex('I') && GetIndex(specChar) <= GetIndex('P'))
{
nationInfo = new NameCodePair("Redfor", "redfor");
var specIndex = GetIndex(specChar) - GetIndex('I');
specInfo = GetSpecInfo(specIndex);
return true;
}
}
return false;
}
