public CustomIssue Get(int id)
{
CustomIssue c = new CustomIssue();
var res = (from i in db.bookissues
join b in db.books
on i.bid equals b.bid
join u in db.users
on i.uid equals u.uid
where i.iis == id
select new { IIS = i.iis,
BNAME = b.bname,
UNAME = u.uname,
ISSUEDATE = i.issuedate,
NOFDAYS = i.noofdays,
EXRETURNDATE = i.expreturndate,
ACTUALDATE = i.actualreturndate,
FINE = i.fine }).SingleOrDefault();
c.iis = res.IIS;
c.bookname = res.BNAME;
c.username = res.UNAME;
c.issuedate = res.ISSUEDATE;
c.noofdays = res.NOFDAYS;
c.expreturndate = res.EXRETURNDATE;
c.actualreturndate = res.ACTUALDATE;
c.fine = res.FINE;
return(c);
}
public IEnumerable <CustomIssue> Get()
{
List <CustomIssue> custom = new List <CustomIssue>();
var res = db.bookissues.ToList();
foreach (var i in res)
{
CustomIssue c = new CustomIssue();
c.iis = i.iis;
c.bookname = i.book.bname;
c.username = i.user.uname;
c.issuedate = i.issuedate;
c.noofdays = i.noofdays;
c.expreturndate = i.expreturndate;
c.actualreturndate = i.actualreturndate;
c.fine = i.fine;
custom.Add(c);
}
return(custom);
}
public void IssueMouseLeftButtonDown(CustomIssue issue)
{
Process.Start(issue.Url);
}
