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