private void CheckTableDescription()
{
string tmp;
bool id_event, id_instanz, typ;
var query = conn.Table <Table_Beschreibung>();
foreach (var entry in query)
{
id_event = EventPKs.Contains(entry.Id_Veranstaltung);
id_instanz = InstanzPKs.Contains(entry.Id_Instanz);
typ = API_Contract.ProgrammDescrTypHR.TryGetValue(entry.Typ, out tmp);
if (!id_event || !id_instanz || !typ)
{
var invalid = new InvalidStruct(entry);
if (!id_event)
{
invalid.errors.Add("ID_VERANSTALTUNG");
}
if (!id_instanz)
{
invalid.errors.Add("ID_INSTANZ");
}
if (!typ)
{
invalid.errors.Add("TYP");
}
invalidEntrys.Add(invalid);
}
}
}
private void CheckTableInstanz()
{
bool event_id, date;
var query = conn.Table <Table_Instanz>();
foreach (var entry in query)
{
event_id = EventPKs.Contains(entry.Id_Veranstaltung);
date = Regex.IsMatch(entry.StartDatum, "^20(1[7-9]|[2-9][0-9])\\/(0[0-9]|1[0,2])\\/[0-3][0-9]$");
if (!event_id || !date)
{
var invalid = new InvalidStruct(entry);
if (!event_id)
{
invalid.errors.Add("EVENT_ID");
}
if (!date)
{
invalid.errors.Add("DATUM");
}
invalidEntrys.Add(invalid);
}
// Add pks
InstanzPKs.Add(entry.Id);
}
}
private void CheckTableTermin()
{
string tmp;
bool id_event, time, typ;
var query = conn.Table <Table_Termin>();
foreach (var entry in query)
{
id_event = EventPKs.Contains(entry.Id_Veranstaltung);
time = Regex.IsMatch(entry.Uhrzeit, "^(0[0-9]|1[0-9]|2[0-3]):[0-5][0-9]:[0-9]*$");
typ = API_Contract.ProgrammTerminTypHR.TryGetValue(entry.Typ, out tmp);
if (!id_event || !time || !typ)
{
var invalid = new InvalidStruct(entry);
if (!id_event)
{
invalid.errors.Add("ID_VERANSTALTUNG");
}
if (!time)
{
invalid.errors.Add("UHRZEIT");
}
if (!typ)
{
invalid.errors.Add("TYP");
}
invalidEntrys.Add(invalid);
}
}
}
private void CheckTableVeranstaltung()
{
bool year, lang;
var query = conn.Table <Table_Veranstaltung>();
foreach (var entry in query)
{
year = entry.Jahr >= 2017;
lang = GtkHelper.FindInArray(API_Contract.SupportedLanguages, entry.Sprache) != -1;
if (!year || !lang)
{
var invalid = new InvalidStruct(entry);
if (!year)
{
invalid.errors.Add("JAHR");
}
if (!lang)
{
invalid.errors.Add("SPRACHE");
}
invalidEntrys.Add(invalid);
}
// Add pks
EventPKs.Add(entry.Id);
}
}
private void CheckTableKategorieTabText()
{
string tmp;
bool typ;
var query = conn.Table <Table_Kategorie_Tab_Text>();
foreach (var entry in query)
{
typ = API_Contract.CategorieTextParentTypHR.TryGetValue(entry.Typ, out tmp);
if (!typ)
{
var invalid = new InvalidStruct(entry);
invalid.errors.Add("TYP");
invalidEntrys.Add(invalid);
}
}
}
