private void BooksDashboard_Load(object sender, EventArgs e)
{
UpdateDgvBooks();
CmbGenreBook.DataSource = db.BookGenre.Select(bg => new CmbBooksClass {
Id = bg.Id, GenreName = bg.GenreName
}).ToList();
db.SaveChanges();
//CmbGenreBook.AutoCompleteMode = AutoCompleteMode.Suggest;
//CmbGenreBook.AutoCompleteSource = AutoCompleteSource.ListItems;
}
private void LendingDashboard_Load(object sender, EventArgs e)
{
DgvLending.DataSource = db.Lending.Select(lend => new
{
lend.Id,
lend.Members.MemberName,
lend.Members.MemberSurname,
lend.LentedUsername,
lend.DataTimeBorrowed,
lend.DataTimeReturned,
PasssportId = lend.Members.PassportId
}).OrderByDescending(lend => lend.Id).ToList();
cmbPassportId.DataSource = db.Members.Select(ps => new PassportClass {
Id = ps.Id, PassportId = ps.PassportId
}).ToList();
cmbPassportId.AutoCompleteMode = AutoCompleteMode.Suggest;
cmbPassportId.AutoCompleteSource = AutoCompleteSource.ListItems;
combBookName.DataSource = db.Books.Select(cmb => new CmbBooksClass {
Id = cmb.Id, GenreName = cmb.BookName
}).ToList();
db.SaveChanges();
}
private void Members_Load(object sender, EventArgs e)
{
UpdateMembersDgv();
db.SaveChanges();
}
