// GET Select Page by Id
public Domain.CMSPage GetPageById(int pagesId)
{
Domain.CMSPage p = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CMSPages_SelectById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", pagesId);
}, map : delegate(IDataReader reader, short set)
{
if (set == 0)
{
p = new CMSPage();
int startingIndex = 0;
p.Id = reader.GetSafeInt32(startingIndex++);
p.PageName = reader.GetSafeString(startingIndex++);
p.PageDescription = reader.GetSafeString(startingIndex++);
p.PageTemplate = reader.GetSafeInt32(startingIndex++);
p.PageIsActive = reader.GetSafeBool(startingIndex++);
}
});
return(p);
}
// GET List the Pages Index
public List <Domain.CMSPage> List()
{
List <Domain.CMSPage> returnList = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CMSPages_List"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
}, map : delegate(IDataReader reader, short set)
{
Domain.CMSPage p = new Domain.CMSPage();
int startingIndex = 0;
p.Id = reader.GetSafeInt32(startingIndex++);
p.PageName = reader.GetSafeString(startingIndex++);
p.PageDescription = reader.GetSafeString(startingIndex++);
p.PageTemplate = reader.GetSafeInt32(startingIndex++);
p.PageIsActive = reader.GetSafeBool(startingIndex++);
if (returnList == null)
{
returnList = new List <Domain.CMSPage>();
}
returnList.Add(p);
});
return(returnList);
}
