//Daten laden
void LoadData()
{
int curCVID = dbcv.CurrentCVID;
var query = dbcv.dbCon.Table <DrivingLicenceTableItem>().Where(v => v.PersonendatenID == curCVID & v.Index == MyCounter);
if (query.Count() > 0)
{
dbRow = query.First();
HasLicense.SelectedIndex = dbRow.LicenseYes;
KlasseTyp.SelectedIndex = dbRow.LicenseTextID;
}
}
//Daten der Seite speichern
void SaveData()
{
int curCVID = dbcv.CurrentCVID;
var query = dbcv.dbCon.Table <DrivingLicenceTableItem>().Where(v => v.PersonendatenID == curCVID & v.Index == MyCounter);
if (query.Count() > 0)
{
dbRow = query.First();
}
else
{
DrivingLicenceTableItem newDBRow = new DrivingLicenceTableItem();
newDBRow.PersonendatenID = curCVID;
newDBRow.Index = MyCounter;
dbcv.dbCon.Insert(newDBRow);
dbRow = newDBRow;
SumPages += 1;
};
dbRow.LicenseYes = HasLicense.SelectedIndex;
dbRow.LicenseTextID = KlasseTyp.SelectedIndex;
dbcv.dbCon.Update(dbRow);
}
private List <ExpandoObject> GetDriveLicense()
{
List <ExpandoObject> DriveLicenses = new List <ExpandoObject>();
string DriveType = "";
string DriveTypeAll = "";
var query = dbcv.dbCon.Table <DrivingLicenceTableItem>().Where(v => v.PersonendatenID == dbcv.CurrentCVID);
if (query.Count() > 0)
{
for (int i = 1; i < query.Count() + 1; i++)
{
var query1 = dbcv.dbCon.Table <DrivingLicenceTableItem>().Where(v => v.PersonendatenID == dbcv.CurrentCVID & v.Index == i);
pdRowLicense = query1.First();
if (pdRowLicense.LicenseYes == 0)
{
switch (pdRowLicense.LicenseTextID)
{
case 0:
DriveType = "Klasse AM";
break;
case 1:
DriveType = "Klasse A1";
break;
case 2:
DriveType = "Klasse A2";
break;
case 3:
DriveType = "Klasse A";
break;
case 4:
DriveType = "Klasse B";
break;
case 5:
DriveType = "Klasse B96";
break;
case 6:
DriveType = "Klasse BE";
break;
case 7:
DriveType = "Klasse C1";
break;
case 8:
DriveType = "Klasse C1E";
break;
case 9:
DriveType = "Klasse C";
break;
case 10:
DriveType = "Klasse CE";
break;
case 11:
DriveType = "Klasse D1";
break;
case 12:
DriveType = "Klasse D1E";
break;
case 13:
DriveType = "Klasse D";
break;
case 14:
DriveType = "Klasse DE";
break;
case 15:
DriveType = "Klasse T";
break;
case 16:
DriveType = "Klasse L";
break;
}
if (i == 1)
{
DriveTypeAll = DriveType;
}
else
{
DriveTypeAll = DriveTypeAll + ", " + DriveType;
}
}
}
DriveLicenses.Add(GetDynamicDrive(DriveTypeAll));
}
return(DriveLicenses);
}
