private void button1_Click(object sender, EventArgs e) { bd = new Book_ShopEntities(); var item = (from r in bd.Reservations join b in bd.Buyers on r.Id_Buyer equals b.Id_Buyer join bk in bd.Books on r.Id_Book equals bk.Id_Book select new { LastNameBuyer = b.LastName, FirstNameBuyer = b.FistName, NameOfBook = bk.NameBook }).ToList(); dataGridViewAllBooks.DataSource = null; dataGridViewAllBooks.DataSource = item; }
private void btnShow_Click(object sender, EventArgs e) { bd = new Book_ShopEntities(); bd.Books.Load(); dataGridViewAllBooks.DataSource = bd.Books.Local.ToBindingList(); dataGridViewAllBooks.DataSource = bd.Books.Local.ToBindingList(); dataGridViewAllBooks.Columns["Themes"].Visible = false; dataGridViewAllBooks.Columns["Authors"].Visible = false; dataGridViewAllBooks.Columns["Publishers"].Visible = false; dataGridViewAllBooks.Columns["Discounts"].Visible = false; dataGridViewAllBooks.Columns["NextTome"].Visible = false; dataGridViewAllBooks.Columns["Reservations"].Visible = false; dataGridViewAllBooks.Columns["Sales"].Visible = false; dataGridViewAllBooks.Columns["Sales"].Visible = false; dataGridViewAllBooks.Columns["Sales"].Visible = false; }
public FormMain(Users new_user, int userId) { InitializeComponent(); this.u = new_user; this.userId = userId; textBoxLog.Text = u.Login.ToString(); bd = new Book_ShopEntities(); bd.Books.Load(); dataGridViewAllBooks.DataSource = bd.Books.Local.ToBindingList(); dataGridViewAllBooks.Columns["Themes"].Visible = false; dataGridViewAllBooks.Columns["Authors"].Visible = false; dataGridViewAllBooks.Columns["Publishers"].Visible = false; dataGridViewAllBooks.Columns["Discounts"].Visible = false; dataGridViewAllBooks.Columns["NextTome"].Visible = false; dataGridViewAllBooks.Columns["Reservations"].Visible = false; dataGridViewAllBooks.Columns["Sales"].Visible = false; }
private void btnNewBook_Click(object sender, EventArgs e) { //bd.Configuration.LazyLoadingEnabled = true; //bd = new Book_ShopEntities1(); //var selected = bd.InfoBook; //StringBuilder builder = new StringBuilder(); //foreach (InfoBook book in selected) //{ // builder.AppendLine($"{book.NameBook} {book.Fullname_Author}"); //} //dataGridViewAllBooks.DataSource = null; //dataGridViewAllBooks.DataSource = builder.ToString(); bd = new Book_ShopEntities(); var new_book = bd.InfoBook.OrderBy(x => x.NameBook).ToList(); dataGridViewAllBooks.DataSource = null; dataGridViewAllBooks.DataSource = new_book; }
public SearchForm(Books b, Authors a, Themes t) { InitializeComponent(); this.b = b; this.a = a; this.t = t; bd = new Book_ShopEntities(); cmbBoxName.DataSource = null; cmbBoxAuthor.DataSource = null; cmbBoxTheme.DataSource = null; //cmbBoxName.DataSource = bd.Books.ToList(); //cmbBoxName.DisplayMember = "NameBook"; //cmbBoxName.ValueMember = "Id_Book"; //cmbBoxAuthor.DataSource = bd.Books.ToList(); //cmbBoxAuthor.DisplayMember = "LastName"; //cmbBoxAuthor.ValueMember = "Id_Author"; //cmbBoxTheme.DataSource = bd.Books.ToList(); //cmbBoxTheme.DisplayMember = "NameGenre"; //cmbBoxTheme.ValueMember = "Id_Theme"; }
public UserForm() { InitializeComponent(); bd = new Book_ShopEntities(); textBoxPassword.PasswordChar = '*'; }