static List <string> GetFileToProcess()
{
using (OiAContextcs context = new OiAContextcs())
{
var files = context.PendingFile.Where(x => x.Status == ProcessStatus.New).Select(x => x.FileFullName).ToList();
return(files);
}
}
static void SaveToDb(IEnumerable <PendingFile> files)
{
using (OiAContextcs context = new OiAContextcs())
{
context.PendingFile.AddRange(files);
context.SaveChanges();
}
}
static void SaveToDb(string file, string message)
{
using (OiAContextcs context = new OiAContextcs())
{
context.PendingFile.Single(x => x.FileFullName == file).Status = ProcessStatus.Error + message;
context.SaveChanges();
}
}
static void SaveToDb(IEnumerable <FileDetail> files)
{
using (OiAContextcs context = new OiAContextcs())
{
var fileDetails = files.ToList();
foreach (var file in fileDetails)
{
context.PendingFile.Single(x => x.FileFullName == file.FullName).Status = ProcessStatus.Complete;
}
context.FileSystem.AddRange(fileDetails);
context.SaveChanges();
}
}
