public Order TransactionPayment(Order order, IEnumerable <OrderDetail> orderDetails, BankCreditCard bankCreditCard) { try { using (var bankContext = new BankContext()) { using (var transaction = bankContext.Database.BeginTransaction()) { try { Order orderAdded; bankContext.Entry(bankCreditCard).State = System.Data.Entity.EntityState.Modified; bankContext.SaveChanges(); using (var pOPContext = new POPContext()) { orderAdded = pOPContext.Orders.Add(order); pOPContext.SaveChanges(); foreach (var item in orderDetails) { item.OrderId = order.OrderId; pOPContext.OrderDetails.Add(item); } pOPContext.OrderDetails.AddRange(orderDetails); //Save and discard changes pOPContext.SaveChanges(); } transaction.Commit(); return(orderAdded); } catch (Exception) { } } } } catch (Exception e) { } return(null); }
/// <summary> /// The contructor requires an open DataContext to work with /// </summary> /// <param name="context">An open DataContext</param> public BaseRepositoryEF() { _context = new POPContext(); }