public List<BookRegisterDTO> GetBookRegisterByStatusAndCreatedDate(BookRegisterStatus status, DateTime createdDate)
{
return _bookRegisterDao.GetByStatusAndCreatedDate(status, createdDate);
}
public List<BookRegisterDTO> GetByStatusAndCreatedDate(BookRegisterStatus status, DateTime createdDate)
{
var listRegister = new List<BookRegisterDTO>();
try
{
SqlDataReader reader = ConnectionManager.GetCommand("SP1001ByStatusAndCreatedDate",
new Dictionary<string, SqlDbType>()
{
{"@Status", SqlDbType.Int},
{"@CreatedDate", SqlDbType.DateTime}
},
new List<object>()
{
(int) status,
createdDate
}).ExecuteReader();
BookRegisterDTO register;
while (reader.Read())
{
register = new BookRegisterDTO();
register.UserId = reader["UserID"].ToString();
register.ISBN = reader["ISBN"].ToString();
register.RegisterDate = (DateTime)reader["RegisterDate"];
register.Note = reader["Note"].ToString();
int statusTmp;
int.TryParse(reader["Status"].ToString(), out statusTmp);
register.Status = (BookRegisterStatus)Enum.Parse(typeof(BookRegisterStatus), status.ToString());
register.CreatedDate = (DateTime)reader["CreatedDate"];
register.UpdatedDate = (DateTime)reader["UpdatedDate"];
listRegister.Add(register);
}
}
catch (Exception e)
{
Log.Logger.Error("Error at BookRegisterDAO - GetByStatusAndCreatedDate", e);
return null;
}
return listRegister;
}