public void DeleteDomain(int domain_id, DbManager db)
{
if (domain_id < 0)
{
throw new ArgumentException("Argument domain_id less then zero.", "domain_id");
}
if (db == null)
{
throw new ArgumentNullException("db");
}
const string group_alias = "msg";
const string address_alias = "msa";
var group_query = new SqlQuery(MailGroupTable.name + " " + group_alias)
.InnerJoin(AddressTable.name + " " + address_alias,
Exp.EqColumns(MailGroupTable.Columns.id_address.Prefix(group_alias),
AddressTable.Columns.id.Prefix(address_alias)
)
)
.Select(MailGroupTable.Columns.id.Prefix(group_alias))
.Where(AddressTable.Columns.tenant.Prefix(address_alias), tenant_id)
.Where(AddressTable.Columns.id_domain.Prefix(address_alias), domain_id)
.Where(AddressTable.Columns.is_mail_group.Prefix(address_alias), true);
var mailbox_query = new SqlQuery(AddressTable.name)
.Select(AddressTable.Columns.id_mailbox)
.Where(AddressTable.Columns.tenant, tenant_id)
.Where(AddressTable.Columns.id_domain, domain_id)
.Where(AddressTable.Columns.is_mail_group, false)
.Where(AddressTable.Columns.is_alias, false);
var delete_web_domain_query = new SqlDelete(DomainTable.name)
.Where(DomainTable.Columns.tenant, tenant_id)
.Where(DomainTable.Columns.id, domain_id);
var result = db.ExecuteList(group_query);
var group_ids = result.Select(r => (int)r[0]).ToList();
var group_dal = new MailGroupDal(tenant_id);
foreach (var group_id in group_ids)
{
group_dal.DeleteMailGroup(group_id, db);
}
result = db.ExecuteList(mailbox_query);
var mailbox_ids = result.Select(r => (int)r[0]).ToList();
var mailbox_dal = new MailboxDal(tenant_id);
foreach (var mailbox_id in mailbox_ids)
{
mailbox_dal.DeleteMailbox(mailbox_id, db);
}
db.ExecuteNonQuery(delete_web_domain_query);
}
public void DeleteDomain(int domainId, DbManager db)
{
if (domainId < 0)
{
throw new ArgumentException("Argument domain_id less then zero.", "domainId");
}
if (db == null)
{
throw new ArgumentNullException("db");
}
const string group_alias = "msg";
const string address_alias = "msa";
var groupQuery = new SqlQuery(MailGroupTable.Name.Alias(group_alias))
.InnerJoin(AddressTable.Name.Alias(address_alias),
Exp.EqColumns(MailGroupTable.Columns.AddressId.Prefix(group_alias),
AddressTable.Columns.Id.Prefix(address_alias)
)
)
.Select(MailGroupTable.Columns.Id.Prefix(group_alias))
.Where(AddressTable.Columns.Tenant.Prefix(address_alias), tenant)
.Where(AddressTable.Columns.DomainId.Prefix(address_alias), domainId)
.Where(AddressTable.Columns.IsMailGroup.Prefix(address_alias), true);
var mailboxQuery = new SqlQuery(AddressTable.Name)
.Select(AddressTable.Columns.MailboxId)
.Where(AddressTable.Columns.Tenant, tenant)
.Where(AddressTable.Columns.DomainId, domainId)
.Where(AddressTable.Columns.IsMailGroup, false)
.Where(AddressTable.Columns.IsAlias, false);
var deleteWebDomainQuery = new SqlDelete(DomainTable.Name)
.Where(DomainTable.Columns.Tenant, tenant)
.Where(DomainTable.Columns.Id, domainId);
var result = db.ExecuteList(groupQuery);
var groupIds = result.Select(r => (int)r[0]).ToList();
var groupDal = new MailGroupDal(tenant);
foreach (var groupId in groupIds)
{
groupDal.DeleteMailGroup(groupId, db);
}
result = db.ExecuteList(mailboxQuery);
var mailboxIds = result.Select(r => (int)r[0]).ToList();
var mailboxDal = new MailboxDal(tenant);
foreach (var mailboxId in mailboxIds)
{
mailboxDal.DeleteMailbox(mailboxId, db);
}
db.ExecuteNonQuery(deleteWebDomainQuery);
}
public void DeleteDomain(int domainId, DbManager db)
{
if (domainId < 0)
throw new ArgumentException("Argument domain_id less then zero.", "domainId");
if(db == null)
throw new ArgumentNullException("db");
const string group_alias = "msg";
const string address_alias = "msa";
var groupQuery = new SqlQuery(MailGroupTable.name + " " + group_alias)
.InnerJoin(AddressTable.name + " " + address_alias,
Exp.EqColumns(MailGroupTable.Columns.id_address.Prefix(group_alias),
AddressTable.Columns.id.Prefix(address_alias)
)
)
.Select(MailGroupTable.Columns.id.Prefix(group_alias))
.Where(AddressTable.Columns.tenant.Prefix(address_alias), tenant)
.Where(AddressTable.Columns.id_domain.Prefix(address_alias), domainId)
.Where(AddressTable.Columns.is_mail_group.Prefix(address_alias), true);
var mailboxQuery = new SqlQuery(AddressTable.name)
.Select(AddressTable.Columns.id_mailbox)
.Where(AddressTable.Columns.tenant, tenant)
.Where(AddressTable.Columns.id_domain, domainId)
.Where(AddressTable.Columns.is_mail_group, false)
.Where(AddressTable.Columns.is_alias, false);
var deleteWebDomainQuery = new SqlDelete(DomainTable.name)
.Where(DomainTable.Columns.tenant, tenant)
.Where(DomainTable.Columns.id, domainId);
var result = db.ExecuteList(groupQuery);
var groupIds = result.Select(r => (int)r[0]).ToList();
var groupDal = new MailGroupDal(tenant);
foreach (var groupId in groupIds)
{
groupDal.DeleteMailGroup(groupId, db);
}
result = db.ExecuteList(mailboxQuery);
var mailboxIds = result.Select(r => (int)r[0]).ToList();
var mailboxDal = new MailboxDal(tenant);
foreach (var mailboxId in mailboxIds)
{
mailboxDal.DeleteMailbox(mailboxId, db);
}
db.ExecuteNonQuery(deleteWebDomainQuery);
}