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); }