public frmBorrowBook() { InitializeComponent(); context = new SA45_Team08B_LibraryEntities(); b = null; m = null; }
private void MemberInfo_UpdateDetails_Load(object sender, EventArgs e) { statusStrip1.ForeColor = Color.White; context = new SA45_Team08B_LibraryEntities(); lblIDValid.Text = lblAddressValid.Text = lblCityValid.Text = lblEmailValid.Text = lblMemberNameValid.Text = lblPostalCodeValid.Text = lblPlaceOfBirthValid.Text = lblPhoneValid.Text = ""; cbbContactTitle.Text = "MR"; }
private void frmBookInfo_Load(object sender, EventArgs e) { context = new SA45_Team08B_LibraryEntities(); pnlAdmin.Hide(); EnableButtons(false); lblValid.Text = ""; lblValid.ForeColor = Color.Red; ShowAvailDate(false); }
public frmReturn() { InitializeComponent(); //timer1.Tick += new EventHandler(timer1_tick); context = new SA45_Team08B_LibraryEntities(); //lblDateReturn.Text = DateTime.Today.ToString(); //shows the time today for return MaximizeBox = false; MinimizeBox = false; btnSubmit.Enabled = false; rbMemberID.Checked = true; }
private void btnGo_Click(object sender, EventArgs e) { SA45_Team08B_LibraryEntities context = new SA45_Team08B_LibraryEntities(); int id = Convert.ToInt16(txtBook.Text); Book b = new Book(); b = context.Books.Where(x => x.BookID == id).First(); txtBookType.Text = b.BookType; txtBookTitle.Text = b.BookTitle; txtPublisher.Text = b.Publisher; txtTotalStock.Text = b.TotalStock.ToString(); txtNumberBorrow.Text = b.NumberBorrowed.ToString(); txtAuthor.Text = b.Author; }
private void MemberInfo_UpdateDetails_Load(object sender, EventArgs e) { context = new SA45_Team08B_LibraryEntities(); member = context.Members.Where(x => x.MemberID == MemberIDSelected).First(); tbxAddress.Text = member.Address; tbxCity.Text = member.City; tbxMemberID.Text = member.MemberID; cbbContactTitle.Text = member.ContactTitle; cbbCountryCode.Text = member.PlaceOfBirth; tbxEmail.Text = member.EmailAddress; //cbbMemberCategory.Text = member.MemberCategory; tbxMemberName.Text = member.MemberName; tbxPhone.Text = member.PhoneNumber; tbxPostalCode.Text = member.PostalCode; }
private void btnSearch_Click(object sender, EventArgs e) { //context = new LibraryEntities(); //var qry = from x in context.Members // where txtMemberID.Text == x.MemberID || txtMemberName.Text == x.MemberName select x; //dgv.DataSource = qry.ToList(); using (frmSearchMember f = new frmSearchMember()) { context = new SA45_Team08B_LibraryEntities(); f.ShowDialog(); if (f.DialogResult == DialogResult.OK) { txtMemberID.Text = f.GetID; btnGo_Click(sender, e); } } }
private void MemberInfo_UpdateDetails_Load(object sender, EventArgs e) { statusStrip1.ForeColor = Color.White; context = new SA45_Team08B_LibraryEntities(); member = context.Members.Where(x => x.MemberID == MemberIDSelected).First(); lblAddressValid.Text = lblCityValid.Text = lblEmailValid.Text = lblMemberNameValid.Text = lblPostalCodeValid.Text = lblPlaceOfBirthValid.Text = lblPhoneValid.Text = ""; tbxAddress.Text = member.Address; tbxCity.Text = member.City; tbxMemberID.Text = member.MemberID; cbbContactTitle.Text = member.ContactTitle; cbbPlaceOfBirth.Text = member.PlaceOfBirth; tbxEmail.Text = member.EmailAddress; //cbbMemberCategory.Text = member.MemberCategory; tbxMemberName.Text = member.MemberName; tbxPhone.Text = member.PhoneNumber; tbxPostalCode.Text = member.PostalCode; }
private void btnDelete_Click(object sender, EventArgs e) { SA45_Team08B_LibraryEntities context = new SA45_Team08B_LibraryEntities(); DialogResult r = MessageBox.Show("Are you sure to delete the record?", "Confirm", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { using (TransactionScope ts = new TransactionScope()) { Book b = new Book(); int id = Convert.ToInt16(txtBook.Text); var q = from x in context.Books where x.BookID == id select x; b = q.First(); context.Books.Remove(b); context.SaveChanges(); ts.Complete(); } sslDelete.Text = "You have deleted the record successfully."; } }
private void BookInfo_Update_Load(object sender, EventArgs e) { statusStrip1.ForeColor = Color.White; context = new SA45_Team08B_LibraryEntities(); lblAuthorValid.Text = lblBookTitleValid.Text = lblBookTypeValid.Text = lblPublisherValid.Text = lblTotalStockValid.Text = ""; book = context.Books.Where(x => x.BookID == BookIDSelected).First(); nudTotalStock.Value = (short)book.TotalStock; tbxAuthor.Text = book.Author; tbxBookID.Text = book.BookID.ToString(); tbxBookTitle.Text = book.BookTitle; cbbBookType.Text = book.BookType; tbxNumberBorowed.Text = book.NumberBorrowed.ToString(); tbxPublisher.Text = book.Publisher; //cbbRating.Text = book.Rating; //nudTotalStock.Maximum = 20; //nudTotalStock.Minimum = 1; checkChanges(); }
private void btnSearch_Click(object sender, EventArgs e) { SA45_Team08B_LibraryEntities context = new SA45_Team08B_LibraryEntities(); frmSearchBook f = new frmSearchBook(); DialogResult r = f.ShowDialog(); if (r == DialogResult.OK) { txtBook.Text = f.GetID; int id = Convert.ToInt16(txtBook.Text); Book b = new Book(); b = context.Books.Where(x => x.BookID == id).First(); txtBookType.Text = b.BookType; txtBookTitle.Text = b.BookTitle; txtPublisher.Text = b.Publisher; txtTotalStock.Text = b.TotalStock.ToString(); txtNumberBorrow.Text = b.NumberBorrowed.ToString(); txtAuthor.Text = b.Author; } }
public frmSearchMember() { InitializeComponent(); context = new SA45_Team08B_LibraryEntities(); }
private void button1_Click(object sender, EventArgs e) { SA45_Team08B_LibraryEntities context = new SA45_Team08B_LibraryEntities(); short bkID; int testId; short bkStock; bool valid = true; Book b; if (!Int16.TryParse(txtBID.Text, out bkID)) { if (int.TryParse(txtBID.Text, out testId)) { lblErrorID.Text = "Select an ID less than 32768"; } else { lblErrorID.Text = "Book ID should only contain numbers"; } valid = false; } else { try { b = context.Books.Where(x => x.BookID == bkID).First(); //no error means book is already inside database lblErrorID.Text = "Book ID in use. Please enter another ID"; valid = false; } catch (Exception ex) { lblErrorID.Text = ""; } } if (txtBookTitle.Text == "") { lblErrorTitle.Text = "Title field cannot be empty"; valid = false; } else { lblErrorTitle.Text = ""; } if (cmbBookType.Text == "") { lblErrorType.Text = "Please select a book type"; valid = false; } else { lblErrorType.Text = ""; } if (txtPublisher.Text == "") { lblErrorPublisher.Text = "Publisher field cannot be empty"; valid = false; } else { lblErrorPublisher.Text = ""; } if (txtAuthor.Text == "") { lblErrorAuthor.Text = "Author field cannot be empty"; valid = false; } else { lblErrorAuthor.Text = ""; } if (!Int16.TryParse(txtTotalStock.Text, out bkStock)) { lblErrorStock.Text = "Please enter a number"; valid = false; } else { lblErrorStock.Text = ""; } if (valid) { DialogResult r = MessageBox.Show("Are you sure to add the book?", "Confirm", MessageBoxButtons.YesNo); if (r == DialogResult.Yes) { using (TransactionScope ts = new TransactionScope()) { Book bk = new Book(); bk.BookID = Convert.ToInt16(txtBID.Text); bk.BookTitle = txtBookTitle.Text; bk.BookType = cmbBookType.Text; bk.Author = txtAuthor.Text; bk.Publisher = txtPublisher.Text; bk.TotalStock = Convert.ToInt16(txtTotalStock.Text); context.Books.Add(bk); context.SaveChanges(); ts.Complete(); sslAdd.Text = "You have added the book successfully!"; } } } }