//private void btn_search_Click(object sender, EventArgs e) //{ // lbl_status.Text = ""; // int ID = Convert.ToInt32(txt_IDbook.Text); // string str = "select * from BookTbl where BookID=" + ID; // using (BlogDbContext mc = new BlogDbContext()) // { // var _bookList = mc.Database.SqlQuery<BookTbl>("select * from BookTbl where BookID={0}", ID); // var _bookList = mc.Database.SqlQuery<BookTbl>(str); // if (_bookList != null) // { // dataGridView1.DataSource = _bookList.ToList(); // BookID = ID; // } // else // { // lbl_status.Text = "شناسه کتاب معتبر نیست"; // } // } //} private void btn_borrow_Click_1(object sender, EventArgs e) { using (BlogDbContext mc = new BlogDbContext()) { var _bookList = mc.BookTbls.Where(x => x.ID == this.BookID).FirstOrDefault(); if (_bookList != null) { if (_bookList.Available == false) { _lbl_s.Text = "کتاب در قفسه موجود نیست"; return; } else { _bookList.Available = false; mc.SaveChanges(); using (BlogDbContext le2 = new BlogDbContext()) { BorrowerTbl _borrowList = new BorrowerTbl() { IDBook = BookID, IDMember = UserID, ReciveDate = DateTime.Now, DueDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day).AddDays(20) }; mc.BorrowerTbls.Add(_borrowList); mc.SaveChanges(); } this.Close(); } } } }
private void ReturnBook(int BookID, int ID) { using (BlogDbContext mc = new BlogDbContext()) { BookTbl _BTbl = mc.BookTbls.Where(x => x.ID == BookID).FirstOrDefault(); _BTbl.Available = true; BorrowerTbl _BrwTbl = mc.BorrowerTbls.Where(x => x.ID == ID).FirstOrDefault(); _BrwTbl.ReturnDate = DateTime.Now; mc.SaveChanges(); } }