// list website by site ID public Domain.Website GetWebsiteBySlug(string slug) { Domain.Website item = null; DataProvider.ExecuteCmd(GetConnection, "dbo.Website_SelectBySlug" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Slug", slug); }, map : delegate(IDataReader reader, short set) { Domain.Website p = new Domain.Website(); int startingIndex = 0; //startingOrdinal p.ID = reader.GetSafeInt32(startingIndex++); p.Name = reader.GetSafeString(startingIndex++); p.Slug = reader.GetSafeString(startingIndex++); p.Url = reader.GetSafeString(startingIndex++); p.Theme = reader.GetSafeString(startingIndex++); p.Description = reader.GetSafeString(startingIndex++); p.Active = reader.GetSafeBool(startingIndex++); item = p; } ); return(item); }
// list website by User ID public List <Domain.Website> GetWebsiteByUserID(string id) { List <Domain.Website> list = null; DataProvider.ExecuteCmd(GetConnection, "dbo.Website_SelectByUserID" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@UserID", id); }, map : delegate(IDataReader reader, short set) { Domain.Website p = new Domain.Website(); int startingIndex = 0; //startingOrdinal p.ID = reader.GetSafeInt32(startingIndex++); p.Name = reader.GetSafeString(startingIndex++); p.Slug = reader.GetSafeString(startingIndex++); p.Url = reader.GetSafeString(startingIndex++); p.Theme = reader.GetSafeString(startingIndex++); p.Description = reader.GetSafeString(startingIndex++); p.Active = reader.GetSafeBool(startingIndex++); if (list == null) { list = new List <Domain.Website>(); } list.Add(p); } ); return(list); }
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); }