private void LibraryScreen_Load(object sender, EventArgs e) { context = new SA47_Team12aCADatabaseEntities(); Mem = context.Members.ToList(); Books = context.Books.ToList(); Aut = context.Authors.ToList(); labelWelcome.Text = showname; //-------------------------HIDE TABS BASED ON USER------------------------------ if (login == "b") { this.BookMaintain.Hide(); tabControlMenus.TabPages.Remove(IssueBook); this.MemberMaintain.Hide(); tabControlMenus.TabPages.Remove(ReturnBook); this.BookMaintain.Hide(); tabControlMenus.TabPages.Remove(BookMaintain); this.MemberMaintain.Hide(); tabControlMenus.TabPages.Remove(MemberMaintain); this.Reports.Hide(); tabControlMenus.TabPages.Remove(Reports); this.buttonSProceed.Hide(); this.buttonASProceed.Hide(); } //----------------------------SEARCH------------------ pub = new List <string>(); type = new List <string>(); for (int i = 0; i < Books.Count; i++) { int id = Books[i].BookID; string title = Books[i].BookTitle; pub.Add(Books[i].Publisher); type.Add(Books[i].BookType); comboBoxBookID.Items.Add(id); comboBoxBookTitle.Items.Add(title); } var unique_pub = new HashSet <string>(pub); foreach (string publisher in unique_pub) { comboBoxPublisher.Items.Add(publisher); } var unique_type = new HashSet <string>(type); foreach (string booktype in unique_type) { comboBoxBookType.Items.Add(booktype); } for (int i = 0; i < Aut.Count; i++) { string authorName = Aut[i].AuthorName; comboBoxAuthorName.Items.Add(authorName); } }
private void buttonRBSearchTrans_Click(object sender, EventArgs e) { try { context = new SA47_Team12aCADatabaseEntities(); IssueTransaction = context.IssueTrans.ToList(); Mem = context.Members.ToList(); Books = context.Books.ToList(); string memname = textBoxRBMemName.Text.ToLower(); string bookname = textBoxRBBookTitle.Text.ToLower(); bool bookstatus = true; bool memstatus = true; bool transtatus = true; for (int i = 0; i < Mem.Count; i++) { if (memname == Mem[i].MemberName.ToLower()) { //TextBoxTryMemName.Text = Mem[i].MemberID.ToString(); memID = Mem[i].MemberID; memstatus = false; break; } } if (memstatus == true) { MessageBox.Show("Member not found"); } for (int j = 0; j < Books.Count; j++) { if (bookname == Books[j].BookTitle.ToLower()) { //TryBookNameTextBox.Text = Books[j].BookID.ToString(); bookID = Books[j].BookID; bookstatus = false; break; } } if (bookstatus == true) { MessageBox.Show("Book not found"); } for (int count = 0; count < IssueTransaction.Count; count++) { if ((bookID == IssueTransaction[count].BookID) || (memID == IssueTransaction[count].MemberID)) { //var transrecord1 = context.IssueTrans.Where((x => (x.BookID == bookID && x.MemberID == memID))); var transrecord1 = from x in context.IssueTrans.Where(x => (x.BookID == bookID || x.MemberID == memID)) select(new { x.TransactionID, x.BookID, x.MemberID, x.IssueDate, x.DueDate, x.ActualReturnDate, x.FineAmount, x.Remarks, x.Status }); dataGridViewReturnBook.DataSource = transrecord1.ToList(); transtatus = false; } } if (transtatus == true) { MessageBox.Show("Transaction not found"); } } catch (ArgumentException ex) { MessageBox.Show(ex.Message); } }