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
};
}
