public async Task <RepositoryResponse <bool> > InitCms(InitCulture culture)
{
RepositoryResponse <bool> result = new RepositoryResponse <bool>();
SioCmsContext context = null;
SioCmsAccountContext accountContext = null;
IDbContextTransaction transaction = null;
IDbContextTransaction accTransaction = null;
bool isSucceed = true;
try
{
if (!string.IsNullOrEmpty(SioService.GetConnectionString(SioConstants.CONST_CMS_CONNECTION)))
{
context = new SioCmsContext();
accountContext = new SioCmsAccountContext();
await context.Database.MigrateAsync();
await accountContext.Database.MigrateAsync();
transaction = context.Database.BeginTransaction();
var countCulture = context.SioCulture.Count();
var isInit = countCulture > 0;
if (!isInit)
{
isSucceed = InitCultures(culture, context, transaction);
isSucceed = isSucceed && InitPositions(context, transaction);
isSucceed = isSucceed && InitThemes(context, transaction);
isSucceed = isSucceed && await InitConfigurationsAsync(culture, context, transaction);
isSucceed = isSucceed && await InitLanguagesAsync(culture, context, transaction);
}
else
{
isSucceed = true;
}
if (isSucceed && context.SioPage.Count() == 0)
{
var cate = new SioPage()
{
Id = 1,
Level = 0,
Title = "Home",
Specificulture = culture.Specificulture,
Template = "Pages/_Home.cshtml",
Type = (int)SioPageType.Home,
CreatedBy = "Admin",
CreatedDateTime = DateTime.UtcNow,
Status = (int)PageStatus.Published
};
context.Entry(cate).State = EntityState.Added;
var alias = new SioUrlAlias()
{
Id = 1,
SourceId = "1",
Type = (int)UrlAliasType.Page,
Specificulture = culture.Specificulture,
CreatedDateTime = DateTime.UtcNow,
Alias = cate.Title.ToLower()
};
context.Entry(alias).State = EntityState.Added;
var createVNHome = await context.SaveChangesAsync().ConfigureAwait(false);
isSucceed = createVNHome > 0;
var cate404 = new SioPage()
{
Id = 2,
Title = "404",
Level = 0,
Specificulture = culture.Specificulture,
Template = "Pages/_404.cshtml",
Type = (int)SioPageType.Article,
CreatedBy = "Admin",
CreatedDateTime = DateTime.UtcNow,
Status = (int)PageStatus.Published
};
var alias404 = new SioUrlAlias()
{
Id = 2,
SourceId = "2",
Type = (int)UrlAliasType.Page,
Specificulture = culture.Specificulture,
CreatedDateTime = DateTime.UtcNow,
Alias = cate404.Title.ToLower()
};
context.Entry(cate404).State = EntityState.Added;
context.Entry(alias404).State = EntityState.Added;
var create404 = await context.SaveChangesAsync().ConfigureAwait(false);
isSucceed = create404 > 0;
}
if (isSucceed)
{
transaction.Commit();
}
else
{
transaction.Rollback();
}
}
result.IsSucceed = isSucceed;
return(result);
}
catch (Exception ex) // TODO: Add more specific exeption types instead of Exception only
{
transaction?.Rollback();
accTransaction?.Rollback();
result.IsSucceed = false;
result.Exception = ex;
return(result);
}
finally
{
context?.Dispose();
accountContext?.Dispose();
}
}
public override async Task <RepositoryResponse <bool> > SaveSubModelsAsync(SioCulture parent, SioCmsContext _context = null, IDbContextTransaction _transaction = null)
{
var result = new RepositoryResponse <bool>()
{
IsSucceed = true
};
if (Id == 0)
{
var getPages = await SioPages.ReadViewModel.Repository.GetModelListByAsync(c => c.Specificulture == SioService.GetConfig <string>(SioConstants.ConfigurationKeyword.DefaultCulture), _context, _transaction);
if (getPages.IsSucceed)
{
foreach (var p in getPages.Data)
{
var page = new SioPage()
{
Specificulture = Specificulture,
Id = p.Id,
Content = p.Content,
CreatedBy = p.CreatedBy,
CreatedDateTime = DateTime.UtcNow,
Layout = p.Layout,
CssClass = p.CssClass,
Excerpt = p.Excerpt,
Icon = p.Icon,
Image = p.Image,
Level = p.Level,
ModifiedBy = p.ModifiedBy,
PageSize = p.PageSize,
Priority = p.Priority,
SeoDescription = p.SeoDescription,
SeoKeywords = p.SeoKeywords,
SeoName = p.SeoName,
SeoTitle = p.SeoTitle,
StaticUrl = p.StaticUrl,
Status = (int)p.Status,
Tags = p.Tags,
Template = p.Template,
Title = p.Title,
Type = (int)p.Type,
};
_context.Entry(page).State = Microsoft.EntityFrameworkCore.EntityState.Added;
}
}
var getConfigurations = await SioConfigurations.ReadMvcViewModel.Repository.GetModelListByAsync(c => c.Specificulture == SioService.GetConfig <string>(SioConstants.ConfigurationKeyword.DefaultCulture), _context, _transaction);
if (getConfigurations.IsSucceed)
{
foreach (var c in getConfigurations.Data)
{
var cnf = new SioConfiguration()
{
Keyword = c.Keyword,
Specificulture = Specificulture,
Category = c.Category,
DataType = (int)c.DataType,
Description = c.Description,
Priority = c.Priority,
Status = (int)c.Status,
Value = c.Value
};
_context.Entry(cnf).State = Microsoft.EntityFrameworkCore.EntityState.Added;
}
}
var getLanguages = await SioLanguages.ReadMvcViewModel.Repository.GetModelListByAsync(c => c.Specificulture == SioService.GetConfig <string>(SioConstants.ConfigurationKeyword.DefaultCulture), _context, _transaction);
if (getLanguages.IsSucceed)
{
foreach (var c in getLanguages.Data)
{
var cnf = new SioLanguage()
{
Keyword = c.Keyword,
Specificulture = Specificulture,
Category = c.Category,
DataType = (int)c.DataType,
Description = c.Description,
Priority = c.Priority,
Status = (int)c.Status,
DefaultValue = c.DefaultValue
};
_context.Entry(cnf).State = Microsoft.EntityFrameworkCore.EntityState.Added;
}
}
_context.SaveChanges();
}
return(result);
}
