public List <Domain.Blog> ListBlogsByWebsiteId(PaginateListRequestModel model, int websiteId)
{
List <Domain.Blog> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.WebsiteBlogs_ListBlogsByWebsiteId"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@CurrentPage", model.CurrentPage);
paramCollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage);
paramCollection.AddWithValue("@websiteId", websiteId);
}
, map : delegate(IDataReader reader, short set)
{
Domain.Website w = new Domain.Website();
Domain.Blog p = new Domain.Blog();
Domain.BlogMedia bm = new Domain.BlogMedia();
int startingIndex = 0;
w.ID = reader.GetSafeInt32(startingIndex++);
p.Id = reader.GetSafeInt32(startingIndex++);
p.Title = reader.GetSafeString(startingIndex++);
p.PublishDate = reader.GetSafeDateTime(startingIndex++);
p.Slug = reader.GetSafeString(startingIndex++);
p.UserId = reader.GetSafeString(startingIndex++);
p.PageContent = reader.GetSafeString(startingIndex++);
p.IsFeatured = reader.GetSafeBool(startingIndex++);
bm.BlogId = reader.GetSafeInt32(startingIndex++);
bm.IsCoverPhoto = reader.GetSafeBool(startingIndex++);
bm.ID = reader.GetSafeInt32(startingIndex++);
bm.MediaType = reader.GetSafeString(startingIndex++);
bm.Path = reader.GetSafeString(startingIndex++);
bm.FileName = reader.GetSafeString(startingIndex++);
bm.FileType = reader.GetSafeString(startingIndex++);
bm.Title = reader.GetSafeString(startingIndex++);
bm.Description = reader.GetSafeString(startingIndex++);
bm.CreatedDate = reader.GetSafeDateTime(startingIndex++);
bm.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
bm.ThumbnailPath = reader.GetSafeString(startingIndex++);
p.Media = bm;
if (list == null)
{
list = new List <Domain.Blog>();
}
list.Add(p);
});
return(list);
}
public List <Domain.Blog> GetBlogsLatestToOldest(PaginateListRequestModel model)
{
List <Domain.Blog> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Blog_Listingstwo"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@CurrentPage", model.CurrentPage);
paramCollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage);
}
, map : delegate(IDataReader reader, short set)
{
Domain.Blog p = new Domain.Blog();
Domain.BlogMedia bm = new Domain.BlogMedia();
int startingIndex = 0;
p.Id = reader.GetSafeInt32(startingIndex++);
p.Title = reader.GetSafeString(startingIndex++);
p.PublishDate = reader.GetSafeDateTime(startingIndex++);
p.UserId = reader.GetSafeString(startingIndex++);
p.PageContent = reader.GetSafeString(startingIndex++);
p.Slug = reader.GetSafeString(startingIndex++);
bm.BlogId = reader.GetSafeInt32(startingIndex++);
bm.IsCoverPhoto = reader.GetSafeBool(startingIndex++);
bm.ID = reader.GetSafeInt32(startingIndex++);
bm.MediaType = reader.GetSafeString(startingIndex++);
bm.Path = reader.GetSafeString(startingIndex++);
bm.FileName = reader.GetSafeString(startingIndex++);
bm.FileType = reader.GetSafeString(startingIndex++);
bm.Title = reader.GetSafeString(startingIndex++);
bm.Description = reader.GetSafeString(startingIndex++);
if (list == null)
{
list = new List <Domain.Blog>();
}
if (bm.ID == 0)
{
p.Media = null;
}
else
{
p.Media = bm;
}
list.Add(p);
});
return(list);
}
public List <Domain.BlogMedia> BlogsMediaList(int BlogId)
{
List <Domain.BlogMedia> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.BlogsMedia_ListById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", BlogId);
}
, map : delegate(IDataReader reader, short set)
{
Domain.BlogMedia p = new Domain.BlogMedia();
int startingIndex = 0;
p.BlogId = reader.GetSafeInt32(startingIndex++);
p.IsCoverPhoto = reader.GetSafeBool(startingIndex++);
p.MediaType = reader.GetSafeString(startingIndex++);
p.Path = reader.GetSafeString(startingIndex++);
p.FileName = reader.GetSafeString(startingIndex++);
p.FileType = reader.GetSafeString(startingIndex++);
p.Title = reader.GetSafeString(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.UserID = reader.GetSafeString(startingIndex++);
p.CreatedDate = reader.GetSafeDateTime(startingIndex++);
p.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
p.ID = reader.GetSafeInt32(startingIndex++);
if (list == null)
{
list = new List <Domain.BlogMedia>();
}
list.Add(p);
});
return(list);
}