public Email[] GetAllEmailsFromList() { using (EmailDbContext emaildb = new EmailDbContext()) { return(emaildb.Emails.Where(x => x.U_Id == userid && x.Emlist_Id == emaillistid).ToArray()); } }
public string[] GetEmailAddresses() { using (EmailDbContext emaildb = new EmailDbContext()) { return(emaildb.Emails.Where(x => x.U_Id == userid && x.Emlist_Id == emaillistid).Select(x => x.Email_Add).ToArray()); } }
public void Update() { using (EmailDbContext db = new EmailDbContext()) { Email email = db.Emails.Where(x => x.U_Id == userid && x.Eml_Id == emailid).FirstOrDefault(); try { if (firstname != email.F_Name) { email.F_Name = firstname; } else if (lastname != email.L_Name) { email.L_Name = lastname; } else if (emailaddress != "") { email.Email_Add = emailaddress; } db.SaveChanges(); ProecessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }
public EmailController(ILogger <EmailController> logger, IMapper mapper, EmailDbContext dbContext, IOptions <AppSettings> appSettings) { _logger = logger; _mapper = mapper; _dbContext = dbContext; _appSettings = appSettings; }
public Email GetEmail() { using (EmailDbContext db = new EmailDbContext()) { return(db.Emails.Where(x => x.U_Id == userid && x.Eml_Id == emailid).First()); } }
public void Add() { using (EmailDbContext db = new EmailDbContext()) { try { Email email = new Email() { F_Name = firstname, L_Name = lastname, Email_Add = emailaddress, Eml_Id = emailid, U_Id = userid }; db.Emails.Add(email); db.SaveChangesAsync(); ProecessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }
public List <Email> GetAllEmails() { using (EmailDbContext db = new EmailDbContext()) { return(db.Emails.Where(x => x.U_Id == userid).ToList()); } }
/// <summary> /// Uses InMemoryDatabase to create a mock database for each test /// </summary> public SendMailTestBase() { var options = new DbContextOptionsBuilder <EmailDbContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()) .Options; _context = new EmailDbContext(options); _context.Database.EnsureCreated(); }
public AccountController(UserManager <AppUser> userManager , SignInManager <AppUser> signInManager , IPasswordHasher <AppUser> passwordHasher , EmailDbContext db ) { _userManager = userManager; _signInManager = signInManager; _passwordHasher = passwordHasher; _db = db; //_passwordValidator = passwordValidator; }
public void Delete() { using (EmailDbContext db = new EmailDbContext()) { try { Email email = db.Emails.Where(x => x.U_Id == userid && x.Eml_Id == emailid).FirstOrDefault(); db.Emails.Remove(email); db.SaveChangesAsync(); ProecessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, EmailDbContext _context) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseHsts(); } app.UseHttpsRedirection(); app.UseMvc(); if (!_context.Database.EnsureCreated()) { _context.Database.Migrate(); } }
public void GetItems_ReturnsSingleItem() { var builder = new DbContextOptionsBuilder <EmailDbContext>(); builder.UseInMemoryDatabase <EmailDbContext>(Guid.NewGuid().ToString()); var options = builder.Options; using (var context = new EmailDbContext(options)) { var orders = new List <Email> { new Email { Id = 33, Subject = "Email Subject" }, }; context.Emails.AddRange(orders); context.SaveChanges(); } using (var context = new EmailDbContext(options)) { var loggerMock = new Mock <ILogger <EmailController> >(); var config = new MapperConfiguration(cfg => cfg.AddProfile <AutoMapping>()); var mapper = config.CreateMapper(); var settingsMock = new Mock <IOptions <AppSettings> >(); var controller = new EmailController(loggerMock.Object, mapper, context, settingsMock.Object); var result = controller.Get(); var okResult = result as OkObjectResult; // assert Assert.NotNull(okResult); Assert.True(okResult is OkObjectResult); Assert.IsType <List <EmailDTO> >(okResult.Value); Assert.Equal(StatusCodes.Status200OK, okResult.StatusCode); var collection = okResult.Value as List <EmailDTO>; Assert.Single(collection); } }
public AuthService(EmailDbContext context, ILoggerFactory logger) { _logger = logger.CreateLogger <AuthService>(); _clients = context.Set <ServiceClient>(); }
public StatusService(EmailDbContext dbContext, ILoggerFactory logger) { _logger = logger.CreateLogger <StatusService>(); _emails = dbContext.Set <EmailTrail>(); }
public EmailTemplateRepository(EmailDbContext context, ILogger <EmailTemplateRepository> logger) { _context = context; _logger = logger; }
public EmailProviderRepository(EmailDbContext context, ILogger <IEmailProviderRepository> logger) { _context = context; _logger = logger; }
public AdminService() { _db = new EmailDbContext(); client = new RedisClient(RedisIP, RedisPort); }
public Essential() { _context = new EmailDbContext(); }
public EmailController(EmailDbContext db) { _db = db; }
public static void Send(MailMessage message) { // Queue an e-mail to send later using (EmailDbContext db = new EmailDbContext()) { try { EmailMessage emailMessage = new EmailMessage { Id = Guid.NewGuid(), From = ((message.From == null) ? (new MailAddress("*****@*****.**", "Doug Lockwood's Application")).ToString() : message.From.ToString()), To = message.To.ToString(), Cc = message.CC.ToString(), Bcc = message.Bcc.ToString(), Subject = message.Subject, Body = message.Body, IsBodyHtml = message.IsBodyHtml, ReplyTo = message.ReplyToList.ToString(), Created = DateTime.Now, Expires = DateTime.Now.AddDays(_daysToExpiration) }; db.Email.Add(emailMessage); db.SaveChanges(); } catch { throw; } } ////// Send an e-mail ////SmtpClient client = new SmtpClient ////{ //// Host = "host276.hostmonster.com", //// Credentials = new NetworkCredential("*****@*****.**", "D0ugl@$L"), ////}; ////message.From = new MailAddress("*****@*****.**"); ////if (message.IsBodyHtml) ////{ //// message.Body = message.Body.Replace(@"\r\n", "<br/>"); ////} ////message.Body += //// ((message.IsBodyHtml) ? "<p> </p><hr/><footer><p>" : "\r\n\r\n--------------------\r\n") //// + "This message was sent by McREL International through an unmonitored e-mail address. Please do not reply to this e-mail." //// + ((message.IsBodyHtml) ? "</p><p>" : "\r\n\r\n") //// + "You can learn more about McREL International by visiting us " //// + ((message.IsBodyHtml) ? "<a href=\"http://www.mcrel.org\">online</a>.</p><p>" : "online at http://www.mcrel.org.\r\n\r\n") //// + "McREL International" //// + ((message.IsBodyHtml) ? "<br/>" : "\r\n") //// + "4601 DTC Boulevard, Suite 500" //// + ((message.IsBodyHtml) ? "<br/>" : "\r\n") //// + "Denver, CO 80237-2596" //// + ((message.IsBodyHtml) ? "<br/>" : "\r\n") //// + "P: 303.337.0990" //// + ((message.IsBodyHtml) ? "<br/>" : "\r\n") //// + "F: 303.337.3005" //// + ((message.IsBodyHtml) ? "<br/>" : "\r\n") //// + "*****@*****.**" //// + ((message.IsBodyHtml) ? "<br/>" : "\r\n") //// + ((message.IsBodyHtml) ? "<a href=\"http://www.mcrel.org\">www.mcrel.org</a>" : "http://www.mcrel.org") //// + ((message.IsBodyHtml) ? "</p></footer>" : "\r\n--------------------\r\n") //// ; ////client.Send(message); }
public EmailRepository(EmailDbContext context) { _context = context; }
public async Task <string> FunctionHandler(SNSEvent snsEvent, ILambdaContext context) { string mongoConnectionString = Environment.GetEnvironmentVariable("MongoDB_ConnectionString"); DateTime now = DateTime.UtcNow; XmlConfigurator.Configure(m_logRepo, new System.IO.FileInfo("log4net.config")); foreach (var record in snsEvent.Records) { var snsRecord = record.Sns; JObject message = JObject.Parse(snsRecord.Message); string notificationId; switch (message["notificationType"].ToString()) { case "Bounce": notificationId = message["bounce"]["feedbackId"].ToString(); break; case "Complaint": notificationId = message["complaint"]["feedbackId"].ToString(); break; default: notificationId = ""; break; } m_log.Info($"[{record.EventSource} {snsRecord.Timestamp}] Message = {snsRecord.Message}"); if (!String.IsNullOrEmpty(mongoConnectionString)) { string mongoDatabaseName = mongoConnectionString.Substring(mongoConnectionString.LastIndexOf("/") + 1); MongoClient mongoClient = new MongoClient(mongoConnectionString); IMongoDatabase mongoDatabase = mongoClient.GetDatabase(mongoDatabaseName); IMongoCollection <EmailNotificationLog> emailNotificationLogCollection = mongoDatabase.GetCollection <EmailNotificationLog>("EmailNotificationLog"); IMongoCollection <EmailBlackList> emailBlackListCollection = mongoDatabase.GetCollection <EmailBlackList>("EmailBlackList"); emailBlackListCollection.Indexes.CreateOne(new BsonDocument("EmailAddress", 1), new CreateIndexOptions { Name = "UX_EmailBlackList_EmailAddress", Unique = true }); await emailNotificationLogCollection.InsertOneAsync(new EmailNotificationLog { NotificationType = message["notificationType"].ToString(), NotificationId = notificationId, Event = BsonSerializer.Deserialize <BsonDocument>(snsRecord.Message), Timestamp = snsRecord.Timestamp, Created = now }); if ((message["notificationType"].ToString() == "Bounce") && (message["bounce"]["bounceType"].ToString() == "Permanent")) { foreach (JObject bouncedRecipient in message["bounce"]["bouncedRecipients"]) { string emailAddress = bouncedRecipient["emailAddress"].ToString().ToLower(); long count = await emailBlackListCollection.Find(Builders <EmailBlackList> .Filter.Where(x => x.EmailAddress == emailAddress)).CountAsync(); if (count == 0) { await emailBlackListCollection.InsertOneAsync(new EmailBlackList { EmailAddress = emailAddress, Created = now }); } } } } if (EmailDbContext.IsActive()) { using (var db = new EmailDbContext()) { var emailNotificationLog = new EmailNotificationLog { NotificationType = message["notificationType"].ToString(), NotificationId = notificationId, Message = snsRecord.Message, Timestamp = snsRecord.Timestamp, Created = now }; db.EmailNotificationLog.Add(emailNotificationLog); if ((message["notificationType"].ToString() == "Bounce") && (message["bounce"]["bounceType"].ToString() == "Permanent")) { foreach (JObject bouncedRecipient in message["bounce"]["bouncedRecipients"]) { string emailAddress = bouncedRecipient["emailAddress"].ToString().ToLower(); if (db.EmailBlackList.Where(x => x.EmailAddress == emailAddress).Count() == 0) { var emailBlackList = new EmailBlackList { EmailAddress = emailAddress, Created = now }; db.EmailBlackList.Add(emailBlackList); } } } db.SaveChanges(); } } } return("okay"); }
public HomeController(EmailDbContext dbContext, UserManager <AppUser> userManager) { db = dbContext; _userManager = userManager; }
public MailService(IServiceProvider serviceProvider, ILogger <MailService> logger, EmailDbContext emailDbContext) { _serviceProvider = serviceProvider; _logger = logger; _emailDbContext = emailDbContext; }
public RabbitService(EmailDbContext dbContext, ILoggerFactory logger) { _logger = logger.CreateLogger <RabbitService>(); _emails = dbContext.Set <EmailTrail>(); _dbContext = dbContext; }