private static void InitiliazeDatabase()
{
try
{
var ctx = new MassDefectContext();
ctx.Database.Initialize(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
static void Main()
{
MassDefectContext context = new MassDefectContext();
XDocument xml = XDocument.Load(NewAnomaliesPath);
IEnumerable <XElement> anomalies = xml.XPathSelectElements("anomalies/anomaly");
foreach (XElement anomalie in anomalies)
{
ImportAnomalyAndVictims(anomalie, context);
}
}
private static void ImportVictim(XElement victimNode, MassDefectContext context, Anomaly anomaly)
{
var name = victimNode.Attribute("name");
//check...
var personEntity = GetPersonByName(name.Value, context);
//check...
anomaly.Victims.Add(personEntity);
}
private static Person GetPersonByName(string personName, MassDefectContext context)
{
foreach (var person in context.Persons)
{
if (person.Name == personName)
{
return(person);
}
}
return(null);
}
private static Planet GetPlanetByName(string planetName, MassDefectContext context)
{
foreach (var planet in context.Planets)
{
if (planet.Name == planetName)
{
return(planet);
}
}
return(null);
}
private static Star GetStarByName(string starName, MassDefectContext context)
{
foreach (var star in context.Stars)
{
if (star.Name == starName)
{
return(star);
}
}
return(null);
}
private static SolarSystem GetSolarSystemByName(string solarSystemName, MassDefectContext context)
{
foreach (var solarSystem in context.SolarSystems)
{
if (solarSystem.Name == solarSystemName)
{
return(solarSystem);
}
}
return(null);
}
private static Anomaly GetAnomalyById(int?anomalyId, MassDefectContext context)
{
foreach (var anomaly in context.Anomalies)
{
if (anomaly.Id == anomalyId)
{
return(anomaly);
}
}
return(null);
}
private static void ExportPlanetsWhichAreNotAnomalyOrigins(MassDefectContext context)
{
var planets = context.Planets.Where(p => !p.OriginalAnomalies.Any())
.Select(p => new
{
name = p.Name
}).ToList();
var text = JsonConvert.SerializeObject(planets, Formatting.Indented);
File.WriteAllText("../../export/planets.json", text);
}
private static void ExportPlanetsWhichAreNotAnomalyOrigins(MassDefectContext context)
{
var exportedPlanets = context.Planets.Where(planet => !planet.OriginAnomalies.Any()).
Select(planet => new
{
name = planet.Name
});
var planetExport = JsonConvert.SerializeObject(exportedPlanets, Formatting.Indented);
File.WriteAllText(exportPathPlantes, planetExport);
}
public static void Main(string[] args)
{
var xml = XDocument.Load(NewAnomaliesPath);
var anomalies = xml.XPathSelectElements("anomalies/anomaly");
MassDefectContext context = new MassDefectContext();
foreach (XElement anomaly in anomalies)
{
ImportAnomalyAndVictims(anomaly, context);
}
}
static void Main(string[] args)
{
MassDefectContext context = new MassDefectContext();
ExportPlanetsWhichAreNotAnomalyOrigins(context);
ExportPeopleWhichHaveNotBeenVictims(context);
ExportTopAnomaly(context);
context.SaveChanges();
}
static void Main(string[] args)
{
XDocument xml = XDocument.Load(AnomaliesXMLPath);
IEnumerable <XElement> anomalies = xml.XPathSelectElements("anomalies/anomaly");
MassDefectContext context = new MassDefectContext();
foreach (var anomaly in anomalies)
{
ImportAnomalyAndVictims(anomaly, context);
}
}
static void Main()
{
var context = new MassDefectContext();
//ImportSolarSystems(context); Console.WriteLine();
//ImportStars(context); Console.WriteLine();
//ImportPlanets(context); Console.WriteLine();
//ImportPersons(context); Console.WriteLine();
//ImportAnomalies(context); Console.WriteLine();
//ImportAnomalyVictims(context);
ImportNewAnomalies(context);
}
private static Anomaly GetAnomalyById(string id, MassDefectContext context)
{
var anomalies = context.Anomalies;
foreach (var anomaly in anomalies)
{
if (anomaly.Id.ToString() == id)
{
return(anomaly);
}
}
return(null);
}
private static void ExportPeopleWhichHaveNotBeenVictims(MassDefectContext context)
{
var persons = context.Persons.Where(p => !p.Anomalies.Any())
.Select(p => new
{
name = p.Name,
homePlanet = new { name = p.HomePlanet.Name }
}).ToList();
var text = JsonConvert.SerializeObject(persons, Formatting.Indented);
File.WriteAllText("../../export/persons.json", text);
}
private static Person GetPersonByName(string person, MassDefectContext context)
{
var anomPerson = context.Persons;
foreach (var person1 in anomPerson)
{
if (person1.Name.Equals(person))
{
return(person1);
}
}
return(null);
}
public static void Main()
{
//IMPORTANT!
//To run it -> CHANGE data source in all Connection Strings!
var context = new MassDefectContext();
ExportPlanetsWhichAreNotAnomalyOrigins(context);
ExportPeopleWhoHaveNotBeenVictims(context);
ExportTopAnomaly(context);
}
private static Person GetPersonByName(string value, MassDefectContext context)
{
var names = context.Persons;
foreach (var item in names)
{
if (item.Name == value)
{
return(item);
}
}
return(null);
}
public static void Main()
{
var context = new MassDefectContext();
try
{
context.Database.Initialize(true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private static SolarSystem GetSolarSystemByName(string solarSystem, MassDefectContext context)
{
var solarSystemNames = context.SolarSystems;
foreach (var solarSystemName in solarSystemNames)
{
if (solarSystemName.Name == solarSystem)
{
return(solarSystemName);
}
}
return(null);
}
private static Star GetStarByName(string sun, MassDefectContext context)
{
var suns = context.Stars;
foreach (var star in suns)
{
if (star.Name == sun)
{
return(star);
}
}
return(null);
}
private static Person GetPersonByName(string value, MassDefectContext context)
{
var persons = context.Persons;
foreach (var person in persons)
{
if (person.Name == value)
{
return(person);
}
}
return(null);
}
private static Anomaly GetAnomalyById(int id, MassDefectContext context)
{
var anomaly = context.Anomalies;
foreach (var anom in anomaly)
{
if (anom.Id == id)
{
return(anom);
}
}
return(null);
}
private static Planet GetPlanetByName(string value, MassDefectContext context)
{
var planets = context.Planets;
foreach (var planet in planets)
{
if (planet.Name == value)
{
return(planet);
}
}
return(null);
}
private static Star GetSunByName(string sun, MassDefectContext context)
{
var planets = context.Stars;
foreach (var planet in planets)
{
if (planet.Name.Equals(sun))
{
return(planet);
}
}
return(null);
}
static void Main()
{
var xml = XDocument.Load(NewAnomaliesPath);
var anomalies = xml.XPathSelectElements("anomalies/anomaly");
var context = new MassDefectContext();
var count = context.Anomalies.Count();
foreach (var anomaly in anomalies)
{
ImportAnomalyAndVictims(anomaly, context);
}
}
private static SolarSystem GetSolarSystemByName(string solarSystem, MassDefectContext context)
{
var system = context.SolarSystems;
foreach (var solarSystem1 in system)
{
if (solarSystem1.Name.Equals(solarSystem))
{
return(solarSystem1);
}
}
return(null);
}
private static Planet GetHomePlanet(string homePlanet, MassDefectContext context)
{
var planets = context.Planets;
foreach (var planet in planets)
{
if (planet.Name.Equals(homePlanet))
{
return(planet);
}
}
return(null);
}
public static void Main()
{
var xml = XDocument.Load(NewAnomaliesPath);
var anomalies = xml.XPathSelectElements("anomalies/anomaly");
var context = new MassDefectContext();
foreach (var anomaly in anomalies)
{
ImportAnomalyAndVictims(anomaly, context);
Console.WriteLine("Successfully imported anomaly.");
}
}
