//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();
}
}
