private void FindSong()
{
obj = new ComposersLibrary_EF.DBLibraryEntities1();
query = (from c in obj.SONGs
select c);
if (!String.IsNullOrWhiteSpace(NameTextBox.Text))
{
query = query.Where(c => c.SNG_NAME.Contains(NameTextBox.Text));
}
if (!String.IsNullOrWhiteSpace(GenreTextBox.Text))
{
query = query.Where(c => c.SNG_GENRE.Contains(GenreTextBox.Text));
}
if (!String.IsNullOrWhiteSpace(DurationTextBox.Text))
{
TimeSpan time;
if (TimeSpan.TryParse(DurationTextBox.Text, out time))
{
query = query.Where(c => c.SNG_DURATION.Value <= time);
}
else
{
MessageBox.Show("You have entered the wrong format of duration time of song, it must be HH:MM:SS.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
DurationTextBox.Text = "";
return;
}
}
sONGBindingSource.DataSource = query.ToList();
}
private void FindPerformances()
{
obj = new ComposersLibrary_EF.DBLibraryEntities1();
var query = (from c in obj.PERFORMANCEs
select c);
query = query.Where(c => c.PRF_DATE.Value > (DateTimePickerFrom.Value));
query = query.Where(c => c.PRF_DATE.Value < DateTimePickerTo.Value);
pERFORMANCEBindingSource.DataSource = query.ToList();
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
ctx = new ComposersLibrary_EF.DBLibraryEntities1();
ctx.SONGs.Load();
this.sONGBindingSource.DataSource = ctx.SONGs.Local.ToBindingList();
ctx.PERFORMERs.Load();
this.pERFORMERBindingSource.DataSource = ctx.PERFORMERs.Local.ToBindingList();
ctx.PERFORMANCEs.Load();
this.pERFORMANCEBindingSource.DataSource = ctx.PERFORMANCEs.Local.ToBindingList();
ctx.COMPOSERs.Load();
this.cOMPOSERBindingSource.DataSource = ctx.COMPOSERs.Local.ToBindingList();
}
private void FindComposers()
{
obj = new ComposersLibrary_EF.DBLibraryEntities1();
var query = (from c in obj.COMPOSERs
select c);
if (!String.IsNullOrWhiteSpace(NameTextBox.Text))
{
query = query.Where(c => c.CMP_FULL_NAME.Contains(NameTextBox.Text));
}
if (!String.IsNullOrWhiteSpace(NationalityTextBox.Text))
{
query = query.Where(c => c.CMP_NATIONALITY.Contains(NationalityTextBox.Text));
}
cOMPOSERBindingSource.DataSource = query.ToList();
}
private void FindPerformer()
{
obj = new ComposersLibrary_EF.DBLibraryEntities1();
var query = (from c in obj.PERFORMERs
where c.PERFORMANCEs.Any()
select c);
if (!String.IsNullOrWhiteSpace(NameTextBox.Text))
{
query = query.Where(c => c.PF_NAME.Contains(NameTextBox.Text));
}
if (!String.IsNullOrWhiteSpace(NationalityTextBox.Text))
{
query = query.Where(c => c.PF_NATIONALITY.Contains(NationalityTextBox.Text));
}
pERFORMERBindingSource.DataSource = query.ToList();
}
