public void AddPayments(object sender, FileSystemEventArgs e)
{
if (IsTargetExtension(Path.GetExtension(e.FullPath)))
{
var payments = new XMLDeserializator <List <Payment> >();
var table = payments.Load(e.FullPath);
var comparer = new PaymentsCompare();
if (table?.Any() == true)
{
using (var context = new GeneratorContext())
{
using (var transaction = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Payments] ON");
var clientPayments = context.Payments.ToList();
var difPayments = table.Except(clientPayments, comparer);
context.AddRange(difPayments);
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Payments] OFF");
transaction.Commit();
}
}
}
}
}
public async Task Execute(IJobExecutionContext context)
{
await Task.Run(() =>
{
var people = new XMLDeserializator <List <Person> >();
var payments = new XMLDeserializator <List <Payment> >();
var tablePeople = people.Load(ConfigurationManager.AppSettings["BaseOfNames"]);
var tablePayments = payments.Load(ConfigurationManager.AppSettings["BaseOfPayments"]);
var peopleComparer = new PeopleCompare();
var paymentsComparer = new PaymentsCompare();
if (tablePeople?.Any() == true)
{
using (var dbContext = new GeneratorContext())
{
using (var transaction = dbContext.Database.BeginTransaction())
{
dbContext.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[People] ON");
var clients = dbContext.People.ToList();
var difClients = tablePeople.Except(clients, peopleComparer);
dbContext.AddRange(difClients);
dbContext.SaveChanges();
dbContext.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[People] OFF");
transaction.Commit();
}
}
}
if (tablePayments?.Any() == true)
{
using (var context = new GeneratorContext())
{
using (var transaction = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Payments] ON");
var clientPayments = context.Payments.ToList();
var difPayments = tablePayments.Except(clientPayments, paymentsComparer);
context.AddRange(difPayments);
context.SaveChanges();
context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Payments] OFF");
transaction.Commit();
}
}
}
});
}
