public MailTag SaveMailTag(int tenant, string user, MailTag tag)
{
using (var db = GetDb())
{
using (var tx = db.BeginTransaction())
{
if (tag.Id == 0)
{
tag.Id = db.ExecuteScalar <int>(
new SqlInsert(TagTable.Name)
.InColumnValue(TagTable.Columns.Id, 0)
.InColumnValue(TagTable.Columns.Tenant, tenant)
.InColumnValue(TagTable.Columns.User, user)
.InColumnValue(TagTable.Columns.TagName, tag.Name)
.InColumnValue(TagTable.Columns.Style, tag.Style)
.InColumnValue(TagTable.Columns.Addresses, string.Join(";", tag.Addresses.ToArray()))
.Identity(0, 0, true));
}
else
{
db.ExecuteNonQuery(
new SqlUpdate(TagTable.Name)
.Set(TagTable.Columns.TagName, tag.Name)
.Set(TagTable.Columns.Style, tag.Style)
.Set(TagTable.Columns.Addresses, string.Join(";", tag.Addresses.ToArray()))
.Where(TagTable.Columns.Id, tag.Id));
db.ExecuteNonQuery(
new SqlDelete(TagAddressTable.Name)
.Where(TagAddressTable.Columns.TagId, tag.Id));
}
if (tag.Addresses.Any())
{
var insertQuery =
new SqlInsert(TagAddressTable.Name)
.InColumns(TagAddressTable.Columns.TagId,
TagAddressTable.Columns.Address,
TagAddressTable.Columns.Tenant);
tag.Addresses
.ForEach(addr =>
insertQuery
.Values(tag.Id, addr, tenant));
db.ExecuteNonQuery(insertQuery);
}
tx.Commit();
}
}
return(tag);
}
public MailTag SaveMailTag(int id_tenant, string id_user, MailTag tag)
{
using (var db = GetDb())
{
using (var tx = db.BeginTransaction())
{
if (tag.Id == 0)
{
tag.Id = db.ExecuteScalar <int>(
new SqlInsert(MAIL_TAG)
.InColumnValue(TagFields.id, 0)
.InColumnValue(TagFields.id_tenant, id_tenant)
.InColumnValue(TagFields.id_user, id_user)
.InColumnValue(TagFields.name, tag.Name)
.InColumnValue(TagFields.style, tag.Style)
.InColumnValue(TagFields.addresses, string.Join(";", tag.Addresses.ToArray()))
.Identity(0, 0, true));
}
else
{
db.ExecuteNonQuery(
new SqlUpdate(MAIL_TAG)
.Set(TagFields.name, tag.Name)
.Set(TagFields.style, tag.Style)
.Set(TagFields.addresses, string.Join(";", tag.Addresses.ToArray()))
.Where(TagFields.id, tag.Id));
db.ExecuteNonQuery(
new SqlDelete(MAIL_TAG_ADDRESSES)
.Where(TagAddressFields.id_tag, tag.Id));
}
if (tag.Addresses.Any())
{
var insert_query =
new SqlInsert(MAIL_TAG_ADDRESSES)
.InColumns(TagAddressFields.id_tag,
TagAddressFields.address,
TagAddressFields.id_tenant);
tag.Addresses
.ForEach(addr =>
insert_query
.Values(tag.Id, addr, id_tenant));
db.ExecuteNonQuery(insert_query);
}
tx.Commit();
}
}
return(tag);
}