Add/Delete culture data

[abircan]

Add/Delete culture data

[aliramadan8]

Hi , i found it much faster to do it from DB side so i created a stored procedure and i just call it from my code ,my procedure below add new culture to the site , simply copying all existing word in new language ,but no translation

Create procedure  [dbo].[usp_syCreateSiteCulture] 
(
@NewCulture nvarchar(15) -- new culture to be used ex 'ar-eg'

)
As
Begin


INSERT INTO [dbo].[tblLocalizationRecords]
           ([ResourceId]
           ,[ResourceKey]
           ,[Value]
           ,[LocalizationCulture]
           ,[UpdatedTimestamp]
           ,[FriendlyName])

  	SELECT Distinct  
       [ResourceId]
      ,[ResourceKey]
      ,[Value]
      ,@NewCulture
      ,GetDate()
      ,[FriendlyName]
  FROM [dbo].[tblLocalizationRecords] Orgi
  Where LocalizationCulture = 'en-US'

  and NOT EXISTS (Select * from tblLocalizationRecords tb
          where  tb.[ResourceId] = orgi.[ResourceId]
		    and  tb.[ResourceKey] = orgi.ResourceKey
			and  [LocalizationCulture] = @NewCulture )
End

[abircan]

Thank you @damienbod

I used StringExtendedLocalizerFactory in my solution.

 var defaultLang = stringExtendedLocalizerFactory.GetLocalizationData(DateTime.MinValue, "tr-tr", $"Create for {Lang.Name} translation") as List<LocalizationRecord>;
            List<LocalizationRecord> newRecords = new List<LocalizationRecord>();
            foreach (var item in defaultLang)
            {
                LocalizationRecord r = new LocalizationRecord
                {
                    Key = item.Key,
                    LocalizationCulture = Lang.Code,
                    ResourceKey = item.ResourceKey,
                    Text = item.Key
                };
                newRecords.Add(r);
            }
            stringExtendedLocalizerFactory.AddNewLocalizationData(newRecords, "Copy from default language");
  stringExtendedLocalizerFactory.ResetCache(); 

[abircan]

@borahanarslan şu an production da ASP .NET Core 3.1 projesi ile kullanıyorum.

I am using AspNetCoreLocalization with ASP .NET Core 3.1 project.

[abircan]

Hello @damienbod , are you still developing this project?

[damienbod]

Sorry for the slow answer, busy at the day job

Hi @abircan yes, you could just use EF Core with a new context, or use the existing to create your queries to delete, add in anyway you want.

Greetings Damien

[borahanarslan]

Thank you @damienbod

I used StringExtendedLocalizerFactory in my solution.

 var defaultLang = stringExtendedLocalizerFactory.GetLocalizationData(DateTime.MinValue, "tr-tr", $"Create for {Lang.Name} translation") as List<LocalizationRecord>;
            List<LocalizationRecord> newRecords = new List<LocalizationRecord>();
            foreach (var item in defaultLang)
            {
                LocalizationRecord r = new LocalizationRecord
                {
                    Key = item.Key,
                    LocalizationCulture = Lang.Code,
                    ResourceKey = item.ResourceKey,
                    Text = item.Key
                };
                newRecords.Add(r);
            }
            stringExtendedLocalizerFactory.AddNewLocalizationData(newRecords, "Copy from default language");
  stringExtendedLocalizerFactory.ResetCache(); 

Hocam 3.1 sürümünde denedinizmi çalışıyormu ?