private void check_in_Click(object sender, EventArgs e) { LMSentities ctx = new LMSentities(); int loanNumber = (int)dataGridView1.CurrentRow.Cells[0].Value; LoanRecord checkedIn = ctx.LoanRecords.Where(x => x.LoanNumber == loanNumber).First(); checkedIn.DateReturned = dateTimePicker1.Value; checkedIn.LoadStatus = "in"; ctx.SaveChanges(); }
private void search_Click(object sender, EventArgs e) { LMSentities ctx = new LMSentities(); string searchfield = textBox2.Text; if (isDigitOnly(searchfield)) { int searchNum = Convert.ToInt32(searchfield); dataGridView1.DataSource = ctx.LoanRecords.Where(x => x.MemberID == searchNum && x.LoadStatus == "out").Select(x => new { x.LoanNumber, x.ISBN, x.Book.Title, x.Book.Author, x.MemberID, x.Member.MumberName, x.LoadStatus }).ToList(); } else { dataGridView1.DataSource = ctx.LoanRecords.Where( x => x.ISBN == searchfield || x.Book.Title == searchfield || x.Book.Author == searchfield || x.Member.MumberName == searchfield ).Select(x => new { x.LoanNumber, x.ISBN, x.Book.Title, x.Book.Author, x.MemberID, x.Member.MumberName, x.LoadStatus }).ToList(); } }
private void Return_Load(object sender, EventArgs e) { LMSentities ctx = new LMSentities(); dataGridView1.DataSource = ctx.LoanRecords.Where(x => x.LoadStatus == "out").Select(x => new { x.LoanNumber, x.ISBN, x.Book.Title, x.Book.Author, x.MemberID, x.Member.MumberName, x.LoadStatus }).ToList(); }