public MainEncyclopedia() { InitializeComponent(); LoadEncyclopedia(); var n1 = new TreeNodeViewModel("General"); n1.PropertyChanged += UpdateTextBox; using (var context = new Db1Entities()) { var raceList = ( from c in context.Aliens select c ).ToList(); var raceNodeList = new List<TreeNodeViewModel>(); foreach (var t1 in raceList.Select(item => new TreeNodeViewModel(item.Name))) { t1.PropertyChanged += UpdateTextBox; raceNodeList.Add(t1); } var n2 = new TreeNodeViewModel("Races", raceNodeList, null); n2.PropertyChanged += UpdateTextBox; var settings = new SettingsViewModel(new[] { n1, n2 }); DataContext = settings; } }
private void btDel_Click( object sender, RoutedEventArgs e ) { var context = new Db1Entities(); var query = from c in context.Attribute where c.Name == TbStat.Text select c; var foundstat = query.FirstOrDefault(); if (TbStat.Text == "") { MessageBox.Show("Please input Stat!"); } else { if (foundstat != null && foundstat.Id != 0) { context.Attribute.Remove(foundstat); context.SaveChanges(); FillListbox(); MessageBox.Show("'" + TbStat.Text + "' deleted from the Database"); TbStat.Text = ""; } else { MessageBox.Show("No Stat with that Name found in the Database"); } } }
private void btAdd_Click( object sender, RoutedEventArgs e ) { using (var context = new Db1Entities()) { var req = new Requirements { SourceItemID = _sourceItemId, TargetRequirementID = _targetItemId, TargetType = _targetType, SourceType = _sourceType, Condition = CbConditions.SelectedValue.ToString(), SourceName = TbObject.Text, TargetName = TbTarget.Text, ConditionValue = TbConditionValue.Text }; context.Requirements.Add(req); context.SaveChanges(); } var treeViewItem = TvObjects.SelectedItem as TreeViewItem; if (treeViewItem != null) { treeViewItem.IsSelected = false; } var viewItem = TvTargets.SelectedItem as TreeViewItem; if (viewItem != null) { viewItem.IsSelected = false; } TbConditionValue.Text = ""; TbObject.Text = ""; TbTarget.Text = ""; LoadSetPrereqList(); }
private static void newTextbox_KeyDown( object sender, KeyEventArgs e ) { if (e.Key != Key.Enter) { return; } using (var context = new Db1Entities()) { var textBox = sender as TextBox; if (textBox != null) { var encyclopedia = new Encyclopedia { Name = textBox.Text }; context.Encyclopedia.Add(encyclopedia); } context.SaveChanges(); var box = sender as TextBox; if (box != null) { MessageBox.Show("The Encyclopedia '" + box.Text + "' has been added to the Database"); } } var grid = ( (TextBox) sender ).Parent as Grid; ( grid?.Parent as Window )?.Close(); }
private void btAdd_Click( object sender, RoutedEventArgs e ) { int result; int.TryParse(TbPoints.Text, out result); using (var context = new Db1Entities()) { var addSkill = new Skills { SkillName = TbSkillName.Text, DifficultyLevel = TbDifficultyLevel.Text, notes = TbNotes.Text, points = result, reference = TbReference.Text, tech_level = TbTechLevel.Text, ControllingAttribute = TbControllingAttribute.Text, Description = TbDiscription.Text, Defaults = TbDefault.Text, Prerequisites = TbPrerequisite.Text }; //AddSkill.specialization = tbSpecialization.Text; //AddSkill.Modifiers = tbModifiers.Text; context.Skills.Add(addSkill); context.SaveChanges(); } InitForm(); btClear_Click(this, null); }
public static DateTime GetCurrentDateTime() { var timecontext = new Db1Entities(); var query = from c in timecontext.UDateTime orderby c.Id descending select c; var filterquery = query.FirstOrDefault(); return filterquery?.CurrentDateTime ?? new DateTime(); }
private void btAdd_Click( object sender, RoutedEventArgs e ) { var findcontext = new Db1Entities(); var query = from c in findcontext.Attribute where c.Name == TbStat.Text select c; var foundstat = query.FirstOrDefault(); if (foundstat == null) { if (TbStat.Text == "") { MessageBox.Show("Please input Stat!"); } else { using (var context = new Db1Entities()) { var newStat = new Attribute { Name = TbStat.Text }; context.Attribute.Add(newStat); context.SaveChanges(); } MessageBox.Show("'" + TbStat.Text + "' added to the Database"); FillListbox(); TbStat.Text = ""; } } else { MessageBox.Show("That Stat allready exists in the Database!"); } }
public static List <StarSystems> LoadAllSystems() { var context = new Db1Entities(); var query = from c in context.StarSystems select c; var allSystems = query.ToList(); return(allSystems); }
private void btDelete_Click( object sender, RoutedEventArgs e ) { using (var context = new Db1Entities()) { var delFaction = ( from c in context.Factions where c.Id == LoadedId select c ).FirstOrDefault(); context.Entry(delFaction).State = EntityState.Deleted; context.SaveChanges(); } MessageBox.Show("The Faction '" + TbName.Text + "' has been deleted from the Database"); btClear_Click(this, null); }
private void btApply_Click( object sender, RoutedEventArgs e ) { if (TbIsOuter.Text == "true") { OuterMoonlets updatemoonlet; using (var ctx = new Db1Entities()) { updatemoonlet = ctx.OuterMoonlets.FirstOrDefault(s => s.Id.ToString() == TbMoonletId.Text); } if (updatemoonlet != null) { updatemoonlet.name = TbMoonletName.Text; updatemoonlet.planetRadius = double.Parse(TbMoonletRadius.Text); updatemoonlet.blackbodyTemp = double.Parse(TbMoonletblackbodyTemp.Text); updatemoonlet.planetRadius = double.Parse(TbMoonletRadius.Text); updatemoonlet.orbitalEccent = double.Parse(TbMoonletorbitalEccent.Text); updatemoonlet.orbitalPeriod = double.Parse(TbMoonletorbitalPeriod.Text); updatemoonlet.orbitalRadius = double.Parse(TbMoonletorbitalRadius.Text); } using (var dbCtx = new Db1Entities()) { dbCtx.Entry(updatemoonlet).State = EntityState.Modified; dbCtx.SaveChanges(); } SystemSelector.CurrentInstance.LoadSystemsFromSql(); } else { InnerMoonlets updatemoonlet; using (var ctx = new Db1Entities()) { updatemoonlet = ctx.InnerMoonlets.FirstOrDefault(s => s.Id.ToString() == TbMoonletId.Text); } if (updatemoonlet != null) { if (TbMoonletName.Text != "") { updatemoonlet.name = TbMoonletName.Text; } updatemoonlet.planetRadius = double.Parse(TbMoonletRadius.Text); updatemoonlet.blackbodyTemp = double.Parse(TbMoonletblackbodyTemp.Text); updatemoonlet.planetRadius = double.Parse(TbMoonletRadius.Text); updatemoonlet.orbitalEccent = double.Parse(TbMoonletorbitalEccent.Text); updatemoonlet.orbitalPeriod = double.Parse(TbMoonletorbitalPeriod.Text); updatemoonlet.orbitalRadius = double.Parse(TbMoonletorbitalRadius.Text); } using (var dbCtx = new Db1Entities()) { dbCtx.Entry(updatemoonlet).State = EntityState.Modified; dbCtx.SaveChanges(); } SystemSelector.CurrentInstance.LoadSystemsFromSql(); } }
public static void SetCurrentDateTime( DateTime dt ) { using (var context = new Db1Entities()) { var uDateTime = new UDateTime { CurrentDateTime = dt, SystemTime = DateTime.Now }; context.UDateTime.Add(uDateTime); context.SaveChanges(); } }
private void btApply_Click( object sender, RoutedEventArgs e ) { Planets updateplanet; using (var ctx = new Db1Entities()) { updateplanet = ctx.Planets.FirstOrDefault(s => s.Id.ToString() == TbPlanetId.Text); } if (updateplanet != null) { updateplanet.name = TbPlanetName.Text; updateplanet.atmCate = int.Parse(TbPlanetatmCate.Text); updateplanet.atmMass = double.Parse(TbPlanetatmMass.Text); updateplanet.atmPres = TbPlanetatmPres.Text; updateplanet.atmnote = TbPlanetatmNote.Text; updateplanet.axialTilt = double.Parse(TbPlanetaxialTilt.Text); updateplanet.mass = double.Parse(TbPlanetPlanetMass.Text); updateplanet.RVM = TbPlanetRvm.Text; updateplanet.orbitalPeriod = double.Parse(TbPlanetorbitalPeriod.Text); updateplanet.orbitalRadius = double.Parse(TbPlanetorbitalRadius.Text); updateplanet.orbitalEccent = double.Parse(TbPlanetorbitalEccent.Text); updateplanet.moonRadius = double.Parse(TbPlanetRadius.Text); updateplanet.baseType = int.Parse(TbPlanetType.Text); updateplanet.SatelliteSize = int.Parse(TbPlanetSite.Text); updateplanet.blackbodyTemp = double.Parse(TbPlanetbbt.Text); updateplanet.dayFaceMod = int.Parse(TbPlanetdayFaceMod.Text); updateplanet.density = double.Parse(TbPlanetDensity.Text); updateplanet.diameter = double.Parse(TbPlanetDiameter.Text); updateplanet.gravity = double.Parse(TbPlanetGravity.Text); updateplanet.hydCoverage = TbPlanethydCov.Text; updateplanet.isResonant = bool.Parse(TbPlanetisRes.Text); updateplanet.isTideLocked = bool.Parse(TbPlanetisTideLock.Text); updateplanet.retrogradeMotion = bool.Parse(TbPlanetretrogradeMotion.Text); updateplanet.rotationalPeriod = double.Parse(TbPlanetrotPeriod.Text); updateplanet.SatelliteSize = int.Parse(TbPlanetSite.Text); updateplanet.siderealPeriod = double.Parse(TbPlanetsiderealPeriod.Text); updateplanet.surfaceTemp = double.Parse(TbPlanetsurfaceTemp.Text); updateplanet.tecActivity = double.Parse(TbPlanettecActivity.Text); updateplanet.tideForce = double.Parse(TbPlanettideForce.Text); updateplanet.volActivity = double.Parse(TbPlanetvolActivity.Text); updateplanet.orbitalCycle = double.Parse(TbPlanetOrbitalCycle.Text); } using (var dbCtx = new Db1Entities()) { //3. Mark entity as modified dbCtx.Entry(updateplanet).State = EntityState.Modified; //4. call SaveChanges dbCtx.SaveChanges(); } SystemSelector.CurrentInstance.LoadSystemsFromSql(); }
private void btAdd_Click( object sender, RoutedEventArgs e ) { using (var context = new Db1Entities()) { var sg = new StatGroup { Name = TbGroupName.Text }; context.StatGroup.Add(sg); context.SaveChanges(); } LoadListBoxContent(); TbGroupName.Text = ""; TbGroupName1.Text = ""; }
private void btDel1_Click( object sender, RoutedEventArgs e ) { var context = new Db1Entities(); var groups = LbGroups.SelectedItem as StatGroup; var query = from c in context.StatSubGroup where groups.Id == c.GroupId select c; var delSubGroup = query.FirstOrDefault(); using (context) { var ssg = delSubGroup; context.Entry(ssg).State = EntityState.Deleted; context.SaveChanges(); } LoadSubListBoxContent(); }
private void LoadCompleteSystem() { if (CbSelectSystem.SelectedItem == null) { } else { var context = new Db1Entities(); context.Configuration.ProxyCreationEnabled = false; var query = ( from p in context.StarSystems.Include("Stars").Include("Stars").Include("Stars.Planets").Include("Stars.Planets.InnerMoonlets1").Include("Stars.Planets.OuterMoonlets1").Include("Stars.Planets.MajorMoons1") where p.Id == (int) CbSelectSystem.SelectedValue select p ).FirstOrDefault(); _loadedSystem = query; } }
private void btDelete_Click( object sender, RoutedEventArgs e ) { var context = new Db1Entities(); var id = int.Parse(TbId.Text); var queryModifier = from c in context.Modifier where c.Id == id select c; using (context) { var deleteModifier = queryModifier.FirstOrDefault(); context.Entry(deleteModifier).State = EntityState.Deleted; context.SaveChanges(); } InitForm(); btClear_Click(this, null); }
private void btApply_Click( object sender, RoutedEventArgs e ) { MajorMoons updateplanet; using (var ctx = new Db1Entities()) { updateplanet = ctx.MajorMoons.FirstOrDefault(s => s.Id.ToString() == TbMoonId.Text); } if (updateplanet != null) { updateplanet.name = TbMoonName.Text; updateplanet.atmCate = int.Parse(TbMoonatmCate.Text); updateplanet.atmMass = double.Parse(TbMoonatmMass.Text); updateplanet.axialTilt = double.Parse(TbMoonaxialTilt.Text); updateplanet.mass = double.Parse(TbMoonMoonMass.Text); updateplanet.RVM = double.Parse(TbMoonRvm.Text); updateplanet.orbitalPeriod = double.Parse(TbMoonorbitalPeriod.Text); updateplanet.orbitalRadius = double.Parse(TbMoonorbitalRadius.Text); updateplanet.orbitalEccent = double.Parse(TbMoonorbitalEccent.Text); updateplanet.moonRadius = double.Parse(TbMoonRadius.Text); updateplanet.baseType = int.Parse(TbMoonType.Text); updateplanet.SatelliteSize = int.Parse(TbMoonSite.Text); updateplanet.blackbodyTemp = double.Parse(TbMoonbbt.Text); updateplanet.dayFaceMod = int.Parse(TbMoondayFaceMod.Text); updateplanet.density = double.Parse(TbMoonDensity.Text); updateplanet.diameter = double.Parse(TbMoonDiameter.Text); updateplanet.gravity = double.Parse(TbMoonGravity.Text); updateplanet.hydCoverage = TbMoonhydCov.Text; updateplanet.isResonant = bool.Parse(TbMoonisRes.Text); updateplanet.isTideLocked = bool.Parse(TbMoonisTideLock.Text); updateplanet.retrogradeMotion = bool.Parse(TbMoonretrogradeMotion.Text); updateplanet.rotationalPeriod = double.Parse(TbMoonrotPeriod.Text); updateplanet.SatelliteSize = int.Parse(TbMoonSite.Text); updateplanet.siderealPeriod = double.Parse(TbMoonsiderealPeriod.Text); updateplanet.surfaceTemp = double.Parse(TbMoonsurfaceTemp.Text); updateplanet.tecActivity = double.Parse(TbMoontecActivity.Text); updateplanet.tideForce = int.Parse(TbMoontideForce.Text); updateplanet.tideTotal = int.Parse(TbMoontideTotal.Text); updateplanet.volActivity = double.Parse(TbMoonvolActivity.Text); updateplanet.orbitalCycle = double.Parse(TbMoonOrbitalCycle.Text); } using (var dbCtx = new Db1Entities()) { dbCtx.Entry(updateplanet).State = EntityState.Modified; dbCtx.SaveChanges(); } SystemSelector.CurrentInstance.LoadSystemsFromSql(); }
private static bool UserExists( string userName ) { //grundsätzlich existiert er nicht var userExists = false; //Neue SQL verbindung var context = new Db1Entities(); var query = from c in context.Registration where c.Username == userName select c; var adv = query.FirstOrDefault(); if (adv != null) { //User existiert userExists = true; } return userExists; }
private void btAdd1_Click( object sender, RoutedEventArgs e ) { using (var context = new Db1Entities()) { var statGroup = LbGroups.SelectedItem as StatGroup; if (statGroup != null) { var ssg = new StatSubGroup { Name = TbSubGroupName.Text, GroupId = statGroup.Id }; context.StatSubGroup.Add(ssg); } context.SaveChanges(); } LoadSubListBoxContent(); TbSubGroupName.Text = ""; }
public static bool LoginCheck( Client cl ) { using (var regcontext = new Db1Entities()) { var query = from c in regcontext.Registration where c.Username == cl.UserName && c.Password == cl.EncPassword select c; try { var firstOrDefault = query.FirstOrDefault(); var userId = firstOrDefault?.Id; return userId > 0; } catch (Exception) { // ignored } } return false; }
private void btApply_Click( object sender, RoutedEventArgs e ) { StarSystems updatesystem; using (var ctx = new Db1Entities()) { updatesystem = ctx.StarSystems.FirstOrDefault(s => s.Id.ToString() == TbSysId.Text); } if (updatesystem != null) { updatesystem.sysName = TbSysName.Text; updatesystem.sysAge = double.Parse(TbSysAge.Text); } using (var dbCtx = new Db1Entities()) { dbCtx.Entry(updatesystem).State = EntityState.Modified; dbCtx.SaveChanges(); } SystemSelector.CurrentInstance.LoadSystemsFromSql(); }
private void btAdd_Click( object sender, RoutedEventArgs e ) { using (var context = new Db1Entities()) { var addModifier = new Modifier { Name = TbModifierName.Text, Notes = TbNotes.Text, Description = TbDiscription.Text, Modifying_Property = TbModProp.Text, Group = CbGroup.Text, SubGroup = CbSubGroup.Text }; context.Modifier.Add(addModifier); context.SaveChanges(); } InitForm(); btClear_Click(this, null); }
public void UpdateAdvantage( AdvantageControl advControl ) { //Reads out of the Database to Edit LbModifier.Items.Clear(); BtAddAdvantage.IsEnabled = false; BtEditAdvantage.IsEnabled = true; using (var context = new Db1Entities()) { var loadItem = context.Advantages.SingleOrDefault(x => x.Id == advControl.AdvantageId); //returns a single item. if (loadItem != null) { _updateId = loadItem.Id; TbName.Text = loadItem.Name; TbDiscription.Text = loadItem.Discription; CbisEnabled.IsChecked = loadItem.isEnabled; TbPointCost.Text = loadItem.PointCost.ToString(); CbisPhysical.IsChecked = loadItem.isPhysical; CbisMental.IsChecked = loadItem.isMental; CbisSocial.IsChecked = loadItem.isSocial; CbisExotic.IsChecked = loadItem.isExotic; CbisSuperNatural.IsChecked = loadItem.isSuperNatural; CbisMundane.IsChecked = loadItem.isMundane; CbhasLevels.IsChecked = loadItem.hasLevels != null && (bool) loadItem.hasLevels; CbisCreationLocked.IsChecked = loadItem.isCreationLocked != null && (bool) loadItem.isCreationLocked; TbReference.Text = loadItem.Reference; TbLimitation.Text = loadItem.Limitation; } var usedModifers = ( from c in context.UsedModifier where c.ForeignId == loadItem.Id select c ).ToList(); foreach (var umod in usedModifers) { var mod = ( from c in context.Modifier where c.Id == umod.ModifierId select c ).FirstOrDefault(); LbModifier.Items.Add(mod); LbModifier.DisplayMemberPath = "Name"; if (mod != null) { _dictMod.Add(mod, umod); } } CheckRequirement(); } }
public bool RegistrationCheck( Client c ) { var vUserExists = UserExists(c.UserName); if (vUserExists) { return false; } using (var context = new Db1Entities()) { var newReg = new Registration { Username = c.UserName, EMail = c.EMail, Password = c.EncPassword }; context.Registration.Add(newReg); context.SaveChanges(); } return true; }
private void btCreate_Click( object sender, RoutedEventArgs e ) { using (var context = new Db1Entities()) { var faction = new Factions { Name = TbName.Text, HomePlanet = TbHomeplanet.Text, Race = CbRace.SelectedValue.ToString(), Cunning = IudCunning.Value, Force = IudForce.Value, Wealth = IudWealth.Value, Income = IudIncome.Value, MaxHp = IudMaxHp.Value }; context.Factions.Add(faction); context.SaveChanges(); } MessageBox.Show("The Faction '" + TbName.Text + "' has been saved to the Database"); btClear_Click(this, null); }
public void DeleteAdvantage( AdvantageControl advControl ) { using (var context = new Db1Entities()) { var itemToRemove = context.Advantages.SingleOrDefault(x => x.Id == advControl.AdvantageId); //returns a single item. var moddelist = ( from c in context.UsedModifier where c.ForeignId == itemToRemove.Id select c ).ToList(); if (itemToRemove != null) { context.Entry(itemToRemove).State = EntityState.Deleted; foreach (var item in moddelist) { context.Entry(item).State = EntityState.Deleted; } context.SaveChanges(); } } MessageBox.Show("Deleted!"); LoadStackPanelContent(); ClearControls(); }
public static Character GetBlankCharacter( Client client ) { var c = new Character { Age = 18, Name = "", Strenght = 10, Intelligence = 10, Dexterity = 10, Health = 10 }; if (c.Strenght != null) { c.BasicLift = CalcBasicLift((int) c.Strenght); c.HitPoints = CalcHp((int) c.Strenght); } if (c.Intelligence != null) { c.WillPower = CalcWillPower((int) c.Intelligence); c.Perception = CalcPerception((int) c.Intelligence); } if (c.Health != null) { c.FatiguePoints = CalcBaseFatiguePoints((int) c.Health); if (c.Dexterity != null) { c.BasicSpeed = CalcBasicSpeed((int) c.Health, (int) c.Dexterity); } } if (c.BasicSpeed != null) { c.BasicMove = CalcBasicMove((double) c.BasicSpeed); } c.PlayerName = client.UserName; c.PointTotal = 100; var context = new Db1Entities(); c.PlayerId = ( from cn in context.Registration where cn.Username == client.UserName select cn.Id ).FirstOrDefault(); return c; }
private void btAddSpec_Click( object sender, RoutedEventArgs e ) { if (TbSpecName.Text != "") { using (var context = new Db1Entities()) { var ss = new SkillSpecialization { Name = TbSpecName.Text, Prerequisites = TbSpecPrereq.Text, SkillId = int.Parse(TbId.Text), Default = TbSpecDefault.Text, Discription = TbSpecDiscription.Text, Modifiers = TbSpecModifiers.Text, IsOptional = CbSpecIsOptional.IsChecked }; context.SkillSpecialization.Add(ss); context.SaveChanges(); } CleanControls(); } PreparePage1(); }
private void btApply_Click( object sender, RoutedEventArgs e ) { Stars updatestar; using (var ctx = new Db1Entities()) { updatestar = ctx.Stars.Where(s => s.Id.ToString() == TbStarId.Text).FirstOrDefault(); } if (updatestar != null) { if (TbStarName.Text != "") { updatestar.name = TbStarName.Text; } updatestar.currLumin = double.Parse(TbStarLum.Text); updatestar.distFromPrimary = double.Parse(TbStarDistFromPrim.Text); updatestar.effTemp = double.Parse(TbStareffTemp.Text); updatestar.initLumin = double.Parse(TbStarinitLum.Text); updatestar.initMass = double.Parse(TbStarinitMass.Text); updatestar.isFlareStar = bool.Parse(TbStarisFlare.Text); updatestar.orbitalEccent = double.Parse(TbStarorbitalEccent.Text); updatestar.orbitalPeriod = double.Parse(TbStarorbitalPeriod.Text); updatestar.orbitalRadius = double.Parse(TbStarorbitalRadius.Text); updatestar.radius = double.Parse(TbStarRadius.Text); updatestar.specType = TbStarSpecType.Text; updatestar.starColor = TbStarDistFromPrim.Text; } using (var dbCtx = new Db1Entities()) { //3. Mark entity as modified dbCtx.Entry(updatestar).State = EntityState.Modified; //4. call SaveChanges dbCtx.SaveChanges(); } SystemSelector.CurrentInstance.LoadSystemsFromSql(); }
//Specialization TAB private void PreparePage1() { TbSkillNameP1.Text = TbSkillName.Text = _selectedSkill.SkillName; var id = int.Parse(TbId.Text); var context = new Db1Entities(); var query = from c in context.SkillSpecialization where c.SkillId == id select c; var foundSpecializations = query.ToList(); TabItemSpecializations.Foreground = foundSpecializations.Count > 0 ? Brushes.Green : Brushes.White; LbSpecializations.ItemsSource = foundSpecializations; LbSpecializations.DisplayMemberPath = "Name"; }
private void InitForm() { var context = new Db1Entities(); var query = from c in context.Skills select c; _loadedSkills = query.ToList(); CbExistingSkill.ItemsSource = _loadedSkills.OrderBy(skills => skills.SkillName); CbExistingSkill.DisplayMemberPath = "SkillName"; }
public static void InsertSystem(StarSystem system) { using (var context = new Db1Entities()) { var newSystem = new StarSystems { sysName = system.SysName, habitableZones = system.HabitableZones.Count, maxMass = system.MaxMass, numDwarfPlanets = system.NumDwarfPlanets, star2index = system.Star2Index, star3index = system.Star3Index, subCompanionStar2index = system.SubCompanionStar2Index, subCompanionStar3index = system.SubCompanionStar3Index, sysAge = system.SysAge, sysStars = system.SysStars.Count }; foreach (var star in system.SysStars) { var newStar = new Stars { currLumin = Math.Round(star.CurrLumin, 4), distFromPrimary = star.DistFromPrimary, effTemp = Math.Round(star.EffTemp, 4), gasGiantFlag = star.GasGiantFlag, initLumin = star.InitLumin, initMass = star.InitMass, isFlareStar = star.IsFlareStar, name = star.Name, orbitalEccent = star.OrbitalEccent, orbitalPeriod = Math.Round(star.OrbitalPeriod, 4), orbitalRadius = star.OrbitalRadius, orbitalSep = star.OrbitalSep, orderID = star.OrderId, parentID = star.ParentId, parentName = star.ParentName, radius = Math.Round(star.GetRadiusAu(), 4), selfID = star.SelfId, specType = star.SpecType, starAge = star.StarAge, starColor = star.StarColor, sysPlanets = star.SysPlanets.Count, StarOrder = Star.GetDescFromFlag(star.SelfId) }; newStar.StarOrder = star.ReturnCurrentBranchDesc(); newStar.OrbitalDetails = star.PrintOrbitalDetails(); newStar.StarString = star.ToString(); foreach (var sat in star.SysPlanets) { var newSatellite = new Planets(); var type = ""; var pressure = ""; if (OptionCont.ExpandAsteroidBelt != null && (sat.BaseType != Satellite.BasetypeAsteroidbelt || (bool)OptionCont.ExpandAsteroidBelt)) { type = sat.DescSizeType(); } if (sat.BaseType == Satellite.BasetypeAsteroidbelt) { type = "Asteroid Belt"; } if (sat.BaseType == Satellite.BasetypeAsteroidbelt) { pressure = "None."; } if (sat.BaseType == Satellite.BasetypeGasgiant) { pressure = "Superdense Atmosphere."; } if (sat.BaseType == Satellite.BasetypeMoon || sat.BaseType == Satellite.BasetypeTerrestial) { pressure = sat.GetDescAtmCategory() + "(" + Math.Round(sat.AtmPres, 2) + ")"; } newSatellite.SatelliteSize = sat.SatelliteSize; newSatellite.SatelliteType = sat.SatelliteType; newSatellite.atmCate = sat.AtmCate.Count; newSatellite.atmMass = sat.AtmMass; newSatellite.atmPres = pressure; newSatellite.axialTilt = sat.AxialTilt; newSatellite.baseType = sat.BaseType; newSatellite.blackbodyTemp = sat.BlackbodyTemp; newSatellite.dayFaceMod = Convert.ToInt32(sat.DayFaceMod); newSatellite.density = sat.Density; newSatellite.diameter = Math.Round(sat.DiameterInKm(), 2); newSatellite.gravity = Math.Round(sat.Gravity * Satellite.Gforce, 2); newSatellite.hydCoverage = sat.HydCoverage * 100 + "%"; newSatellite.innerMoonlets = sat.InnerMoonlets.Count; newSatellite.isResonant = sat.IsResonant; newSatellite.isTideLocked = sat.IsTideLocked; newSatellite.majorMoons = sat.MajorMoons.Count; newSatellite.mass = sat.Mass; newSatellite.masterOrderID = sat.MasterOrderId; newSatellite.moonRadius = sat.MoonRadius; newSatellite.name = sat.Name; newSatellite.nightFaceMod = Convert.ToInt32(sat.NightFaceMod); newSatellite.orbitalCycle = sat.OrbitalCycle; newSatellite.orbitalEccent = sat.OrbitalEccent; newSatellite.orbitalPeriod = sat.OrbitalPeriod; newSatellite.orbitalRadius = Math.Round(sat.OrbitalRadius, 2); newSatellite.outerMoonlets = sat.OuterMoonlets.Count; newSatellite.parentDiam = sat.ParentDiam; newSatellite.parentID = sat.ParentId; newSatellite.parentName = sat.ParentName; newSatellite.retrogradeMotion = sat.RetrogradeMotion; newSatellite.rotationalPeriod = sat.RotationalPeriod; newSatellite.selfID = sat.SelfId; newSatellite.siderealPeriod = sat.SiderealPeriod; newSatellite.surfaceTemp = sat.SurfaceTemp; newSatellite.tecActivity = sat.TecActivity; newSatellite.tideTotal = sat.TideTotal; newSatellite.volActivity = sat.VolActivity; newSatellite.sattype = type; newSatellite.atmnote = sat.DescAtm(); newSatellite.RVM = sat.GetRvmDesc(); newSatellite.planetString = sat.ToString(); foreach (var innerMoonlet in sat.InnerMoonlets) { var newInnerMoonlet = new InnerMoonlets { blackbodyTemp = innerMoonlet.BlackbodyTemp, name = innerMoonlet.Name, orbitalEccent = innerMoonlet.OrbitalEccent, orbitalPeriod = innerMoonlet.OrbitalPeriod, orbitalRadius = Math.Round(innerMoonlet.OrbitalRadius, 2), parentID = innerMoonlet.ParentId, parentName = innerMoonlet.ParentName, planetRadius = innerMoonlet.PlanetRadius, selfID = innerMoonlet.SelfId, innerMoonString = innerMoonlet.ToString() }; newSatellite.InnerMoonlets1.Add(newInnerMoonlet); } foreach (var outerMoonlet in sat.OuterMoonlets) { var newOuterMoonlet = new OuterMoonlets { blackbodyTemp = outerMoonlet.BlackbodyTemp, name = outerMoonlet.Name, orbitalEccent = outerMoonlet.OrbitalEccent, orbitalPeriod = outerMoonlet.OrbitalPeriod, orbitalRadius = Math.Round(outerMoonlet.OrbitalRadius, 2), parentID = outerMoonlet.ParentId, parentName = outerMoonlet.ParentName, planetRadius = outerMoonlet.PlanetRadius, selfID = outerMoonlet.SelfId, outerMoonString = outerMoonlet.ToString() }; newSatellite.OuterMoonlets1.Add(newOuterMoonlet); } foreach (var majorMoon in sat.MajorMoons) { var newMajorMoon = new MajorMoons { RVM = majorMoon.Rvm, SatelliteSize = majorMoon.SatelliteSize, SatelliteType = majorMoon.SatelliteType, atmCate = majorMoon.AtmCate.Count, atmMass = majorMoon.AtmMass, axialTilt = majorMoon.AxialTilt, baseType = majorMoon.BaseType, blackbodyTemp = majorMoon.BlackbodyTemp, dayFaceMod = Convert.ToInt32(majorMoon.DayFaceMod), density = majorMoon.Density, diameter = Math.Round(majorMoon.DiameterInKm(), 2), gravity = Math.Round(majorMoon.Gravity * Satellite.Gforce, 2), hydCoverage = sat.HydCoverage * 100 + "%", innerMoonlets = majorMoon.InnerMoonlets.Count, isResonant = majorMoon.IsResonant, isTideLocked = majorMoon.IsTideLocked, majorMoons1 = majorMoon.MajorMoons.Count, mass = majorMoon.Mass, moonRadius = majorMoon.MoonRadius, name = majorMoon.Name, nightFaceMod = Convert.ToInt32(majorMoon.NightFaceMod), orbitalCycle = majorMoon.OrbitalCycle, orbitalEccent = majorMoon.OrbitalEccent, orbitalPeriod = majorMoon.OrbitalPeriod, orbitalRadius = Math.Round(majorMoon.OrbitalRadius, 2), outerMoonlets = majorMoon.OuterMoonlets.Count, parentDiam = majorMoon.ParentDiam, parentID = majorMoon.ParentId, parentName = majorMoon.ParentName, retrogradeMotion = majorMoon.RetrogradeMotion, rotationalPeriod = majorMoon.RotationalPeriod, selfID = majorMoon.SelfId, siderealPeriod = majorMoon.SiderealPeriod, surfaceTemp = majorMoon.SurfaceTemp, tecActivity = majorMoon.TecActivity, tideForce = majorMoon.TideForce.Count, tideTotal = majorMoon.TideTotal, volActivity = majorMoon.VolActivity, MajorMoonString = majorMoon.ToString() }; newSatellite.MajorMoons1.Add(newMajorMoon); } newStar.Planets.Add(newSatellite); } context.Stars.Add(newStar); } context.StarSystems.Add(newSystem); context.SaveChanges(); } }