public FileStorageSystem(DataBaseSettings DdtaBaseSettings, IStorageIO fileIO, ISerializationFactory sf, IPecanLogger logger)
{
this.Logger = logger;
this.DataBaseSettings = DdtaBaseSettings;
this._fileIO = fileIO;
this.SerializationFactory = sf;
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="executable">Выполняемое.</param>
/// <param name="coreBaseResourceErrors">Ядро. Основа. Ресурсы. Ошибки.</param>
/// <param name="resourceSuccesses">Ресурсы успехов.</param>
/// <param name="resourceErrors">Ресурсы ошибок.</param>
/// <param name="dataBaseSettings">Настройки основы данных.</param>
/// <param name="cacheSettings">Настройки кэширования.</param>
/// <param name="cache">Кэш.</param>
/// <param name="coreCachingResourceErrors">Ресурсы ошибок ядра кэширования.</param>
public ModProductCachingJobItemInsertService(
Func <ModProductBaseJobItemGetOutput, Task <ModProductBaseJobItemGetOutput> > executable,
CoreBaseResourceErrors coreBaseResourceErrors,
ModProductBaseResourceSuccesses resourceSuccesses,
ModProductBaseResourceErrors resourceErrors,
DataBaseSettings dataBaseSettings,
ICoreCachingCommonClientConfigSettings cacheSettings,
ICoreCachingCache cache,
CoreCachingResourceErrors coreCachingResourceErrors
) : base(executable, coreBaseResourceErrors, resourceSuccesses, resourceErrors, dataBaseSettings)
{
if (cacheSettings.IsCachingEnabled)
{
var client = new CoreCachingClientWithChangeAndRead <ModProductBaseJobItemGetOutput>(
"Item.Insert",
cacheSettings,
cache,
coreCachingResourceErrors
);
var tags = new[]
{
dataBaseSettings.Product.DbTableWithSchema,
dataBaseSettings.ProductCategory.DbTableWithSchema,
dataBaseSettings.ProductFeature.DbTableWithSchema,
dataBaseSettings.ProductProductFeature.DbTableWithSchema
};
Executable = input => client.ChangeAndRead(() => executable.Invoke(input), tags);
}
}
public void GetByID(String id)
{
try
{
String query = String.Format(@"SELECT *
FROM xCNBVCriterios
WHERE IDCriterio = {0}
ORDER BY IDCriterio", id);
DataBaseSettings db = new DataBaseSettings();
DataTable aux = db.GetDataTable(query);
if (aux.Rows.Count > 0)
{
this.criterio = aux.Rows[0]["Criterio"].ToString();
this.tipoOpcion = aux.Rows[0]["TipoOpcion"].ToString();
}
else
{
throw new Exception(String.Format("Criterio con el ID {0} no fue encontrado", id));
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="executable">Выполняемое.</param>
/// <param name="coreBaseResourceErrors">Ядро. Основа. Ресурсы. Ошибки.</param>
/// <param name="dataBaseSettings">Настройки основы данных.</param>
/// <param name="cacheSettings">Настройки кэширования.</param>
/// <param name="cache">Кэш.</param>
/// <param name="coreCachingResourceErrors">Ресурсы ошибок ядра кэширования.</param>
public ModDummyMainCachingJobOptionsDummyManyToManyGetService(
Func <Task <ModDummyMainBaseCommonJobOptionListGetOutput> > executable,
CoreBaseResourceErrors coreBaseResourceErrors,
DataBaseSettings dataBaseSettings,
ICoreCachingCommonClientConfigSettings cacheSettings,
ICoreCachingCache cache,
CoreCachingResourceErrors coreCachingResourceErrors
) : base(executable, coreBaseResourceErrors)
{
if (cacheSettings.IsCachingEnabled)
{
var client = new CoreCachingClientWithChangeAndRead <ModDummyMainBaseCommonJobOptionListGetOutput>(
"Options.DummyManyToMany.Get",
cacheSettings,
cache,
coreCachingResourceErrors
);
var tags = new[]
{
dataBaseSettings.DummyManyToMany.DbTableWithSchema
};
Executable = () =>
{
return(client.Read(() => executable.Invoke(), null, tags));
};
}
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="executable">Выполняемое.</param>
/// <param name="coreBaseResourceErrors">Ядро. Основа. Ресурсы. Ошибки.</param>
/// <param name="resourceSuccesses">Ресурсы успехов.</param>
/// <param name="resourceErrors">Ресурсы ошибок.</param>
/// <param name="dataBaseSettings">Настройки основы данных.</param>
/// <param name="cacheSettings">Настройки кэширования.</param>
/// <param name="cache">Кэш.</param>
/// <param name="coreCachingResourceErrors">Ресурсы ошибок ядра кэширования.</param>
public ModDummyMainCachingJobItemUpdateService(
Func <ModDummyMainBaseJobItemGetOutput, Task <ModDummyMainBaseJobItemGetOutput> > executable,
CoreBaseResourceErrors coreBaseResourceErrors,
ModDummyMainBaseResourceSuccesses resourceSuccesses,
ModDummyMainBaseResourceErrors resourceErrors,
DataBaseSettings dataBaseSettings,
ICoreCachingCommonClientConfigSettings cacheSettings,
ICoreCachingCache cache,
CoreCachingResourceErrors coreCachingResourceErrors
) : base(executable, coreBaseResourceErrors, resourceSuccesses, resourceErrors, dataBaseSettings)
{
if (cacheSettings.IsCachingEnabled)
{
var client = new CoreCachingClientWithChangeAndRead <ModDummyMainBaseJobItemGetOutput>(
"Item.Update",
cacheSettings,
cache,
coreCachingResourceErrors
);
var tags = new[]
{
dataBaseSettings.DummyMain.DbTableWithSchema,
dataBaseSettings.DummyManyToMany.DbTableWithSchema,
dataBaseSettings.DummyMainDummyManyToMany.DbTableWithSchema,
dataBaseSettings.DummyOneToMany.DbTableWithSchema
};
Executable = input => client.ChangeAndRead(() => executable.Invoke(input), tags);
}
}
public UserRepository(DataBaseSettings setting)
{
var client = new MongoClient(setting.ConnectionString);
var dbClient = client.GetDatabase(setting.DatabaseName);
users = dbClient.GetCollection <User>(CollectionName);
}
public AkkaActorSystemMechanism(IActorRef storageActorRef, IStorageMechanism worker, DataBaseSettings DdtaBaseSettings, IPecanLogger logger)
{
this.Logger = logger;
this._storageActorRef = storageActorRef;
this._worker = worker;
this.FileSystem = this._worker?.FileSystem;
this.DataBaseSettings = DdtaBaseSettings;
}
/// <inheritdoc/>
public DataEntitySqlServerDbFactory(
string connectionString,
DataBaseSettings dataBaseSettings,
CoreBaseEnvironment environment
)
: base(connectionString, dataBaseSettings)
{
Environment = environment;
}
public ProvidersConsultController(CookieServices _ICookieServices,
SessionUser _SessionUser,
IConfiguration _IConfiguration)
{
CookiesServices = _ICookieServices;
SessionUser = _SessionUser;
Configuration = _IConfiguration;
DataBaseSettings = Configuration.GetSectionMapped <DataBaseSettings>();
ApiServicesSettings = Configuration.GetSectionMapped <ApiServicesSettings>();
}
public void Insert()
{
try
{
String query = String.Format("INSERT INTO xCNBVCriterios (Criterio, TipoOpcion) VALUES ('{0}', '{1}')", criterio, tipoOpcion);
DataBaseSettings db = new DataBaseSettings();
db.ExecuteQuery(query);
} catch (Exception ex)
{
throw ex;
}
}
public void Update(int idCriterio, String criterio, String tipoOpcion)
{
try
{
String query = String.Format("UPDATE xCNBVCriterios SET Criterio = '{0}', TipoOpcion = '{2}' WHERE IDCriterio = {1}", criterio, idCriterio, tipoOpcion);
DataBaseSettings db = new DataBaseSettings();
db.ExecuteQuery(query);
} catch (Exception ex)
{
throw ex;
}
}
public void Delete(int idCriterio)
{
try
{
String query = String.Format("DELETE xCNBVCriterios WHERE IDCriterio = {0}", idCriterio);
DataBaseSettings db = new DataBaseSettings();
db.ExecuteQuery(query);
}
catch (Exception ex)
{
throw ex;
}
}
public static void DeleteDataBaseSettings(DataBaseSettings dataBase)
{
ConnectionStringSettings conn = GetConnectionStringSettings(dataBase.Name);
if (conn != null)
{
config.ConnectionStrings.ConnectionStrings.Remove(conn);
DataBaseSettingsGroup.Sections.Remove(dataBase.Name);
SaveConfiguration();
DataBaseSettingsList.Clear();
DataBaseSettingsList = GetDataBaseSettings();
}
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="coreBaseResourceErrors">Ядро. Основа. Ресурсы. Ошибки.</param>
/// <param name="dataBaseSettings">Данные. Основа. Настройки.</param>
/// <param name="resourceSuccesses">Ресурсы. Успехи.</param>
/// <param name="resourceErrors">Ресурсы. Ошибки.</param>
/// <param name="service">Сервис.</param>
public ModDummyMainBaseJobs(
CoreBaseResourceErrors coreBaseResourceErrors,
DataBaseSettings dataBaseSettings,
ModDummyMainBaseResourceSuccesses resourceSuccesses,
ModDummyMainBaseResourceErrors resourceErrors,
ModDummyMainBaseService service
)
{
JobItemDelete = new ModDummyMainBaseJobItemDeleteService(
service.DeleteItem,
coreBaseResourceErrors,
resourceSuccesses
);
JobItemGet = new ModDummyMainBaseJobItemGetService(
service.GetItem,
coreBaseResourceErrors
);
JobItemInsert = new ModDummyMainBaseJobItemInsertService(
service.SaveItem,
coreBaseResourceErrors,
resourceSuccesses,
resourceErrors,
dataBaseSettings
);
JobItemUpdate = new ModDummyMainBaseJobItemUpdateService(
service.SaveItem,
coreBaseResourceErrors,
resourceSuccesses,
resourceErrors,
dataBaseSettings
);
JobListGet = new ModDummyMainBaseJobListGetService(
service.GetList,
coreBaseResourceErrors
);
JobOptionsDummyManyToManyGet = new ModDummyMainBaseJobOptionDummyManyToManyGetListService(
service.GetOptionsDummyManyToMany,
coreBaseResourceErrors
);
JobOptionsDummyOneToManyGet = new ModDummyMainBaseJobOptionDummyOneToManyListGetService(
service.GetOptionsDummyOneToMany,
coreBaseResourceErrors
);
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="executable">Выполняемое.</param>
/// <param name="coreBaseResourceErrors">Ядро. Основа. Ресурсы. Ошибки.</param>
/// <param name="resourceSuccesses">Ресурсы успехов.</param>
/// <param name="resourceErrors">Ресурсы ошибок.</param>
/// <param name="dataBaseSettings">Настройки основы данных.</param>
public ModDummyMainBaseJobItemInsertService(
Func <ModDummyMainBaseJobItemGetOutput, Task <ModDummyMainBaseJobItemGetOutput> > executable,
CoreBaseResourceErrors coreBaseResourceErrors,
ModDummyMainBaseResourceSuccesses resourceSuccesses,
ModDummyMainBaseResourceErrors resourceErrors,
DataBaseSettings dataBaseSettings
) : base(executable, coreBaseResourceErrors)
{
ResourceSuccesses = resourceSuccesses;
ResourceErrors = resourceErrors;
DataBaseSettings = dataBaseSettings;
Execution.FuncGetErrorMessages = GetErrorMessages;
Execution.FuncGetSuccessMessages = GetSuccessMessages;
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="executable">Выполняемое.</param>
/// <param name="coreBaseResourceErrors">Ядро. Основа. Ресурсы. Ошибки.</param>
/// <param name="resourceSuccesses">Ресурсы успехов.</param>
/// <param name="resourceErrors">Ресурсы ошибок.</param>
/// <param name="dataBaseSettings">Настройки основы данных.</param>
public ModDummyMainBaseJobItemUpdateService(
Func <ModDummyMainBaseJobItemGetOutput, Task <ModDummyMainBaseJobItemGetOutput> > executable,
CoreBaseResourceErrors coreBaseResourceErrors,
ModDummyMainBaseResourceSuccesses resourceSuccesses,
ModDummyMainBaseResourceErrors resourceErrors,
DataBaseSettings dataBaseSettings
) : base(
executable,
coreBaseResourceErrors,
resourceSuccesses,
resourceErrors,
dataBaseSettings
)
{
}
public DataTable Get()
{
try
{
String query = String.Format(@"SELECT *
FROM xCNBVCriterios
ORDER BY IDCriterio");
DataBaseSettings db = new DataBaseSettings();
return(db.GetDataTable(query));
}
catch (Exception ex)
{
throw ex;
}
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddCors();
services.AddResponseCompression();
services.Configure <GzipCompressionProviderOptions>(options =>
{
options.Level = CompressionLevel.Fastest;
});
DataBaseSettings setting = new DataBaseSettings()
{
ConnectionString = Configuration["ConectionString"], DatabaseName = Configuration["DbName"]
};
services.AddControllers();
services.AddTransient <IUserService>(s => new UserService(setting));
services.AddTransient <ITestResultService>(s => new TestResultService(setting));
//services.AddRouting();
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="executable">Выполняемое.</param>
/// <param name="coreBaseResourceErrors">Ядро. Основа. Ресурсы. Ошибки.</param>
/// <param name="dataBaseSettings">Настройки основы данных.</param>
/// <param name="cacheSettings">Настройки кэширования.</param>
/// <param name="cache">Кэш.</param>
/// <param name="coreCachingResourceErrors">Ресурсы ошибок ядра кэширования.</param>
public ModProductCachingJobListGetService(
Func <ModProductBaseJobListGetInput, Task <ModProductBaseJobListGetOutput> > executable,
CoreBaseResourceErrors coreBaseResourceErrors,
DataBaseSettings dataBaseSettings,
ICoreCachingCommonClientConfigSettings cacheSettings,
ICoreCachingCache cache,
CoreCachingResourceErrors coreCachingResourceErrors
) : base(executable, coreBaseResourceErrors)
{
if (cacheSettings.IsCachingEnabled)
{
var client = new CoreCachingClientWithChangeAndRead <ModProductBaseJobListGetOutput>(
"List.Get",
cacheSettings,
cache,
coreCachingResourceErrors
);
var tags = new[]
{
dataBaseSettings.Product.DbTableWithSchema
};
Executable = input =>
{
var keys = new object[]
{
input.DataObjectProductCategoryName,
input.DataObjectProductCategoryIds,
input.DataObjectProductCategoryId,
input.DataName,
input.DataIds,
input.DataPageNumber,
input.DataPageSize,
input.DataSortField,
input.DataSortDirection
};
return(client.Read(() => executable.Invoke(input), keys, tags));
};
}
}
public static void UpdateDataBaseSettings(DataBaseSettings dataBase)
{
if (dataBase.IsNew)
{
insertConnectionString(dataBase.Name, dataBase.ConnectionString, "System.Data.EntityClient");
}
else
{
ConnectionStringSettings conn = GetConnectionStringSettings(dataBase.OrginalName);
if (conn != null)
{
conn.Name = dataBase.Name;
conn.ConnectionString = dataBase.ConnectionString;
}
}
SaveConfiguration();
DataBaseSettingsList.Clear();
DataBaseSettingsList = GetDataBaseSettings();
}
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.IgnoreRoute("content/{*pathInfo}");
routes.IgnoreRoute("elmah.axd");
routes.IgnoreRoute("*.png");
routes.IgnoreRoute("*.jpg");
routes.IgnoreRoute("*.gif");
routes.IgnoreRoute("{*favicon}", new { favicon = @"(.*/)?favicon.ico(/.*)?" });
routes.MapMvcAttributeRoutes();
routes.MapRoute(
"Default", // Route name
"{controller}/{action}/{id}", // URL with parameters
new { controller = "Home", action = "Index", id = UrlParameter.Optional }, new string[] { "WBSSLStore.Web.Controllers" } // Parameter defaults
);
//routes.MapRoute("SiteDefault", "{controller}/{action}/{id}", new { controller = "StaticPage", action = "index", id = UrlParameter.Optional }, new string[] { "WBSSLStore.Web.Controllers" });
using (ConfigurationHelper help = new ConfigurationHelper())
{
var allsettings = help.GetAllSettings();
DataBaseSettings dbsettings = allsettings != null && allsettings.DataBaseSetting != null ? allsettings.DataBaseSetting : null;
if (dbsettings != null)
{
var eConfigset = WBSSLStore.Web.Helpers.WBHelper.GetSiteConfiguration(dbsettings.ConnectionString);
if ((int)WBSSLStore.Domain.ConfigurationStage.GeneralSetup != (int)(WBSSLStore.Domain.ConfigurationStage)eConfigset)
{
routes.MapRoute("Installation", "siteinstallation/{controller}/{action}/{id}", new { controller = "Install", action = "paymentsettings", id = UrlParameter.Optional }, new string[] { "WhiteBrandShrink.Controllers" });
}
else
{
LoadCustomRoutes(routes);
}
}
else
{
LoadCustomRoutes(routes);
}
}
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="executable">Выполняемое.</param>
/// <param name="coreBaseResourceErrors">Ядро. Основа. Ресурсы. Ошибки.</param>
/// <param name="dataBaseSettings">Настройки основы данных.</param>
/// <param name="cacheSettings">Настройки кэширования.</param>
/// <param name="cache">Кэш.</param>
/// <param name="coreCachingResourceErrors">Ресурсы ошибок ядра кэширования.</param>
public ModDummyMainCachingJobItemGetService(
Func <ModDummyMainBaseJobItemGetInput, Task <ModDummyMainBaseJobItemGetOutput> > executable,
CoreBaseResourceErrors coreBaseResourceErrors,
DataBaseSettings dataBaseSettings,
ICoreCachingCommonClientConfigSettings cacheSettings,
ICoreCachingCache cache,
CoreCachingResourceErrors coreCachingResourceErrors
) : base(executable, coreBaseResourceErrors)
{
if (cacheSettings.IsCachingEnabled)
{
var client = new CoreCachingClientWithChangeAndRead <ModDummyMainBaseJobItemGetOutput>(
"Item.Get",
cacheSettings,
cache,
coreCachingResourceErrors
);
var tags = new[]
{
dataBaseSettings.DummyMain.DbTableWithSchema,
dataBaseSettings.DummyManyToMany.DbTableWithSchema,
dataBaseSettings.DummyMainDummyManyToMany.DbTableWithSchema,
dataBaseSettings.DummyOneToMany.DbTableWithSchema
};
Executable = input =>
{
var keys = new object[]
{
input.DataId,
input.DataName
};
return(client.Read(() => executable.Invoke(input), keys, tags));
};
}
}
/// <inheritdoc/>
public DataEntitySchemaDummyMainDummyManyToMany(DataBaseSettings dataBaseSettings)
: base(dataBaseSettings)
{
}
/// <inheritdoc/>
public DataEntitySchemaUserClaim(DataBaseSettings dataBaseSettings)
: base(dataBaseSettings)
{
}
public UserRepository(IOptions <DataBaseSettings> options)
{
_databaseSettings = options.Value;
}
/// <inheritdoc/>
public DataEntitySchemaProduct(DataBaseSettings dataBaseSettings)
: base(dataBaseSettings)
{
}
/// <inheritdoc/>
public DataEntitySchemaDummyTree(DataBaseSettings dataBaseSettings)
: base(dataBaseSettings)
{
}
public static void SetBusiness()
{
DataBaseSettings.SetDatabase();
}
/// <inheritdoc/>
public DataEntitySchemaUserLogin(DataBaseSettings dataBaseSettings)
: base(dataBaseSettings)
{
}
/// <inheritdoc/>
public DataEntitySchemaUserRole(DataBaseSettings dataBaseSettings)
: base(dataBaseSettings)
{
}
