private void SaveTenant(DbFactory dbFactory, string alias, TenantStatus status, string newAlias = null, string whereCondition = null)
{
using (var connection = dbFactory.OpenConnection())
{
if (newAlias == null)
{
newAlias = alias;
}
else if (newAlias != alias)
{
newAlias = GetUniqAlias(connection, newAlias);
}
var commandText = string.Format(
"update tenants_tenants " +
"set " +
" status={0}, " +
" alias = '{1}', " +
" last_modified='{2}', " +
" statuschanged='{2}' " +
"where alias = '{3}'",
status.ToString("d"),
newAlias,
DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss"),
alias);
if (!string.IsNullOrEmpty(whereCondition))
{
commandText += (" and " + whereCondition);
}
connection.CreateCommand(commandText).WithTimeout(120).ExecuteNonQuery();
}
}
private void SaveTenant(DbFactory dbFactory, TenantStatus status, string newAlias = null, string whereCondition = null)
{
using (var connection = dbFactory.OpenConnection("core"))
{
if (newAlias == null)
{
newAlias = Tenant.TenantAlias;
}
else if (newAlias != Tenant.TenantAlias)
{
newAlias = GetUniqAlias(connection, newAlias);
}
var commandText = string.Format(
"update tenants_tenants " +
"set " +
" status={0}, " +
" alias = '{1}', " +
" last_modified='{2}', " +
" statuschanged='{2}' " +
"where alias = '{3}'",
status.ToString("d"),
newAlias,
DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss"),
Tenant.TenantAlias);
if (!string.IsNullOrEmpty(whereCondition))
commandText += (" and " + whereCondition);
connection.CreateCommand(commandText).WithTimeout(120).ExecuteNonQuery();
}
}
