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 DownloadAudioNoteFile(string audioNoteFileName) { voiceNoteTranslationEntities8 database = new voiceNoteTranslationEntities8(); audioNote voiceNote = (from current in database.audioNotes where current.audioFileName == audioNoteFileName select current).First(); FileStream file = File.Open(SERVER_DATA_DIRECTORY + voiceNote.audioFileName, FileMode.Open); return(file); }
public void UploadAudioNoteFile(Stream audioNoteFile) { this.CopyStream(audioNoteFile, SERVER_DATA_DIRECTORY + AudioNote.audioFileName); voiceNoteTranslationEntities8 dataBase = new voiceNoteTranslationEntities8(); audioNote voiceNote = new audioNote(); voiceNote.audioFileName = AudioNote.audioFileName; voiceNote.description = AudioNote.description; language language = (from current in dataBase.languages where current.languageName == AudioNote.audioMainLanguage.languageName select current).First(); voiceNote.idLanguage = language.id; dataBase.audioNotes.Add(voiceNote); dataBase.SaveChanges(); }