public static List <Member> ListMembers()
{
members_dbEntities dbContext = new members_dbEntities();
var members = from m in dbContext.Members select m;
return(members.ToList());
}
public static bool Insert(Member member)
{
try
{
members_dbEntities dbContext = new members_dbEntities();
dbContext.Members.Add(member);
dbContext.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public static List <BorrowedBy> SearchBorrowedBooks(int memberId)
{
library_dbEntities dbContextBorrowed = new library_dbEntities();
members_dbEntities memberDbContext = new members_dbEntities();
var memberIds = (from m in memberDbContext.Members
where m.MemberId == memberId
select m).ToArray();
var borrowedMemberIds = (from m in dbContextBorrowed.BorrowedBies
select m).ToArray();
var books = (from bm in borrowedMemberIds where bm.returned == 0
join m in memberIds
on bm.MemberId equals m.MemberId
select bm);
return(books.ToList());
}
public static Member FindMember(int memberId)
{
members_dbEntities dbContext = new members_dbEntities();
return((from m in dbContext.Members where m.MemberId == memberId select m).Single());
}
