public CMSPage SelectAllByPath(string path)
{
CMSPage c = null;
List<CMSContentItem> items = null;
CMSContentItem item = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CMSPage_SelectAllByPath"
, inputParamMapper: delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Path", path);
}, map: delegate(IDataReader reader, short set)
{
if (set == 0)
{
c = new CMSPage();
int startingIndex = 0; //startingOrdinal
c.Id = reader.GetSafeInt32(startingIndex++);
c.Name = reader.GetSafeString(startingIndex++);
c.Url = reader.GetSafeString(startingIndex++);
c.PubDate = reader.GetSafeDateTime(startingIndex++);
c.ExpireDate = reader.GetSafeDateTime(startingIndex++);
if (c.ExpireDate == DateTime.MinValue)
{
c.ExpireDate = null;
}
c.Template = reader.GetSafeInt32(startingIndex++);
c.MetaTag = reader.GetSafeString(startingIndex++);
c.MetaDescription = reader.GetSafeString(startingIndex++);
c.Active = reader.GetSafeBool(startingIndex++);
c.IncludeInNavigation = reader.GetSafeBool(startingIndex++);
}
if (set == 1)
{
item = new CMSContentItem();
int startingIndex = 0;
item.PageId = reader.GetSafeInt32(startingIndex++);
item.TemplateId = reader.GetSafeInt32(startingIndex++);
item.Type = reader.GetSafeInt32(startingIndex++);
item.KeyName = reader.GetSafeString(startingIndex++);
item.ContentId = reader.GetSafeInt32(startingIndex++);
item.TemplateKeyId = reader.GetSafeInt32(startingIndex++);
item.Value = reader.GetSafeString(startingIndex++);
if (items == null)
{
items = new List<CMSContentItem>();
}
items.Add(item);
}
if (items != null)
{
c.Content = new List<CMSContentItem>();
c.Content = items;
}
}
);
return c;
}
private static CMSContentItem MapCMSContentItem(IDataReader reader)
{
CMSContentItem c = new CMSContentItem();
int startingIndex = 0;
c.PageId = reader.GetSafeInt32(startingIndex++);
c.TemplateId = reader.GetSafeInt32(startingIndex++);
c.Type = reader.GetSafeInt32(startingIndex++);
c.KeyName = reader.GetSafeString(startingIndex++);
c.ContentId = reader.GetSafeInt32(startingIndex++, null);
c.TemplateKeyId = reader.GetSafeInt32(startingIndex++, null);
c.Value = reader.GetSafeString(startingIndex++);
return c;
}
public List<CMSContentItem> GetContentById(int id)
{
List<CMSContentItem> items = null;
CMSContentItem item = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.CMSContent_SelectById"
, inputParamMapper: delegate (SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}, map: delegate (IDataReader reader, short set)
{
if (set == 0)
{
item = new CMSContentItem();
int startingIndex = 0;
item.PageId = reader.GetSafeInt32(startingIndex++);
item.TemplateId = reader.GetSafeInt32(startingIndex++);
item.Type = reader.GetSafeInt32(startingIndex++);
item.KeyName = reader.GetSafeString(startingIndex++);
item.ContentId = reader.GetSafeInt32(startingIndex++);
item.TemplateKeyId = reader.GetSafeInt32(startingIndex++);
item.Value = reader.GetSafeString(startingIndex++);
if (items == null)
{
items = new List<CMSContentItem>();
}
items.Add(item);
}
}
);
return items;
}
