Qualification GetOrCreateQualification(New.Person person)
{
var qual = newDatabase.Qualifications.FirstOrDefault(x => x.PersonId == person.PersonId);
if (qual == null)
{
qual = new Qualification
{
Person = person,
};
newDatabase.Qualifications.InsertOnSubmit(qual);
newDatabase.SubmitChanges();
}
return qual;
}
void UpdateQual(Qualification qual, Formrecord record)
{
switch (record.Formfield.Name)
{
case "Date Last BFR or Qual Form 8": qual.LastBFR = TryParseDate(record.Storedvalue); return;
case "Date Last Military Flight Physical": qual.LastMilitaryFlightPhysical = TryParseDate(record.Storedvalue); return;
case "Date Last Altitude Chamber": qual.LastAltitudeChamber = TryParseDate(record.Storedvalue); return;
case "Date Last Egrees Training LL-03": qual.LastEgreesTraining = TryParseDate(record.Storedvalue); return;
case "Date Last Simulator Refresher": qual.LastSimulatorRefresher = TryParseDate(record.Storedvalue); return;
case "Date Last CRM": qual.LastCRM = TryParseDate(record.Storedvalue); return;
case "Date Last Life Support Training": qual.LastLifeSupportTraining = TryParseDate(record.Storedvalue); return;
case "Date Last Flight": qual.LastFlight = TryParseDate(record.Storedvalue); return;
case "Military FCF Qual": qual.MilitaryFCFQualification = PraseFCFQual(record.Storedvalue); return;
default: return;
};
}
partial void UpdateQualification(Qualification instance);
partial void DeleteQualification(Qualification instance);
partial void InsertQualification(Qualification instance);
