protected override void ValidateRequest()
{
// If IP retricted in appsettings
if (_forbiddenPortal)
{
isValid = false;
_redirectUrl = $"/error/403";
}
base.ValidateRequest();
// If this site has not been inited yet
if (MixService.GetConfig <bool>("IsInit"))
{
isValid = false;
if (string.IsNullOrEmpty(MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION)))
{
_redirectUrl = $"Init";
}
else
{
var status = MixService.GetConfig <string>("InitStatus");
_redirectUrl = $"/init/step{status}";
}
}
}
public async System.Threading.Tasks.Task <IActionResult> Alias(string culture,
string alias, int pageIndex, int pageSize = 10)
{
string seoName = Request.Query["alias"];
seoName = seoName ?? alias;
if (_forbidden)
{
return(Redirect($"/error/403"));
}
if (MixService.GetConfig <bool>("IsMaintenance"))
{
return(await PageAsync("maintenance"));
}
if (MixService.GetConfig <bool>("IsInit"))
{
//Go to landing page
return(await AliasAsync(seoName));
}
else
{
if (string.IsNullOrEmpty(MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION)))
{
return(Redirect("Init"));
}
else
{
return(Redirect($"/init/step2"));
}
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
string cnn = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
if (!string.IsNullOrEmpty(cnn))
{
var provider = System.Enum.Parse <MixEnums.DatabaseProvider>(MixService.GetConfig <string>(MixConstants.CONST_SETTING_DATABASE_PROVIDER));
switch (provider)
{
case MixEnums.DatabaseProvider.MSSQL:
optionsBuilder.UseSqlServer(cnn);
break;
case MixEnums.DatabaseProvider.MySQL:
optionsBuilder.UseMySql(cnn);
break;
case MixEnums.DatabaseProvider.PostgreSQL:
optionsBuilder.UseNpgsql(cnn);
break;
default:
break;
}
}
}
public async System.Threading.Tasks.Task <IActionResult> Index()
{
if (_forbidden)
{
return(Redirect($"/error/403"));
}
if (MixService.GetConfig <bool>("IsMaintenance"))
{
return(Redirect($"/{_culture}/maintenance"));
}
if (MixService.GetConfig <bool>("IsInit"))
{
//Go to landing page
return(Redirect($"/{_culture}"));
}
else
{
if (string.IsNullOrEmpty(MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION)))
{
return(Redirect("Init"));
}
else
{
return(Redirect($"/init/step2"));
}
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
//optionsBuilder.EnableSensitiveDataLogging(true);
//define the database to use
string cnn = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
if (!string.IsNullOrEmpty(cnn))
{
var provider = MixService.GetEnumConfig <MixDatabaseProvider>(MixConstants.CONST_SETTING_DATABASE_PROVIDER);
switch (provider)
{
case MixDatabaseProvider.MSSQL:
optionsBuilder.UseSqlServer(cnn);
break;
case MixDatabaseProvider.MySQL:
optionsBuilder.UseMySql(cnn, ServerVersion.AutoDetect(cnn));
break;
case MixDatabaseProvider.SQLITE:
optionsBuilder.UseSqlite(cnn);
break;
case MixDatabaseProvider.PostgreSQL:
optionsBuilder.UseNpgsql(cnn);
break;
default:
break;
}
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
V_0 = MixService.GetConnectionString("MixCmsConnection");
if (!string.IsNullOrEmpty(V_0))
{
switch (Enum.Parse <MixEnums.DatabaseProvider>(MixService.GetConfig <string>("DatabaseProvider")))
{
case 0:
{
dummyVar0 = SqlServerDbContextOptionsExtensions.UseSqlServer(optionsBuilder, V_0, null);
return;
}
case 1:
{
dummyVar1 = MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, V_0, null);
return;
}
case 2:
{
dummyVar2 = NpgsqlDbContextOptionsExtensions.UseNpgsql(optionsBuilder, V_0, null);
break;
}
default:
{
return;
}
}
}
return;
}
/*** Methods ***/
public IDbConnection CreateConnection()
{
var provider = MixService.GetEnumConfig <MixDatabaseProvider>(MixConstants.CONST_SETTING_DATABASE_PROVIDER);
var connectionType = GetDbConnectionType(provider);
var connection = Activator.CreateInstance(connectionType) as IDbConnection;
string cnn = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
connection.ConnectionString = cnn;
return(connection);
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
//define the database to use
//string cnn = "Data Source=mix-messenger.db";
//optionsBuilder.UseSqlite(cnn);
;
// IConfiguration configuration = new ConfigurationBuilder()
//.SetBasePath(System.IO.Directory.GetCurrentDirectory())
//.AddJsonFile(Common.Utility.Const.CONST_FILE_APPSETTING)
//.Build();
// //optionsBuilder.UseSqlServer(cnn);
// string cnn = configuration.GetConnectionString("MixMessengerConnection");
// if (string.IsNullOrEmpty(cnn))
// {
// cnn = _cnn;
// }
// //define the database to use
// if (!string.IsNullOrEmpty(cnn))
// {
// optionsBuilder.UseSqlServer(cnn);
// }
string cnn = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
if (!string.IsNullOrEmpty(cnn))
{
var provider = MixService.GetEnumConfig <MixDatabaseProvider>(MixConstants.CONST_SETTING_DATABASE_PROVIDER);
switch (provider)
{
case MixDatabaseProvider.MSSQL:
optionsBuilder.UseSqlServer(cnn);
break;
case MixDatabaseProvider.MySQL:
optionsBuilder.UseMySql(cnn, ServerVersion.AutoDetect(cnn));
break;
case MixDatabaseProvider.SQLITE:
optionsBuilder.UseSqlite(cnn);
break;
case MixDatabaseProvider.PostgreSQL:
optionsBuilder.UseNpgsql(cnn);
break;
default:
break;
}
}
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
string cnn = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
if (!string.IsNullOrEmpty(cnn))
{
if (MixService.GetConfig <bool>("IsSqlite"))
{
optionsBuilder.UseSqlite(cnn);
}
else
{
optionsBuilder.UseSqlServer(cnn);
}
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
string cnn = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
if (!string.IsNullOrEmpty(cnn))
{
if (MixService.GetConfig <int>(MixConstants.CONST_SETTING_DATABASE_PROVIDER) == (int)MixEnums.DatabaseProvider.MySQL)
{
optionsBuilder.UseMySql(cnn);
}
else
{
optionsBuilder.UseSqlServer(cnn);
}
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.get_IsConfigured())
{
V_0 = MixService.GetConnectionString("MixCmsConnection");
if (!string.IsNullOrEmpty(V_0))
{
if (MixService.GetConfig <bool>("IsMysql"))
{
dummyVar0 = MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, V_0, null);
return;
}
dummyVar1 = SqlServerDbContextOptionsExtensions.UseSqlServer(optionsBuilder, V_0, null);
}
}
return;
}
protected override void ValidateRequest()
{
base.ValidateRequest();
// If this site has not been inited yet
if (MixService.GetAppSetting <bool>(MixAppSettingKeywords.IsInit))
{
isValid = false;
if (string.IsNullOrEmpty(MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION)))
{
_redirectUrl = $"Init";
}
else
{
var status = MixService.GetAppSetting <string>("InitStatus");
_redirectUrl = $"/init/step{status}";
}
}
}
public async System.Threading.Tasks.Task <IActionResult> Index(string culture, string seoName)
{
if (MixService.GetConfig <bool>("IsInit"))
{
//Go to landing page
return(await PageAsync(seoName));
}
else
{
if (string.IsNullOrEmpty(MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION)))
{
return(Redirect("Init"));
}
else
{
return(Redirect($"/init/step2"));
}
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
//define the database to use
//string cnn = "Data Source=mix-messenger.db";
//optionsBuilder.UseSqlite(cnn);
;
// IConfiguration configuration = new ConfigurationBuilder()
//.SetBasePath(System.IO.Directory.GetCurrentDirectory())
//.AddJsonFile(Common.Utility.Const.CONST_FILE_APPSETTING)
//.Build();
// //optionsBuilder.UseSqlServer(cnn);
// string cnn = configuration.GetConnectionString("MixMessengerConnection");
// if (string.IsNullOrEmpty(cnn))
// {
// cnn = _cnn;
// }
// //define the database to use
// if (!string.IsNullOrEmpty(cnn))
// {
// optionsBuilder.UseSqlServer(cnn);
// }
string cnn = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
if (!string.IsNullOrEmpty(cnn))
{
if (MixService.GetConfig <int>(MixConstants.CONST_SETTING_DATABASE_PROVIDER) == (int)MixEnums.DatabaseProvider.MySQL)
{
optionsBuilder.UseMySql(cnn);
}
else
{
optionsBuilder.UseSqlServer(cnn);
}
}
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
if (!optionsBuilder.IsConfigured)
{
//define the database to use
//string cnn = "Data Source=mix-messenger.db";
//string cnn = "Server=(localdb)\\mssqllocaldb;Database=mix-cms.db;Trusted_Connection=True;MultipleActiveResultSets=true";
//optionsBuilder.UseSqlite(cnn);
//define the database to use
string cnn = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
if (!string.IsNullOrEmpty(cnn))
{
if (MixService.GetConfig <bool>("IsMysql"))
{
optionsBuilder.UseMySql(cnn);
}
else
{
optionsBuilder.UseSqlServer(cnn);
}
}
}
}
public AttributeDataViewModel(MixAttributeSetData model, MixCmsContext _context = null, IDbContextTransaction _transaction = null) : base(model, _context, _transaction)
{
CacheConnectionString = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
}
public AttributeDataViewModel() : base()
{
CacheConnectionString = MixService.GetConnectionString(MixConstants.CONST_CMS_CONNECTION);
}
