public void DeleteThubmail(int thimbnailId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
thumbnails thumbnail = context.thumbnails.Where(thmb => thmb.id == thimbnailId).FirstOrDefault();
context.thumbnails.Remove(thumbnail);
context.SaveChanges();
}
}
public void AddEncryptKeys(int fileId, byte[] key, byte[] iv)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
thumbnails thumbnail = context.thumbnails.Where(thmb => thmb.fileId == fileId).FirstOrDefault();
thumbnail.key = key;
thumbnail.iv = iv;
context.SaveChanges();
}
}
public void DeleteThumbnailFromDBbyFileId(int fileId)
{
{
using (var context = new IgorMarkivMessengerDBEntities()) {
thumbnails tmbnl = context.thumbnails.Where(tmb => tmb.fileId == fileId).FirstOrDefault();
if (tmbnl != null)
{
context.thumbnails.Remove(tmbnl);
context.SaveChanges();
}
}
}
}
public int SaveThumbnail(int originalFileId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
thumbnails thumbnail = new thumbnails()
{
fileId = originalFileId
};
context.thumbnails.Add(thumbnail);
context.SaveChanges();
return(context.thumbnails.Where(thmb => thmb.fileId == originalFileId).FirstOrDefault().id);
}
}
