public string Get(string key, string culture) { var record = _localizationRecords.FirstOrDefault(c => c.Key == key && c.Culture == culture); if (record == null) { record = new LocalizationRecord { Key = key, Culture = culture, Value = key }; string insertCommand = _configuration.Translator.Parrottranslator.InsertCommand; var parameters = new DynamicParameters(); parameters.Add("@Key", key); parameters.Add("@Culture", culture); parameters.Add("@Value", key); record.Id = _dbConnection.Query <int>(insertCommand, param: parameters, commandType: CommandType.Text).FirstOrDefault(); _localizationRecords.Add(record); } return(record.Value); }
public string Get(string key, string culture) { var record = _localizationRecords.FirstOrDefault(c => c.Key == key && c.Culture == culture); if (record == null) { record = new LocalizationRecord { Key = key, Culture = culture, Value = key }; string insertCommand = "INSERT INTO [dbo].[ParrotTranslations]([Key],[Value],[Culture]) VALUES (@Key,@Value,@Culture) select SCOPE_IDENTITY()"; var parameters = new DynamicParameters(); parameters.Add("@Key", key); parameters.Add("@Culture", culture); parameters.Add("@Value", key); record.Id = _dbConnection.Query <int>(insertCommand, param: parameters, commandType: CommandType.Text).FirstOrDefault(); _localizationRecords.Add(record); } return(record.Value); }