private void migrateGenders(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("gender"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_SEX") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), ParentValueId = null, Alias = r.Field<string>("NAME_TRANS"), TextContentString = null, IsActive = true }) .ToList(); noms["gender"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["gender"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateAircraftDebtTypesFm(INomRepository repo, SqlConnection conn) { Nom nom = repo.GetNom("aircraftDebtTypesFm"); var nomInfo = new Dictionary<string, Tuple<string, string>>() { {"PLE" , new Tuple<string,string>("ЗАЛОГ" , "Pledge" )}, {"DASS", new Tuple<string,string>("ЗАПОР" , "Distraint" )} }; noms["aircraftDebtTypesFm"] = new Dictionary<string, NomValue>(); foreach (var ni in nomInfo) { NomValue row = new NomValue() { OldId = null, Code = ni.Key, Name = ni.Value.Item1, NameAlt = ni.Value.Item2, Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }; noms["aircraftDebtTypesFm"][Guid.NewGuid().ToString()] = row; nom.NomValues.Add(row); } }
private void migrateAircraftOccurrenceClasses(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("aircraftOccurrenceClasses"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_SHORT_LISTS where domain = 'INCIDENT_CLASS'") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("MEANING"), NameAlt = r.Field<string>("MEANING_TRANS"), Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }) .ToList(); noms["aircraftOccurrenceClasses"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["aircraftOccurrenceClasses"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateAircraftCatAWsFm(INomRepository repo, SqlConnection conn) { Nom nom = repo.GetNom("aircraftCatAWsFm"); var results = conn.CreateStoreCommand(@"SELECT [Category BG], [Category EN], Code FROM CatAW") .Materialize(r => new NomValue { OldId = null, Code = r.Field<string>("Code"), Name = r.Field<string>("Category BG"), NameAlt = r.Field<string>("Category EN"), Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }) .ToList(); noms["aircraftCatAWsFm"] = new Dictionary<string, NomValue>(); foreach (var row in results) { if (row.Code == "0" || row.Code == "BLANK") { continue; } noms["aircraftCatAWsFm"][Guid.NewGuid().ToString()] = row; //no old id nom.NomValues.Add(row); } }
private void migrateAircraftClases66(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("aircraftClases66"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_CATEGORY_66") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("DESCRIPTION"), NameAlt = null, Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = noms["aircraftGroup66"].ByOldId(r.Field<long?>("ID_AC_66").ToString()).NomValueId(), TextContentString = JsonConvert.SerializeObject( new { alias = r.Field<string>("CATEGORY") }) }) .ToList(); noms["aircraftClases66"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["aircraftClases66"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateRatingSubClasses(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("ratingSubClasses"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_SUBCLASS_ATSM") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("DESCRIPTION"), NameAlt = null, Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = noms["ratingClasses"].ByOldId(r.Field<decimal>("CLASS_ID").ToString()).NomValueId(), TextContentString = null }) .ToList(); noms["ratingSubClasses"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["ratingSubClasses"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateSchools(INomRepository repo, OracleConnection conn) { Func<string, int?> getGradId = (oldId) => noms["graduations"].ByOldId(oldId).NomValueId(); Nom nom = repo.GetNom("schools"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.SCHOOL") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = null, TextContentString = JsonConvert.SerializeObject( new { isPilotTraining = r.Field<string>("PILOT_TRAINING")== "Y" ? true : false, graduationId = getGradId(r.Field<decimal?>("GRADUATION_ID").ToString()), graduationIds = r.Field<string>("GRADUATION_ID_LIST") .Split(':') .Select(gi => getGradId(gi)) .Where(gi => gi.HasValue) .Select(gi => gi.Value) .ToArray() }) }) .GroupBy(r => r.Name) .ToList(); noms["schools"] = new Dictionary<string, NomValue>(); foreach (var rows in results) { foreach (var row in rows) { noms["schools"][row.OldId] = rows.First(); } nom.NomValues.Add(rows.First()); } }
private void migrateLim147limitations(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("lim147limitations"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_147_LIMITATION") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = noms["lim147ratings"].ByOldId(r.Field<long?>("ID_147_RATING").ToString()).NomValueId(), TextContentString = JsonConvert.SerializeObject( new { SortOrder = r.Field<string>("SORT_ORDER"), }) }) .ToList(); noms["lim147limitations"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["lim147limitations"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateLim147ratings(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("lim147ratings"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_147_RATING") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("SORT_ORDER"), Name = r.Field<string>("RATING"), NameAlt = null, Alias = null, IsActive = true, ParentValueId = noms["lim147classes"].ByOldId(r.Field<long?>("ID_147_CLASS").ToString()).NomValueId(), TextContentString = null }) .ToList(); noms["lim147ratings"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["lim147ratings"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateLicenceTypeDictionary(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("licenceTypeDictionary"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.LICENCE_DICTIONARY") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = null, Alias = null, IsActive = true, ParentValueId = noms["staffTypes"].ByOldId(r.Field<decimal?>("STAFF_TYPE_ID").ToString()).NomValueId(), TextContentString = null }) .ToList(); noms["licenceTypeDictionary"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["licenceTypeDictionary"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateLicenceTypes(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("licenceTypes"); var templateNames = new Dictionary<string, string>() { { "103", "flight_licence" }, { "161", "foreign_licence" }, { "181", "caa_steward" }, { "242", "student_flight_licence" }, { "261", "coordinator" }, { "262", "flight" }, { "281", "atcl1" }, { "289", "convoy" }, { "301", "student_controller" }, { "302", "AML_national" }, { "321", "coordinator_simi" }, { "323", "rvd_licence" }, { "324", "AML_III" }, { "328", "Pilot142_2013" }, { "329", "CAL03_2013" }, { "361", "pilot" }, { "601", "AML" } }; var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_LICENCE_TYPE") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = true, ParentValueId = noms["staffTypes"].ByOldId(r.Field<decimal?>("STAFF_TYPE_ID").ToString()).NomValueId(), TextContentString = JsonConvert.SerializeObject( new { codeCA = r.Field<string>("CA_CODE"), dateValidFrom = r.Field<DateTime?>("DATE_FROM"), dateValidTo = r.Field<DateTime?>("DATE_TO"), seqNo = r.Field<decimal?>("SEQ_NO"), prtMaxRatingCount = r.Field<decimal?>("PRT_MAX_RATING_COUNT"), prtMaxMedCertCount = r.Field<decimal?>("PRT_MAX_MED_CERT_COUNT"), licenceTypeDictionaryId = noms["licenceTypeDictionary"].ByOldId(r.Field<decimal?>("LICENCE_DICTIONARY_ID").ToString()).NomValueId(), licenceTypeDictionary1Id = noms["licenceTypeDictionary"].ByOldId(r.Field<decimal?>("LICENCE_DICTIONARY1_ID").ToString()).NomValueId(), licenceTypeDictionary2Id = noms["licenceTypeDictionary"].ByOldId(r.Field<decimal?>("LICENCE_DICTIONARY2_ID").ToString()).NomValueId(), prtPrintableDocId = r.Field<decimal?>("PRT_PRINTABLE_DOCUMENT_ID"), qlfCode = r.Field<string>("LICENCE_CODE") != "FCL.CPA" ? r.Field<string>("QLF_CODE") : null, templateName = templateNames[r.Field<object>("PRT_PRINTABLE_DOCUMENT_ID").ToString()], caseTypeAlias = noms["staffTypes"].ByOldId(r.Field<int>("STAFF_TYPE_ID").ToString()).Alias }) }) .ToList(); noms["licenceTypes"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["licenceTypes"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateLicenceChangeReasons(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("licenceChangeReasons"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_LICENCE_CHANGE_REASON") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = null, Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = null, TextContentString = JsonConvert.SerializeObject( new { seqNo = r.Field<decimal?>("SEQ_NO"), reasonGroup = r.Field<string>("REASON_GROUP") }) }) .ToList(); noms["licenceChangeReasons"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["licenceChangeReasons"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateLangLevels(INomRepository repo, OracleConnection conn) { var roleAliases = new Dictionary<string, string[]>() { { "L4", new string[] { "bgCert", "engCert" } }, { "L5", new string[] { "bgCert", "engCert" } }, { "L6", new string[] { "bgCert", "engCert" } }, { " L4", new string[] { "engCert" } }, { " L5", new string[] { "engCert" } }, { " L6", new string[] { "engCert" } }, { "B4", new string[] { "bgCert" } }, { "B5", new string[] { "bgCert" } }, { "B6", new string[] { "bgCert" } }, }; Nom nom = repo.GetNom("langLevels"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_ENG_LANG") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("LANG_LEVEL"), NameAlt = r.Field<string>("LANG_LEVEL_TRANS"), Alias = null, IsActive = true, ParentValueId = null, TextContentString = JsonConvert.SerializeObject( new { roleAliases = roleAliases[r.Field<string>("CODE")], seqNumber = r.Field<decimal?>("SEQ_NUMBER").ToString(), }) }) .ToList(); noms["langLevels"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["langLevels"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateGroundServiceOperatorActivityTypes(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("groundServiceOperatorActivityTypes"); var nomInfo = new Dictionary<string, Tuple<string, string>>() { { "GAS" , new Tuple<string,string>("Наземно администриране и надзор" , "" )}, { "CS" , new Tuple<string,string>("Обслужване на пътници" , "" )}, { "BP" , new Tuple<string,string>("Обработка на багажи" , "" )}, { "CMP" , new Tuple<string,string>("Обработка на товари и поща" , "" )}, { "ACPS" , new Tuple<string,string>("Перонно обслужване на въздухоплавателни средства" , "" )}, { "ACS" , new Tuple<string,string>("Обслужване на въздухоплавателни средства" , "" )}, { "ACSFO" , new Tuple<string,string>("Обслужване на въздухоплавателни средства с горива и масла" , "" )}, { "ACTS" , new Tuple<string,string>("Техническо обслужване на въздухоплавателни средства" , "" )}, { "FOCA" , new Tuple<string,string>("Полетни операции и администриране на екипажите" , "" )}, { "GT" , new Tuple<string,string>("Наземен транспорт" , "" )}, { "BBS" , new Tuple<string,string>("Обслужване на бордния бюфет" , "" )} }; noms["groundServiceOperatorActivityTypes"] = new Dictionary<string, NomValue>(); foreach (var ni in nomInfo) { NomValue row = new NomValue() { OldId = null, Code = ni.Key, Name = ni.Value.Item1, NameAlt = ni.Value.Item2, Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }; noms["groundServiceOperatorActivityTypes"][Guid.NewGuid().ToString()] = row; nom.NomValues.Add(row); } }
private void migratePersonStatusTypes(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("personStatusTypes"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_SHORT_LISTS where domain = 'STATE_REASON'") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("MEANING"), NameAlt = r.Field<string>("MEANING_TRANS"), Alias = null, IsActive = r.Field<string>("CODE") != "BR" ? true : false, ParentValueId = null, TextContentString = null }) .ToList(); noms["personStatusTypes"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["personStatusTypes"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateLimitations66(INomRepository repo, OracleConnection conn) { var limitationTypes = new Dictionary<string, string>() { {"M", "ATSML"}, {"N", "AMLAircrafts"}, {"F", "FCL"}, {"Y", "AMLCommon"} }; Nom nom = repo.GetNom("limitations66"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_LIMITATIONS_66") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE").Trim(), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = null, TextContentString = JsonConvert.SerializeObject( new { type = limitationTypes[r.Field<string>("GENERAL")], point = 13 }) }) .ToList(); noms["limitations66"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["limitations66"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateRatingClassGroups(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("ratingClassGroups"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_RATING_CLASS_GROUP") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = null, Alias = null, IsActive = true, ParentValueId = null, TextContentString = JsonConvert.SerializeObject( new { caseTypeAlias = noms["staffTypes"].ByOldId(r.Field<decimal>("STAFF_TYPE_ID").ToString()).Alias }) }) .ToList(); noms["ratingClassGroups"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["ratingClassGroups"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateLocationIndicators(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("locationIndicators"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_INDICATOR") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("POSITION"), NameAlt = r.Field<string>("POSITION_TRANS"), Alias = null, IsActive = true, ParentValueId = null, TextContentString = JsonConvert.SerializeObject( new { type = r.Field<string>("FLAG_YN"), }) }) .ToList(); noms["locationIndicators"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["locationIndicators"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateRatingTypes(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("ratingTypes"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_RATING_TYPE") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = true, ParentValueId = null, TextContentString = JsonConvert.SerializeObject( new { codeCA = r.Field<string>("CA_CODE"), dateValidFrom = r.Field<DateTime?>("DATE_FROM"), dateValidTo = r.Field<DateTime?>("DATE_TO") }) }) .ToList(); noms["ratingTypes"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["ratingTypes"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateOrganizationKinds(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("organizationKinds"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_SHORT_LISTS where domain = 'TYPE_ORG'") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("MEANING"), NameAlt = r.Field<string>("MEANING_TRANS"), Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }) .ToList(); noms["organizationKinds"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["organizationKinds"][row.OldId] = row; nom.NomValues.Add(row); } var organizationFmTypes = new List<Tuple<string, string>>() { { new Tuple<string,string>("АД" , "AD")}, { new Tuple<string,string>("ООД" , "OOD")} }; foreach (var type in organizationFmTypes) { NomValue row = new NomValue() { OldId = null, Code = type.Item2, Name = type.Item1, NameAlt = type.Item1, Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }; noms["organizationKinds"][Guid.NewGuid().ToString()] = row; nom.NomValues.Add(row); } }
private void migrateStaffTypes(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("staffTypes"); var aliases = new Dictionary<string, string>() { { "F", "flightCrew" }, { "T", "ovd"}, { "G", "to_vs"}, { "M", "to_suvd"} }; var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_STAFF_TYPE") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), ParentValueId = null, Alias = aliases[r.Field<string>("CODE")], TextContentString = JsonConvert.SerializeObject( new { codeCA = r.Field<string>("CA_CODE") }), IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false }) .ToList(); noms["staffTypes"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["staffTypes"][row.OldId] = row; nom.NomValues.Add(row); } Nom trainingStaffTypesNom = repo.GetNom("trainingStaffTypes"); var copiedResults = results.Select(v => new NomValue { OldId = v.OldId, Code = v.Code, Name = v.Name, NameAlt = v.NameAlt, ParentValueId = v.ParentValueId, Alias = v.Alias, TextContentString = v.TextContentString, IsActive = v.IsActive }); noms["trainingStaffTypes"] = new Dictionary<string, NomValue>(); foreach (var row in copiedResults) { noms["trainingStaffTypes"][row.OldId] = row; trainingStaffTypesNom.NomValues.Add(row); } NomValue generalDocument = new NomValue { NomValueId = 0, Name = "Общ документ", Alias = "general" }; noms["trainingStaffTypes"]["0"] = generalDocument; trainingStaffTypesNom.NomValues.Add(generalDocument); }
private void migrateOrganizationTypes(INomRepository repo, OracleConnection oracleConection, SqlConnection sqlConnection) { Nom nom = repo.GetNom("organizationTypes"); var orgApexTypes = oracleConection.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_FIRM_TYPE") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = null, TextContentString = null }) .ToList(); noms["organizationTypes"] = new Dictionary<string, NomValue>(); foreach (var row in orgApexTypes) { noms["organizationTypes"][row.OldId] = row; nom.NomValues.Add(row); } List<string> addedCodes = orgApexTypes.Select(a => a.Code).ToList(); var orgFmTypes = sqlConnection.CreateStoreCommand(@"select * from OrgGrp") .Materialize(r => new NomValue { OldId = null, Code = r.Field<string>("Code"), Name = r.Field<string>("Group Organization"), NameAlt = r.Field<string>("Group Organization"), Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }) .ToList(); foreach (var row in orgFmTypes.Where(t => !addedCodes.Contains(t.Code))) { noms["organizationTypes"][Guid.NewGuid().ToString()] = row; nom.NomValues.Add(row); } }
private void migrateAircraftCategories(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("aircraftCategories"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_AC_CATEGORY") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = null, TextContentString = null }) .ToList(); results.Add(new NomValue() { OldId = "11", Code = "VP", Name = "Мотопарапланер", NameAlt = "Paramotor-Trike", Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }); results.Add(new NomValue() { OldId = "12", Code = "GR", Name = "Автожир", NameAlt = "Gyroplane", Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }); noms["aircraftCategories"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["aircraftCategories"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migratePersonCheckRatingValues(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("personCheckRatingValues"); var nomInfo = new Dictionary<string, Tuple<string, string, bool>>() { { "G", new Tuple<string,string, bool>("Добро" , "Good" , true)}, { "S", new Tuple<string,string, bool>("Задоволително" , "Satisfactory" , true)}, { "I", new Tuple<string,string, bool>("Недостатъчно" , "Insufficient" , true)}, { "U", new Tuple<string,string, bool>("Неприемливо" , "Unacceptable" , true)}, { "К", new Tuple<string,string, bool>("Компетентен" , "Competent" , true)}, { "Н", new Tuple<string,string, bool>("Некомпетентен" , "Incompetent" , true)}, { "C", new Tuple<string,string, bool>("C" , "C" , false)} }; noms["personCheckRatingValues"] = new Dictionary<string, NomValue>(); int order = 0; foreach (var ni in nomInfo) { NomValue row = new NomValue() { OldId = null, Code = ni.Key, Name = ni.Value.Item1, NameAlt = ni.Value.Item2, Alias = null, IsActive = ni.Value.Item3, ParentValueId = null, TextContentString = null, Order = order++ }; noms["personCheckRatingValues"][Guid.NewGuid().ToString()] = row; nom.NomValues.Add(row); } }
private void migrateAircraftCreditorsFm(INomRepository repo, SqlConnection conn) { Nom nom = repo.GetNom("aircraftCreditorsFm"); var results = conn.CreateStoreCommand(@"select distinct t_Creditor_Name from Morts_new") .Materialize(r => new NomValue { OldId = null, Code = null, Name = r.Field<string>("t_Creditor_Name"), NameAlt = null, Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }) .ToList(); noms["aircraftCreditorsFm"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["aircraftCreditorsFm"][Guid.NewGuid().ToString()] = row; nom.NomValues.Add(row); } }
private void migratePersonExperienceRoles(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("experienceRoles"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_EXPERIENCE_ROLE") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = null, TextContentString = JsonConvert.SerializeObject( new { codeCA = r.Field<string>("CA_CODE"), }) }) .ToList(); noms["experienceRoles"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["experienceRoles"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateAircraftLimitationsFm(INomRepository repo, SqlConnection conn) { Nom nom = repo.GetNom("aircraftLimitationsFm"); var results = conn.CreateStoreCommand(@" SELECT [Code] code, [Limitation BG] name, [Limitation EN] nameAlt FROM [GvaAircraft].[dbo].[LimitAW]") .Materialize(r => new NomValue { OldId = r.Field<string>("code"), Code = r.Field<string>("code"), Name = r.Field<string>("name"), NameAlt = r.Field<string>("nameAlt"), Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }) .ToList(); noms["aircraftLimitationsFm"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["aircraftLimitationsFm"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migratePersonRatingModels(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("personRatingModels"); var nomInfo = new Dictionary<string, Tuple<string, string>>() { { "P", new Tuple<string,string>("Постоянно" , "Permanently" )}, { "T", new Tuple<string,string>("Временно" , "Temporarily" )} }; noms["personRatingModels"] = new Dictionary<string, NomValue>(); foreach (var ni in nomInfo) { NomValue row = new NomValue() { OldId = null, Code = ni.Key, Name = ni.Value.Item1, NameAlt = ni.Value.Item2, Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }; noms["personRatingModels"][Guid.NewGuid().ToString()] = row; nom.NomValues.Add(row); } }
private void migrateAircraftOperTypes(INomRepository repo, OracleConnection conn) { Nom nom = repo.GetNom("aircraftOperTypes"); var results = conn.CreateStoreCommand(@"SELECT * FROM CAA_DOC.NM_AC_OPER") .Materialize(r => new NomValue { OldId = r.Field<object>("ID").ToString(), Code = r.Field<string>("CODE"), Name = r.Field<string>("NAME"), NameAlt = r.Field<string>("NAME_TRANS"), Alias = null, IsActive = r.Field<string>("VALID_YN") == "Y" ? true : false, ParentValueId = null, TextContentString = null }) .ToList(); noms["aircraftOperTypes"] = new Dictionary<string, NomValue>(); foreach (var row in results) { noms["aircraftOperTypes"][row.OldId] = row; nom.NomValues.Add(row); } }
private void migrateEURegTypesFm(INomRepository repo, SqlConnection conn) { Nom nom = repo.GetNom("EURegTypesFm"); var nomInfo = new Dictionary<string, Tuple<string, string>>() { { "EU" , new Tuple<string,string>("EU" , "EU" )}, { "EUR" , new Tuple<string,string>("EU - Restricted" , "EU - Restricted" )}, { "OD" , new Tuple<string,string>("Old Doc" , "Old Doc" )}, { "AN" , new Tuple<string,string>("Annex II" , "Annex II" )}, { "A2" , new Tuple<string,string>("Article-2" , "Article-2" )}, { "A1" , new Tuple<string,string>("Article-1" , "Article-1" )}, { "VLA" , new Tuple<string,string>("VLA" , "VLA" )}, { "AM" , new Tuple<string,string>("Amateur" , "Amateur" )}, { "EXP" , new Tuple<string,string>("EXP" , "EXP" )}, { "RU" , new Tuple<string,string>("RU" , "RU" )}, }; noms["EURegTypesFm"] = new Dictionary<string, NomValue>(); foreach (var ni in nomInfo) { NomValue row = new NomValue() { OldId = null, Code = ni.Key, Name = ni.Value.Item1, NameAlt = ni.Value.Item2, Alias = null, IsActive = true, ParentValueId = null, TextContentString = null }; noms["EURegTypesFm"][Guid.NewGuid().ToString()] = row; nom.NomValues.Add(row); } }