public override PropLogCollection GetPropLogs(int userID, PropLogType type, int pageNumber, int pageSize)
{
using (SqlQuery query = new SqlQuery())
{
query.Pager.TableName = "bx_PropLogs";
query.Pager.SortField = "PropLogID";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
query.Pager.SelectCount = true;
query.Pager.Condition = "UserID = @UserID";
query.CreateParameter <int>("@UserID", userID, SqlDbType.Int);
if (type != PropLogType.All)
{
query.CreateParameter <PropLogType>("@Type", type, SqlDbType.TinyInt);
query.Pager.Condition += " AND Type = @Type";
}
using (XSqlDataReader reader = query.ExecuteReader())
{
PropLogCollection result = new PropLogCollection(reader);
if (reader.NextResult() && reader.Read())
{
result.TotalRecords = reader.Get <int>(0);
}
return(result);
}
}
}
public override PropLogCollection GetPropLogs(int userID, PropLogType type, int pageNumber, int pageSize)
{
using(SqlQuery query = new SqlQuery())
{
query.Pager.TableName = "bx_PropLogs";
query.Pager.SortField = "PropLogID";
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = pageSize;
query.Pager.SelectCount = true;
query.Pager.Condition = "UserID = @UserID";
query.CreateParameter<int>("@UserID", userID, SqlDbType.Int);
if(type != PropLogType.All)
{
query.CreateParameter<PropLogType>("@Type", type, SqlDbType.TinyInt);
query.Pager.Condition += " AND Type = @Type";
}
using (XSqlDataReader reader = query.ExecuteReader())
{
PropLogCollection result = new PropLogCollection(reader);
if(reader.NextResult() && reader.Read())
result.TotalRecords = reader.Get<int>(0);
return result;
}
}
}
