private void ConvertFromReader(SqlDataReader reader, BookTransferHistoryDataObject obj)
{
obj.BookAggregateRootId = Convert.ToInt64(reader["AggregateRootId"]);
obj.BookID = Guid.Parse(Convert.ToString(reader["ID"]));
obj.Returned = Convert.ToBoolean(reader["Returned"]);
obj.ISBN = Convert.ToString(reader["ISBN"]);
obj.Title = Convert.ToString(reader["Title"]);
obj.ReturnedDate = Convert.ToDateTime(reader["ReturnedDate"]);
obj.BorrowedDate = Convert.ToDateTime(reader["BorrowedDate"]);
}
private List <BookTransferHistoryDataObject> PopulateBookTransferHistory(Guid userID)
{
List <BookTransferHistoryDataObject> objs = new List <BookTransferHistoryDataObject>();
string sql = @"SELECT b.ID AS ID, b.AggregateRootId AS AggregateRootId, b.Title as Title, b.ISBN as ISBN, t.ReturnedDate as ReturnedDate, t.Returned as Returned, t.BorrowedDate as BorrowedDate
FROM Books AS b INNER JOIN
BookTransferHistory AS t ON t.BookID = b.ID
WHERE (t.UserID = @userId)
ORDER BY t.BorrowedDate DESC";
using (SqlDataReader reader = SqlHelper.ExecuteReader(this.QueryDBConnectionString,
CommandType.Text,
sql,
new SqlParameter("@userId", userID)))
{
while (reader.Read())
{
BookTransferHistoryDataObject obj = new BookTransferHistoryDataObject();
this.ConvertFromReader(reader, obj);
objs.Add(obj);
}
reader.Close();
}
return(objs);
}
