private void LoadComboBoxGroups()
{
var context = new Db1Entities();
CbGroup.ItemsSource = (from c in context.StatGroup select c).ToList().OrderBy(statGroup => statGroup.Name);
CbGroup.DisplayMemberPath = "Name";
}
private void InitForm()
{
var context = new Db1Entities();
CbExistingModifier.ItemsSource = (from c in context.Modifier select c).ToList().OrderBy(modifier => modifier.Name);
CbExistingModifier.DisplayMemberPath = "Name";
}
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 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();
}
public List <Character> RequestSavedCharacters(Client c)
{
using (var context = new Db1Entities())
{
return((from q in context.Character where q.PlayerName == c.UserName select q).ToList());
}
}
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();
}
public List <Skills> RequestSkills(Client client)
{
var context = new Db1Entities();
var skillList = (from c in context.Skills where c.isEnabled select c).ToList();
return(skillList);
}
private void btModifierUpd_Click(object sender, RoutedEventArgs e)
{
if (LbModifier.SelectedItem != null)
{
using (var context = new Db1Entities())
{
_dictMod[(Modifier)LbModifier.SelectedItem].Value = int.Parse(TbModVal.Text);
_dictMod[(Modifier)LbModifier.SelectedItem].Operator = CbModOp.Text;
UsedModifier foundmod;
_dictMod.TryGetValue((Modifier)LbModifier.SelectedItem, out foundmod);
var usedmod = (from c in context.UsedModifier where c.Id == foundmod.Id select c).FirstOrDefault();
if (usedmod != null)
{
if (foundmod != null)
{
usedmod.Operator = foundmod.Operator;
usedmod.Value = foundmod.Value;
}
context.Entry(usedmod).State = EntityState.Modified;
}
context.SaveChanges();
}
LbModifier.SelectedItem = null;
CbModOp.Text = "";
TbModVal.Text = "";
}
}
public List <Disadvantages> RequestDisadvantages(Client client)
{
var context = new Db1Entities();
var disAdvlist = (from c in context.Disadvantages where c.isEnabled select c).ToList();
return(disAdvlist);
}
public List <Requirements> RequestRequirements(Client client)
{
var context = new Db1Entities();
var reqlist = (from c in context.Requirements select c).ToList();
return(reqlist);
}
private void LoadModifierComboBox()
{
var context = new Db1Entities();
CbModifier.ItemsSource = (from c in context.Modifier select c).ToList().OrderBy(modifier => modifier.Name);
CbModifier.DisplayMemberPath = "Name";
}
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)
{
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!");
}
}
private void btUpdate_Click(object sender, RoutedEventArgs e)
{
var context = new Db1Entities();
var id = int.Parse(TbId.Text);
var queryskill = from c in context.Skills where c.Id == id select c;
using (context)
{
var updateSkill = queryskill.FirstOrDefault();
if (updateSkill != null)
{
updateSkill.SkillName = TbSkillName.Text;
updateSkill.DifficultyLevel = TbDifficultyLevel.Text;
updateSkill.notes = TbNotes.Text;
updateSkill.points = int.Parse(TbPoints.Text);
updateSkill.reference = TbReference.Text;
//UpdateSkill.specialization = tbSpecialization.Text;
updateSkill.tech_level = TbTechLevel.Text;
updateSkill.ControllingAttribute = TbControllingAttribute.Text;
updateSkill.Description = TbDiscription.Text;
//UpdateSkill.Modifiers = tbModifiers.Text;
updateSkill.Defaults = TbDefault.Text;
updateSkill.Prerequisites = TbPrerequisite.Text;
context.Entry(updateSkill).State = EntityState.Modified;
}
context.SaveChanges();
}
InitForm();
}
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);
}
private void LoadComboBoxSubGroups()
{
var context = new Db1Entities();
var sg = CbGroup.SelectedItem as StatGroup;
CbSubGroup.ItemsSource = (from c in context.StatSubGroup where c.GroupId == sg.Id select c).ToList().OrderBy(statSubGroup => statSubGroup.Name);
CbSubGroup.DisplayMemberPath = "Name";
}
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 FillRaceComboBox()
{
using (var context = new Db1Entities())
{
CbRace.ItemsSource = (from c in context.Aliens select c).ToList();
CbRace.DisplayMemberPath = "Name";
CbRace.SelectedValuePath = "Id";
}
}
private void LoadListBoxContent()
{
var context = new Db1Entities();
var query = from c in context.StatGroup select c;
var groupList = query.ToList();
LbGroups.ItemsSource = groupList;
LbGroups.DisplayMemberPath = "Name";
}
public bool SaveCharacter(Client client, Character c)
{
using (var context = new Db1Entities())
{
context.Character.Add(c);
context.SaveChanges();
}
return(true);
}
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";
}
private void FillListbox()
{
var context = new Db1Entities();
var query = from c in context.Attribute select c;
var stats = query.ToList();
LbStats.ItemsSource = stats;
LbStats.DisplayMemberPath = "StatName";
LbStats.SelectedValuePath = "Id";
}
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();
}
}
private void btDelete_Click(object sender, RoutedEventArgs e)
{
using (var context = new Db1Entities())
{
var delAlien = (from c in context.Aliens where c.Id == _loadedAlien.Id select c).FirstOrDefault();
context.Entry(delAlien).State = EntityState.Deleted;
context.SaveChanges();
MessageBox.Show("'" + _loadedAlien.Name + "' has been removed from the Database");
ClearControls();
}
}
private void CheckRequirement()
{
var context = new Db1Entities();
var advantagequery = (from c in context.Advantages where c.Name == TbName.Text select c).FirstOrDefault();
var reqquery = (from c in context.Requirements where c.SourceItemID == advantagequery.Id select c).FirstOrDefault();
if (reqquery == null)
{
return;
}
RbRegSet.IsChecked = reqquery.SourceItemID == _updateId;
}
//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 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();
}
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 btDelete_Click(object sender, RoutedEventArgs e)
{
var context = new Db1Entities();
var id = int.Parse(TbId.Text);
var queryskill = from c in context.Skills where c.Id == id select c;
using (context)
{
var deleteSkill = queryskill.FirstOrDefault();
context.Entry(deleteSkill).State = EntityState.Deleted;
context.SaveChanges();
}
InitForm();
}
