public Payment Add_old(Payment payment)
{
// Create transaction
using (var dbTransaction = _db.Database.BeginTransaction())
{
try
{
// 1. Inital Payment data
this.Payment = new Payment(payment);
this.Payment.PrepareToSave();
// 2. Add payment to context
var paymentRepo = new PaymentRepository(_db);
this.Payment.Sequence = paymentRepo.Get().Where(p => p.CostCenterID == this.Payment.CostCenterID).ToList().Count + 1;
paymentRepo.Add(this.Payment);
paymentRepo.Save();
// 3. Add each budget transaction by BudgetTransactionManager
BudgetTransactionManager transactionManager = new BudgetTransactionManager(_db);
var budgetTrans = payment.BudgetTransactions;
if (budgetTrans != null)
{
foreach (var tran in budgetTrans)
{
tran.PaymentID = this.Payment.PaymentID;
tran.Amount = 0 - tran.Amount;
transactionManager.Add(tran);
}
}
// 4. Comiit save change
dbTransaction.Commit();
return(this.Payment);
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw ex;
}
}
}
public void Update_old(Payment payment)
{
using (var dbTransaction = _db.Database.BeginTransaction())
{
try
{
//1. Get payment
Payment paymentindb;
List <BudgetTransaction> newtransactions = new List <BudgetTransaction>();
this.Payment = new Payment(payment);
var paymentRepo = new PaymentRepository(_db);
paymentindb = paymentRepo.GetById(payment.PaymentID);
paymentRepo.Update(this.Payment);
paymentRepo.Save();
var transmanager = new BudgetTransactionManager(_db);
paymentindb.BudgetTransactions = transmanager.SumTransaction(paymentindb.BudgetTransactions.ToList());
// for update transaction
foreach (var itemindb in paymentindb.BudgetTransactions)
{
var tran = payment.BudgetTransactions.Where(t => t.BudgetID == itemindb.BudgetID).FirstOrDefault();
if (tran == null)
{
// delete
if (isLastTransaction(itemindb))
{
// Delete
transmanager.Delete(itemindb);
}
else
{
newtransactions.Add(new BudgetTransaction()
{
PaymentID = payment.PaymentID,
BudgetID = itemindb.BudgetID,
Amount = itemindb.Amount,
RefID = itemindb.BudgetTransactionID
});
}
}
else
{
if (tran.Amount == itemindb.Amount)
{
payment.BudgetTransactions.Remove(tran);
}
else
{
if (isLastTransaction(itemindb))
{
BudgetTransaction updateitem;
//Update
using (var transRepo = new TransactionRepository())
{
updateitem = transRepo.GetById(itemindb.BudgetTransactionID);
}
updateitem.Amount = updateitem.Amount + (itemindb.Amount - tran.Amount);
transmanager.Update(itemindb);
}
else
{
// Add new transaction
newtransactions.Add(new BudgetTransaction()
{
PaymentID = payment.PaymentID,
BudgetID = itemindb.BudgetID,
Amount = itemindb.Amount - tran.Amount,
RefID = itemindb.BudgetTransactionID
});
}
}
}
}
// for new transaction
foreach (var item in payment.BudgetTransactions)
{
var tran = newtransactions.FirstOrDefault(t => t.BudgetID == item.BudgetID);
if (tran == null)
{
newtransactions.Add(new BudgetTransaction()
{
PaymentID = payment.PaymentID,
BudgetID = item.BudgetID,
Amount = 0 - item.Amount
});
}
}
foreach (var item in newtransactions)
{
transmanager.Add(item);
}
dbTransaction.Commit();
}
catch (Exception ex)
{
dbTransaction.Rollback();
throw;
}
}
}