protected string MappingID(string id, bool saveIfNotExist = false)
{
if (id == null)
{
return(null);
}
string result;
if (id.StartsWith(Id))
{
result = Regex.Replace(BitConverter.ToString(Hasher.Hash(id.ToString(), HashAlg.MD5)), "-", "").ToLower();
}
else
{
result = FilesDbContext.ThirdpartyIdMapping
.Where(r => r.HashId == id)
.Select(r => r.Id)
.FirstOrDefault();
}
if (saveIfNotExist)
{
var newMapping = new DbFilesThirdpartyIdMapping
{
Id = id,
HashId = result,
TenantId = TenantID
};
FilesDbContext.ThirdpartyIdMapping.Add(newMapping);
FilesDbContext.SaveChanges();
}
return(result);
}
private void DeleteTagsBeforeSave()
{
var mustBeDeleted =
Query(FilesDbContext.Tag)
.Join(FilesDbContext.TagLink, r => r.Id, l => l.TagId, (tag, link) => new TagLinkData {
Tag = tag, Link = link
})
.Where(r => r.Link.TenantId == r.Tag.TenantId)
.Where(r => (r.Tag.Flag == TagType.New || r.Tag.Flag == TagType.Recent) && r.Link.CreateOn <= TenantUtil.DateTimeNow().AddMonths(-1))
.ToList();
foreach (var row in mustBeDeleted)
{
var linksToRemove = Query(FilesDbContext.TagLink)
.Where(r => r.TagId == row.Link.TagId)
.Where(r => r.EntryId == row.Link.EntryId)
.Where(r => r.EntryType == row.Link.EntryType)
.ToList();
FilesDbContext.TagLink.RemoveRange(linksToRemove);
}
FilesDbContext.SaveChanges();
var tagsToRemove = from ft in FilesDbContext.Tag
join ftl in FilesDbContext.TagLink.DefaultIfEmpty() on new { TenantId = ft.TenantId, Id = ft.Id } equals new { TenantId = ftl.TenantId, Id = ftl.TagId }
where ftl == null
select ft;
FilesDbContext.Tag.RemoveRange(tagsToRemove.ToList());
FilesDbContext.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Expires = -1;
HttpPostedFile file = Request.Files["uploaded"];
ZipFile zipFile = ZipFile.Read(file.InputStream);
StringBuilder zipContent = new StringBuilder();
foreach (var zipEntry in zipFile.Entries)
{
MemoryStream memoryStream = new MemoryStream();
zipEntry.Extract(memoryStream);
memoryStream.Position = 0;
StreamReader reader = new StreamReader(memoryStream);
zipContent.AppendLine(reader.ReadToEnd());
}
using (FilesDbContext db = new FilesDbContext())
{
db.Files.Add(new Models.File()
{
Content = zipContent.ToString()
});
db.SaveChanges();
}
Response.ContentType = "application/json";
Response.Write("{}");
}
public void DeleteAllLink(string fileId)
{
var link = FilesDbContext.FilesLink.Where(r => r.TenantId == TenantID && (r.SourceId == fileId || r.LinkedId == fileId));
FilesDbContext.FilesLink.RemoveRange(link);
FilesDbContext.SaveChanges();
}
private void RemoveTagInDb(Tag tag)
{
if (tag == null)
{
return;
}
var id = Query(FilesDbContext.Tag)
.Where(r => r.Name == tag.TagName)
.Where(r => r.Owner == tag.Owner)
.Where(r => r.Flag == tag.TagType)
.Select(r => r.Id)
.FirstOrDefault();
if (id != 0)
{
var toDelete = Query(FilesDbContext.TagLink)
.Where(r => r.TagId == id)
.Where(r => r.EntryId == MappingID(tag.EntryId).ToString())
.Where(r => r.EntryType == tag.EntryType);
FilesDbContext.TagLink.RemoveRange(toDelete);
FilesDbContext.SaveChanges();
var count = Query(FilesDbContext.TagLink).Where(r => r.TagId == id).Count();
if (count == 0)
{
var tagToDelete = Query(FilesDbContext.Tag).Where(r => r.Id == id);
FilesDbContext.Tag.RemoveRange(tagToDelete);
FilesDbContext.SaveChanges();
}
}
}
private void DeleteTagsBeforeSave()
{
var mustBeDeleted =
Query(FilesDbContext.Tag)
.Join(FilesDbContext.TagLink, r => r.Id, l => l.TagId, (tag, link) => new TagLinkData {
Tag = tag, Link = link
})
.Where(r => r.Link.TenantId == r.Tag.TenantId)
.Where(r => r.Tag.Flag == TagType.New && r.Link.CreateOn <= TenantUtil.DateTimeNow().AddMonths(-1));
foreach (var row in mustBeDeleted)
{
var linksToRemove = Query(FilesDbContext.TagLink)
.Where(r => r.TagId == row.Link.TagId)
.Where(r => r.EntryId == row.Link.EntryId)
.Where(r => r.EntryType == row.Link.EntryType);
FilesDbContext.TagLink.RemoveRange(linksToRemove);
}
FilesDbContext.SaveChanges();
var tagsToRemove = Query(FilesDbContext.Tag)
.Where(r => !Query(FilesDbContext.TagLink).Where(a => a.TagId == r.Id).Any());
FilesDbContext.Tag.RemoveRange(tagsToRemove);
FilesDbContext.SaveChanges();
}
public void DeleteFile(string fileId)
{
var boxFile = GetBoxFile(fileId);
if (boxFile == null)
{
return;
}
var id = MakeId(boxFile.Id);
using (var tx = FilesDbContext.Database.BeginTransaction())
{
var hashIDs = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => r.Id.StartsWith(id))
.Select(r => r.HashId)
.ToList();
var link = Query(FilesDbContext.TagLink)
.Where(r => hashIDs.Any(h => h == r.EntryId))
.ToList();
FilesDbContext.TagLink.RemoveRange(link);
FilesDbContext.SaveChanges();
var tagsToRemove = from ft in FilesDbContext.Tag
join ftl in FilesDbContext.TagLink.DefaultIfEmpty() on new { TenantId = ft.TenantId, Id = ft.Id } equals new { TenantId = ftl.TenantId, Id = ftl.TagId }
where ftl == null
select ft;
FilesDbContext.Tag.RemoveRange(tagsToRemove.ToList());
var securityToDelete = Query(FilesDbContext.Security)
.Where(r => hashIDs.Any(h => h == r.EntryId));
FilesDbContext.Security.RemoveRange(securityToDelete);
FilesDbContext.SaveChanges();
var mappingToDelete = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => hashIDs.Any(h => h == r.HashId));
FilesDbContext.ThirdpartyIdMapping.RemoveRange(mappingToDelete);
FilesDbContext.SaveChanges();
tx.Commit();
}
if (!(boxFile is ErrorFile))
{
ProviderInfo.Storage.DeleteItem(boxFile);
}
ProviderInfo.CacheReset(boxFile.Id, true);
var parentFolderId = GetParentFolderId(boxFile);
if (parentFolderId != null)
{
ProviderInfo.CacheReset(parentFolderId);
}
}
protected void UpdatePathInDB(string oldValue, string newValue)
{
if (oldValue.Equals(newValue))
{
return;
}
using (var tx = FilesDbContext.Database.BeginTransaction())
{
var oldIDs = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => r.Id.StartsWith(oldValue))
.Select(r => r.Id)
.ToList();
foreach (var oldID in oldIDs)
{
var oldHashID = MappingID(oldID);
var newID = oldID.Replace(oldValue, newValue);
var newHashID = MappingID(newID);
var mappingForUpdate = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => r.HashId == oldHashID)
.ToList();
foreach (var m in mappingForUpdate)
{
m.Id = newID;
m.HashId = newHashID;
}
FilesDbContext.SaveChanges();
var securityForUpdate = Query(FilesDbContext.Security)
.Where(r => r.EntryId == oldHashID)
.ToList();
foreach (var s in securityForUpdate)
{
s.EntryId = newHashID;
}
FilesDbContext.SaveChanges();
var linkForUpdate = Query(FilesDbContext.TagLink)
.Where(r => r.EntryId == oldHashID)
.ToList();
foreach (var l in linkForUpdate)
{
l.EntryId = newHashID;
}
FilesDbContext.SaveChanges();
}
tx.Commit();
}
}
public void DeleteFile(string fileId)
{
var onedriveFile = GetOneDriveItem(fileId);
if (onedriveFile == null)
{
return;
}
var id = MakeId(onedriveFile.Id);
using (var tx = FilesDbContext.Database.BeginTransaction())
{
var hashIDs = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => r.Id.StartsWith(id))
.Select(r => r.HashId)
.ToList();
var link = Query(FilesDbContext.TagLink)
.Where(r => hashIDs.Any(h => h == r.EntryId))
.ToList();
FilesDbContext.TagLink.RemoveRange(link);
FilesDbContext.SaveChanges();
var tagsToRemove = Query(FilesDbContext.Tag)
.Where(r => !Query(FilesDbContext.TagLink).Where(a => a.TagId == r.Id).Any());
FilesDbContext.Tag.RemoveRange(tagsToRemove);
var securityToDelete = Query(FilesDbContext.Security)
.Where(r => hashIDs.Any(h => h == r.EntryId));
FilesDbContext.Security.RemoveRange(securityToDelete);
FilesDbContext.SaveChanges();
var mappingToDelete = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => hashIDs.Any(h => h == r.HashId));
FilesDbContext.ThirdpartyIdMapping.RemoveRange(mappingToDelete);
FilesDbContext.SaveChanges();
tx.Commit();
}
if (!(onedriveFile is ErrorItem))
{
ProviderInfo.Storage.DeleteItem(onedriveFile);
}
ProviderInfo.CacheReset(onedriveFile.Id);
var parentFolderId = GetParentFolderId(onedriveFile);
if (parentFolderId != null)
{
ProviderInfo.CacheReset(parentFolderId);
}
}
public void DeleteLink(string sourceId)
{
var link = FilesDbContext.FilesLink
.Where(r => r.TenantId == TenantID && r.SourceId == sourceId && r.LinkedFor == AuthContext.CurrentAccount.ID)
.SingleOrDefault();
FilesDbContext.FilesLink.Remove(link);
FilesDbContext.SaveChanges();
}
public ActionResult Create(Files files)
{
// holding key/value pairs
var v = Request.Params;
if (ModelState.IsValid)
{
var fileExtensions = new[] { ".jpg", ".png", "jpeg" };
var checkextension = Path.GetExtension(files.UploadFile.FileName);
//Select files less than 10ΜB
if (!fileExtensions.Contains(checkextension))
{
TempData["WarningExtension"] = "Select jpg, png or jpeg only";
return(RedirectToAction("Create", "Files"));
}
//file upload up to 10MB
if (files.UploadFile != null && (files.UploadFile.ContentLength > 0 && (files.UploadFile.ContentLength <= (1024 * 1024 * 10)))) //Size = 10 MB
{
//Using MemoryStream to Serialize
using (var mem = new MemoryStream())
{
//reads the bytes from the current stream and writes them to another stream
files.UploadFile.InputStream.CopyTo(mem);
//returns the array of unsigned bytes from the created memory stream
content = mem.GetBuffer();
//returns an array that contains substrings
fileExtension = files.UploadFile.FileName.Split(new[] { '.' }).Last();
//gets the uploaded file name
file = Path.GetFileName(files.UploadFile.FileName);
//gets the image from the specified data stream
Image imageTest = Image.FromStream(mem);
FilesWidth = imageTest.Width.ToString();
FilesHeight = imageTest.Height.ToString();
FilesSize = files.UploadFile.ContentLength / 1024;
}
}
//data binding
var datBind = new Files()
{
Content = content,
FilesExtension = fileExtension,
FilesName = file,
FilesWidth = FilesWidth,
FilesHeight = FilesHeight,
FileSize = FilesSize,
};
//passing new Files object to db
db.Files.Add(datBind);
//saves changes to db
db.SaveChanges();
}
TempData["Success"] = "File uploaded";
return(RedirectToAction("Create", "Files"));
}
public void DeleteToken(string app, Guid?userId = null)
{
var apps = FilesDbContext.ThirdpartyApp
.Where(r => r.TenantId == TenantManager.GetCurrentTenant().TenantId)
.Where(r => r.UserId == (userId ?? AuthContext.CurrentAccount.ID))
.Where(r => r.App == app);
FilesDbContext.RemoveRange(apps);
FilesDbContext.SaveChanges();
}
public void AddLink(string sourceId, string linkedId)
{
FilesDbContext.AddOrUpdate(r => r.FilesLink, new DbFilesLink()
{
TenantId = TenantID,
SourceId = sourceId,
LinkedId = linkedId,
LinkedFor = AuthContext.CurrentAccount.ID
});
FilesDbContext.SaveChanges();
}
public void DeleteFolder(string folderId)
{
var dropboxFolder = GetDropboxFolder(folderId);
var id = MakeId(dropboxFolder);
using (var tx = FilesDbContext.Database.BeginTransaction())
{
var hashIDs = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => r.Id.StartsWith(id))
.Select(r => r.HashId)
.ToList();
var link = Query(FilesDbContext.TagLink)
.Where(r => hashIDs.Any(h => h == r.EntryId))
.ToList();
FilesDbContext.TagLink.RemoveRange(link);
FilesDbContext.SaveChanges();
var tagsToRemove = Query(FilesDbContext.Tag)
.Where(r => !Query(FilesDbContext.TagLink).Where(a => a.TagId == r.Id).Any());
FilesDbContext.Tag.RemoveRange(tagsToRemove);
var securityToDelete = Query(FilesDbContext.Security)
.Where(r => hashIDs.Any(h => h == r.EntryId));
FilesDbContext.Security.RemoveRange(securityToDelete);
FilesDbContext.SaveChanges();
var mappingToDelete = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => hashIDs.Any(h => h == r.HashId));
FilesDbContext.ThirdpartyIdMapping.RemoveRange(mappingToDelete);
FilesDbContext.SaveChanges();
tx.Commit();
}
if (!(dropboxFolder is ErrorFolder))
{
ProviderInfo.Storage.DeleteItem(dropboxFolder);
}
ProviderInfo.CacheReset(MakeDropboxPath(dropboxFolder), true);
var parentFolderPath = GetParentFolderPath(dropboxFolder);
if (parentFolderPath != null)
{
ProviderInfo.CacheReset(parentFolderPath);
}
}
public void SaveToken(Token token)
{
var dbFilesThirdpartyApp = new DbFilesThirdpartyApp
{
App = token.App,
Token = EncryptToken(token),
UserId = AuthContext.CurrentAccount.ID,
TenantId = TenantManager.GetCurrentTenant().TenantId
};
FilesDbContext.AddOrUpdate(r => r.ThirdpartyApp, dbFilesThirdpartyApp);
FilesDbContext.SaveChanges();
}
private Tag SaveTag(Tag t, Dictionary <string, int> cacheTagId, DateTime createOn)
{
var cacheTagIdKey = string.Join("/", new[] { TenantID.ToString(), t.Owner.ToString(), t.TagName, ((int)t.TagType).ToString(CultureInfo.InvariantCulture) });
if (!cacheTagId.TryGetValue(cacheTagIdKey, out var id))
{
id = FilesDbContext.Tag
.Where(r => r.Owner == t.Owner)
.Where(r => r.Name == t.TagName)
.Where(r => r.Flag == t.TagType)
.Select(r => r.Id)
.FirstOrDefault();
if (id == 0)
{
var toAdd = new DbFilesTag
{
Id = 0,
Name = t.TagName,
Owner = t.Owner,
Flag = t.TagType,
TenantId = TenantID
};
toAdd = FilesDbContext.Tag.Add(toAdd).Entity;
FilesDbContext.SaveChanges();
id = toAdd.Id;
}
cacheTagId.Add(cacheTagIdKey, id);
}
t.Id = id;
var linkToInsert = new DbFilesTagLink
{
TenantId = TenantID,
TagId = id,
EntryId = MappingID(t.EntryId, true).ToString(),
EntryType = t.EntryType,
CreateBy = AuthContext.CurrentAccount.ID,
CreateOn = createOn,
TagCount = t.Count
};
FilesDbContext.AddOrUpdate(r => r.TagLink, linkToInsert);
FilesDbContext.SaveChanges();
return(t);
}
public void RemoveSubject(Guid subject)
{
using var tr = FilesDbContext.Database.BeginTransaction();
var toDelete1 = FilesDbContext.Security.Where(r => r.Subject == subject);
var toDelete2 = FilesDbContext.Security.Where(r => r.Owner == subject);
FilesDbContext.RemoveRange(toDelete1);
FilesDbContext.SaveChanges();
FilesDbContext.RemoveRange(toDelete2);
FilesDbContext.SaveChanges();
tr.Commit();
}
public void DeleteFolder(string folderId)
{
var folder = GetFolderById(folderId);
var id = MakeId(folder);
using (var tx = FilesDbContext.Database.BeginTransaction())
{
var hashIDs = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => r.Id.StartsWith(id))
.Select(r => r.HashId)
.ToList();
var link = Query(FilesDbContext.TagLink)
.Where(r => hashIDs.Any(h => h == r.EntryId))
.ToList();
FilesDbContext.TagLink.RemoveRange(link);
FilesDbContext.SaveChanges();
var tagsToRemove = from ft in FilesDbContext.Tag
join ftl in FilesDbContext.TagLink.DefaultIfEmpty() on new { TenantId = ft.TenantId, Id = ft.Id } equals new { TenantId = ftl.TenantId, Id = ftl.TagId }
where ftl == null
select ft;
FilesDbContext.Tag.RemoveRange(tagsToRemove.ToList());
var securityToDelete = Query(FilesDbContext.Security)
.Where(r => hashIDs.Any(h => h == r.EntryId));
FilesDbContext.Security.RemoveRange(securityToDelete);
FilesDbContext.SaveChanges();
var mappingToDelete = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => hashIDs.Any(h => h == r.HashId));
FilesDbContext.ThirdpartyIdMapping.RemoveRange(mappingToDelete);
FilesDbContext.SaveChanges();
tx.Commit();
}
if (!(folder is ErrorEntry))
{
ProviderInfo.Storage.DeleteFileSystemEntry(folder);
}
}
public virtual int UpdateProviderInfo(int linkId, AuthData authData)
{
var forUpdate = FilesDbContext.ThirdpartyAccount
.Where(r => r.Id == linkId)
.Where(r => r.TenantId == TenantID)
.ToList();
foreach (var f in forUpdate)
{
f.UserName = authData.Login ?? "";
f.Password = EncryptPassword(authData.Password);
f.Token = EncryptPassword(authData.Token ?? "");
f.Url = authData.Url ?? "";
}
FilesDbContext.SaveChanges();
return(forUpdate.Count == 1 ? linkId : default);
private void UpdateNewTagsInDb(Tag tag, DateTime createOn)
{
if (tag == null) return;
var forUpdate = Query(FilesDbContext.TagLink)
.Where(r => r.TagId == tag.Id)
.Where(r => r.EntryType == tag.EntryType)
.Where(r => r.EntryId == MappingID(tag.EntryId).ToString());
foreach (var f in forUpdate)
{
f.CreateBy = AuthContext.CurrentAccount.ID;
f.CreateOn = createOn;
f.TagCount = tag.Count;
}
FilesDbContext.SaveChanges();
}
public void DeleteFolder(string folderId)
{
var folder = GetFolderById(folderId);
var id = MakeId(folder);
using (var tx = FilesDbContext.Database.BeginTransaction())
{
var hashIDs = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => r.Id.StartsWith(id))
.Select(r => r.HashId)
.ToList();
var link = Query(FilesDbContext.TagLink)
.Where(r => hashIDs.Any(h => h == r.EntryId))
.ToList();
FilesDbContext.TagLink.RemoveRange(link);
FilesDbContext.SaveChanges();
var tagsToRemove = Query(FilesDbContext.Tag)
.Where(r => !Query(FilesDbContext.TagLink).Where(a => a.TagId == r.Id).Any());
FilesDbContext.Tag.RemoveRange(tagsToRemove);
var securityToDelete = Query(FilesDbContext.Security)
.Where(r => hashIDs.Any(h => h == r.EntryId));
FilesDbContext.Security.RemoveRange(securityToDelete);
FilesDbContext.SaveChanges();
var mappingToDelete = Query(FilesDbContext.ThirdpartyIdMapping)
.Where(r => hashIDs.Any(h => h == r.HashId));
FilesDbContext.ThirdpartyIdMapping.RemoveRange(mappingToDelete);
FilesDbContext.SaveChanges();
tx.Commit();
}
if (!(folder is ErrorEntry))
{
ProviderInfo.Storage.DeleteFileSystemEntry(folder);
}
}
protected void UploadButton_Click(object sender, EventArgs e)
{
var db = new FilesDbContext();
foreach (UploadedFile file in this.RadAsyncUpload.UploadedFiles)
{
if (!file.FileName.EndsWith(".zip"))
{
continue;
}
using (var zipFile = ZipFile.Read(file.InputStream))
{
foreach (var zipContent in zipFile)
{
if (!zipContent.FileName.EndsWith(".txt"))
{
continue;
}
using (var stream = new MemoryStream())
{
zipContent.Extract(stream);
stream.Position = 0;
var reader = new StreamReader(stream);
var txt = reader.ReadToEnd();
db.TextFiles.Add(new TextFile()
{
Name = zipContent.FileName,
Content = txt
});
db.SaveChanges();
}
}
}
}
}
protected void GetRecalculateFilesCountUpdate(object folderId)
{
var folders = FilesDbContext.Folders
.Where(r => r.TenantId == TenantID)
.Where(r => FilesDbContext.Tree.Where(r => r.FolderId.ToString() == folderId.ToString()).Select(r => r.ParentId).Any(a => a == r.Id))
.ToList();
foreach (var f in folders)
{
var filesCount =
FilesDbContext.Files
.Join(FilesDbContext.Tree, a => a.FolderId, b => b.FolderId, (file, tree) => new { file, tree })
.Where(r => r.file.TenantId == f.TenantId)
.Where(r => r.tree.ParentId == f.Id)
.Count();
f.FilesCount = filesCount;
}
FilesDbContext.SaveChanges();
}
public void Save()
{
db.SaveChanges();
}
public void SetShare(FileShareRecord r)
{
if (r.Share == FileShare.None)
{
var entryId = (MappingID(r.EntryId) ?? "").ToString();
if (string.IsNullOrEmpty(entryId))
{
return;
}
using (var tx = FilesDbContext.Database.BeginTransaction())
{
var files = new List <string>();
if (r.EntryType == FileEntryType.Folder)
{
var folders = new List <string>();
if (int.TryParse(entryId, out var intEntryId))
{
var foldersInt = FilesDbContext.Tree
.Where(r => r.ParentId.ToString() == entryId)
.Select(r => r.FolderId)
.ToList();
folders.AddRange(foldersInt.Select(folderInt => folderInt.ToString()));
files.AddRange(Query(FilesDbContext.Files).Where(r => foldersInt.Any(a => a == r.FolderId)).Select(r => r.Id.ToString()));
}
else
{
folders.Add(entryId);
}
var toDelete = FilesDbContext.Security
.Where(a => a.TenantId == r.Tenant)
.Where(a => folders.Any(b => b == a.EntryId))
.Where(a => a.EntryType == FileEntryType.Folder)
.Where(a => a.Subject == r.Subject);
FilesDbContext.Security.RemoveRange(toDelete);
FilesDbContext.SaveChanges();
}
else
{
files.Add(entryId);
}
if (0 < files.Count)
{
var toDelete = FilesDbContext.Security
.Where(a => a.TenantId == r.Tenant)
.Where(a => files.Any(b => b == a.EntryId))
.Where(a => a.EntryType == FileEntryType.File)
.Where(a => a.Subject == r.Subject);
FilesDbContext.Security.RemoveRange(toDelete);
FilesDbContext.SaveChanges();
}
tx.Commit();
}
}
else
{
var toInsert = new DbFilesSecurity
{
TenantId = r.Tenant,
EntryId = MappingID(r.EntryId, true).ToString(),
EntryType = r.EntryType,
Subject = r.Subject,
Owner = r.Owner,
Security = r.Share,
TimeStamp = DateTime.UtcNow
};
FilesDbContext.AddOrUpdate(r => r.Security, toInsert);
FilesDbContext.SaveChanges();
}
}