/// <summary> /// Register tenant shard /// </summary> /// <param name="tenantServerConfig">The tenant server configuration.</param> /// <param name="databaseConfig">The database configuration.</param> /// <param name="catalogConfig">The catalog configuration.</param> /// <param name="resetEventDate">If set to true, the events dates for all tenants will be reset </param> public async void RegisterTenantShard(TenantServerConfig tenantServerConfig, DatabaseConfig databaseConfig, CatalogConfig catalogConfig, bool resetEventDate) { //get all database in devtenantserver var tenants = GetAllTenantNames(tenantServerConfig, databaseConfig); var connectionString = new SqlConnectionStringBuilder { UserID = databaseConfig.DatabaseUser, Password = databaseConfig.DatabasePassword, ApplicationName = "EntityFramework", ConnectTimeout = databaseConfig.ConnectionTimeOut }; foreach (var tenant in tenants) { var tenantId = GetTenantKey(tenant); var result = await Sharding.RegisterNewShard(tenant, tenantId, tenantServerConfig.TenantServer, databaseConfig.DatabaseServerPort, catalogConfig.ServicePlan); if (result) { if (resetEventDate) { #region EF6 try { using (var context = new TenantContext(Sharding.ShardMap, tenantId, connectionString.ConnectionString)) { context.Database.ExecuteSqlCommand("sp_ResetBookingDates"); } var emailDetails = _configuration.GetSection("EmailNotification"); var fromEmailId = emailDetails["FromServiceEmailId"]; var ServiceName = emailDetails["ServiceName"]; _emailService.SendEmailToTenants(fromEmailId, ServiceName, "*****@*****.**", "Pramati"); } catch (ShardManagementException ex) { string errorText; if (ex.ErrorCode == ShardManagementErrorCode.MappingIsOffline) { errorText = "Tenant '" + tenant + "' is offline. Could not reset booking dates:" + ex.ToString(); } else { errorText = ex.ToString(); } Console.WriteLine(errorText); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } #endregion } } } }
/// <summary> /// Resolves any mapping differences between the global shard map in the catalog and the local shard map located a tenant database /// </summary> /// <param name="tenantId">The tenant identifier.</param> /// <param name="UseGlobalShardMap">Specifies if the global shard map or the local shard map should be used as the source of truth for resolution.</param> public void ResolveMappingDifferences(int TenantId, bool UseGlobalShardMap = false) { Sharding.ResolveMappingDifferences(TenantId, UseGlobalShardMap); }