public void ArchiveSuccessfulIPN(SidejobEntities context) { var customersuccessfulIPN = (from c in context.CustomerSuccesfulIPNs where c.ProjectID == ProjectID select c).ToList(); if (customersuccessfulIPN.Count != 0) { foreach (var acsipn in customersuccessfulIPN.Select(csipn => new ArchivedCustomerSuccesfulIPN { IPNID = csipn.IPNID, GrossTotal = csipn.GrossTotal, Invoice = csipn.Invoice, PaymentStatus = csipn.PaymentStatus, FirstName = csipn.FirstName, LastName = csipn.LastName, PaymentFee = csipn.PaymentFee, BusinessEmail = csipn.BusinessEmail, ReceiverEmail = csipn.ReceiverEmail, ItemName = csipn.ItemName, CurrencyCode = csipn.CurrencyCode, TransactionId = csipn.TransactionId, Custom = csipn.Custom, SubscriberId = csipn.SubscriberId, CustomerID = csipn.CustomerID, ProjectID = csipn.ProjectID, TxType = csipn.TxType, PendingReason = csipn.PendingReason, PaymentDate = csipn.PaymentDate, Address = csipn.Address, City = csipn.City, State = csipn.State, Zip = csipn.Zip, Country = csipn.Country, CountryCode = csipn.CountryCode, AddressStatus = csipn.AddressStatus, PayerStatus = csipn.PayerStatus, PayerID = csipn.PayerID, PaymentType = csipn.PaymentType, NotifyVersion = csipn.NotifyVersion, PayerPhone = csipn.PayerPhone, Tax = csipn.Tax, PayerBusinessName = csipn.PayerBusinessName })) { context.AddToArchivedCustomerSuccesfulIPNs(acsipn); } } var professionalsuccessfulIPN = (from c in context.ProfessionalSuccesfulIPNs where c.ProjectID == ProjectID select c).ToList(); if (professionalsuccessfulIPN.Count != 0) { foreach (var apsipn in professionalsuccessfulIPN.Select(csipn => new ArchivedProfessionalSuccesfulIPN { IPNID = csipn.IPNID, GrossTotal = csipn.GrossTotal, Invoice = csipn.Invoice, PaymentStatus = csipn.PaymentStatus, FirstName = csipn.FirstName, LastName = csipn.LastName, PaymentFee = csipn.PaymentFee, BusinessEmail = csipn.BusinessEmail, ReceiverEmail = csipn.ReceiverEmail, ItemName = csipn.ItemName, CurrencyCode = csipn.CurrencyCode, TransactionId = csipn.TransactionId, Custom = csipn.Custom, SubscriberId = csipn.SubscriberId, ProID = csipn.ProID, ProjectID = csipn.ProjectID, TxType = csipn.TxType, PendingReason = csipn.PendingReason, PaymentDate = csipn.PaymentDate, Address = csipn.Address, City = csipn.City, State = csipn.State, Zip = csipn.Zip, Country = csipn.Country, CountryCode = csipn.CountryCode, AddressStatus = csipn.AddressStatus, PayerStatus = csipn.PayerStatus, PayerID = csipn.PayerID, PaymentType = csipn.PaymentType, NotifyVersion = csipn.NotifyVersion, PayerPhone = csipn.PayerPhone, Tax = csipn.Tax, PayerBusinessName = csipn.PayerBusinessName })) { context.AddToArchivedProfessionalSuccesfulIPNs(apsipn); } } var customersuccessfulpdt = (from c in context.CustomerSuccessfulPDTs where c.ProjectID == ProjectID select c).ToList(); if (customersuccessfulpdt.Count != 0) { foreach (var acspdt in customersuccessfulpdt.Select(cspdt => new ArchivedCustomerSuccessfulPDT { PDTID = cspdt.PDTID, GrossTotal = cspdt.GrossTotal, Invoice = cspdt.Invoice, PaymentStatus = cspdt.PaymentStatus, FirstName = cspdt.FirstName, LastName = cspdt.LastName, PaymentFee = cspdt.PaymentFee, BusinessEmail = cspdt.BusinessEmail, TxToken = cspdt.TxToken, ReceiverEmail = cspdt.ReceiverEmail, ItemName = cspdt.ItemName, CurrencyCode = cspdt.CurrencyCode, TransactionId = cspdt.TransactionId, Custom = cspdt.Custom, subscriberId = cspdt.subscriberId, CustomerID = cspdt.CustomerID, ProjectID = cspdt.ProjectID })) { context.AddToArchivedCustomerSuccessfulPDTs(acspdt); } var professionalsuccessfulpdt = (from c in context.ProfessionalSuccessfulPDTs where c.ProjectID == ProjectID select c).ToList(); if (professionalsuccessfulpdt.Count != 0) { foreach (var apspdt in professionalsuccessfulpdt.Select(cspdt => new ArchivedProfessionalSuccessfulPDT { PDTID = cspdt.PDTID, GrossTotal = cspdt.GrossTotal, Invoice = cspdt.Invoice, PaymentStatus = cspdt.PaymentStatus, FirstName = cspdt.FirstName, LastName = cspdt.LastName, PaymentFee = cspdt.PaymentFee, BusinessEmail = cspdt.BusinessEmail, TxToken = cspdt.TxToken, ReceiverEmail = cspdt.ReceiverEmail, ItemName = cspdt.ItemName, CurrencyCode = cspdt.CurrencyCode, TransactionId = cspdt.TransactionId, Custom = cspdt.Custom, subscriberId = cspdt.subscriberId, ProID = cspdt.ProID, ProjectID = cspdt.ProjectID })) { context.AddToArchivedProfessionalSuccessfulPDTs(apspdt); } } } }