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