private void DispatcherTimer_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
DispatcherTimer.Stop();
try
{
_emailService = _container.Resolve<IEmailService>();
var list = new List<EmailViewModel>();
var model = new EmailViewModel
{
UserId = "5",
UserName = "******",
ServerName = "195.87.213.235",
DataBaseName = "Otokar-DMS",
Password = "******",
ConnectionString = "Server=195.87.213.235;Database=Otokar-DMS;User Id=DMSUser;Password = Xyz123; ",//dynamic from db
SqlQuery = "SELECT TOP 10 * from DMS_USER",//dynamic from db
ProviderName = "SqlServerImplementor"
};
list.Add(model);
foreach (var item in list)
{
_emailService.ConnectionOpen(item);
_emailService.ExecuteQuery(item);
}
}
catch (System.Exception ex)
{
}
DispatcherTimer.Start();
}