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();
}
