private void buttonSearch_Click(object sender, EventArgs e) { ctx.Dispose(); ctx = new KZVLDataEF.KZVLEntities(); var player = (from c in ctx.Players select c); var group = (from c in ctx.Groups select c); var divizion = (from c in ctx.Divizions select c); if (!string.IsNullOrWhiteSpace(comboBoxName.Text)) { group = group.Where(g => g.GR_Name.Contains(comboBoxName.Text)); } if (!string.IsNullOrWhiteSpace(comboBoxBestPlayer.Text)) { player = player.Where(p => p.PL_Name.Contains(comboBoxBestPlayer.Text)); group = group.Where(g => g.GR_BestPlayer_Players_Id == player.FirstOrDefault().PL_Id); } if (!string.IsNullOrWhiteSpace(comboBoxNumber.Text)) { int res = int.Parse(comboBoxNumber.Text); divizion = divizion.Where(d => d.DZ_Number == res); group = group.Where(g => g.GR_Divizion_Divizions_Id == divizion.FirstOrDefault().DZ_Id); } group.Load(); this.groupsBindingSource.DataSource = ctx.Groups.Local.ToBindingList(); }
public FrmTeam() { InitializeComponent(); ctx = new KZVLDataEF.KZVLEntities(); ctx.Teams.Load(); ctx.Players.Load(); ctx.Groups.Load(); this.teamsBindingSource.DataSource = ctx.Teams.Local.ToBindingList(); this.playersBindingSource.DataSource = ctx.Players.Local.ToBindingList(); this.groupsBindingSource.DataSource = ctx.Groups.Local.ToBindingList(); }
private void buttonSearch_Click(object sender, EventArgs e) { ctx.Dispose(); ctx = new KZVLDataEF.KZVLEntities(); var team = (from c in ctx.Teams select c); var player = (from c in ctx.Players select c); var role = (from c in ctx.Role select c); if (!string.IsNullOrWhiteSpace(comboBoxName.Text)) { player = player.Where(p => p.PL_Name.Contains(comboBoxName.Text)); } if (!string.IsNullOrWhiteSpace(comboBoxNumber.Text)) { player = player.Where(p => p.PL_Number == int.Parse(comboBoxNumber.Text)); } if (!string.IsNullOrWhiteSpace(comboBoxHeight.Text)) { int res = int.Parse(comboBoxHeight.Text); player = player.Where(p => p.PL_Height == res); } if (!string.IsNullOrWhiteSpace(comboBoxRole.Text)) { role = role.Where(r => r.RL_Name.Contains(comboBoxRole.Text)); player = player.Where(p => p.PL_Role_Role_Id == role.FirstOrDefault().RL_Id); } if (!string.IsNullOrWhiteSpace(comboBoxTeam.Text)) { team = team.Where(t => t.TM_Name.Contains(comboBoxTeam.Text)); player = player.Where(p => p.PL_Team_Teams_Id == team.FirstOrDefault().TM_Id); } if (!string.IsNullOrWhiteSpace(comboBoxCountOfTheBestPlayer.Text)) { int res = int.Parse(comboBoxCountOfTheBestPlayer.Text); player = player.Where(p => p.PL_CountOfBestPlayerMatch == res); } if (!string.IsNullOrWhiteSpace(comboBoxCategory.Text)) { player = player.Where(p => p.PL_Category.Contains(comboBoxCategory.Text)); } player.Load(); this.playersBindingSource.DataSource = ctx.Players.Local.ToBindingList(); }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); ctx = new KZVLDataEF.KZVLEntities(); ctx.Teams.Load(); this.teamsBindingSource.DataSource = ctx.Teams.Local.ToBindingList(); ctx.Players.Load(); this.playersBindingSource.DataSource = ctx.Players.Local.ToBindingList(); ctx.Groups.Load(); this.groupsBindingSource.DataSource = ctx.Groups.Local.ToBindingList(); ctx.Divizions.Load(); this.divizionsBindingSource.DataSource = ctx.Divizions.Local.ToBindingList(); ctx.Role.Load(); this.roleBindingSource.DataSource = ctx.Role.Local.ToBindingList(); }
private void buttonSearch_Click(object sender, EventArgs e) { ctx.Dispose(); ctx = new KZVLDataEF.KZVLEntities(); var team = (from c in ctx.Teams select c); var player = (from c in ctx.Players select c); var group = (from c in ctx.Groups select c); if (!string.IsNullOrWhiteSpace(comboBoxName.Text)) { team = team.Where(c => c.TM_Name.Contains(comboBoxName.Text)); } if (!string.IsNullOrWhiteSpace(comboBoxRating.Text)) { int res = int.Parse(comboBoxRating.Text); team = team.Where(c => c.TM_Rating == res); } if (!string.IsNullOrWhiteSpace(comboBoxCaptain.Text)) { player = player.Where(c => c.PL_Name.Contains(comboBoxCaptain.Text)); team = team.Where(t => t.TM_Captain_Players_Id == player.FirstOrDefault().PL_Id); } if (!string.IsNullOrWhiteSpace(comboBoxGroup.Text)) { group = group.Where(c => c.GR_Name.Contains(comboBoxGroup.Text)); team = team.Where(c => c.TM_Group_Groups_Id == group.FirstOrDefault().GR_Id); } team.Load(); this.teamsBindingSource.DataSource = ctx.Teams.Local.ToBindingList(); }