public static List <string> DataPopulationQueries()
{
var entries = new List <string>();
var auditSessionAndQueries = CreateAuditingSession("Mike Minns", "*****@*****.**", "Session 1", DateTime.Now);
entries.AddRange(auditSessionAndQueries.Queries);
var auditSession = auditSessionAndQueries.Instance;
var scrapbook = new Book("1st Derbyshire Yeomanry Scrapbook 1939 - 1947");
entries.AddRange(scrapbook.ToInsertQueries());
var citation1 = new Citation(scrapbook.Name, 1, auditSession.Id);
entries.AddRange(citation1.ToInsertQueries());
var uk = new Country("en-UK", citation1.Id, auditSession.Id);
entries.AddRange(uk.ToInsertQueries());
var derby = new Municipality("Derby", citation1.Id, auditSession.Id);
entries.AddRange(derby.ToInsertQueries());
entries.AddRange(new HostedBy(derby.Id, uk.Id, citation1.Id, auditSession.Id).ToInsertQueries());
var catterick = new Municipality("Catterick", citation1.Id, auditSession.Id);
entries.AddRange(catterick.ToInsertQueries());
entries.AddRange(new HostedBy(catterick.Id, uk.Id, citation1.Id, auditSession.Id).ToInsertQueries());
var london = new Municipality("London", citation1.Id, auditSession.Id);
entries.AddRange(london.ToInsertQueries());
entries.AddRange(new HostedBy(london.Id, uk.Id, citation1.Id, auditSession.Id).ToInsertQueries());
/*
* var scrapBook = new SimplePublication("1st Derbyshire Yeomanry Scrapbook 1939 - 1947",
* new VariousAuthors(),
* new UnknownEditors(),
* new UnknownPublicationDateTime(),
* new SimplePublisher("Bemrose & Sons Ltd",
* new List<IPostalAddress>() {
* new SimplePostalAddress(derby, uk),
* new SimplePostalAddress(london, uk)
* }
* )
* );
*/
var variousPerson = new Person("Various");
entries.AddRange(variousPerson.ToInsertQueries());
entries.AddRange(new Authored(variousPerson.Id, scrapbook.Id, citation1.Id, auditSession.Id).ToInsertQueries());
var unknownPerson = new Person("Unknown");
entries.AddRange(unknownPerson.ToInsertQueries());
entries.AddRange(new Edited(unknownPerson.Id, scrapbook.Id, citation1.Id, auditSession.Id).ToInsertQueries());
var bemrosePublisher = new Publisher("Bemrose & Sons Ltd", citation1.Id, auditSession.Id);
entries.AddRange(bemrosePublisher.ToInsertQueries());
entries.AddRange(new HostedBy(bemrosePublisher.Id, derby.Id, citation1.Id, auditSession.Id).ToInsertQueries());
entries.AddRange(new Hosts(derby.Id, bemrosePublisher.Id, citation1.Id, auditSession.Id).ToInsertQueries());
entries.AddRange(new HostedBy(bemrosePublisher.Id, london.Id, citation1.Id, auditSession.Id).ToInsertQueries());
entries.AddRange(new Hosts(london.Id, bemrosePublisher.Id, citation1.Id, auditSession.Id).ToInsertQueries());
entries.AddRange(new Published(bemrosePublisher.Id, scrapbook.Id, citation1.Id, auditSession.Id).ToInsertQueries());
entries.AddRange(new PublishedBy(scrapbook.Id, bemrosePublisher.Id, citation1.Id, auditSession.Id).ToInsertQueries());
/*
*
* var mobilisationDate = new FuzzyDateTime(new DateTime(1939, 7, 29), "yyyy/MM/dd");
* var veDay = new FuzzyDateTime(new DateTime(1945, 5, 8), "yyyy/MM/dd");
*/
var mobilisationDate = new FuzzyDateTime(new DateTime(1939, 7, 29), "yyyy/MM/dd", citation1.Id, auditSession.Id);
entries.AddRange(mobilisationDate.ToInsertQueries());
var mobilisationDay = new KeyDateTime("UK Mobilisation Day", citation1.Id, auditSession.Id);
entries.AddRange(mobilisationDay.ToInsertQueries());
entries.AddRange(new WhatHappenedWhen(mobilisationDay.Id, mobilisationDate.Id, citation1.Id, auditSession.Id).ToInsertQueries());
entries.AddRange(new WhenWhatHappened(mobilisationDate.Id, mobilisationDay.Id, citation1.Id, auditSession.Id).ToInsertQueries());
/*
* entries.AddRange(mobilisationDay.ToInsertQueries());
* entries.AddRange(new AuditedBy(mobilisationDay.Id, auditSession.Id).ToInsertQueries());
*
* var veDate = new FuzzyDateTime(new DateTime(1945, 5, 8), "yyyy/MM/dd", citation1.Id, auditSession.Id);
* entries.AddRange(veDate.ToInsertQueries());
* var veDay = new KeyDateTime("VE Day", citation1.Id, auditSession.Id);
* entries.AddRange(new WhatHappenedWhen(veDay.Id, veDate.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new WhenWhatHappened(veDate.Id, veDay.Id, citation1.Id, auditSession.Id).ToInsertQueries());
*/
/*
* var armouredCar = new TemporalRole(
* new Reconnaissance(),
* new FuzzyDateRange(
* mobilisationDate),
* GetCitationPage(1, scrapBook),
* audit);
*
*/
/*
*
* var firstDerbyshireYeomanry = new Unit("1st Derbyshire Yeomanry", "regiment", citation1.Id, auditSession.Id);
* //var firstDerbyshireYeomanry = new Regiment("1st Derbyshire Yeomanry", citation1, auditSession);
* var reconnaissance = new OrganisationRole("reconnaissance");
*
* var actedAs = new ActedAsDuring(firstDerbyshireYeomanry.Id, reconnaissance.Id, mobilisationDate.Id, citation1.Id, auditSession.Id);
* entries.AddRange(firstDerbyshireYeomanry.ToInsertQueries());
* entries.AddRange(reconnaissance.ToInsertQueries());
* entries.AddRange(actedAs.ToInsertQueries());
*/
/*
* var siddalsRoad = new SimplePostalAddress(null, new SimpleStreetAddress(91, "Siddals Road"), derby, null, null, uk, null, null);
* var siddalsRoadPosting = new TemporalLocation(siddalsRoad, new FuzzyDateRange(mobilisationDate),
* GetCitationPage(1, scrapBook),
* audit);
*/
/*
* var ninetyOne = new Building(91, citation1.Id, auditSession.Id);
* entries.AddRange(ninetyOne.ToInsertQueries());
*
* var siddalsRoad = new Street("Siddals Road", citation1.Id, auditSession.Id);
* entries.AddRange(siddalsRoad.ToInsertQueries());
*
* entries.AddRange(new Hosts(siddalsRoad.Id, ninetyOne.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(ninetyOne.Id, siddalsRoad.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new Hosts(derby.Id, siddalsRoad.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(siddalsRoad.Id, derby.Id, citation1.Id, auditSession.Id).ToInsertQueries());
*
*
*
* var latLong = new LatitudeLongtitude(0.0, 0.0, citation1.Id, auditSession.Id);
* entries.AddRange(new Hosts(ninetyOne.Id, latLong.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(latLong.Id, ninetyOne.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new Hosts(siddalsRoad.Id, latLong.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(latLong.Id, siddalsRoad.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new Hosts(derby.Id, latLong.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(latLong.Id, derby.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new Hosts(uk.Id, latLong.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(latLong.Id, uk.Id, citation1.Id, auditSession.Id).ToInsertQueries());
*
* var address = new Address(citation1.Id, auditSession.Id);
* entries.AddRange(new Hosts(address.Id, ninetyOne.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(ninetyOne.Id, address.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new Hosts(address.Id, siddalsRoad.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(siddalsRoad.Id, address.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new Hosts(address.Id, derby.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(derby.Id, address.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new Hosts(address.Id, uk.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(uk.Id, address.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new Hosts(address.Id, latLong.Id, citation1.Id, auditSession.Id).ToInsertQueries());
* entries.AddRange(new HostedBy(latLong.Id, address.Id, citation1.Id, auditSession.Id).ToInsertQueries());
*
* entries.AddRange(new LocatedInDuring(firstDerbyshireYeomanry.Id, address.Id, mobilisationDate.Id, citation1.Id, auditSession.Id).ToInsertQueries());
*/
/*
*
* firstDerbyshireYeomanry.AddLocation(siddalsRoadPosting);
*
* var mccHarrison = new Person("M.C.C", "Harrision", null, uk, GetCitationPage(2, scrapBook),
* audit);
*
* var commandFirstDerbyshireYeomanryPosting = new TemporalRole(new LieutenantColonel(firstDerbyshireYeomanry, mccHarrison),
* new FuzzyDateRange(
* new FuzzyDateTime(new DateTime(1939, 11, 7), "yyy/MM"),
* new FuzzyDateTime(new DateTime(1941, 4, 1), "yyy/MM")
* ),
* GetCitationPage(1, scrapBook),
* audit);
*
* firstDerbyshireYeomanry.AddPersonel(commandFirstDerbyshireYeomanryPosting);
* mccHarrison.AddAppointment(commandFirstDerbyshireYeomanryPosting);
*
*
*
*
*
*
*
* var ashbourneRoad = new SimplePostalAddress(null, new SimpleStreetAddress("Ashbourne Road"), derby, null, null, uk, null, null);
* var ashbourneRoadPosting = new TemporalLocation(ashbourneRoad, new FuzzyDateRange(new FuzzyDateTime(new DateTime(1939, 11, 1), "yyyy/MM"), new FuzzyDateTime(new DateTime(1940, 05, 1), "yyyy/MM")),
* GetCitationPage(2, scrapBook),
* audit);
*
* firstDerbyshireYeomanry.AddLocation(ashbourneRoadPosting);
* mccHarrison.AddLocation(ashbourneRoadPosting);
*
*
*
*
*
* var cavalryDivison = new TemporalRole(
* new Cavalry(),
* new FuzzyDateRange(
* mobilisationDate),
* GetCitationPage(4, scrapBook),
* audit);
* var catterickGarrision = new SimplePostalAddress(null, null, catterick, null, null, uk, null, null);
* var catterickGarrisionPosting = new TemporalLocation(catterickGarrision, new FuzzyDateRange(mobilisationDate, new FuzzyDateTime(new DateTime(1940, 05, 1), "yyyy/MM")),
* GetCitationPage(4, scrapBook),
* audit);
*
* var firstCavalryDivision = new Division("1st Cavalry", armouredCar, uk,
* GetCitationPage(4, scrapBook),
* audit);
* firstCavalryDivision.AddLocation(catterickGarrisionPosting);
*
* var cocFirstDerbyshireYeomanry = new TemporalChainOfCommand(firstCavalryDivision, firstDerbyshireYeomanry, new FuzzyDateRange(mobilisationDate, new FuzzyDateTime(new DateTime(1940, 05, 1), "yyyy/MM")),
* GetCitationPage(4, scrapBook),
* audit);
* firstCavalryDivision.AddHierarchy(cocFirstDerbyshireYeomanry);
* firstDerbyshireYeomanry.AddHierarchy(cocFirstDerbyshireYeomanry);
*
* var search = new FuzzyDateRange(new FuzzyDateTime(new DateTime(1939, 1, 1), "yyyy/MM/dd"), new FuzzyDateTime(new DateTime(1940, 12, 31), "yyyy/MM/dd"));
*
*
* var aSquadron = new Squadron("A", armouredCar, uk, GetCitationPage(7, scrapBook), audit);
* var bSquadron = new Squadron("B", armouredCar, uk, GetCitationPage(7, scrapBook), audit);
* var cSquadron = new Squadron("C", armouredCar, uk, GetCitationPage(7, scrapBook), audit);
* var dSquadron = new Squadron("D", armouredCar, uk, GetCitationPage(7, scrapBook), audit);
*
*
* EstablishChainOfCommand(firstDerbyshireYeomanry, aSquadron, mobilisationDate, veDay, GetCitationPage(4, scrapBook), audit);
* EstablishChainOfCommand(firstDerbyshireYeomanry, bSquadron, mobilisationDate, veDay, GetCitationPage(4, scrapBook), audit);
* EstablishChainOfCommand(firstDerbyshireYeomanry, cSquadron, mobilisationDate, veDay, GetCitationPage(4, scrapBook), audit);
* EstablishChainOfCommand(firstDerbyshireYeomanry, dSquadron, mobilisationDate, veDay, GetCitationPage(4, scrapBook), audit);
*
* var caistor = new Municipality("Caistor");
* var talbotArms = new SimplePostalAddress(null, new SimpleStreetAddress("16 High Street"), caistor, null, new SimplePostalCode("LN7 6QF"), uk, null, null);
* var rotationStart = new DateTime(1939, 11, 27);
* var rotationEnd = new DateTime(1940, 5, 24);
* int rotation = 0;
* while (rotationStart < rotationEnd)
* {
* var talbotArmsPostingRotation = new TemporalLocation(talbotArms, new FuzzyDateRange(new FuzzyDateTime(rotationStart, "yyyy/MM/dd"), 14),
* GetCitationPage(2, scrapBook),
* audit);
* rotationStart = rotationStart.AddDays(14);
* int i = rotation % 4;
* switch (i)
* {
* case 0:
* aSquadron.AddLocation(talbotArmsPostingRotation);
* entries.Add(GetEntry(aSquadron, talbotArmsPostingRotation));
* break;
* case 1:
* bSquadron.AddLocation(talbotArmsPostingRotation);
* entries.Add(GetEntry(bSquadron, talbotArmsPostingRotation));
* break;
* case 2:
* cSquadron.AddLocation(talbotArmsPostingRotation);
* entries.Add(GetEntry(cSquadron, talbotArmsPostingRotation));
* break;
* case 3:
* dSquadron.AddLocation(talbotArmsPostingRotation);
* entries.Add(GetEntry(dSquadron, talbotArmsPostingRotation));
* break;
* }
*
* rotation++;
* }
*
*
* entries.Add(GetEntry(firstDerbyshireYeomanry, firstDerbyshireYeomanry.Locations[0]));
* entries.Add(GetEntry(firstDerbyshireYeomanry, firstDerbyshireYeomanry.Locations[1]));
* entries.Add(GetEntry(mccHarrison, mccHarrison.Locations[0]));
* entries.Add(GetEntry(firstCavalryDivision, firstCavalryDivision.Locations[0]));
*
*/
return(entries);
}
