private void btnPrice_Click(object sender, EventArgs e) { try { if (txMemberID == null || txBookID == null || txRemarks == null) { throw new InvalidInputException(); } Transaction t = context.Transactions.Where(x => x.MemberID == txMemberID.Text && x.BookID == txBookID.Text).First(); if (t.LoanStatus == "Borrowed") { gvReturn.DataSource = context.Books.Select(x => new { x.BookID, x.Title, x.Price }).Where(x => x.BookID == txBookID.Text).ToList(); Book b = context.Books.Where(x => x.BookID == txBookID.Text).First(); b.TotalStock -= 1; float fine; Member m = context.Members.Where(x => x.MemberID == txMemberID.Text).First(); Book b1 = context.Books.Where(x => x.BookID == txBookID.Text).First(); fine = (float)Convert.ToDouble(m.FineAmount + b.Price); m.FineAmount = fine; txFineAmount.Text = Convert.ToString(fine); context.SaveChanges(); MessageBox.Show("Total stock value is deducted"); } else { MessageBox.Show("The book is already returned"); } } catch (Exception a) { a = new InvalidInputException("Please fill in all fields."); MessageBox.Show(a.Message); } }
private void btnUpfM_Click(object sender, EventArgs e) { GalaxyEntities ctx = new GalaxyEntities(); Member c = new Member(); try { // Validate ID to be existing if (txmemberID.Text.Length == 5 && txmemberID.Text.Substring(0, 1) == "M") { if (Convert.ToInt32(txmemberID.Text.Substring(1, 4)) >= 1000 && Convert.ToInt32(txmemberID.Text.Substring(1, 4)) <= ctx.Members.Count() + 999) { // Identify member record c = ctx.Members.Where(x => x.MemberID == txmemberID.Text).First(); c.FineAmount = Convert.ToDouble(txFine.Text); ctx.SaveChanges(); MessageBox.Show("Successful update!"); btnclr_Click(sender, e); } } else { MessageBox.Show("Not an existing MemberID!"); } } catch (Exception a) { a = new InvalidInputException("Please ensure that details of member is correct."); MessageBox.Show(a.Message); } }
private void btnConfirm_Click(object sender, EventArgs e) { try { if (txTitle.Text == "" || txPublisher.Text == "" || txAuthor.Text == "" || txShelf.Text == "" || txPrice.Text == "" || txStock.Text == "") { throw new InvalidInputException(); } //Create book record b = new Book(); b.BookID = newBookID; b.Title = txTitle.Text; b.Publisher = txPublisher.Text; b.Author = txAuthor.Text; b.BookCategory = cbxCategory.SelectedItem.ToString(); b.Location = "F" + cbxFloor.SelectedItem.ToString() + "-L" + txShelf.Text; b.Price = Convert.ToDouble(txPrice.Text); b.TotalStock = Convert.ToInt32(txStock.Text); b.NumberBorrowed = 0; b.Availability = "yes"; //Store book record to database context.Books.Add(b); context.SaveChanges(); // Inform user and clear page MessageBox.Show("Book successfully added!"); ResetValues(); } catch (Exception a) { a = new InvalidInputException("Please fill in all fields."); MessageBox.Show(a.Message); } }
private void btnConfirm_Click(object sender, EventArgs e) { try { if (txTitle.Text == "" || txPublisher.Text == "" || txAuthor.Text == "" || txShelf.Text == "" || txPrice.Text == "" || txStock.Text == "") { throw new InvalidInputException(); } // Update book details in database b.Title = txTitle.Text; b.Publisher = txPublisher.Text; b.Author = txAuthor.Text; b.BookCategory = cbxCategory.SelectedItem.ToString(); b.Location = "F" + cbxFloor.SelectedItem.ToString() + "-L" + txShelf.Text; b.Price = Convert.ToDouble(txPrice.Text); b.TotalStock = Convert.ToInt32(txStock.Text); if (rbtnYes.Checked) { b.Availability = "yes"; } else { b.Availability = "no"; } context.SaveChanges(); MessageBox.Show("Book information successfully updated!"); ResetValues(); readOnlyFields(); } catch (Exception a) { a = new InvalidInputException("Please fill in all fields."); MessageBox.Show(a.Message); } }
public void search() { try { // Perform SQL query with condition indicated by user has input search text if (txInput.Text != "") { switch (cbxSearchBy.SelectedItem.ToString()) { case "Book ID": gv.DataSource = context.Books.Where(x => x.BookID.Contains(txInput.Text)). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Title": gv.DataSource = context.Books.Where(x => x.Title.Contains(txInput.Text)). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Publisher": gv.DataSource = context.Books.Where(x => x.Publisher.Contains(txInput.Text)). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Author": gv.DataSource = context.Books.Where(x => x.Author.Contains(txInput.Text)). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Book Category": gv.DataSource = context.Books.Where(x => x.BookCategory.Contains(txInput.Text)). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Location": gv.DataSource = context.Books.Where(x => x.Location.Contains(txInput.Text)). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Price": amount = double.Parse(txInput.Text); gv.DataSource = context.Books.Where(x => x.Price == amount). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Total Stock": amount = int.Parse(txInput.Text); gv.DataSource = context.Books.Where(x => x.TotalStock == amount). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Number Borrowed": amount = int.Parse(txInput.Text); gv.DataSource = context.Books.Where(x => x.NumberBorrowed == amount). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; case "Availability": gv.DataSource = context.Books.Where(x => x.Availability == txInput.Text). Select(x => new { x.BookID, x.Title, x.Publisher, x.Author, x.BookCategory, x.Location, x.Price, x.TotalStock, x.NumberBorrowed, x.Availability }).ToList(); break; } } } catch (Exception a) { a = new InvalidInputException("Invalid number."); MessageBox.Show(a.Message); } }