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(); } }