public object fill()
{
var queryFill = from i in obj_bookDAL.Get_book()
select new
{
isbn = i.b_isbn,
title = i.b_title,
moalef = i.b_moalef,
chap = i.b_print,
grooh = i.b_group,
page = i.b_page,
mojood = i.b_total
};
return(queryFill.ToList());
}
public object fillAmanat()
{
var queryFill = from i in obj_amanat.Get_Amanat()
where i.am_resid = false
join j in obj_member.get_member() on i.am_member_code equals j.m_code
join k in obj_book.Get_book() on i.am_book_isbn equals k.b_isbn
select new
{
codeAmanat = i.am_id,
codOzviat = i.am_member_code,
name = j.m_fname,
lastName = j.m_lname,
bookIsbn = k.b_isbn,
titleBook = k.b_title,
dateGiveBook = i.am_start,
dateBackBook = i.am_end
};
return(queryFill.ToList());
}