public CommentController() { //this.commentRepository = commentRepository; //this.stringRepository = stringRepository; var connectionString = Settings.GetStringDB(); commentRepository = new CommentRepository(connectionString); stringRepository = new TranslationSubstringRepository(connectionString); ur = new UserRepository(connectionString); }
public TranslationWriter(string localDefault) { _localDefault = localDefault; var connectionString = Settings.GetStringDB(); translationRep = new TranslationRepository(connectionString); localeRep = new LocaleRepository(connectionString); ts = new TranslationSubstringRepository(connectionString); }
public ReadWriteFileController() { string connectionString = Settings.GetStringDB(); _localizationProjectRepository = new LocalizationProjectRepository(connectionString); _localeRepository = new LocaleRepository(connectionString); _translationRepository = new TranslationRepository(connectionString); _translationSubstringRepository = new TranslationSubstringRepository(connectionString); _IXmlNodeExtensions = new IXmlNodeExtensions(connectionString); _glossaryRepository = new GlossaryRepository(connectionString); _partOfSpeechRepository = new PartOfSpeechRepository(connectionString); }
public void Initialize(Guid id) { var connectionString = Settings.GetStringDB(); //TOD нужно передавать глассарий //memoryId = Guid.Parse("47faa0d8-56da-4e09-b151-ded06b587338"); memoryId = id; gsr = new TranslationMemoryRepository(connectionString); IEnumerable <TranslationMemory> gList = gsr.GetForEditAsync(memoryId).Result; List <TranslationMemory> tt = gList.ToList(); memory = tt[0]; //TODO нужно обработать создание нового глоссария, если текущего нет glossaryRep = new GlossaryRepository(connectionString); tWriter = new TranslationWriter(_localDefault); ts = new TranslationSubstringRepository(connectionString); }
public async Task <Guid?> AddNewTermAsync(Guid glossaryId, TranslationSubstring newTerm, Guid?partOfSpeechId) { var glossary = await this.GetByIDAsync(id : glossaryId); newTerm.id_file_owner = glossary.ID_File; newTerm.word_count = TranslationSubstringRepository.GetWordsCount(newTerm.substring_to_translate); try { using (var dbConnection = new NpgsqlConnection(connectionString)) { var insertNewStingSql = "INSERT INTO translation_substrings " + "(" + "substring_to_translate, " + "description, " + "context_file, " + "translation_max_length, " + "id_file_owner, " + "value, " + "position_in_text, " + "word_count" + ") VALUES " + "(" + "@substring_to_translate, " + "@description, " + "@context_file, " + "@translation_max_length, " + "@id_file_owner, " + "@value, " + "@position_in_text, " + "@word_count" + ") " + "RETURNING id"; var insertNewStingParam = newTerm; this.LogQuery(insertNewStingSql, newTerm.GetType(), insertNewStingParam); var idOfNewTerm = await dbConnection .ExecuteScalarAsync <Guid>( sql : insertNewStingSql, param : insertNewStingParam); var instertGlossaryStringAssotiationSql = "INSERT INTO glossaries_strings (id_glossary, id_string,id_part_of_speech) VALUES (@glossary_id, @string_id, @parts_of_speechId)"; var instertGlossaryStringAssotiationParam = new { glossary_id = glossaryId, string_id = idOfNewTerm, parts_of_speechId = partOfSpeechId }; this.LogQuery(instertGlossaryStringAssotiationSql, instertGlossaryStringAssotiationParam); await dbConnection .ExecuteAsync( sql : instertGlossaryStringAssotiationSql, param : instertGlossaryStringAssotiationParam); return(idOfNewTerm); } } catch (NpgsqlException exception) { this._loggerError.WriteLn( $"Ошибка в {nameof(GlossaryRepository)}.{nameof(GlossaryRepository.AddNewTermAsync)} {nameof(NpgsqlException)} ", exception); return(null); } catch (Exception exception) { this._loggerError.WriteLn( $"Ошибка в {nameof(GlossaryRepository)}.{nameof(GlossaryRepository.AddNewTermAsync)} {nameof(Exception)} ", exception); return(null); } }
public FilesRepository(string connectionStr) : base(connectionStr) { _action = new UserActionRepository(connectionStr); _tsr = new TranslationSubstringRepository(connectionStr); }