static async Task Main(string[] args)
{
using (var db = new MailsAndSendersDbModel(new DbContextOptionsBuilder <MailsAndSendersDbModel>().UseSqlServer(Utils.ConnectionString).Options))
{
await db.Database.EnsureCreatedAsync();
var senderscount = await db.Senders.CountAsync();
var recipientscount = await db.Recipients.CountAsync();
var serverscount = await db.Servers.CountAsync();
var messagescount = await db.Messages.CountAsync();
var taskscount = await db.SenderTasks.CountAsync();
Console.WriteLine($"Servers count={serverscount}");
Console.WriteLine($"Senders count={senderscount}");
Console.WriteLine($"Recipients count={recipientscount}");
Console.WriteLine($"Messages count={messagescount}");
Console.WriteLine($"SenderTasks count={taskscount}");
if (serverscount == 0)
{
await db.Servers.AddRangeAsync(new List <Server> {
new Server {
Name = "smtp.yandex.ru", Address = "yandex.ru", Port = 587, Login = "******", Password = "******"
}
, new Server {
Name = "smtp.mail.ru", Address = "mail.ru", Port = 465, Login = "******", Password = "******"
}
, new Server {
Name = "smtp.gmail.com", Address = "gmail.com", Port = 587, Login = "******", Password = "******"
}
});
db.SaveChanges();
}
if (recipientscount == 0)
{
await db.Recipients.AddAsync(new Recipient { Name = "Полятыкина Татьяна", Address = "*****@*****.**" });
db.SaveChanges();
}
if (senderscount == 0)
{
await db.Senders.AddAsync(new Sender { Name = "Полятыкина Татьяна", Address = "*****@*****.**" });
await db.Senders.AddAsync(new Sender { Name = "Tester", Address = "*****@*****.**" });
await db.Senders.AddAsync(new Sender { Name = "Geek test", Address = "*****@*****.**" });
db.SaveChanges();
}
}
Console.ReadLine();
}
public MainWindowViewModel(IMailService mailService, MailsAndSendersDbModel mailsAndSendersDb)
{
_mailService = mailService;
_mailsAndSendersDb = mailsAndSendersDb;
_mailsAndSendersDb.Database.EnsureCreated();
}
