public void Remove(FileInfoEx fileInfoEx) { try { string directoryPath = ConfigurationSettings.AppSettings["FileTransferPath"]; DirectoryInfo directoryInfo; if (!Directory.Exists(directoryPath)) { directoryInfo = Directory.CreateDirectory(directoryPath); } else { directoryInfo = new DirectoryInfo(directoryPath); } string filePath = Path.Combine(directoryInfo.FullName, fileInfoEx.FileNameOnServer); File.Delete(filePath); using (FileTransferContext context = new FileTransferContext()) { FileInfoEx file = context.Files.FirstOrDefault(f => f.FileNameOnServer.Equals(fileInfoEx.FileNameOnServer)); if (file != null) { context.Files.Remove(file); context.SaveChanges(); } } } catch (Exception e) { Console.WriteLine(e); } }
private static void SaveFileInfoToDataBase(FileDataUpload file) { try { FileInfoEx fileInfoEx = new FileInfoEx { FileNameOnServer = file.FileId, OriginalFileName = file.FileName, Author = file.Author, DateUpload = file.DateUpload, Description = file.Description }; using (FileTransferContext context = new FileTransferContext()) { context.Files.Add(fileInfoEx); context.SaveChanges(); } } catch (Exception e) { Console.WriteLine(e); } }
public FileInfoEx[] GetListFiles(FileListType type, string value) { FileInfoEx[] filesEx = null; try { using (FileTransferContext context = new FileTransferContext()) { switch (type) { case FileListType.AllFiles: filesEx = context.Files.ToArray(); break; case FileListType.ByAuthor: filesEx = context.Files.Where(f => f.Author.ToLower().Contains(value.ToLower())).ToArray(); break; case FileListType.ByFileName: filesEx = context.Files.Where(f => f.OriginalFileName.ToLower().Contains(value.ToLower())).ToArray(); break; case FileListType.ByDateUpload: DateTime date = DateTime.Parse(value); filesEx = context.Files.Where(f => EntityFunctions.TruncateTime(f.DateUpload) >= EntityFunctions.TruncateTime(date)).ToArray(); break; } } } catch (Exception e) { Console.WriteLine(e); } return(filesEx); }