public List <MemberBookList> MemberBookList(int memberID)
{
helper.CommandText = @"select b.BookName
from MemberBookList mbl
join Books b
on b.BookID = mbl.BookID
join Members m
on m.MemberID = mbl.MemberID
where mbl.MemberID = @memberID";
helper.Parameters.Clear();
helper.Parameters.Add("@memberID", memberID);
List <MemberBookList> books = new List <MemberBookList>();
MemberBookList bookList = null;
SqlDataReader reader = helper.GetEntity();
while (reader.Read())
{
bookList = MapBook(reader);
books.Add(bookList);
}
reader.Close();
return(books);
}
public int Insert(MemberBookList bookList)
{
helper.CommandText = "insert into MemberBookList (BookID,MemberID) values(@bookID,@memberID)";
helper.Parameters.Clear();
helper.Parameters.Add("@bookID", bookList.BookID);
helper.Parameters.Add("@memberID", bookList.MemberID);
return(helper.ExecuteQuery());
}
public bool AddBookMemberList(MemberBookList bookList)
{
try
{
CheckBookID(bookList.BookID);
}
catch (Exception ex)
{
throw ex;
}
return(_memberBookListDAL.Insert(bookList) > 0);
}
private MemberBookList MapBook(SqlDataReader reader) // book özelliklerini okurken kullanılan metot
{
MemberBookList booklist = new MemberBookList();
//booklist.ListID = (int)reader["ListID"];
//booklist.BookID = (int)reader["BookID"];
//booklist.MemberID = (int)reader["MemberID"];
booklist.book = new Book()
{
BookID = booklist.BookID, BookName = reader["BookName"].ToString()
};
return(booklist);
}
