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 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();
}
}
private void LoadStackPanelContent()
{
Sp1.Children.Clear();
var context = new Db1Entities();
var query = from c in context.Advantages select c;
var advlist = query.ToList().OrderBy(advantages => advantages.Name);
foreach (var adv in advlist)
{
var ex = new Expander();
var ac = new AdvantageControl();
ac.InitControl(adv);
var vb1 = new Viewbox();
Sp1.Children.Add(ex);
ex.Content = vb1;
ex.Header = adv.Name;
vb1.Child = ac;
vb1.Height = ac.Height;
}
}
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 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 LoadStackPanelContent()
{
Sp1.Children.Clear();
var context = new Db1Entities();
var query = from c in context.Advantages select c;
var advlist = query.ToList().OrderBy(advantages => advantages.Name);
foreach (var adv in advlist)
{
var ex = new Expander();
var ac = new AdvantageControl();
ac.InitControl(adv);
var vb1 = new Viewbox();
Sp1.Children.Add(ex);
ex.Content = vb1;
ex.Header = adv.Name;
vb1.Child = ac;
vb1.Height = ac.Height;
}
}
