public Messenger(IConfiguration config, JobConfigRepo jobRepo, MessageRepo msgRepo, ExecutionRepo execRepo, SmtpConfigRepo smtpConfigRepo) { _config = config; _jobRepo = jobRepo; _msgRepo = msgRepo; _execRepo = execRepo; _smtpConfigRepo = smtpConfigRepo; _sqlClient = new SQLClientAdo(); string configToExecute = _config["ExecuteOptions:JobName"]; string smtpConfigName = _config["ExecuteOptions:SmtpConfigName"]; var jobConfig = _jobRepo.GetByJobName(configToExecute); var smtpConfig = _smtpConfigRepo.GetByConfigName(smtpConfigName); //Create execution object to run job Execution = new Execution() { SysUser = _config["ExecuteOptions:Caller"], StartTime = DateTime.Now, JobConfig = jobConfig, SmtpConfig = smtpConfig }; _emailSender = new EmailSender(Execution.SmtpConfig); }
private void ProcessNew() { var sqlClientAdo = new SQLClientAdo(); //Rows with name/value pairs for template matching dbRows = sqlClientAdo.GetDbRows(Execution.JobConfig); foreach (DbRow row in dbRows) { Message msg = row.GetMessage(Execution.Config.Sender); if (msg.Status != MessageStatus.Sent) { Execution.NewSendFails++; } _msgRepo.Create(msg); } }
public void GetDbRows() { var sqlClientDAL = new SQLClientAdo(); JobConfig cfg = new JobConfig() { ConnectionString = "Server=(localdb)\\MSSQLLocalDB;Database=Camris;Trusted_Connection=True;MultipleActiveResultSets=true", JobName = "MedicaidCoverageChange", SenderAddress = "*****@*****.**", ViewName = "vwMedicaidCoverageChange", SenderName = "Frank Linden" }; //var actual = sqlClientDAL.GetDbRows( // cfg); // var expected = new List<DbViewRow>().FromJsonPath("SQLClientDAL\\GetMessages\\expected1.json").ToList(); // Assert.True(actual.IsEqual(expected)); }
public Messenger(IConfiguration config, SyncConfigRepo configRepo, MessageRepo msgRepo, SyncExecutionRepo execRepo) { _config = config; _syncConfigRepo = configRepo; _msgRepo = msgRepo; _execRepo = execRepo; _sqlClient = new SQLClientAdo(); string configToExecute = _config["ExecuteOptions:JobName"]; string smtpConfigName = _config["ExecuteOptions:SmtpConfigName"]; var syncConfig = _syncConfigRepo.GetByConfigName(configToExecute); //Create execution object to run job Execution = new SyncExecution() { SysUser = _config["ExecuteOptions:Caller"], StartTime = DateTime.Now, Config = syncConfig }; }