public void CheckAndUpdateTextDescriptionToJson()
{
Console.WriteLine("Check and update text descriptions...");
using (var serviceScope = _serviceProvider.GetRequiredService <IServiceScopeFactory>().CreateScope())
{
var scopedCtxMgr = serviceScope.ServiceProvider.GetService <IContextManager>();
var commonService = serviceScope.ServiceProvider.GetService <ICommonService>();
int updatedItemCount = 0;
scopedCtxMgr.ExecuteWriter(unitOfWork =>
{
//Organization description
updatedItemCount = 0;
var organizationDescriptionRep = unitOfWork.CreateRepository <IOrganizationDescriptionRepository>();
organizationDescriptionRep.All().ForEach(entity =>
{
if (!string.IsNullOrEmpty(entity.Description) && !IsValidJson(entity.Description))
{
entity.Description = _textManager.ConvertTextWithLineBreaksToJson(entity.Description);
updatedItemCount++;
}
});
Console.WriteLine($@"Update OrganizationDescription is done. Result updated {updatedItemCount}.");
//Service description
updatedItemCount = 0;
var serviceDescriptionRep = unitOfWork.CreateRepository <IServiceDescriptionRepository>();
serviceDescriptionRep.All().ForEach(entity =>
{
if ((commonService.IsDescriptionEnumType(entity.TypeId, DescriptionTypeEnum.Description.ToString()) || commonService.IsDescriptionEnumType(entity.TypeId, DescriptionTypeEnum.ServiceUserInstruction.ToString())) &&
!string.IsNullOrEmpty(entity.Description) && !IsValidJson(entity.Description))
{
entity.Description = _textManager.ConvertTextWithLineBreaksToJson(entity.Description);
updatedItemCount++;
}
});
Console.WriteLine($@"Update ServiceDescription is done. Result updated {updatedItemCount}.");
//Service requirement
updatedItemCount = 0;
var serviceRequirementRep = unitOfWork.CreateRepository <IServiceRequirementRepository>();
serviceRequirementRep.All().ForEach(entity =>
{
if (!string.IsNullOrEmpty(entity.Requirement) && !IsValidJson(entity.Requirement))
{
entity.Requirement = _textManager.ConvertTextWithLineBreaksToJson(entity.Requirement);
updatedItemCount++;
}
});
Console.WriteLine($@"Update ServiceRequirement is done. Result updated {updatedItemCount}.");
//ServiceChannel description
updatedItemCount = 0;
var serviceChannelDescriptionRep = unitOfWork.CreateRepository <IServiceChannelDescriptionRepository>();
serviceChannelDescriptionRep.All().ForEach(entity =>
{
if (commonService.IsDescriptionEnumType(entity.TypeId, DescriptionTypeEnum.Description.ToString()) && !string.IsNullOrEmpty(entity.Description) && !IsValidJson(entity.Description))
{
entity.Description = _textManager.ConvertTextWithLineBreaksToJson(entity.Description);
updatedItemCount++;
}
});
Console.WriteLine($@"Update ServiceChannelDescription is done. Result updated {updatedItemCount}.");
//Statutory service requirement
updatedItemCount = 0;
var statutoryServiceRequirementRep = unitOfWork.CreateRepository <IStatutoryServiceRequirementRepository>();
statutoryServiceRequirementRep.All().ForEach(entity =>
{
if (!string.IsNullOrEmpty(entity.Requirement) && !IsValidJson(entity.Requirement))
{
entity.Requirement = _textManager.ConvertTextWithLineBreaksToJson(entity.Requirement);
updatedItemCount++;
}
});
Console.WriteLine($@"Update StatutoryServiceRequirement is done. Result updated {updatedItemCount}.");
//Statutory service description
updatedItemCount = 0;
var statutoryServiceDescriptionRep = unitOfWork.CreateRepository <IStatutoryServiceDescriptionRepository>();
statutoryServiceDescriptionRep.All().ForEach(entity =>
{
if ((commonService.IsDescriptionEnumType(entity.TypeId, DescriptionTypeEnum.Description.ToString()) ||
commonService.IsDescriptionEnumType(entity.TypeId, DescriptionTypeEnum.BackgroundDescription.ToString()) ||
commonService.IsDescriptionEnumType(entity.TypeId, DescriptionTypeEnum.ServiceUserInstruction.ToString())) &&
!string.IsNullOrEmpty(entity.Description) && !IsValidJson(entity.Description))
{
entity.Description = _textManager.ConvertTextWithLineBreaksToJson(entity.Description);
updatedItemCount++;
}
});
Console.WriteLine($@"Update StatutoryServiceDescription is done. Result updated {updatedItemCount}.");
unitOfWork.Save(SaveMode.NonTrackedDataMigration);
Console.WriteLine("Done.");
});
}
}