//public frmNewMember(string userNameFromLogin, string userCategory) //{ // InitializeComponent(); // // Assign the properties UserNameFromLogin & UserCategory respectively when form is contructed // UserNameFromLogin = userNameFromLogin; // UserCategory = userCategory; //} private void frmNewMember_Load(object sender, EventArgs e) { context = new PGPLibraryEntities(); n = new Navigation(); txtBoxPassword.UseSystemPasswordChar = true; txtBoxPasswordCheck.UseSystemPasswordChar = true; }
private void frmNewMember2_Load(object sender, EventArgs e) { HideWarningLabels(); n = new Navigation(); context = new PGPLibraryEntities(); isSubmitClicked = false; }
private void frmBorrowBook_BookID_Load(object sender, EventArgs e) { n = new Navigation(); context = new PGPLibraryEntities(); var a = context.BookListings.Select(x => new { x.BookID, x.ISBN, x.BookTitle, x.BookType, x.Language, x.AuthorID, x.PublisherID, x.TotalStock, x.NumberLoaned, x.Section, x.CallNumber, x.Notes, x.Publisher.PublisherName, x.Author.AuthorName }); if (a != null) { dgvSearchBookID.DataSource = a.ToList(); } }
private void frmSearchBook_Load(object sender, EventArgs e) { n = new Navigation(); PGPLibraryEntities context = new PGPLibraryEntities(); lblUser.Text = $"{UserCategory}: {UserNameFromLogin}"; lblBookNotFound.Visible = false; lblBookAvailble.Visible = false; }
private void frmBorrowBook_Load(object sender, EventArgs e) { n = new Navigation(); context = new PGPLibraryEntities(); lblUserDetails.Text = $"{UserCategory}: {UserNameFromLogin}"; int?a = context.Members.Where(x => x.Username.ToUpper() == UserNameFromLogin.ToUpper()).Select(x => x.MemberID).FirstOrDefault(); if (a != null) { txtBoxMemberID.Text = a.ToString(); var firstName = context.Members.Where(x => x.Username.ToUpper() == UserNameFromLogin.ToUpper()).Select(x => x.FirstName).First(); var lastName = context.Members.Where(x => x.Username.ToUpper() == UserNameFromLogin.ToUpper()).Select(x => x.LastName).First(); txtBoxMemberName.Text = $"{firstName} {lastName}"; } dtpBorrow.Value = DateTime.Now; dtpDue.Value = DateTime.Now.AddMonths(1); lblNoBooksWarning.Visible = false; }
private void btnAdd_Click(object sender, EventArgs e) { PGPLibraryEntities context = new PGPLibraryEntities(); BookListing nbook = new BookListing(); BookAdjustment adjust = new BookAdjustment(); if (!GotEmptyField() && AdddataType() && IsAddMore()) { //Update Booklisting Table nbook.ISBN = txtISBNAdd.Text; nbook.BookTitle = txtBookTitleAdd.Text; nbook.CallNumber = txtCallNoAdd.Text; nbook.Notes = txtNoteAdd.Text; nbook.BookType = cboBoxBookTypeAdd.SelectedItem.ToString(); nbook.Language = cboBoxLanguageAdd.SelectedItem.ToString(); Author author = context.Authors.Where(x => x.AuthorName == cboBoxAuthorAdd.SelectedItem.ToString()).First(); nbook.AuthorID = author.AuthorID; Publisher publisher = context.Publishers.Where(x => x.PublisherName == cboBoxPublisherAdd.SelectedItem.ToString()).First(); nbook.PublisherID = publisher.PublisherID; nbook.Section = cboBoxSectionAdd.SelectedItem.ToString(); nbook.BookID = "B00" + context.ControlTables.Where(x => x.NumberType == "BookID").Select(x => x.FirstFreeNo).First(); nbook.NumberLoaned = 0; //Update BookAdjustment Table adjust.BookID = "B00" + context.ControlTables.Where(x => x.NumberType == "BookID").Select(x => x.FirstFreeNo).First(); adjust.DateAdjust = DateTime.Now; //Librarian librarian = context.Librarians.Where(x => x.Username == lblUser.Text).First(); //adjust.WhoAdjust = librarian.LibrarianID; adjust.WhoAdjust = Convert.ToInt32("4000"); adjust.AdjustmentReason = "Buy new books"; adjust.AdjustmentQty = Convert.ToInt32(txtQuantityAdd.Text); nbook.TotalStock = Convert.ToInt32(txtQuantityAdd.Text); ////Update ControlNumber //ControlTable control = context.ControlTables.Where(x => x.NumberType == "BookID").First(); //control.FirstFreeNo += 1; MessageBox.Show("Add book successfully."); context.BookAdjustments.Add(adjust); context.BookListings.Add(nbook); context.SaveChanges(); } }
private void frmProfile_Load(object sender, EventArgs e) { n = new Navigation(); lblUserDetails.Text = $"{UserCategory}: {UserNameFromLogin}"; PGPLibraryEntities context = new PGPLibraryEntities(); if (UserCategory == "Member") { var s = from x in context.Members where x.Username == UserNameFromLogin select new { x.MemberID }; int memberID = Convert.ToInt32(s.FirstOrDefault().MemberID); //MemberID is int var q = from x in context.IssueTrans from y in context.BookListings where x.BookID == y.BookID && x.LoanStatus == "OUT" && x.MemberID == memberID select new { x.TransactionID, x.MemberID, x.BookID, y.BookTitle, x.DateBorrow, x.DateDue, x.OverdueFine }; dgvProfile.DataSource = q.ToList(); } }
private void frmDashboard_Load(object sender, EventArgs e) { context = new PGPLibraryEntities(); n = new Navigation(); lblUserDetails.Text = $"{UserCategory}: {UserNameFromLogin}"; }