private void Create(CultureInfo culture, string fullTypeName, string name, string translatedText)
{
var sql =
@"INSERT INTO LocalizedTypes (LocaleId, [Key], TypeName, TextName, Value, UpdatedAt, UpdatedBy)
VALUES (@lcid, @TextKey, @TypeName, @TextName, @value, @updat, @updby)";
var key = new TypePromptKey(fullTypeName, name);
using (var cmd = _db.Connection.CreateCommand())
{
cmd.AddParameter("lcid", culture.LCID);
cmd.AddParameter("TextKey", key.ToString());
cmd.AddParameter("TypeName", fullTypeName);
cmd.AddParameter("TextName", name);
cmd.AddParameter("value", translatedText);
cmd.AddParameter("updat", DateTime.Now);
cmd.AddParameter("updby", Thread.CurrentPrincipal.Identity.Name);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}