protected void btnInsertGuild_Click(object sender, EventArgs e) { using (var db = new GuildManagementContext()) { Guild tempGuild = new Guild(); tempGuild.name = txtGuildName.Text; db.guilds.Add(tempGuild); db.SaveChanges(); napuniGuildove(); } }
private void loadGuildMember() { lbGuildMembers.Items.Clear(); using (var db = new GuildManagementContext()) { var members = (from m in db.members where m.guildID.ToString().Equals(ddlGuilds.SelectedValue) select m).ToList(); foreach(Member m in members) { lbGuildMembers.Items.Add(new ListItem(m.nickname)); } } }
protected void btnInsertMember_Click(object sender, EventArgs e) { using (var db = new GuildManagementContext()) { Member tempMember = new Member(); tempMember.nickname = txtMemberNickname.Text; int temp; int.TryParse(txtMemberGuildId.Text, out temp); tempMember.guildID = temp; db.members.Add(tempMember); db.SaveChanges(); loadGuildMember(); } }
private void napuniGuildove() { ddlGuilds.Items.Clear(); using (var db = new GuildManagementContext()) { var guilds = (from g in db.guilds select g).ToList(); foreach(Guild g in guilds) { ddlGuilds.Items.Add(new ListItem(g.name, g.guildID.ToString())); } } loadGuildMember(); }
protected void btnDeleteMember_Click(object sender, EventArgs e) { using (var db = new GuildManagementContext()) { var members = (from m in db.members where m.nickname.Equals(txtMemberNickname.Text) select m).ToList(); foreach(Member m in members) { db.members.Remove(m); db.SaveChanges(); } } loadGuildMember(); }