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 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);
}
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();
}
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 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 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 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 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();
}
private void btUpdateSpec_Click( object sender, RoutedEventArgs e )
{
var context = new Db1Entities();
var queryspec = from c in context.SkillSpecialization where c.Id == ( (SkillSpecialization) LbSpecializations.SelectedItem ).Id select c;
using (context)
{
var updateSpec = queryspec.FirstOrDefault();
if (updateSpec != null)
{
updateSpec.Discription = TbSpecDiscription.Text;
updateSpec.Name = TbSpecName.Text;
updateSpec.Prerequisites = TbSpecPrereq.Text;
updateSpec.Default = TbSpecDefault.Text;
updateSpec.Modifiers = TbSpecModifiers.Text;
updateSpec.IsOptional = CbSpecIsOptional.IsChecked;
context.Entry(updateSpec).State = EntityState.Modified;
}
context.SaveChanges();
}
LbSpecializations.SelectedItem = null;
PreparePage1();
}
private void btDerlSpec_Click( object sender, RoutedEventArgs e )
{
if (LbSpecializations.SelectedItem != null)
{
var context = new Db1Entities();
var queryspec = from c in context.SkillSpecialization where c.Id == ( (SkillSpecialization) LbSpecializations.SelectedItem ).Id select c;
using (context)
{
var deleteSpec = queryspec.FirstOrDefault();
context.Entry(deleteSpec).State = EntityState.Deleted;
context.SaveChanges();
}
CleanControls();
}
PreparePage1();
}
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();
}
private void btDel_Click( object sender, RoutedEventArgs e )
{
var item = LbSetPrerequisites.SelectedItem.ToString();
Requirements reqitem;
_dictPrereq.TryGetValue(item, out reqitem);
if (reqitem != null)
{
var delContext = new Db1Entities();
var delQuery = from c in delContext.Requirements where c.Id == reqitem.Id select c;
using (var context = new Db1Entities())
{
var deletereq = delQuery.FirstOrDefault();
context.Entry(deletereq).State = EntityState.Deleted;
context.SaveChanges();
}
}
LoadSetPrereqList();
}
private void btSave_Click( object sender, RoutedEventArgs e )
{
if (_loadedParent == "Races")
{
using (var context = new Db1Entities())
{
var updateRace = ( from c in context.encycloRace where c.RaceName == _loadedItem select c ).FirstOrDefault();
if (updateRace != null)
{
updateRace.RaceDiscription = _loadedRange.Text;
context.Entry(updateRace).State = EntityState.Modified;
}
context.SaveChanges();
}
}
BtSave.IsEnabled = false;
}
private void btEditAdvantage_Click( object sender, RoutedEventArgs e )
{
//Writes the Update back to the Database
var context = new Db1Entities();
var editAdv = ( from c in context.Advantages where c.Name == TbName.Text select c ).FirstOrDefault();
using (context)
{
if (editAdv != null)
{
editAdv.Discription = TbDiscription.Text;
if (CbisEnabled.IsChecked != null)
{
editAdv.isEnabled = (bool) CbisEnabled.IsChecked;
editAdv.isExotic = CbisExotic.IsChecked != null && (bool) CbisExotic.IsChecked;
editAdv.isMental = CbisMental.IsChecked != null && (bool) CbisMental.IsChecked;
editAdv.isMundane = CbisMundane.IsChecked != null && (bool) CbisMundane.IsChecked;
editAdv.isPhysical = CbisPhysical.IsChecked != null && (bool) CbisPhysical.IsChecked;
editAdv.isSocial = CbisSocial.IsChecked != null && (bool) CbisSocial.IsChecked;
editAdv.isSuperNatural = CbisSuperNatural.IsChecked != null && (bool) CbisSuperNatural.IsChecked;
editAdv.Limitation = TbLimitation.Text;
editAdv.Name = TbName.Text;
editAdv.hasLevels = CbhasLevels.IsChecked != null && (bool) CbhasLevels.IsChecked;
editAdv.PointCost = int.Parse(TbPointCost.Text);
editAdv.isCreationLocked = CbisCreationLocked.IsChecked != null && (bool) CbisCreationLocked.IsChecked;
}
editAdv.Reference = TbReference.Text;
context.Entry(editAdv).State = EntityState.Modified;
}
context.SaveChanges();
}
BtAddAdvantage.IsEnabled = true;
BtEditAdvantage.IsEnabled = false;
LoadStackPanelContent();
ClearControls();
}
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 btUpdate_Click( object sender, RoutedEventArgs e )
{
using (var context = new Db1Entities())
{
var updateFaction = ( from c in context.Factions where c.Id == LoadedId select c ).FirstOrDefault();
if (updateFaction != null)
{
updateFaction.Name = TbName.Text;
updateFaction.HomePlanet = TbName.Text;
updateFaction.Race = CbRace.SelectedValue.ToString();
updateFaction.Cunning = IudCunning.Value;
updateFaction.Force = IudForce.Value;
updateFaction.Wealth = IudWealth.Value;
updateFaction.Income = IudIncome.Value;
updateFaction.MaxHp = IudMaxHp.Value;
context.Entry(updateFaction).State = EntityState.Modified;
}
context.SaveChanges();
}
MessageBox.Show("The Faction '" + TbName.Text + "' has been Updated");
btClear_Click(this, null);
}
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 btUpdate_Click( object sender, RoutedEventArgs e )
{
using (var context = new Db1Entities())
{
var updateAlien = ( from c in context.Aliens where c.Id == _loadedAlien.Id select c ).FirstOrDefault();
if (updateAlien != null)
{
updateAlien.Name = TbName.Text;
updateAlien.chemicalBasis = CbChemicalBasis.SelectedValue.ToString();
updateAlien.LandOrWater = CbLandOrWater.SelectedValue.ToString();
updateAlien.LandHabitat = CbLandHabitat.SelectedValue.ToString();
updateAlien.WaterHabitat = CbWaterHabitat.SelectedValue.ToString();
updateAlien.TrophicDiet = CbThrophicDiet.SelectedValue.ToString();
updateAlien.PrimaryLocomotion = CbPrimaryLocomotion.SelectedValue.ToString();
updateAlien.SecondaryLocomotion = CbSecondaryLocomotion.SelectedValue.ToString();
updateAlien.hasSecondaryLocomotuib = CheckHasSecondaryLocmotion.IsChecked;
updateAlien.Gravity = null; //FIXME
updateAlien.SizeClass = CbSizeClass.SelectedValue.ToString();
updateAlien.Size = double.Parse(CbSize.Text);
updateAlien.Symmetry = CbSymmetry.SelectedValue.ToString();
updateAlien.Sides = int.Parse(CbSides.Text);
updateAlien.LimbSegments = int.Parse(CbLimbSegments.Text);
updateAlien.Tail = CbTails.SelectedValue.ToString();
updateAlien.Manipulators = int.Parse(CbManipulators.Text);
updateAlien.Skeleton = CbSkeleton.SelectedValue.ToString();
updateAlien.SkinClass = CbSkinClass.SelectedValue.ToString();
updateAlien.Skin = CbSkin.SelectedValue.ToString();
updateAlien.Breathing = CbBreathing.SelectedValue.ToString();
updateAlien.Temperatur = CbTemperture.SelectedValue.ToString();
updateAlien.Growth = CbGrowthRate.SelectedValue.ToString();
updateAlien.Sex = CbSexes.SelectedValue.ToString();
updateAlien.Gestation = CbGestation.SelectedValue.ToString();
updateAlien.Strategy = CbStrategy.SelectedValue.ToString();
updateAlien.OffspringCount = int.Parse(CbOffspringCount.Text);
updateAlien.PrimarySense = CbPrimarySense.SelectedValue.ToString();
updateAlien.Vision = CbVision.SelectedValue.ToString();
updateAlien.Hearing = CbHearing.SelectedValue.ToString();
updateAlien.Touch = CbTouch.SelectedValue.ToString();
updateAlien.TasteSmell = CbTasteSmell.SelectedValue.ToString();
updateAlien.Intelligence = CbIntelligence.SelectedValue.ToString();
updateAlien.IntelligenceValue = int.Parse(CbIntelligenceValue.Text);
updateAlien.MatingBehaviour = CbMatingBehaviour.SelectedValue.ToString();
updateAlien.SocialOrganization = CbSocialOrganization.SelectedValue.ToString();
updateAlien.SocialGroupSize = int.Parse(CbSocialGroupSize.Text);
updateAlien.Concentration = CbConcentration.SelectedValue.ToString();
updateAlien.Curiosity = CbCuriosity.SelectedValue.ToString();
updateAlien.Egoism = CbEgoism.SelectedValue.ToString();
updateAlien.Empathy = CbEmpathy.SelectedValue.ToString();
updateAlien.Gegariousness = CbGegariousness.SelectedValue.ToString();
updateAlien.Imagination = CbImagination.SelectedValue.ToString();
updateAlien.Chauvinism = CbChauvinism.SelectedValue.ToString();
updateAlien.Suspicion = CbSuspicion.SelectedValue.ToString();
updateAlien.Playfulness = CbPlayfulness.SelectedValue.ToString();
if (RaceImageWindow.Source != null)
{
if (!_loadedAlien.Image.SequenceEqual(BuildByteArrayFromImage(_raceBitmapImage)))
{
byte[] buffer;
var fileStream = new FileStream(_imagePath, FileMode.Open, FileAccess.Read);
try
{
var length = (int) fileStream.Length; // get file length
buffer = new byte[length]; // create buffer
int count; // actual number of bytes read
var sum = 0; // total number of bytes read
// read until Read method returns 0 (end of the stream has been reached)
while (( count = fileStream.Read(buffer, sum, length - sum) ) > 0)
{
sum += count; // sum is a buffer offset for next reading
}
}
finally
{
fileStream.Close();
}
updateAlien.Image = buffer;
}
}
context.Entry(updateAlien).State = EntityState.Modified;
}
context.SaveChanges();
}
MessageBox.Show("The Alien '" + TbName.Text + "' has been Updated");
}
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 btUpd1_Click( object sender, RoutedEventArgs e )
{
var context = new Db1Entities();
var updateSubGroup = LbSubGroups.SelectedItem as StatSubGroup;
var @group = updateSubGroup;
var query = from c in context.StatSubGroup where @group.Id == c.Id select c;
updateSubGroup = query.FirstOrDefault();
using (context)
{
var ssg = updateSubGroup;
if (ssg != null)
{
ssg.Name = TbSubGroupName.Text;
context.Entry(ssg).State = EntityState.Modified;
}
context.SaveChanges();
}
LoadListBoxContent();
}
private void btUpdate_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 updateModifier = queryModifier.FirstOrDefault();
if (updateModifier != null)
{
updateModifier.Name = TbModifierName.Text;
updateModifier.Notes = TbNotes.Text;
updateModifier.Description = TbDiscription.Text;
updateModifier.Modifying_Property = TbModProp.Text;
updateModifier.Group = CbGroup.Text;
updateModifier.SubGroup = CbSubGroup.Text;
context.Entry(updateModifier).State = EntityState.Modified;
}
context.SaveChanges();
}
InitForm();
btClear_Click(this, null);
}
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 = "";
}
}
