private void CreatePaymentsInDatabase(List<Payment> paymentsToUpdate)
{
using (DataClassesDataContext context = new DataClassesDataContext())
{
List<XERO_PAYMENT> xeroPayments = new List<XERO_PAYMENT>();
foreach (var payment in paymentsToUpdate)
{
XERO_PAYMENT xeroPayment = new XERO_PAYMENT();
xeroPayment.AccountCode = payment.Account.Code;
xeroPayment.Amount = payment.Amount;
xeroPayment.CurrencyRate = payment.CurrencyRate;
xeroPayment.Date = payment.Date;
xeroPayment.InvoiceNumber = payment.Invoice.Number;
xeroPayment.IsReconciled = payment.IsReconciled;
xeroPayment.PaymentStatus = payment.Status.ToString();
xeroPayment.PaymentType = payment.Type.ToString();
xeroPayment.Reference = payment.Reference;
xeroPayment.XeroId = payment.Id.ToString();
xeroPayment.UpdateDate = payment.UpdatedDateUtc.GetValueOrDefault();
xeroPayments.Add(xeroPayment);
}
context.XERO_PAYMENTs.InsertAllOnSubmit(xeroPayments);
context.SubmitChanges();
}
}
private void UpdatePaymentsInDatabase(List<Payment> paymentsToUpdate)
{
using (DataClassesDataContext context = new DataClassesDataContext())
{
List<XERO_PAYMENT> xeroPayments = new List<XERO_PAYMENT>();
foreach (var payment in paymentsToUpdate)
{
var originalPayment = (from xm in context.XERO_PAYMENTs
where xm.XeroId == payment.Id.ToString()
select xm).FirstOrDefault();
originalPayment.AccountCode = payment.Account.Code;
originalPayment.Amount = payment.Amount;
originalPayment.CurrencyRate = payment.CurrencyRate;
originalPayment.Date = payment.Date;
originalPayment.InvoiceNumber = payment.Invoice.Number;
originalPayment.IsReconciled = payment.IsReconciled;
originalPayment.PaymentStatus = payment.Status.ToString();
originalPayment.PaymentType = payment.Type.ToString();
originalPayment.Reference = payment.Reference;
originalPayment.XeroId = payment.Id.ToString();
originalPayment.UpdateDate = payment.UpdatedDateUtc.GetValueOrDefault();
xeroPayments.Add(originalPayment);
}
context.SubmitChanges();
}
}