private void btnReturn_Click(object sender, EventArgs e) { try { // Validate Book ID if (txBookID.Text.Length == 5 && txBookID.Text.Substring(0, 1) == "G" && Convert.ToInt32(txBookID.Text.Substring(1, 4)) >= 1 && Convert.ToInt32(txBookID.Text.Substring(1, 4)) <= context.Books.Count()) { //Check if member has borrowed this book if (context.Transactions.Where(x => (x.BookID == txBookID.Text) && (x.MemberID == txMemberID.Text) && (x.LoanStatus == "Borrowed")).FirstOrDefault() == null) { throw new NoTransactionException(); } Transaction r = context.Transactions.Where(x => (x.BookID == txBookID.Text) && (x.MemberID == txMemberID.Text) && (x.LoanStatus == "Borrowed")).FirstOrDefault(); MessageBox.Show(r.TransactionID.ToString()); // Indentify transaction record and update return date, loanstatus and remarks Transaction t = context.Transactions.Where(x => x.MemberID == txMemberID.Text && x.BookID == txBookID.Text && x.LoanStatus == "Borrowed").First(); t.ReturnDate = DateTime.Today.Date; t.LoanStatus = "Returned"; t.Remarks = txRemarks.Text; gvReturn.DataSource = context.Transactions.Where(x => x.LoanStatus == "Borrowed" && x.MemberID == txMemberID.Text).Select(x => new { x.TransactionID, x.BookID, x.MemberID, x.LoanStatus, x.IssueDate, x.DueDate, }).ToList(); // Identify member record Member m = context.Members.Where(x => x.MemberID == txMemberID.Text).First(); CalculateFine(); // Update fine amount in member record txFineAmount.Text = Convert.ToString(m.FineAmount); // Display fine amount to user // Identify book record Book b = context.Books.Where(x => x.BookID == txBookID.Text).First(); b.NumberBorrowed -= 1; // decrease book borrowed context.SaveChanges(); } else { MessageBox.Show("This book is not existing! You may input the wrong BookID, please check and input again!"); } } catch (NoTransactionException ex) { ex = new NoTransactionException("Member did not borrow this book."); MessageBox.Show(ex.Message); } catch (Exception ex) { MessageBox.Show("Invalid MemberId" + ex.ToString()); } }
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 btnUpdate_Click(object sender, EventArgs e) { try { Staff s = context.Staffs.Where(x => x.Username == txtUserName.Text && x.EmailAddress == txtEmailId.Text).First(); if (txtNewPassword.Text != txtRetypePassword.Text) { MessageBox.Show("Password does'nt match"); } else { s = context.Staffs.Where(x => x.Username == txtUserName.Text).First(); s.Password = txtNewPassword.Text; context.SaveChanges(); MessageBox.Show("Password Changed"); } } catch (Exception ex) { MessageBox.Show("Invalid Details. Please check the details entered " + ex.Message); } //this.Hide(); //f = new frm2Login(); //f.Location = this.Location; //f.ShowDialog(); //this.Close(); btnBack_Click(sender, e); }
private void Extension(GalaxyEntities context) { Transaction t = context.Transactions.Where(x => x.BookID == txBookID.Text && x.MemberID == txMemberID.Text).FirstOrDefault(); t.IssueDate = DateTime.Today.Date; t.DueDate = DateTime.Now.AddDays(10); t.ExtensionCount += 1; context.SaveChanges(); }
private void btnConfirm_Click(object sender, EventArgs e) { try { if (choose == "Update") { groupBoxReadOnly(true); m = context.Members.Where(x => x.MemberID == txCustomerID.Text.ToUpper()).First(); updateMember(m); m.Status = cbxStatus.Text; context.SaveChanges(); MessageBox.Show("Customer information successfully updated!"); btnAdd.Enabled = true; btnConfirm.Enabled = false; resetCustomerDetails(); } if (choose == "Add") { if (txCustomerName.Text == "" || txPhoneNumber.Text == "" || txEmailAddress.Text == "") { throw new ErrorException("Please ensure fill in all the necessary details."); } updateMember(m); m.CurrentBorrowing = 0; m.FineAmount = 0; context.Members.Add(m); context.SaveChanges(); MessageBox.Show("Customer successfully added!"); resetCustomerDetails(); } } catch (Exception a) { a = new ErrorException("Please ensure valid format for all the details."); MessageBox.Show(a.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { GalaxyEntities ctx = new GalaxyEntities(); Staff c = ctx.Staffs.Where(x => x.StaffID == txID.Text).First(); c.Name = txName.Text; c.Password = txPassword.Text; c.PhoneNumber = txPhoneNo.Text; c.Position = txPosition.Text; c.Username = txUserName.Text; c.Address = txAddress.Text; c.EmailAddress = txEmail.Text; ctx.SaveChanges(); MessageBox.Show("Information successfully updated!"); }
private void btnDelete_Click(object sender, EventArgs e) { GalaxyEntities ctx = new GalaxyEntities(); if (txID.Text.Length == 3 && txID.Text.Substring(0, 1) == "S" && Convert.ToInt32(txID.Text.Substring(1, 2)) >= 1 && Convert.ToInt32(txID.Text.Substring(1, 2)) <= ctx.Staffs.Count()) { Staff c = ctx.Staffs.Where(x => x.StaffID == txID.Text).First(); ctx.Staffs.Remove(c); ctx.SaveChanges(); MessageBox.Show("Staff successfully deleted!"); } else { MessageBox.Show("This staff is not existing! You may input the wrong StaffID, please check and input again!"); } }
private void btnAdd_Click(object sender, EventArgs e) { GalaxyEntities ctx = new GalaxyEntities(); if (txID.Text.Length == 3 && txID.Text.Substring(0, 1) == "S" && Convert.ToInt32(txID.Text.Substring(1, 2)) >= 1 && Convert.ToInt32(txID.Text.Substring(1, 2)) <= ctx.Staffs.Count()) { bool check = false; foreach (Staff x in ctx.Staffs.ToList()) { if (txID.Text == x.StaffID) { check = true; break; } } if (check == false) { Staff c = new Staff(); c.StaffID = txID.Text; c.Name = txName.Text; c.Password = txPassword.Text; c.PhoneNumber = txPhoneNo.Text; c.Position = txPosition.Text; c.Username = txUserName.Text; c.Address = txAddress.Text; c.EmailAddress = txEmail.Text; ctx.Staffs.Add(c); ctx.SaveChanges(); MessageBox.Show("Staff successfully added!"); } else { MessageBox.Show("Existed Member ID, please set other ID!!"); } } else { MessageBox.Show("You may input the wrong StaffID, please check and input again!"); } }
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); } }
private void btnConfirm_Click(object sender, EventArgs e) { using (GalaxyEntities context = new GalaxyEntities()) { txMemberID.Text.Trim(); txBookID.Text.Trim(); if (txMemberID.Text.Length == 5 && txMemberID.Text.Substring(0, 1) == "M" && Convert.ToDouble(txMemberID.Text.Substring(1, 4)) >= 1000 && Convert.ToDouble(txMemberID.Text.Substring(1, 4)) <= context.Members.Count() + 999) { if (txBookID.Text.Length == 5 && txBookID.Text.Substring(0, 1) == "G" && Convert.ToDouble(txBookID.Text.Substring(1, 4)) >= 1 && Convert.ToDouble(txBookID.Text.Substring(1, 4)) <= context.Books.Count()) { int i = TotalBookStockValidation(context); if (i > 0) { var count = context.Transactions.Where(x => x.MemberID == txMemberID.Text && x.LoanStatus == "Borrowed").Count(); var Lecturer = context.Members.Where(x => x.MemberID == txMemberID.Text && x.MemberCategory == "Lecturer"); if (count <= 3) { Transaction t = new Transaction(); t.TransactionID = (context.Transactions.Count() + 1); t.BookID = txBookID.Text; t.MemberID = txMemberID.Text; t.IssueDate = DateTime.Today.Date; t.DueDate = DateTime.Now.AddDays(10); t.LoanStatus = ""; context.Transactions.Add(t); context.SaveChanges(); DateTime r = DateTime.Today; Transaction t1 = context.Transactions.Where (x => x.MemberID == txMemberID.Text && x.BookID == txBookID.Text).First(); if (Lecturer != null) //Lecturers loan duration is 20 compared to 10 { t1.DueDate = DateTime.Today.Date.AddDays(20); } else { t1.DueDate = DateTime.Now.AddDays(10); } Book b1 = new Book(); b1 = context.Books.Where(x => x.BookID == txBookID.Text).First(); b1.NumberBorrowed += 1; b1.TotalStock -= 1; Member a = new Member(); a = context.Members.Where(x => x.MemberID == txMemberID.Text).First(); a.CurrentBorrowing += 1; t.LoanStatus = "Borrowed"; context.SaveChanges(); GV.DataSource = context.Transactions.Where(x => x.LoanStatus == "Borrowed" && x.MemberID == txMemberID.Text). Select(x => new { x.TransactionID, x.BookID, x.MemberID, x.ReturnDate, x.IssueDate, x.DueDate, x.ExtensionCount, x.LoanStatus, x.Remarks }). ToList(); } else { txSuccess.Text = "Borrowing Limit Reached"; } } else { txSuccess.Text = "Book Currently Unavailable!"; } } else { txSuccess.Text = "Wrong input!"; } } else { txSuccess.Text = "Wrong Input!"; } } }