public GridDataSet GetAttachments(int userID, int pageSize, int pageNumber) { var attachments = YafContext.Current.GetRepository <Attachment>().GetPaged( a => a.UserID == userID, pageIndex: pageNumber, pageSize: pageSize); var attachmentItems = new List <AttachmentItem>(); foreach (var attach in attachments) { var url = attach.FileName.IsImageName() ? "{0}resource.ashx?i={1}&b={2}&editor=true".FormatWith( YafForumInfo.ForumClientFileRoot, attach.ID, YafContext.Current.PageBoardID) : "{0}Images/document.png".FormatWith(YafForumInfo.ForumClientFileRoot); var description = "{0} ({1} kb)".FormatWith(attach.FileName, attach.Bytes / 1024); var iconImage = attach.FileName.IsImageName() ? @"<img class=""popupitemIcon"" src=""{0}"" alt=""{1}"" title=""{1}"" />" .FormatWith(url, description) : "<i class=\"far fa-file-alt attachment-icon\"></i>"; var attachment = new AttachmentItem { FileName = attach.FileName, OnClick = "insertAttachment('{0}', '{1}')".FormatWith(attach.ID, url), IconImage = @"{0}<span>{1}</span>".FormatWith(iconImage, description) }; if (attach.FileName.IsImageName()) { attachment.DataURL = url; } attachmentItems.Add(attachment); } return(new GridDataSet { PageNumber = pageNumber, TotalRecords = attachments.Any() ? YafContext.Current.GetRepository <Attachment>().Count(a => a.UserID == userID) .ToType <int>() : 0, PageSize = pageSize, AttachmentList = attachmentItems }); }
public GridDataSet GetAttachments(int pageSize, int pageNumber) { var attachments = YafContext.Current.GetRepository <Attachment>() .List(userID: YafContext.Current.PageUserID, pageIndex: pageNumber, pageSize: pageSize); var attachmentItems = new List <AttachmentItem>(); foreach (DataRow row in attachments.Rows) { var url = row["FileName"].ToString().IsImageName() ? "{0}resource.ashx?i={1}&b={2}&editor=true".FormatWith( YafForumInfo.ForumClientFileRoot, row["AttachmentID"], YafContext.Current.PageBoardID) : "{0}Images/document.png".FormatWith(YafForumInfo.ForumClientFileRoot); var attachment = new AttachmentItem() { FileName = row["FileName"].ToString(), OnClick = "insertAttachment('{0}', '{1}')".FormatWith( row["AttachmentID"], url), IconImage = @"<img class=""popupitemIcon"" src=""{0}"" alt=""{1}"" title=""{1}"" /><span>{1}</span>" .FormatWith( url, "{0} ({1} kb)".FormatWith( row["FileName"].ToString(), row["Bytes"].ToType <int>() / 1024)) }; if (row["FileName"].ToString().IsImageName()) { attachment.DataURL = url; } attachmentItems.Add(attachment); } return(new GridDataSet { PageNumber = pageNumber, TotalRecords = attachments.HasRows() ? attachments.AsEnumerable().First().Field <int>("TotalRows") : 0, PageSize = pageSize, AttachmentList = attachmentItems }); }
public GridDataSet GetAlbumImages(int userID, int pageSize, int pageNumber) { var albumImages = YafContext.Current.GetRepository <UserAlbumImage>().GetUserAlbumImagesPaged( userId: userID, pageIndex: pageNumber, pageSize: pageSize); var images = new List <AttachmentItem>(); foreach (var image in albumImages) { var url = "{0}resource.ashx?imgprv={1}".FormatWith(YafForumInfo.ForumClientFileRoot, image.ID); var attachment = new AttachmentItem { FileName = image.FileName, OnClick = "setStyle('AlbumImgId', '{0}')".FormatWith(image.ID), IconImage = @"<img class=""popupitemIcon"" src=""{0}"" alt=""{1}"" title=""{1}"" width=""40"" height=""40"" />" .FormatWith( url, image.Caption.IsSet() ? image.Caption : image.FileName), DataURL = url }; images.Add(attachment); } return(new GridDataSet { PageNumber = pageNumber, TotalRecords = albumImages.Any() ? YafContext.Current.GetRepository <UserAlbumImage>() .GetUserAlbumImageCount(userID) : 0, PageSize = pageSize, AttachmentList = images }); }
public GridDataSet GetAttachments(int pageSize, int pageNumber) { var attachments = YafContext.Current.GetRepository<Attachment>() .List(userID: YafContext.Current.PageUserID, pageIndex: pageNumber, pageSize: pageSize); var attachmentItems = new List<AttachmentItem>(); foreach (DataRow row in attachments.Rows) { var url = row["FileName"].ToString().IsImageName() ? "{0}resource.ashx?i={1}&b={2}&editor=true".FormatWith( YafForumInfo.ForumClientFileRoot, row["AttachmentID"], YafContext.Current.PageBoardID) : "{0}Images/document.png".FormatWith(YafForumInfo.ForumClientFileRoot); var attachment = new AttachmentItem() { FileName = row["FileName"].ToString(), OnClick = "insertAttachment('{0}', '{1}')".FormatWith( row["AttachmentID"], url), IconImage = @"<img class=""popupitemIcon"" src=""{0}"" alt=""{1}"" title=""{1}"" /><span>{1}</span>" .FormatWith( url, "{0} ({1} kb)".FormatWith( row["FileName"].ToString(), row["Bytes"].ToType<int>() / 1024)) }; if (row["FileName"].ToString().IsImageName()) { attachment.DataURL = url; } attachmentItems.Add(attachment); } return new GridDataSet { PageNumber = pageNumber, TotalRecords = attachments.HasRows() ? attachments.AsEnumerable().First().Field<int>("TotalRows") : 0, PageSize = pageSize, AttachmentList = attachmentItems }; }