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."); } }