private void btnLogin_Click(object sender, EventArgs e)
{
SA47_Team10BCADatabaseEntities context = new SA47_Team10BCADatabaseEntities();
if (memberIDTextBox.Text == context.LoginDetails.Select(x => x.Username).First().ToString() && passwordTextBox.Text == context.LoginDetails.Select(x => x.Password).First().ToString())
{
DialogResult = DialogResult.OK;
}
else
{
wrongLoginLabel.Text = "Wrong Member ID / Password";
}
}
private void IssueReturnList_Load(object sender, EventArgs e)
{
SA47_Team10BCADatabaseEntities context = new SA47_Team10BCADatabaseEntities();
dataGridView2.DataSource = context.IssueReturn.Select
(x => new
{
x.TransactionID,
x.MemberID,
x.BookID,
x.DateExpiry,
x.DateIssue,
x.DateReturn,
x.LoanStatus,
x.Remarks
}).ToList();
}
private void BorrowRecordForm_Load(object sender, EventArgs e)
{
context = new SA47_Team10BCADatabaseEntities();
Members member = context.Members.Where(x => x.MemberID == memID).First();
MemberNameLabel.Text = "Borrow Record of " + member.MemberName;
BorrowRecordDataGridView.DataSource = context.IssueReturn.Where(x => x.MemberID == memID)
.Select(x => new
{
x.TransactionID,
x.MemberID,
x.BookID,
x.Book.BookName,
x.DateIssue,
x.DateExpiry,
x.DateReturn,
x.LoanStatus,
x.Remarks
}).ToList();
}
private void Home_Load(object sender, EventArgs e)
{
context = new SA47_Team10BCADatabaseEntities();
dateTimeLabel.Text = DateTime.Now.ToString();
IssuedQtyLabel.Text = context.Books.Sum(x => x.NumberBorrowed).ToString();
}
private void SearchMemberForm_Load(object sender, EventArgs e)
{
context = new SA47_Team10BCADatabaseEntities();
}
private void MemberListForm_Load(object sender, EventArgs e)
{
context = new SA47_Team10BCADatabaseEntities();
MemListDataGridView.DataSource = context.Members.Select(x => new { x.MemberID, x.MemberName, x.PhoneNumber }).ToList();
}
private void BookMaintainList_Load(object sender, EventArgs e)
{
SA47_Team10BCADatabaseEntities context = new SA47_Team10BCADatabaseEntities();
dataGridView1.DataSource = context.Books.ToList();
}