protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
ctx = new FCDataEF.DBFClubsEntities();
ctx.Clubs.Load();
clubBindingSource.DataSource = ctx.Clubs.Local.ToBindingList();
ctx.Leagues.Load();
leagueBindingSource.DataSource = ctx.Leagues.Local.ToBindingList();
ctx.Titles.Load();
titleBindingSource.DataSource = ctx.Titles.Local.ToBindingList();
ctx.Contracts.Load();
contractBindingSource.DataSource = ctx.Contracts.Local.ToBindingList();
ctx.Federations.Load();
federationBindingSource.DataSource = ctx.Federations.Local.ToBindingList();
ctx.Countries.Load();
countryBindingSource.DataSource = ctx.Countries.Local.ToBindingList();
ctx.Players.Load();
playerBindingSource.DataSource = ctx.Players.Local.ToBindingList();
}
private void SearchBtn_Click(object sender, EventArgs e)
{
ctx_club.Dispose();
ctx_club = new FCDataEF.DBFClubsEntities();
var query = (from c in ctx_club.Clubs select c);
if (!String.IsNullOrWhiteSpace(ClubNameTB.Text))
{
query = query.Where(c => c.ClubName.Contains(ClubNameTB.Text));
}
if (!String.IsNullOrWhiteSpace(DescriptionTB.Text))
{
query = query.Where(c => c.Description.Contains(DescriptionTB.Text));
}
if (minTrackBar.Value < maxTrackBar.Value)
{
query = query.Where(c => c.YearOfFoundation > minTrackBar.Value && c.YearOfFoundation < maxTrackBar.Value);
}
query.Load();
source.DataSource = ctx_club.Clubs.Local.ToBindingList();
}
public SearchDialog(BindingSource clubSource)
{
InitializeComponent();
ctx_club = new FCDataEF.DBFClubsEntities();
source = clubSource;
}