public PermissionAttachmentInfo(IPermissible permissible, string permission, PermissionAttachment attachment, bool value)
{
this.Permissible = permissible;
this.Permission = permission;
this.Attachment = attachment;
this.Value = value;
}
// FileId is used for legacy attachments
public PermissionAttachment Get(int attachmentId, int fileId, bool withSecurity)
{
PermissionAttachment result = null;
using (IDataReader dr = SqlHelper.ExecuteReader(connectionString, dbPrefix + "Attachments_Get", attachmentId, fileId, withSecurity))
{
if (dr.Read())
{
result = FillAttachment(dr);
}
dr.Close();
}
return(result);
}
private static PermissionAttachment FillAttachment(IDataRecord dr)
{
var result = new PermissionAttachment
{
AttachmentId = Utilities.SafeConvertInt(dr["AttachId"]),
UserId = Utilities.SafeConvertInt(dr["UserId"], -1),
FileName = Utilities.SafeConvertString(dr["FileName"]),
ContentType = Utilities.SafeConvertString(dr["ContentType"]),
FileSize = Utilities.SafeConvertLong(dr["FileSize"]),
FileId = dr["FileId"] as int?,
AllowDownload = Utilities.SafeConvertBool(dr["AllowDownload"], true)
};
if (dr.HasColumn("FileData"))
{
result.FileData = dr["FileData"] as byte[];
}
if (dr.HasColumn("CanRead"))
{
result.CanRead = Utilities.SafeConvertString(dr["CanRead"], "0;1;-3;-1;|||"); // Default to public read permissions
}
return(result);
}
private static PermissionAttachment FillAttachment(IDataRecord dr)
{
var result = new PermissionAttachment
{
AttachmentId = Utilities.SafeConvertInt(dr["AttachId"]),
UserId = Utilities.SafeConvertInt(dr["UserId"], -1),
FileName = Utilities.SafeConvertString(dr["FileName"]),
ContentType = Utilities.SafeConvertString(dr["ContentType"]),
FileSize = Utilities.SafeConvertLong(dr["FileSize"]),
FileId = dr["FileId"] as int?,
AllowDownload = Utilities.SafeConvertBool(dr["AllowDownload"], true)
};
if (dr.HasColumn("FileData"))
result.FileData = dr["FileData"] as byte[];
if (dr.HasColumn("CanRead"))
result.CanRead = Utilities.SafeConvertString(dr["CanRead"], "0;1;-3;-1;|||"); // Default to public read permissions
return result;
}
