Beispiel #1
0
        /// <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
                    }
                }
            }
        }
Beispiel #2
0
 /// <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);
 }