public FileInstance RetrieveFileInstance(FileInfo fileInfo)
{
using (var ctx = new FreeSpaceContext())
{
return(ctx.FileInstances.FirstOrDefault(f => f.FilePath == fileInfo.DirectoryName && f.FileName == fileInfo.Name && !f.IsHistory));
}
}
public FileThumbPrint RetrieveFileThumbPrint(int Id)
{
using (var ctx = new FreeSpaceContext())
{
return(ctx.FileThumbPrints.Find(Id));
}
}
public List <FileInstance> RetrieveAllInstancesWithThumbPrint(int Id)
{
using (var ctx = new FreeSpaceContext())
{
return((from f in ctx.FileInstances where f.FileThumbPrintId == Id && !f.IsHistory select f).ToList());
}
}
public FileThumbPrint RetrieveFileThumbPrint(string md5, long fileSize)
{
using (var ctx = new FreeSpaceContext())
{
return(ctx.FileThumbPrints.FirstOrDefault(tp => tp.MD5 == md5 && tp.FileSize == fileSize && !tp.IsHistory));
}
}
public FileThumbPrint UpdateFileThumbPrint(FileThumbPrint thumbPrint)
{
using (var ctx = new FreeSpaceContext())
{
thumbPrint.UpdatedStamp = DateTime.Now;
ctx.FileThumbPrints.Attach(thumbPrint);
ctx.SaveChanges();
return(thumbPrint);
}
}
public FileInstance UpdateFileInstance(FileInstance instance)
{
using (var ctx = new FreeSpaceContext())
{
instance.UpdatedStamp = DateTime.Now;
ctx.FileInstances.Attach(instance);
ctx.SaveChanges();
return(instance);
}
}
public void CreateScanException(Exception ex, ScanExceptionType exType, string shortDesc, string fullPath)
{
using (var ctx = new FreeSpaceContext())
{
var instance = new ScanException
{
CreatedStamp = DateTime.Now,
ExceptionType = (int)exType,
Path = fullPath,
ShortDesc = shortDesc,
Source = ex.Source,
HResult = ex.HResult,
Message = ex.Message,
StackTrace = ex.StackTrace,
ExceptionName = ex.GetType().ToString()
};
var fnf = ex as FileNotFoundException;
if (fnf != null)
{
instance.InnerExceptionMessage = fnf.InnerException?.Message;
instance.ExceptionName = fnf.GetType().ToString();
}
var dnf = ex as DirectoryNotFoundException;
if (dnf != null)
{
instance.InnerExceptionMessage = dnf.InnerException?.Message;
instance.ExceptionName = dnf.GetType().ToString();
}
var ptl = ex as PathTooLongException;
if (ptl != null)
{
instance.InnerExceptionMessage = ptl.InnerException?.Message;
instance.ExceptionName = ptl.GetType().ToString();
}
var ua = ex as UnauthorizedAccessException;
if (ua != null)
{
instance.InnerExceptionMessage = ua.InnerException?.Message;
instance.ExceptionName = ua.GetType().ToString();
}
var ioe = ex as IOException;
if (ioe != null)
{
instance.InnerExceptionMessage = ioe.InnerException?.Message;
instance.ExceptionName = ioe.GetType().ToString();
}
ctx.ScanExceptions.Add(instance);
ctx.SaveChanges();
}
}
public bool SoftDeleteFileThumbPrint(int Id)
{
var list = RetrieveAllInstancesWithThumbPrint(Id);
if (list.Count == 1)
{
using (var ctx = new FreeSpaceContext())
{
var tp = ctx.FileThumbPrints.Find(Id);
tp.IsHistory = true;
tp.UpdatedStamp = DateTime.Now;
ctx.FileThumbPrints.Attach(tp);
ctx.SaveChanges();
return(true);
}
}
return(false);
}
