private void Libextendbook_Load(object sender, EventArgs e) { context = new LibrarySevenAEntities(); List <BookTransaction> lbt = new List <BookTransaction>(); try { lbt = context.BookTransactions.Where(x => x.MemberID == memberID).ToList(); if (lbt.Count > 0) { List <object> lbtd = new List <object>(); for (int i = 0; i < lbt.Count; i++) { int temp = Convert.ToInt32(lbt[i].TransactionID.ToString()); var q = from x in context.BookTransDetails where x.TransactionID == temp && x.RentalStatus == false select new { x.TransactionID, x.BookID, x.book.BookTitle, x.DateDue }; if (q.ToList().Count > 0) { object bktd = q.ToList().First(); lbtd.Add(bktd); } } dataGridView1.DataSource = lbtd; this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } } catch (InvalidOperationException) { MessageBox.Show("No previous transaction found!"); } }
private void MainForm_Load(object sender, EventArgs e) { LibrarySevenAEntities context = new LibrarySevenAEntities(); Employee emp = context.Employees.Where(x => x.EmployeeID == temp1.empid).ToList().First(); string str = emp.EmployeeName.ToString(); label1.Text = "Welcome! " + str; }
private void ShowDitailButton_Click(object sender, EventArgs e) { context = new LibrarySevenAEntities(); int TrID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); var q = context.BookTransDetails.Where(x => x.TransactionID == TrID); dataGridView2.DataSource = q.ToList(); dataGridView2.Columns[5].Visible = false; dataGridView2.Columns[6].Visible = false; }
private void ExtendButton_Click(object sender, EventArgs e) { DateTime datedue = Convert.ToDateTime(dataGridView1.CurrentRow.Cells[3].Value.ToString()); int TrID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); int BID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[1].Value.ToString()); context = new LibrarySevenAEntities(); var QBT = context.BookTransactions.Where(x => x.TransactionID == TrID); BookTransaction bk = QBT.First(); if (bk.OriginalDateDue == datedue) { var QBTD = context.BookTransDetails.Where(x => x.TransactionID == TrID && x.BookID == BID); BookTransDetail btd = QBTD.First(); btd.DateDue = datedue.AddDays(21); context.SaveChanges(); //refresh context = new LibrarySevenAEntities(); List <BookTransaction> lbt = new List <BookTransaction>(); lbt = context.BookTransactions.Where(x => x.MemberID == memberID).ToList(); if (lbt.Count > 0) { List <object> lbtd = new List <object>(); for (int i = 0; i < lbt.Count; i++) { int temp = Convert.ToInt32(lbt[i].TransactionID.ToString()); var q = from x in context.BookTransDetails where x.TransactionID == temp && x.RentalStatus == false select new { x.TransactionID, x.BookID, x.book.BookTitle, x.DateDue }; if (q.ToList().Count > 0) { object bktd = q.ToList().First(); lbtd.Add(bktd); } } dataGridView1.DataSource = lbtd; this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } } else { MessageBox.Show("Unable to extend, this book has previously been extended"); } }
private void EditDetailsForm_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; context = new LibrarySevenAEntities(); m = context.Members.Where(x => x.MemberID == A.ID).ToList().First(); ID.Text = m.MemberID.ToString(); Name1.Text = m.MemberName; Type.Text = m.MemberType; Gender.Text = m.Gender; Age.Text = m.Age.ToString(); Address.Text = m.Address; Country.Text = m.Country; Postalcode.Text = m.PostalCode; ContactNum.Text = m.ContactNumber; cBTitle.Text = m.ContactTitle; EmaiAddress.Text = m.EmailAddress; Remark.Text = m.Remarks; }
private void Login_Click(object sender, EventArgs e) { LibrarySevenAEntities context = new LibrarySevenAEntities(); try { var s = Convert.ToInt16(MemberIDTextBox.Text); if (context.Employees.Where(x => x.EmployeeID == s).ToList().Count > 0) { Employee m = context.Employees.Where(x => x.EmployeeID == s).ToList().First(); if (m.EmployeePassword == MemberPasswordTextBox.Text) { temp1.empid = s; MainForm f = new MainForm(); f.Show(); MemberIDTextBox.Text = ""; MemberPasswordTextBox.Text = ""; this.Hide(); } else { lblPasswordError.Text = "Incorrect Password/ User ID"; } } else { MessageBox.Show("User ID is incorrect!"); } } catch (OverflowException) { lblError.Text = "User ID is a 4 digit number"; } catch (FormatException) { lblError.Text = "User ID is numerical"; } }
private void Login_Click(object sender, EventArgs e) { LibrarySevenAEntities context = new LibrarySevenAEntities(); try { var s = Convert.ToInt16(MemberIDTextBox.Text); if (context.Members.Where(x => x.MemberID == s).ToList().Count > 0) { Member m = context.Members.Where(x => x.MemberID == s).ToList().First(); if (m.Password == MemberPasswordTextBox.Text) { A.ID = s; CustomerInterfaceForm CIF = new CustomerInterfaceForm(); CIF.Show(); MemberIDTextBox.Text = ""; MemberPasswordTextBox.Text = ""; } else { lblPasswordError.Text = "Incorrect Password/ User ID"; } } else { MessageBox.Show("UserID is incorrect!"); } } catch (OverflowException) { lblError.Text = "User ID is a 4 digit number"; }catch (FormatException) { lblError.Text = "User ID is numerical"; } }
private void SearchButton_Click(object sender, EventArgs e) { try { context = new LibrarySevenAEntities(); if (TransactionIDTextBox.Text != "") { int j = Convert.ToInt32(TransactionIDTextBox.Text); var q = context.BookTransactions.Where(x => x.TransactionID == j); dataGridView1.DataSource = q.ToList(); dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[5].Visible = false; this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } else { if (BookIDTextBox.Text == "") { if (MemberIDTextBox.Text == "") { var q = context.BookTransactions; dataGridView1.DataSource = q.ToList(); dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[5].Visible = false; this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } else if (MemberIDTextBox.Text != "") { short j = Convert.ToInt16(MemberIDTextBox.Text); var q = context.BookTransactions.Where(x => x.MemberID == j); dataGridView1.DataSource = q.ToList(); dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[5].Visible = false; this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } } else { List <BookTransDetail> LBTD = new List <BookTransDetail>(); int w = Convert.ToInt32(BookIDTextBox.Text); LBTD = context.BookTransDetails.Where(x => x.BookID == w).ToList(); if (LBTD.Count > 0) { List <BookTransaction> LBKT = new List <BookTransaction>(); if (MemberIDTextBox.Text == "") { for (int i = 0; i < LBTD.Count; i++) { int temp = Convert.ToInt32(LBTD[i].TransactionID.ToString()); var q = context.BookTransactions.Where(x => x.TransactionID == temp); BookTransaction bkt = q.ToList().First(); LBKT.Add(bkt); } } else { for (int i = 0; i < LBTD.Count; i++) { int temp = Convert.ToInt32(LBTD[i].TransactionID.ToString()); int j = Convert.ToInt16(MemberIDTextBox.Text); var q = context.BookTransactions.Where(x => x.TransactionID == temp && x.MemberID == j); if (q.ToList().Count > 0) { BookTransaction bkt = q.ToList().First(); LBKT.Add(bkt); } } } dataGridView1.DataSource = LBKT; dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[5].Visible = false; this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } } } } catch (Exception ex) { if (ex is FormatException || ex is InvalidOperationException) { lblInputError.Text = "Incorrect Input, please check your search values"; return; } } }