public ConnectedRegistrationViewDO(PartVersion<AircraftCertRegistrationFMDO> registration)
{
this.LotId = registration.Part.LotId;
this.PartIndex = registration.Part.Index;
this.ActNumber = registration.Content.ActNumber;
this.CertNumber = registration.Content.CertNumber;
this.CertDate = registration.Content.CertDate;
this.IsActive = registration.Content.IsActive;
this.IsCurrent = registration.Content.IsCurrent;
this.RegisterCode = registration.Content.Register.Code;
}
public PersonInfoDO(
PartVersion<PersonDataDO> personDataPart,
PartVersion<InspectorDataDO> inspectorDataPart,
PartVersion<ExaminerDataDO> examinerDataPart)
{
this.PersonData = personDataPart.Content;
this.InspectorData = inspectorDataPart == null ?
null :
inspectorDataPart.Content;
this.ExaminerData = examinerDataPart == null ?
null :
examinerDataPart.Content;
}
public GameObject GetGOFromTypeAndVersion(ObjectType type, PartVersion version)
{
var intVersion = (int)version;
switch (type)
{
case ObjectType.HEAD: return(_headList.Objects.ElementAt(intVersion).gameObject);
case ObjectType.CHEST: return(_chestList.Objects.ElementAt(intVersion).gameObject);
case ObjectType.LEFT_ARM: return(_leftArmList.Objects.ElementAt(intVersion).gameObject);
case ObjectType.RIGHT_ARM: return(_rightArmList.Objects.ElementAt(intVersion).gameObject);
}
return(null);
}
private static void CreateTestPart()
{
using (var db = new ngenDbContext())
{
var part = db.Parts.SingleOrDefault(p => p.DrawingNumber == "ABC123");
if (part != null)
{
return;
}
var customer = new Customer
{
FullName = "Test Customer Limited",
ShortName = "Test Customer"
};
part = new Part
{
Customer = customer,
DrawingNumber = "ABC123",
Name = "Test Part"
};
var version = new PartVersion
{
VersionNumber = "01",
Changes = "N/A",
Part = part
};
db.Customers.Add(customer);
db.Parts.Add(part);
db.PartVersions.Add(version);
db.SaveChanges();
Console.WriteLine();
Console.WriteLine("Test part record created");
}
}
public AircraftDO(PartVersion<AircraftDataDO> aircraftDataPart)
{
this.AircraftData = aircraftDataPart.Content;
}
private object[] GetACLimitations(
PartVersion<PersonRatingDO> rating,
PartVersion<PersonRatingEditionDO> edition,
List<string> validAliases,
List<string> validCodes)
{
List<object> acLimitations = new List<object>();
if (rating.Content.AircraftTypeGroupId.HasValue && rating.Content.AircraftTypeCategoryId.HasValue &&
(edition.Content.Limitations != null && edition.Content.Limitations.Count > 0))
{
var aircraftTypeCategory = this.nomRepository.GetNomValue("aircraftClases66", rating.Content.AircraftTypeCategoryId.Value);
if (validCodes.Contains(nomRepository.GetNomValue("aircraftGroup66", aircraftTypeCategory.ParentValueId.Value).Code) &&
validAliases.Contains(nomRepository.GetNomValue("aircraftClases66", aircraftTypeCategory.NomValueId).TextContent.Get<string>("alias")))
{
acLimitations.Add(new
{
AIRCRAFT = this.nomRepository.GetNomValue("aircraftTypeGroups", rating.Content.AircraftTypeGroupId.Value).Name,
CAT = aircraftTypeCategory.Code.Contains("C") ? "C" : aircraftTypeCategory.Code,
LIM = string.Join(",", this.nomRepository.GetNomValues("limitations66", edition.Content.Limitations.ToArray()).Select(l => l.Name))
});
}
}
return acLimitations.ToArray();
}
private PartVersion<JObject> fixPersonFlyingExperience(PartVersion<JObject> flyingExperiencePartVersion)
{
int? oldId = flyingExperiencePartVersion.Content.Get<int?>("__oldId");
if (oldId.HasValue)
{
var result = this.oracleConn.CreateStoreCommand(
@"SELECT AMOUNT,
AMOUNT_M,
AMOUNT_SUM,
AMOUNT_M_SUM,
AMOUNT_12,
AMOUNT_M_12
FROM CAA_DOC.FLYING_EXPERIENCE WHERE {0}",
new DbClause("ID = {0}", oldId.Value)
)
.Materialize(r =>
Utils.ToJObject(new
{
total = Utils.TimeToMilliseconds(r.Field<int?>("AMOUNT"), r.Field<short?>("AMOUNT_M")),
totalDoc = Utils.TimeToMilliseconds(r.Field<int?>("AMOUNT_SUM"), r.Field<short?>("AMOUNT_M_SUM")),
totalLastMonths = Utils.TimeToMilliseconds(r.Field<int?>("AMOUNT_12"), r.Field<short?>("AMOUNT_M_12"))
}))
.Single();
flyingExperiencePartVersion.Content["total"] = result.Get<long?>("total");
flyingExperiencePartVersion.Content["totalDoc"] = result.Get<long?>("totalDoc");
flyingExperiencePartVersion.Content["totalLastMonths"] = result.Get<long?>("totalLastMonths");
return flyingExperiencePartVersion;
}
else
{
return null;
}
}
