private void FillSkillsCB() { using (var ctx = new Shadowrun3Context()) { DataSet skillDS = new DataSet(); DataTable skillDT = new DataTable("sdt"); DataColumn skillDC = new DataColumn("Skill", typeof(Skill)); skillDT.Columns.Add(skillDC); DataColumn skillIdDC = new DataColumn("SkillId", typeof(string)); skillDT.Columns.Add(skillIdDC); foreach (Skill skill in ctx.Skills.Where(a => a.SkillGroup.SkillGroupId == "Close Combat" || a.SkillId == "Exotic Melee Weapon")) { DataRow skillDR = skillDT.NewRow(); skillDR["Skill"] = skill; skillDR["SkillId"] = skill.SkillId; skillDT.Rows.Add(skillDR); } skillDS.Tables.Add(skillDT); mwSkillCB.DataSource = skillDS.Tables["sdt"].DefaultView; mwSkillCB.DisplayMember = "SkillId"; mwSkillCB.BindingContext = this.BindingContext; } }
private void DisplayS(string et) { using (var ctx = new Shadowrun3Context()) { DataSet esDS = new DataSet(); DataTable esDT = new DataTable("esDT"); DataColumn esDC = new DataColumn("Skill", typeof(string)); esDT.Columns.Add(esDC); DataColumn rankDC = new DataColumn("Rank", typeof(int)); esDT.Columns.Add(rankDC); foreach (EnemySkill etS in ctx.EnemySkills.Where(a => a.EnemyType.EnemyTypeId == et)) { DataRow esDR = esDT.NewRow(); esDR["Skill"] = etS.Skill.SkillId; esDR["Rank"] = etS.EnemySkillRank; esDT.Rows.Add(esDR); } esDS.Tables.Add(esDT); sDGV.DataSource = esDS.Tables["esDT"].DefaultView; sDGV.BindingContext = this.BindingContext; } }
private void DisplayEnemies(string enc) { using (var ctx = new Shadowrun3Context()) { DataSet eDS = new DataSet(); DataTable eDT = new DataTable("eDT"); DataColumn eDC = new DataColumn("Enemy", typeof(string)); eDT.Columns.Add(eDC); DataColumn deadDC = new DataColumn("Dead?", typeof(bool)); eDT.Columns.Add(deadDC); foreach (NamedEnemy neE in ctx.NamedEnemys.Where(a => a.Encounter.EncounterId == enc)) { DataRow eDR = eDT.NewRow(); eDR["Enemy"] = neE.NamedEnemyId; eDR["Dead?"] = neE.DeadOrAlive; eDT.Rows.Add(eDR); } eDS.Tables.Add(eDT); enemyDGV.DataSource = eDS.Tables["eDT"].DefaultView; enemyDGV.BindingContext = this.BindingContext; } }
private void rwSubmitButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { RangedWeapon rw = new RangedWeapon(); rw.RangedWeaponId = nameTB.Text; rw = SetVar(rw); Skill newSkill = ctx.Skills.FirstOrDefault(i => i.SkillId == skillString); rw.skill = newSkill; try { ctx.RangedWeapons.Add(rw); ctx.SaveChanges(); ResetForm(); } catch { MessageBox.Show("That weapon already exists"); } } }
private void button2_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { ctx.MatrixPrograms.Remove(ctx.MatrixPrograms.Single(a => a.MatrixProgramId == programNameTB.Text)); ctx.SaveChanges(); ResetForm(); } }
private void updateButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { EnemyType et = ctx.EnemyTypes.First(a => a.EnemyTypeId == nameTB.Text); et = SetVar(et); ctx.SaveChanges(); ResetForm(); } }
private void deleteButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { ctx.EnemyTypes.Remove(ctx.EnemyTypes.Single(a => a.EnemyTypeId == nameTB.Text)); ctx.SaveChanges(); ResetForm(); } }
private void updateButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { Spell sp = ctx.Spells.First(a => a.SpellId == nameTB.Text); sp = SetVar(sp); ctx.SaveChanges(); ResetForm(); } }
private void button1_Click(object sender, EventArgs e) { DataGridViewRow enemy = enemyDGV.CurrentRow; string enemyString = enemy.Cells[0].Value.ToString(); using (var ctx = new Shadowrun3Context()) { NamedEnemy enemy1 = ctx.NamedEnemys.FirstOrDefault(i => i.NamedEnemyId == enemyString); FormEnemy fe = new FormEnemy(enemy1); fe.Show(); } }
private void updateButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { string skillString = skillCB.SelectedValue?.ToString(); Skill newSkill = ctx.Skills.FirstOrDefault(i => i.SkillId == skillString); MatrixProgram updatedProg = ctx.MatrixPrograms.First(a => a.MatrixProgramId == programNameTB.Text); updatedProg.skill = newSkill; ctx.SaveChanges(); ResetForm(); } }
private void DisplayNamedEnemies(string enc) { List <string> neList = new List <string>(); using (var ctx = new Shadowrun3Context()) { foreach (NamedEnemy eachNE in ctx.NamedEnemys.Where(a => a.Encounter.EncounterId == enc)) { neList.Add(eachNE.NamedEnemyId); } } neLB.DataSource = neList; }
private void updateButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { MeleeWeapon mw = ctx.MeleeWeapons.First(a => a.MeleeWeaponId == nameTB.Text); mw = SetVar(mw); Skill newSkill = ctx.Skills.FirstOrDefault(i => i.SkillId == skillString); mw.skill = newSkill; ctx.SaveChanges(); ResetForm(); } }
private void remMeleeButton_Click(object sender, EventArgs e) { string mwString = mwLB.SelectedItem.ToString(); using (var ctx = new Shadowrun3Context()) { MeleeWeapon remMW = ctx.MeleeWeapons.FirstOrDefault(i => i.MeleeWeaponId == mwString); EnemyType updatedET = ctx.EnemyTypes.First(a => a.EnemyTypeId == nameTB.Text); updatedET.MeleeWeapons.Remove(remMW); ctx.SaveChanges(); ResetForm(); } }
private void remSpellButton_Click(object sender, EventArgs e) { string spellString = spellLB.SelectedItem.ToString(); using (var ctx = new Shadowrun3Context()) { Spell remSpell = ctx.Spells.FirstOrDefault(i => i.SpellId == spellString); EnemyType updatedET = ctx.EnemyTypes.First(a => a.EnemyTypeId == nameTB.Text); updatedET.Spells.Remove(remSpell); ctx.SaveChanges(); ResetForm(); } }
private void removeSButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { DataGridViewRow s = sDGV.CurrentRow; string sString = s.Cells[0].Value.ToString(); EnemySkill es = ctx.EnemySkills.FirstOrDefault(i => i.Skill.SkillId == sString); ctx.EnemySkills.Remove(es); ctx.SaveChanges(); ResetForm(); } }
private void addRangedButton_Click(object sender, EventArgs e) { string rwString = rwAddCB.SelectedValue.ToString(); using (var ctx = new Shadowrun3Context()) { RangedWeapon newRW = ctx.RangedWeapons.FirstOrDefault(i => i.RangedWeaponId == rwString); EnemyType updatedET = ctx.EnemyTypes.First(a => a.EnemyTypeId == nameTB.Text); updatedET.RangedWeapons.Add(newRW); ctx.SaveChanges(); ResetForm(); } }
private void updateSGButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { DataGridViewRow sg = sgDGV.CurrentRow; string sgString = sg.Cells[0].Value.ToString(); EnemySkillGroup esg = ctx.EnemySkillGroups.FirstOrDefault(i => i.SkillGroup.SkillGroupId == sgString); esg.Rank = (int)skillGroupRankNB.Value; ctx.SaveChanges(); ResetForm(); } }
private void DisplayMW(string et) { using (var ctx = new Shadowrun3Context()) { List <string> mwList = new List <string>(); foreach (EnemyType etMW in ctx.EnemyTypes.Where(a => a.EnemyTypeId == et)) { foreach (MeleeWeapon mw in etMW.MeleeWeapons) { mwList.Add(mw.MeleeWeaponId); } } mwLB.DataSource = mwList; } }
private void DisplayRW(string et) { using (var ctx = new Shadowrun3Context()) { List <string> rwList = new List <string>(); foreach (EnemyType etRW in ctx.EnemyTypes.Where(a => a.EnemyTypeId == et)) { foreach (RangedWeapon rw in etRW.RangedWeapons) { rwList.Add(rw.RangedWeaponId); } } rwLB.DataSource = rwList; } }
private void updateButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { NamedEnemy ne = ctx.NamedEnemys.First(a => a.NamedEnemyId == nameTB.Text); ne.CurrentHP = (int)HPNB.Value; ne.CurrentStun = (int)StunNB.Value; ne.CurrentMatrix = (int)MatrixNB.Value; ne.CurrentEdge = (int)EdgeNB.Value; ne.CurrentAmmo = (int)AmmoNB.Value; ne.CommRating = (int)SysRatingNB.Value; ctx.SaveChanges(); ResetForm(); } }
private void DisplaySpells(string et) { using (var ctx = new Shadowrun3Context()) { List <string> spellList = new List <string>(); foreach (EnemyType etSpell in ctx.EnemyTypes.Where(a => a.EnemyTypeId == et)) { foreach (Spell spell in etSpell.Spells) { spellList.Add(spell.SpellId); } } spellLB.DataSource = spellList; } }
private void updateButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { DataGridViewRow enc = dataGridView1.CurrentRow; string encString = enc.Cells[0].Value.ToString(); Encounter encounter = ctx.Encounters.FirstOrDefault(i => i.EncounterId == encString); string neString = neCB.SelectedValue.ToString(); NamedEnemy ne = ctx.NamedEnemys.FirstOrDefault(i => i.NamedEnemyId == neString); ne.Encounter = encounter; ctx.SaveChanges(); ResetForm(); } }
private void submitButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { try { Encounter enc = new Encounter(); enc.EncounterId = nameTB.Text; ctx.Encounters.Add(enc); ctx.SaveChanges(); ResetForm(); } catch { MessageBox.Show("That encounter already exists"); } } }
private void programSubmitButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { Skill newSkill = ctx.Skills.FirstOrDefault(i => i.SkillId == skillString); newProgram.skill = newSkill; try { ctx.MatrixPrograms.Add(newProgram); ctx.SaveChanges(); ResetForm(); } catch { MessageBox.Show("That program already exists"); } } }
private void rwSubmitButton_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { try { EnemyType et = new EnemyType(); et.EnemyTypeId = nameTB.Text; et = SetVar(et); ctx.EnemyTypes.Add(et); ctx.SaveChanges(); ResetForm(); } catch { MessageBox.Show("That enemy type already exists"); } } }
private void submitSpell_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { try { Spell sp = new Spell(); sp.SpellId = nameTB.Text; sp = SetVar(sp); ctx.Spells.Add(sp); ctx.SaveChanges(); ResetForm(); } catch { MessageBox.Show("That spell already exists"); } } }
private void addSButton_Click(object sender, EventArgs e) { string sString = skillCB.SelectedValue.ToString(); using (var ctx = new Shadowrun3Context()) { Skill s = ctx.Skills.FirstOrDefault(i => i.SkillId == sString); EnemyType et = ctx.EnemyTypes.First(a => a.EnemyTypeId == nameTB.Text); int rank = (int)skillRankNB.Value; EnemySkill es = new EnemySkill(); es.Skill = s; es.EnemyType = et; es.EnemySkillRank = rank; ctx.EnemySkills.Add(es); ctx.SaveChanges(); ResetForm(); } }
private void addSGButton_Click(object sender, EventArgs e) { string sgString = skillGroupCB.SelectedValue.ToString(); using (var ctx = new Shadowrun3Context()) { SkillGroup sg = ctx.SkillGroups.FirstOrDefault(i => i.SkillGroupId == sgString); EnemyType et = ctx.EnemyTypes.First(a => a.EnemyTypeId == nameTB.Text); int rank = (int)skillGroupRankNB.Value; EnemySkillGroup esg = new EnemySkillGroup(); esg.SkillGroup = sg; esg.EnemyType = et; esg.Rank = rank; ctx.EnemySkillGroups.Add(esg); ctx.SaveChanges(); ResetForm(); } }
private void submitSpell_Click(object sender, EventArgs e) { using (var ctx = new Shadowrun3Context()) { try { //Create new named enemy NamedEnemy ne = new NamedEnemy(); ne.NamedEnemyId = nameTB.Text; //Find out the enemy type for the enemy to be based on string etString = enemyTypeCB.Text; EnemyType et = ctx.EnemyTypes.FirstOrDefault(i => i.EnemyTypeId == etString); ne.EnemyType = et; //Work out the starting HP (8 + body/2 rounded up) int body = 0; if (et.Body % 2 == 0) { body = et.Body / 2; } else { body = (et.Body / 2) + 1; } ne.CurrentHP = 8 + body; //Work out the starting stun (8 + will/2 rounded up) int will = 0; if (et.Willpower % 2 == 0) { will = et.Willpower / 2; } else { will = (et.Willpower / 2) + 1; } ne.CurrentStun = 8 + will; //Work out the starting matrix (8 + sys/2 rounded up) int sys = 0; if (et.SystemRating % 2 == 0) { sys = et.SystemRating / 2; } else { sys = (et.SystemRating / 2) + 1; } ne.CurrentMatrix = 8 + sys; //Get the starting edge and comm rating from enemy type ne.CurrentEdge = et.Edge; ne.CommRating = et.SystemRating; //Add the current ammo from user input ne.CurrentAmmo = (int)AmmoNB.Value; //Start the named enemy as alive ne.DeadOrAlive = false; ctx.NamedEnemys.Add(ne); ctx.SaveChanges(); ResetForm(); } catch { MessageBox.Show("That named enemy already exists"); } } }