public bool ThisOrAnyChildMatchesFilter(string filter)
{
return(
(MatchesFilter(filter)) ||
(HelpCategories.Any(hc => hc.ThisOrAnyChildMatchesFilter(filter)))
);
}
public List <HelpCategories> Get()
{
List <HelpCategories> list = new List <HelpCategories>();
DataProvider.ExecuteCmd("dbo.HelpCategories_SelectAll"
, inputParamMapper : null
, singleRecordMapper : delegate(IDataReader reader, short set)
{
HelpCategories singleItem = Mapper(reader);
list.Add(singleItem);
});
return(list);
}
private HelpCategories Mapper(IDataReader reader)
{
HelpCategories singleItem = new HelpCategories();
int index = 0;
singleItem.Id = reader.GetSafeInt32(index++);
singleItem.Name = reader.GetSafeString(index++);
singleItem.UrlPath = reader.GetSafeString(index++);
singleItem.CreatedDate = reader.GetSafeDateTime(index++);
singleItem.ModifiedDate = reader.GetSafeDateTime(index++);
singleItem.ModifiedBy = reader.GetSafeString(index++);
return(singleItem);
}
public HelpCategories Get(int id)
{
HelpCategories singleItem = null;
DataProvider.ExecuteCmd("dbo.HelpCategories_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
singleItem = Mapper(reader);
});
return(singleItem);
}
public List <HelpCategories> GetCategories()
{
List <HelpCategories> list = new List <HelpCategories>();
DataProvider.ExecuteCmd("dbo.HelpCategories_GetCategories"
, inputParamMapper : null
, singleRecordMapper : delegate(IDataReader reader, short set)
{
HelpCategories singleItem = new HelpCategories();
int index = 0;
singleItem.Id = reader.GetSafeInt32(index++);
singleItem.Name = reader.GetSafeString(index++);
singleItem.UrlPath = reader.GetSafeString(index++);
list.Add(singleItem);
});
return(list);
}