protected void btnSaveCharacter_Click(object sender, EventArgs e) { DungeonTrackerDataContext dtdc = new DungeonTrackerDataContext(); DD_Character character = new DD_Character(); //This checks if there is a character loaded. If there is, then it load the edit. If not, it saves a new one. if (hfCharacterID.Value == "") { dtdc.DD_Characters.InsertOnSubmit(character); } else { character = dtdc.DD_Characters.SingleOrDefault(c => c.ID == Convert.ToInt32(hfCharacterID.Value)); } saveCharacterDetails(character); dtdc.SubmitChanges(); saveCharacterSkills(character); if (hfCharacterID.Value == "") { EventHelper.TriggerEvent(save, this, character); } else { EventHelper.TriggerEvent(edit, this, character); } }
protected void btnSaveCharacterStats_Click(object sender, EventArgs e) { DungeonTrackerDataContext dtdc = new DungeonTrackerDataContext(); DD_Character character = dtdc.DD_Characters.SingleOrDefault(c => c.ID == Convert.ToInt32(hfCharacterID.Value)); saveCharacterStats(character); dtdc.SubmitChanges(); EventHelper.TriggerEvent(save, this, character); }
protected void btnSaveAddUser_Click(object sender, EventArgs e) { try { DungeonTrackerDataContext dtdc = new DungeonTrackerDataContext(); DD_User addUser = new DD_User(); SHA256 shaPassword = SHA256.Create(); Byte[] password = ASCIIEncoding.Default.GetBytes(txtPassword.Text); Byte[] hash = shaPassword.ComputeHash(password); addUser.LastName = txtLastName.Text.ToLower(); addUser.FirstName = txtFirstName.Text.ToLower(); addUser.Password = BitConverter.ToString(hash); addUser.DateCreated = DateTime.Today; if (!dtdc.DD_Users.Any(s => s.Username == txtUsername.Text.ToLower())) { addUser.Username = txtUsername.Text.ToLower(); if (!dtdc.DD_Users.Any(s => s.Email == txtEmail.Text.ToLower())) { addUser.Email = txtEmail.Text; //Inserts the new user to the database on a database submit. dtdc.DD_Users.InsertOnSubmit(addUser); dtdc.SubmitChanges(); } else { //That Email has already been used. } } else { //That username has already been used. } } catch (Exception ex) { } }
protected void submitBeasts_click(object sender, EventArgs e) { DungeonTrackerDataContext dtdc = new DungeonTrackerDataContext(); // DD_Character character = dtdc.DD_Characters.SingleOrDefault(c => c.ID == Convert.ToInt32(ddlCharacters.SelectedValue)); DD_Creep creep = dtdc.DD_Creeps.Single(c => c.ID == Convert.ToInt32(ddlBeasts.SelectedValue)); DD_Beastiary beast = new DD_Beastiary(); DD_Character character = dtdc.DD_Characters.Single(c => c.ID == Convert.ToInt32(ddlCharacters.SelectedValue)); //Must check if character has already seen the beasty... bool doesExist = dtdc.DD_Beastiaries.Any(s => s.CharacterID == character.ID && s.CreepID == creep.ID); if (!doesExist) { beast.HasSeen = true; beast.CharacterID = character.ID; beast.CreepID = creep.ID; dtdc.DD_Beastiaries.InsertOnSubmit(beast); dtdc.SubmitChanges(); FillBeastiary(character); if (alreadySeen.Visible == true) { alreadySeen.Visible = false; } } else { alreadySeen.Visible = true; } /*if (!dtdc.DD_Beastiaries.Any(s => s.CharacterID == character.ID )) * { * }*/ }
protected void btnSaveSpell_Click(object sender, EventArgs e) { try { DungeonTrackerDataContext dtdc = new DungeonTrackerDataContext(); DD_Character character = dtdc.DD_Characters.SingleOrDefault(c => c.ID == Convert.ToInt32(hfCharacterID.Value)); DD_CharacterHasSpell spell = new DD_CharacterHasSpell(); spell.CharacterID = character.ID; spell.SpellID = Convert.ToInt32(ddlSpellList.SelectedValue); dtdc.DD_CharacterHasSpells.InsertOnSubmit(spell); dtdc.SubmitChanges(); EventHelper.TriggerEvent(save, this, spell); } catch (Exception ex) { throw; } }
protected void btnSaveItem_Click(object sender, EventArgs e) { try { DungeonTrackerDataContext dtdc = new DungeonTrackerDataContext(); DD_Character character = dtdc.DD_Characters.SingleOrDefault(c => c.ID == Convert.ToInt32(hfCharacterID.Value)); DD_CharacterHasItem characterItem = new DD_CharacterHasItem(); characterItem.CharacterID = character.ID; characterItem.ItemID = Convert.ToInt32(ddlItemList.SelectedValue); characterItem.Quantity = Convert.ToInt32(txtQuantity.Text); dtdc.DD_CharacterHasItems.InsertOnSubmit(characterItem); dtdc.SubmitChanges(); EventHelper.TriggerEvent(save, this, characterItem); } catch (Exception ex) { throw; } }
private void saveCharacterSkills(DD_Character character) { DungeonTrackerDataContext dtdc = new DungeonTrackerDataContext(); List <DD_Skill> skills = (from skill in dtdc.DD_Skills select skill).ToList(); foreach (DD_Skill skill in skills) { DD_CharacterHasSkill chs = new DD_CharacterHasSkill(); if (hfCharacterID.Value == "") { dtdc.DD_CharacterHasSkills.InsertOnSubmit(chs); chs.CharacterID = character.ID; chs.SkillID = skill.ID; } else { chs = dtdc.DD_CharacterHasSkills.Single(c => c.DD_Character.ID == character.ID && c.SkillID == skill.ID); } switch (skill.Name) { case "Acrobatics": chs.Value = Convert.ToInt32(txtAcrobatics.Text); break; case "Animal Handling": chs.Value = Convert.ToInt32(txtAnimalHandling.Text); break; case "Arcana": chs.Value = Convert.ToInt32(txtArcana.Text); break; case "Athletics": chs.Value = Convert.ToInt32(txtAthletics.Text); break; case "Deception": chs.Value = Convert.ToInt32(txtDeception.Text); break; case "History": chs.Value = Convert.ToInt32(txtHistory.Text); break; case "Insight": chs.Value = Convert.ToInt32(txtInsight.Text); break; case "Intimidation": chs.Value = Convert.ToInt32(txtIntimidation.Text); break; case "Investigation": chs.Value = Convert.ToInt32(txtInvestigation.Text); break; case "Medicine": chs.Value = Convert.ToInt32(txtMedicine.Text); break; case "Nature": chs.Value = Convert.ToInt32(txtNature.Text); break; case "Perception": chs.Value = Convert.ToInt32(txtPerception.Text); break; case "Performance": chs.Value = Convert.ToInt32(txtPerformance.Text); break; case "Persuasion": chs.Value = Convert.ToInt32(txtPersuasion.Text); break; case "Religion": chs.Value = Convert.ToInt32(txtReligion.Text); break; case "Sleight of Hand": chs.Value = Convert.ToInt32(txtSleightofHand.Text); break; case "Stealth": chs.Value = Convert.ToInt32(txtStealth.Text); break; case "Survival": chs.Value = Convert.ToInt32(txtSurvival.Text); break; } } dtdc.SubmitChanges(); }