public ConcertsForm()
{
InitializeComponent();
ctx = new ConcertsDataBase.ConcertsEntities1();
ctx.Artists.Load();
this.artistsBindingSource.DataSource = ctx.Artists.Local.ToBindingList();
ctx.Concerts.Load();
this.concertsBindingSource.DataSource = ctx.Concerts.Local.ToBindingList();
ctx.Places.Load();
this.placesBindingSource.DataSource = ctx.Places.Local.ToBindingList();
ctx.Seats.Load();
this.seatsBindingSource.DataSource = ctx.Seats.Local.ToBindingList();
ctx.Sectors.Load();
this.sectorsBindingSource.DataSource = ctx.Sectors.Local.ToBindingList();
ctx.Tickets.Load();
this.ticketsBindingSource.DataSource = ctx.Tickets.Local.ToBindingList();
ctx.Ticket_States.Load();
this.ticketStatesBindingSource.DataSource = ctx.Ticket_States.Local.ToBindingList();
}
private void buttonSignUp_Click(object sender, EventArgs e)
{
concertsEntities = new ConcertsDataBase.ConcertsEntities1();
ConcertsDataBase.Authorization authorization = new ConcertsDataBase.Authorization();
authorization.Login = textBoxLogin.Text;
authorization.Password = textBoxPassword.Text;
concertsEntities.Authorization.Add(authorization);
concertsEntities.SaveChanges();
}
public FormArtistInfo(int _id, string _name)
{
InitializeComponent();
id = _id;
name = _name;
concerts = new ConcertsDataBase.ConcertsEntities1();
Text = String.Concat(Text, " ", name);
findArtistInfo();
}
private void EnterButton_Click(object sender, EventArgs e)
{
concertsEntities = new ConcertsDataBase.ConcertsEntities1();
var query = (from c in concertsEntities.Authorization
where c.Login == textBoxLogin.Text && c.Password == textBoxPassword.Text
select c).Count();
if (query == 0)
{
MessageBox.Show("Неправильний логін і пароль!");
}
else
{
ConcertsForm form = new ConcertsForm();
form.ShowDialog(this);
form.Dispose();
}
}
private void findArtist()
{
/*var chE = concerts.ChangeTracker.Entries<Artists>().Where(a => a.State != EntityState.Unchanged).ToList();
* if (chE.Count != 0)
* {
* MessageBox.Show("Необхідно зберегти зміни");
* }
* else*/
{
concerts = new ConcertsDataBase.ConcertsEntities1();
var query = (from c in concerts.Artists
where c.Artist_Genre.Contains(comboBoxGenre.Text)
select c);
query.Load();
artistsBindingSource.DataSource = concerts.Artists.Local.ToBindingList();
}
}
void findArtistInfo()
{
var chE = concerts.ChangeTracker.Entries <Artists>().Where(a => a.State != EntityState.Unchanged).ToList();
if (chE.Count != 0)
{
MessageBox.Show("Необхідно зберегти зміни");
}
else
{
concerts.Dispose();
concerts = new ConcertsDataBase.ConcertsEntities1();
var query = (from c1 in concerts.Artists
join c2 in concerts.Concerts on c1.Artist_ID equals c2.Concert_Artist_ID
where c1.Artist_ID == id
select c2);
query.Load();
concertsBindingSource.DataSource = concerts.Concerts.Local.ToBindingList();
}
}
private void findTickets()
{
/*var chE = concerts.ChangeTracker.Entries<Artists>().Where(a => a.State != EntityState.Unchanged).ToList();
* if (chE.Count != 0)
* {
* MessageBox.Show("Необхідно зберегти зміни");
* }
* else*/
{
concerts = new ConcertsDataBase.ConcertsEntities1();
var query = (from c1 in concerts.Artists
join c2 in concerts.Concerts on c1.Artist_ID equals c2.Concert_Artist_ID
join c3 in concerts.Tickets on c2.Concert_ID equals c3.Ticket_Concert_ID
join c4 in concerts.Places on c2.Concert_Place_ID equals c4.Place_ID
select c3);
if (!String.IsNullOrWhiteSpace(textBoxArtist.Text))
{
query = query.Where(c => c.Concerts.Artists.Artist_Name.Contains(textBoxArtist.Text));
}
if (!String.IsNullOrWhiteSpace(textBoxPlace.Text))
{
query = query.Where(c => c.Concerts.Places.Place_Name.Contains(textBoxPlace.Text));
}
if (!String.IsNullOrWhiteSpace(comboBoxState.Text))
{
query = query.Where(c => c.Ticket_States.Name.Contains(comboBoxState.Text));
}
query.Load();
ticketsBindingSource.DataSource = concerts.Tickets.Local.ToBindingList();
}
}
