private void BookMaintenance_Load(object sender, EventArgs e) { bookController = new BookController(); context = bookController.getContext(); dgvbook.DataSource = context.GetBookSP(); dgvcopies.DataSource = context.BookCopies; txtCategoryID.Text = dgvbook.SelectedRows[0].Cells[8].Value.ToString(); txtCategoryName.Text =dgvbook.SelectedRows[0].Cells[3].Value.ToString(); this.dgvbook.SelectionMode=DataGridViewSelectionMode.FullRowSelect; this.dgvbook.MultiSelect = false; dgvbook_SelectionChanged(sender, e); }
private void btnRefresh_Add(object sender, EventArgs e) { context = new LibraryEntities(); FirstName.DataBindings.Add("Text", context.Members, "FirstName"); LastName.DataBindings.Add("Text", context.Members, "LastName"); MemberID.DataBindings.Add("Text", context.Members, "MemberID"); Email.DataBindings.Add("Text", context.Members, "Email"); PhoneNo.DataBindings.Add("Text", context.Members, "PhoneNo"); Address.DataBindings.Add("Text", context.Members, "Address"); dataGridView1.DataSource = context.Members; dataGridView1.Refresh(); }
public IssueController() { context = new LibraryEntities(); }
private void SearchLoanBook_Load(object sender, EventArgs e) { context = new LibraryEntities(); resetForm(); }
public frmSearchBookByCriteria() { InitializeComponent(); context = new LibraryEntities(); }
private void ReturnForm_Load(object sender, EventArgs e) { context = new LibraryEntities(); returnController = new ReturnController(); }
public ReturnController() { context= new LibraryEntities(); }
private void Bookcopies_Load(object sender, EventArgs e) { context = new LibraryEntities(); if (newform == false) { var b = context.Books.First(x => x.BookID == bookid); txtBookID.Text = b.BookID.ToString(); txtAuthor.Text = b.Author; txtISBN.Text = b.ISBN.ToString(); txtEdition.Text = b.Edition.ToString(); txtPublisher.Text = b.Publisher.ToString(); cboCatagoyName.DataSource = context.BookCategories; cboCatagoyName.SelectedValue = b.CategoryID; txtTitle.Text = b.Title.ToString(); //var bc = context.BookCopies.First(x => x.BookID == bookid); //txtBookIDcopy.Text = bc.BookID.ToString(); //txtBookCopy.Text = bc.BookCopyID.ToString(); var q = from x in context.BookCopies where x.BookID == bookid select x; //copies = context.BookCopies.ToList<BookCopy>(x => x.BookID == bookid); copies = q.ToList<BookCopy>(); originalcopies = q.ToList<BookCopy>(); dgvcopy.DataSource = q.ToList(); dgvcopy.Refresh(); // BindingContext[context.BookCopies].AddNew(); } else { var lastBook = (from x in context.Books select x).OrderByDescending(x => x.BookID).Take(1); foreach (Book book in lastBook) { txtBookID.Text = (book.BookID + 1).ToString(); } var q = from x in context.BookCopies where x.BookID == bookid select x; //copies = context.BookCopies.ToList<BookCopy>(x => x.BookID == bookid); originalcopies = q.ToList<BookCopy>(); copies = q.ToList<BookCopy>(); cboCatagoyName.DataSource = context.BookCategories; cboCatagoyName.SelectedIndex = 0; } }
public BookController() { context= new LibraryEntities(); }