public void DownloadNewOrderPayments()
{
FaridiaIronStoreEntities dbLocal = new FaridiaIronStoreEntities();
FaridiaIronStoreServerEntities dbServer = new FaridiaIronStoreServerEntities();
var newServerOrderPaymentMade = dbServer.OrderPaymentMadeServers.Where(aa => aa.StatusCode == (int)ServerDBStatusCode.Added_From_Home).ToList();
if (newServerOrderPaymentMade.Count == 0)
{
return;
}
var config = new MapperConfiguration(cfg => cfg.CreateMap <ServerEntity.OrderPaymentMadeServer, Entity.OrderPaymentMade>());
var mapper = config.CreateMapper();
var OrderPaymentLocal = mapper.Map <List <ServerEntity.OrderPaymentMadeServer>, List <Entity.OrderPaymentMade> >(newServerOrderPaymentMade);
newServerOrderPaymentMade.ForEach(aa => aa.StatusCode = (int)ServerDBStatusCode.Updated_On_Both_Sides);
OrderPaymentLocal.ForEach(aa => aa.StatusCode = (int)LocalDBStatusCode.Updated_From_Server);
try
{
var localDBTransaction = dbLocal.Database.BeginTransaction();
var ServerDBTransaction = dbServer.Database.BeginTransaction();
dbLocal.OrderPaymentMades.SqlQuery("SET IDENTITY_INSERT [OrderPaymentMade] On");
dbLocal.OrderPaymentMades.AddRange(OrderPaymentLocal);
dbLocal.SaveChanges();
dbLocal.OrderPaymentMades.SqlQuery("SET IDENTITY_INSERT [OrderPaymentMade] Off");
dbServer.SaveChanges();
localDBTransaction.Commit();
ServerDBTransaction.Commit();
}
catch
{
throw;
}
}
