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 Payment GetPaymentByID(int paymentID)
{
helper.CommandText = "SELECT * FROM Payment WHERE PaymentID = @paymentID";
helper.Parameters.Clear();
helper.Parameters.Add("@paymentID", paymentID);
Payment payment = null;
SqlDataReader reader = helper.GetEntity();
if (reader.HasRows)
{
reader.Read();
payment = MapPayment(reader);
}
reader.Close();
return(payment);
}
public Author GetAuthorByID(int authorID)
{
helper.CommandText = "select * from Authors WHERE AuthorID= @authorID";
helper.Parameters.Clear();
helper.Parameters.Add("@authorID", authorID);
Author author = null;
SqlDataReader reader = helper.GetEntity();
if (reader.HasRows)
{
reader.Read();
author = MapAuthors(reader);
}
reader.Close();
return(author);
}
public Rent GetRentByID(int rentID) //ıd ye göre uye alır
{
helper.CommandText = "SELECT * FROM Rent WHERE RentID = @rentID";
helper.Parameters.Clear();
helper.Parameters.Add("@rentID", rentID);
Rent rent = null;
SqlDataReader reader = helper.GetEntity();
if (reader.HasRows)
{
reader.Read();
rent = MapRent(reader);
}
reader.Close();
return(rent);
}
//List<Members> memberBook =
public Members GetMemberByID(int memberID) //ıd ye göre uye alır
{
helper.CommandText = "SELECT * FROM Members WHERE MemberID = @memberID";
helper.Parameters.Clear();
helper.Parameters.Add("@memberID", memberID);
Members member = null;
SqlDataReader reader = helper.GetEntity();
if (reader.HasRows)
{
reader.Read();
member = MapMember(reader);
}
reader.Close();
return(member);
}
public Publisher GetPublisherByID(int publisherID) //ıd ye göre publisher alır
{
helper.CommandText = "SELECT * FROM Publishers WHERE PublisherID = @publisherID";
helper.Parameters.Clear();
helper.Parameters.Add("@publisherID", publisherID);
Publisher publisher = null;
SqlDataReader reader = helper.GetEntity();
if (reader.HasRows)
{
reader.Read();
publisher = MapPublisher(reader);
}
reader.Close();
return(publisher);
}
public Book GetBookByID(int bookID)
{
helper.CommandText = "SELECT * FROM Books WHERE BookID = @bookID";
helper.Parameters.Clear();
helper.Parameters.Add("@bookID", bookID);
Book book = null;
SqlDataReader reader = helper.GetEntity();
if (reader.HasRows)
{
reader.Read();
book = MapBook(reader);
}
reader.Close();
return(book);
}
public Admin GetAdminByID(int AdminID) //ıd ye göre admin alır
{
helper.CommandText = "SELECT * FROM Admins WHERE AdminID = @adminID";
helper.Parameters.Clear();
helper.Parameters.Add("@adminID", AdminID);
Admin admin = null;
SqlDataReader reader = helper.GetEntity();
if (reader.HasRows)
{
reader.Read();
admin = MapAdmin(reader);
}
reader.Close();
return(admin);
}