public void SendAnEmail()
{
using (EfRelationshipsDbContext db = new EfRelationshipsDbContext()) {
var email = db.Emails.Where(e => e.ID == 1).FirstOrDefault();
var toAddresses = email.ToAddresses
.Where(x => x.EmailAddressType == EmailAddressType.To)
.Select(y => new MailAddress(y.Address))
.Select(z => new MailAddressCollection() { z }).FirstOrDefault();
var ccAddresses = email.ToAddresses
.Where(x => x.EmailAddressType == EmailAddressType.Cc)
.Select(y => new MailAddress(y.Address))
.Select(z => new MailAddressCollection() { z }).FirstOrDefault();
var bccAddresses = email.ToAddresses
.Where(x => x.EmailAddressType == EmailAddressType.Bcc)
.Select(y => new MailAddress(y.Address))
.Select(z => new MailAddressCollection() { z }).FirstOrDefault();
var emailMessage = new MailMessage() {
Subject = email.Subject,
Body = email.Body,
};
foreach (var address in toAddresses) {
emailMessage.To.Add(address);
}
foreach (var address in ccAddresses) {
emailMessage.CC.Add(address);
}
foreach (var address in bccAddresses) {
emailMessage.Bcc.Add(address);
}
}
}
public void SendAnEmail()
{
using (EfRelationshipsDbContext db = new EfRelationshipsDbContext()) {
var email = db.Emails.Where(e => e.ID == 1).FirstOrDefault();
var toAddresses = email.ToAddresses
.Where(x => x.EmailAddressType == EmailAddressType.To)
.Select(y => new MailAddress(y.Address))
.Select(z => new MailAddressCollection()
{
z
}).FirstOrDefault();
var ccAddresses = email.ToAddresses
.Where(x => x.EmailAddressType == EmailAddressType.Cc)
.Select(y => new MailAddress(y.Address))
.Select(z => new MailAddressCollection()
{
z
}).FirstOrDefault();
var bccAddresses = email.ToAddresses
.Where(x => x.EmailAddressType == EmailAddressType.Bcc)
.Select(y => new MailAddress(y.Address))
.Select(z => new MailAddressCollection()
{
z
}).FirstOrDefault();
var emailMessage = new MailMessage()
{
Subject = email.Subject,
Body = email.Body,
};
foreach (var address in toAddresses)
{
emailMessage.To.Add(address);
}
foreach (var address in ccAddresses)
{
emailMessage.CC.Add(address);
}
foreach (var address in bccAddresses)
{
emailMessage.Bcc.Add(address);
}
}
}
public void SeedEmailsTable()
{
using (EfRelationshipsDbContext db = new EfRelationshipsDbContext()) {
Email email = new Email()
{
Subject = "Hello",
Body = "Here's some work for you to derail you from your project entirely!",
FromAddress = "*****@*****.**",
ToAddresses = new List <EmailAddress> {
new EmailAddress()
{
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.To
},
new EmailAddress()
{
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.To
},
new EmailAddress()
{
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.Cc
},
new EmailAddress()
{
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.Cc
},
new EmailAddress()
{
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.Bcc
},
new EmailAddress()
{
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.Bcc
},
}
};
db.Emails.Add(email);
db.SaveChanges();
}
}
public void SeedEmailsTable()
{
using (EfRelationshipsDbContext db = new EfRelationshipsDbContext()) {
Email email = new Email() {
Subject = "Hello",
Body = "Here's some work for you to derail you from your project entirely!",
FromAddress = "*****@*****.**",
ToAddresses = new List<EmailAddress> {
new EmailAddress() {
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.To
},
new EmailAddress() {
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.To
},
new EmailAddress() {
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.Cc
},
new EmailAddress() {
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.Cc
},
new EmailAddress() {
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.Bcc
},
new EmailAddress() {
Address = "*****@*****.**",
EmailAddressType = EmailAddressType.Bcc
},
}
};
db.Emails.Add(email);
db.SaveChanges();
}
}
