public void UpLoadAudioNoteTranslationFile(Stream audioNoteTranslationFile) { this.CopyStream(audioNoteTranslationFile, SERVER_DATA_DIRECTORY + AudioTranslation.translationFileName); voiceNoteTranslationEntities8 dataBase = new voiceNoteTranslationEntities8(); audioNote audio = (from current in dataBase.audioNotes where current.audioFileName == AudioTranslation.audioId.audioFileName select current).First(); language language = (from current in dataBase.languages where current.languageName == AudioTranslation.languageId.languageName select current).First(); audioTranslation tranlation = new audioTranslation(); tranlation.idAudio = audio.id; tranlation.idLanguage = language.id; tranlation.translationFileName = AudioTranslation.translationFileName; int amount = (from current in dataBase.audioTranslations where current.translationFileName == tranlation.translationFileName select current).Count(); if (amount > 0) { return; } dataBase.audioTranslations.Add(tranlation); dataBase.SaveChanges(); }
public Stream DownloadAudioNoteTranslationFile(string audioNoteTranslationFileName) { voiceNoteTranslationEntities8 database = new voiceNoteTranslationEntities8(); audioTranslation voiceNoteTranslation = (from current in database.audioTranslations where current.translationFileName == audioNoteTranslationFileName select current).First(); FileStream file = File.Open(SERVER_DATA_DIRECTORY + voiceNoteTranslation.translationFileName, FileMode.Open); return(file); }