public void GenderAdmins()
{
var sql = @"SELECT
a.user_id,
a.email,
a.user_name,
a.`password`,
a.ec_salt,
b.shop_name ,b.ru_id
FROM
dsc_admin_user a
LEFT JOIN dsc_seller_shopinfo b ON a.ru_id = b.ru_id where 1=1" ;
var result = DapperHelper.GetSqlResult <dsc_drp_shop>(sql);
var adminRole = _roleRepository.FirstOrDefault(c => c.Name == StaticRoleNames.Tenants.Admin);
foreach (var item in result.Items)
{
var family = _orgRepository.FirstOrDefault(c => c.TreeName == item.shop_name);
if (family == null)
{
family = new OperatorTree()
{
TreeLength = 1,
ShopId = item.ru_id,
TreeName = item.shop_name,
TreeCode = Guid.NewGuid().ToString("D").Split('-').Last()
};
}
else
{
family.TreeName = item.shop_name;
family.ShopId = item.ru_id;
}
_orgRepository.InsertOrUpdate(family);
var temp = _userRepository.FirstOrDefault(u =>
u.UserName == item.user_name);
if (temp == null)
{
temp = User.CreateTenantUser(1, item.user_name, item.user_name, item.email);
temp.Password = item.password;
temp.IsEmailConfirmed = true;
temp.IsActive = true;
temp.IsAdmin = true;
temp.ShopId = item.ru_id;
temp.TreeCode = family.TreeCode;
temp.Salt = item.ec_salt;
temp.EmailAddress = item.user_name + "@" + item.user_id + ".com";
temp.KeyId = item.user_id;
temp = _userRepository.Insert(temp);
_userRoleRepository.Insert(new UserRole(1, temp.Id, adminRole.Id));
}
else
{
temp.Password = item.password;
temp.Salt = item.ec_salt;
temp.KeyId = item.user_id;
temp.EmailAddress = item.user_name + "@" + item.user_id + ".com";
temp.ShopId = item.ru_id;
temp.UserName = item.user_name;
_userRepository.Update(temp);
}
}
}
private void CreateSuperAdminsFromDb(Role adminRole)
{
var sql = @"SELECT
a.user_id,
a.email,
a.user_name,
a.`password`,
a.ec_salt,
b.shop_name ,b.ru_id
FROM
dsc_admin_user a
LEFT JOIN dsc_seller_shopinfo b ON a.ru_id = b.ru_id" ;
var result = DapperHelper.GetSqlResult <dsc_drp_shop>(sql);
foreach (var item in result.Items)
{
var temp = _context.Users.IgnoreQueryFilters().FirstOrDefault(u =>
u.TenantId == _tenantId && u.UserName == item.user_name);
var family = _context.OperatorTrees.IgnoreQueryFilters().FirstOrDefault(c => c.TreeName == item.shop_name);
if (family == null)
{
family = new OperatorTree()
{
TreeLength = 1,
ShopId = item.ru_id,
TreeName = item.shop_name,
TreeCode = Guid.NewGuid().ToString("D").Split('-').Last()
};
_context.OperatorTrees.Add(family);
_context.SaveChanges();
}
if (temp != null)
{
continue;
}
temp = User.CreateTenantUser(_tenantId, item.user_name, item.user_name, item.email);
temp.Password = item.password;
temp.ShopId = item.ru_id;
temp.IsEmailConfirmed = true;
temp.IsActive = true;
temp.IsAdmin = true;
temp.TreeCode = family.TreeCode;
temp.EmailAddress = item.user_name + "@" + item.user_id + ".com";
temp.Salt = item.ec_salt;
temp.KeyId = item.user_id;
_context.Users.Add(temp);
_context.SaveChanges();
// Assign Admin role to admin user
_context.UserRoles.Add(new UserRole(_tenantId, temp.Id, adminRole.Id));
_context.SaveChanges();
// User account of admin user
if (_tenantId == 1)
{
_context.UserAccounts.Add(new UserAccount
{
TenantId = _tenantId,
UserId = temp.Id,
UserName = AbpUserBase.AdminUserName,
EmailAddress = temp.EmailAddress
});
_context.SaveChanges();
}
}
}
